public OBJSQL InsertQuery(string sQuery, List <MySqlParameter> _params = null)
{
OBJSQL objSQL = new OBJSQL();
Int32 record = 0;
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
conn.Open();
MySqlTransaction trans1 = conn.BeginTransaction();
try
{
MySqlCommand cmd = new MySqlCommand()
{
Connection = conn,
Transaction = trans1,
CommandText = sQuery,
CommandType = CommandType.Text,
};
cmd.Parameters.AddRange(_params.ToArray());
record = cmd.ExecuteNonQuery();
trans1.Commit();
}
catch (Exception ex)
{
trans1.Rollback();
XtraMessageBox.Show(ex.Message);
}
if (record != 0)
{
XtraMessageBox.Show(ConfigurationManager.AppSettings["msg_success_insert"]);
GlobalVar.Success = true;
}
else
{
GlobalVar.Success = false;
}
}
return(objSQL);
}
public DataTable ListByQuery(string sQuery)
{
OBJSQL objSQL = new OBJSQL();
DataTable dt = new DataTable();
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
bool bRet = false;
ExecuteController exe = new ExecuteController();
conn.Open();
try
{
MySqlCommand cmd = new MySqlCommand()
{
Connection = conn,
CommandText = sQuery,
CommandType = CommandType.Text,
CommandTimeout = 0
};
int nRet = cmd.ExecuteNonQuery();
if (nRet <= 0)
{
bRet = false;
exe.EXE = bRet;
}
else
{
bRet = true;
exe.EXE = bRet;
}
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
adapter.Fill(dt);
}
catch (Exception ex)
{
objSQL.MSGOUT = ex.Message;
XtraMessageBox.Show(ex.Message);
}
}
return(dt);
}