public BuildQuery(string ConnString)
{
//Initialize hashtable which is going to hold parameter collections
m_ParamCollection = new Hashtable();
//Set Sql connection string
ConnectionString = ConnString;
//Initailize datalayer object
m_oDbManager = new DataManager(DataManager.DatabaseType.MsSql);
}
protected object ExecuteQuery(DbConnection DbConn, DbTransaction DbTrans, string spName, CommandType CmdType, Hashtable ParamTable, DataManager.ExecuteAction ExecAction)
{
if (this.ValidateCommandText(spName))
{
try
{
if (DbConn.State != ConnectionState.Open)
{
DbConn.Open();
}
DbCommand dbCommand = this.GetDbCommand(spName, DbConn);
dbCommand.Transaction = DbTrans;
try
{
dbCommand.CommandType = CmdType;
if (ParamTable != null)
{
Array hashValue = Utils.GetHashValue(ParamTable);
for (int index = 0; index < hashValue.Length; ++index)
{
dbCommand.Parameters.Add((object)(DbParameter)hashValue.GetValue(index));
}
}
if (ExecAction == DataManager.ExecuteAction.NonQuery)
{
long num = long.Parse(dbCommand.ExecuteNonQuery().ToString());
return (object)num;
}
else
{
object obj = dbCommand.ExecuteScalar();
return obj;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (this.m_CloseConnection)
{
DbConn.Close();
dbCommand.Dispose();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (this.m_CloseConnection)
{
DbConn.Dispose();
}
}
}
else
{
throw new Exception("Command text empty");
}
}
public DataManager(DataManager.DatabaseType bkendType)
{
this.BackendType = bkendType;
}
