My botfriend dumped me becuase someone who he works for said im a disgrace 4gettin drunk,how can i get him bac

i was out with my boyfriend at the wkend,he is a successful dj,i was in a club he was workin in,i had been drinkin all day,by the end of the night i was a mess,cant really remember much of it. someone had to carry me out of the club.He went mad said its embarring,&he can not afford for people in his industry thinking his grilfriend is a drunken idiot (which i understand). when i was sober i appologised & said it wouldn't happen again,he was very annoyed for a while but eventually calmed down&things were ok.Then last night his promoter,who has been the main reason why he is so successful sent him a text saying 'if your girlfriend cant behave dont bring her out, its not impressive' etc.he obviously really respects this guy&doesnt want him thinkin his gf is a idiot.he was so annoyed that he said he was sorry but we have to finish as this guy is very important and he doesnt wanna jeapordise that.what shall i do?i dont think we should finish or usually amazin relationship over this