public object ExecuteScalar(DbCommand cmd, DatabaseTransactions databaseTransaction)
{
object obj = null;
try
{
cmd.Connection.Close();
cmd.Connection = databaseTransaction.DbConnection;
cmd.Transaction = databaseTransaction.DbTransactions;
obj = cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
cmd.Dispose();
}
}
return(obj);
}
public DbDataReader ExecuteReader(DbCommand cmd, DatabaseTransactions databaseTransaction)
{
DbDataReader reader;
try
{
cmd.Connection.Close();
cmd.Connection = databaseTransaction.DbConnection;
cmd.Transaction = databaseTransaction.DbTransactions;
reader = cmd.ExecuteReader();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
cmd.Dispose();
}
}
return(reader);
}
public int ExecuteNonQuery(DbCommand cmd, DatabaseTransactions databaseTransaction)
{
int ret = -1;
try
{
cmd.Connection.Close();
cmd.Connection = databaseTransaction.DbConnection;
cmd.Transaction = databaseTransaction.DbTransactions;
ret = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
cmd.Dispose();
}
}
return(ret);
}
public DataTable ExecuteDataTable(DbCommand cmd, DatabaseTransactions databaseTransaction)
{
DataTable dataTable = new DataTable();
try
{
cmd.Connection = databaseTransaction.DbConnection;
cmd.Transaction = databaseTransaction.DbTransactions;
DbProviderFactory dbfactory = DbProviderFactories.GetFactory(ProviderName);
DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
if (dbDataAdapter != null)
{
dbDataAdapter.SelectCommand = cmd;
dbDataAdapter.Fill(dataTable);
}
}
catch (Exception ex)
{
databaseTransaction.RollBack();
throw ex;
}
finally
{
cmd.Parameters.Clear();
if (cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
cmd.Dispose();
}
}
return(dataTable);
}