private void SQLTransaction(MySqlConnection conn, MySqlCommand cmd, DBMailStruct mail)
{
using (MySqlTransaction trans = conn.BeginTransaction())
{
try
{
cmd.Transaction = trans;
cmd.ExecuteNonQuery();
trans.Commit();
mail.isSolve = true;
if (mail.sendTo != null)
{
mail.sendTo(mail);
}
}
catch (Exception e)
{
trans.Rollback();
if (mail.sendTo != null)
{
mail.isSolve = false;
mail.sendTo(mail);
}
throw e;
}
}
}
private void SQLAdapter(MySqlCommand cmd, DBMailStruct mail)
{
using (MySqlDataAdapter adapter = new MySqlDataAdapter(cmd))
{
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
mail.dataTable = dataTable;
mail.isSolve = true;
if (mail.sendTo != null)
{
mail.sendTo(mail);
}
}
}
