There is an elegant way to do this.
Use the transaction for that. start a transaction, put your stored procedures call in try catch block. After executing the stored procedures commit the transaction. else rollback in catch block.
So it would be something like
IDbConnection conn =
IDbTransaction transaction = conn.BeginTransaction();