withdraw code in asp.net vs2019

retrieve Balance based on user Id and compare with entered withdrawl amount, if withdraw amount is greater than the balance left, then roll back transaction.

 

Note:- Always use transaction in such conditions.