Commissioner resigns for alleged affair