The PCs in my campaign are level 5. We are in a major town and a festival is happening.
I have a player whose character will spend 20-30 mins trying to convince random female NPCs to sleep with them, but they don't always succeed. He then gets angry about it and continually pursues said NPC, until I just give up and let it happen in order to continue the story.
He also loses small competitions and get angry because he didn't roll well. He takes it out on the NPC that did win in public, then gets arrested and gets angry about that too.
He blames all of his bad decisions on his low intelligence, but it's not low enough to not understand that common sense is a thing.
Other players have said that he is a blight on the game, endangering their characters. He is a close friend and I work with him. I want him to play but it's so draining I want to stop DMing.
How do I handle this bad player without kicking him out of the game?