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();
try{
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}