Former detective guilty of misconduct over sex on premises