I just want my boyfriends forgiveness please help!?

Ok so last weekend. I had gone to visit(we live an hour away from each other)my boyfriend and we ended up having a few drinks well before I had gone up there I took 1 valium before hand which was a horrible idea but I didnt know we would be drinking and it was just for relaxation I never intended to get messed up, but I did get kind of messed up and so he took me to his parents house to sleep it off and he asked me what I had taken the next day and I just couldnt lie to him because I care too much too do that so I told him the truth and he got very mad at me and would barely talk to me for the rest of the day. I understand why he is mad because I use to have a problem with pills but I dont anymore I can honestly say I wasnt taking the pill in hopes of getting messed up I just needed to relax because Ive been on edge lately because in 5 months hes leaving for grad school and Im really going to miss him. He didnt get me anything for v day he says that he hates that day and that it is stupid, I even asked him if he wanted to hang out for vday but he said he didnt get off work till 830 but we have hung out before that late. So instead he went out drinking with his friends. I dont know what to do I just want him to forgive me and start talking to me again, or does it sound like its over?