0 https://www.codeproject.com/Articles/10223/Using-Transactions-in-ADO-NET
0 You need to surround your code with try catch block for each of the database operations in your methods and in order to rollback you can always use sqltransaction.begintransaction and sqltransaction.rollback methods.
Take a look at detailed example below:
http://www.c-sharpcorner.com/UploadFile/rohatash/performing-sql-server-transaction-using-ado-net/