Have i messed up or was he just after sex anyway?

i think it was both. you messed up and he was just after sex. if he came over to make you feel better you should have let him but chances are that's not the reason he came over he prolly just wanted sex. you don't need him :)