private int ExcutingWithOutTransactions(string connectString, TransactionPararms tParameters)
{
using (MySqlConnection MySqlConnection = new MySqlConnection(connectString))
{
MySqlConnection.Open();
try
{
using (MySqlTransaction MySqlTransaction = MySqlConnection.BeginTransaction())
{
try
{
int ReutnValue = CommandExecuteNonQuery(MySqlConnection, MySqlTransaction, tParameters.TPSqlString, tParameters.TPCommandType, tParameters.MySqlParameters);
MySqlTransaction.Commit();
return(ReutnValue);
}
catch (MySqlException ex)
{
MySqlTransaction.Rollback();
throw ex;
}
finally
{
MySqlTransaction.Dispose();
}
}
}
catch (MySqlException ex)
{
throw ex;
}
finally
{
MySqlConnection.Close();
MySqlConnection.Dispose();
}
}
}
private int ExcutingWithTransactions(TransactionPararms tParameters)
{
MySqlTransaction sqlTrans = (MySqlTransaction)this.Transaction.Transaction;
return(CommandExecuteNonQuery(sqlTrans.Connection, sqlTrans, tParameters.TPSqlString, tParameters.TPCommandType, tParameters.MySqlParameters));
}