public object ExecuteScalar(CommandType commandType, string commandText)
{
this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType);
PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters);
object returnValue = idbCommand.ExecuteScalar();
idbCommand.Parameters.Clear();
return(returnValue);
}
public void BeginTransaction()
{
if (this.idbTransaction == null)
{
idbTransaction = DBManagerFactory.GetTransaction(this.ProviderType, this.idbConnection);
}
this.idbCommand.Transaction = idbTransaction;
}
public DataSet ExecuteDataSet(CommandType commandType, string commandText)
{
this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType);
PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters);
IDbDataAdapter dataAdapter = DBManagerFactory.GetDataAdapter(this.ProviderType);
dataAdapter.SelectCommand = idbCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
idbCommand.Parameters.Clear();
return(dataSet);
}
public int ExecuteNonQuery(CommandType commandType, string commandText)
{
try
{
this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType);
PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters);
int returnValue = idbCommand.ExecuteNonQuery();
idbCommand.Parameters.Clear();
this.Parameters = null;
return(returnValue);
}
catch (Exception ex)
{
ErrorHandler.ThrowError(ex);
return(-1);
}
}
public IDataReader ExecuteReader(string commandText, CommandType commandType)
{
try
{
this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType);
idbCommand.Connection = this.Connection;
PrepareCommand(idbCommand, this.Connection, this.Transaction, commandType, commandText, this.Parameters);
this.DataReader = idbCommand.ExecuteReader();
idbCommand.Parameters.Clear();
return(this.DataReader);
}
catch (Exception ex)
{
ErrorHandler.ThrowError(ex);
return(null);
}
}
public void Open()
{
try
{
idbConnection = DBManagerFactory.GetConnection(this.providerType);
idbConnection.ConnectionString = this.ConnectionString;
if (idbConnection.State != ConnectionState.Open)
{
idbConnection.Open();
}
this.idbCommand = DBManagerFactory.GetCommand(this.ProviderType);
}
catch (Exception ex)
{
throw ex;
}
}
public void CreateParameters(ParamStruct[] param)
{
if (param != null)
{
int intParamLength = param.Length;
idbParameters = new IDbDataParameter[intParamLength];
idbParameters = DBManagerFactory.GetParameters(this.ProviderType, intParamLength);
for (int i = 0; i <= intParamLength - 1; i++)
{
ParamStruct ps = param[i];
IDbDataParameter pm = DBManagerFactory.GetParameter(this.ProviderType);
pm.ParameterName = ps.ParameterName;
pm.Value = ps.Value;
pm.Direction = ps.Direction;
pm.DbType = ps.DbType;
pm.SourceColumn = ps.SourceColumn;
idbParameters[i] = pm;
}
}
}
public void CreateParameters(int paramsCount)
{
idbParameters = new IDbDataParameter[paramsCount];
idbParameters = DBManagerFactory.GetParameters(this.ProviderType, paramsCount);
}
