YES! You CAN get over this and carry on!!
Drinking is what we do. You can analyse why it happened...boredom....complacency whatever. You will learn from it. You will pick yourself up and get back on track.
The alternative isn't worth thinking about.
Get rid of the drink.
You can absolutely get over this xxxx