Really bad fight last night with my SO

So last night my SO and I went to a party with all of our friends (we all live in the same apartment so it’s nice because we all go out together and all come back together). He couldn’t drink because he was driving, and we take turns last time we went out he got drunk and I took care of him so now it was my turn. Anyway, I got drunk (only takes one drink lol) and I went home with one of my girlfriends (who lives in the apartment with us). I was pretty rough so I made myself throw up and drink water and was cleaning the room and getting ready for bed when my SO got home. He lost his shit at me for literally no reason started throwing stuff around getting angry. He told me a piece on the bottom of his car came loose and he was mad about it but that has nothing to do with me and I don’t even drive his car. So I got mad that he was taking it out on me so I got all my stuff together to leave and go to a friends place. That made him angrier and he started saying a bunch of really hurtful stuff. Meanwhile I’m like shivering, feeling like I’m going to vomit, and to top it off I’m on my period so I have cramps too and he’s just being a total asshole. Later he apologized and said he shouldn’t have taken his anger out on me but I just feel like that behavior was unacceptable. He wants to take me to dinner tonight to make up for it, but I don’t know. We’ve been together 2 years and I know he has a temper but that was really bad. Advice?