public static DataSet ExecuteDataSet(string sql, List <MySqlParameter> parameterCollection)
{
DataSet ds = new DataSet();
if (_dbConnect == null)
{
DalMysqlHelper.GetCon();
}
if (_dbConnect.State != ConnectionState.Open)
{
_dbConnect.Open();
}
using (MySqlTransaction transaction = _dbConnect.BeginTransaction())
{
MySqlCommand sqlCommand = new MySqlCommand(sql);
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Connection = _dbConnect;
sqlCommand.Transaction = transaction;
parameterCollection = parameterCollection ?? new List <MySqlParameter>();
foreach (var mySqlParameter in parameterCollection)
{
sqlCommand.Parameters.Add(mySqlParameter);
}
MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter(sqlCommand);
try
{
sqlDataAdapter.Fill(ds);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
_dbConnect.Close();
}
return(ds);
}
public static int ExecuteNonQuery(string sql, List <MySqlParameter> parameterCollection)
{
int result = 0;
if (_dbConnect == null)
{
DalMysqlHelper.GetCon();
}
if (_dbConnect.State != ConnectionState.Open)
{
_dbConnect.Open();
}
using (MySqlTransaction transaction = _dbConnect.BeginTransaction())
{
MySqlCommand sqlCommand = new MySqlCommand(sql);
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Connection = _dbConnect;
sqlCommand.Transaction = transaction;
parameterCollection = parameterCollection ?? new List <MySqlParameter>();
foreach (var mySqlParameter in parameterCollection)
{
sqlCommand.Parameters.Add(mySqlParameter);
}
try
{
result = sqlCommand.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
_dbConnect.Close();
}
return(result);
}
