internal DataSet ExecuteDataSet(string query, CommandType commandtype, DBEnum.DatabaseConnectionState connectionstate)
{
DbDataAdapter adapter = objFactory.CreateDataAdapter();
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
adapter.SelectCommand = objCommand;
DataSet ds = new DataSet();
try
{
adapter.Fill(ds);
}
catch
{
throw;
}
finally
{
objCommand.Parameters.Clear();
if (connectionstate == DBEnum.DatabaseConnectionState.CloseOnExit)
{
if (objConnection.State == System.Data.ConnectionState.Open)
{
objConnection.Close();
}
}
}
return(ds);
}
internal DbDataReader ExecuteReader(string query, CommandType commandtype, DBEnum.DatabaseConnectionState connectionstate)
{
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
DbDataReader reader = null;
try
{
if (objConnection.State == System.Data.ConnectionState.Closed)
{
objConnection.Open();
}
if (connectionstate == DBEnum.DatabaseConnectionState.CloseOnExit)
{
reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
else
{
reader = objCommand.ExecuteReader();
}
}
catch
{
throw;
}
finally
{
objCommand.Parameters.Clear();
}
return(reader);
}
internal object ExecuteScalar(string query, CommandType commandtype, DBEnum.DatabaseConnectionState connectionstate)
{
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
object o = null;
try
{
if (objConnection.State == System.Data.ConnectionState.Closed)
{
objConnection.Open();
}
o = objCommand.ExecuteScalar();
}
catch
{
throw;
}
finally
{
objCommand.Parameters.Clear();
if (connectionstate == DBEnum.DatabaseConnectionState.CloseOnExit)
{
objConnection.Close();
}
}
return(o);
}
internal int ExecuteNonQuery(string query, CommandType commandtype, DBEnum.DatabaseConnectionState connectionstate)
{
objCommand.CommandText = query;
objCommand.CommandType = commandtype;
int i = -1;
try
{
if (objConnection.State == System.Data.ConnectionState.Closed)
{
objConnection.Open();
}
i = objCommand.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
objCommand.Parameters.Clear();
if (connectionstate == DBEnum.DatabaseConnectionState.CloseOnExit)
{
objConnection.Close();
}
}
return(i);
}
public int ExecuteNonQuery(string query, CommandType commandtype, DBEnum.DatabaseConnectionState databaseConnectionState)
{
return(databaseHelper.ExecuteNonQuery(query, commandtype, databaseConnectionState));
}
public DataSet ExecuteDataSet(string query, CommandType commandtype, DBEnum.DatabaseConnectionState databaseConnectionState)
{
this.dataSet = databaseHelper.ExecuteDataSet(query, commandtype, databaseConnectionState);
return(this.dataSet);
}
public object ExecuteScalar(string query, CommandType commandtype, DBEnum.DatabaseConnectionState connectionstate)
{
return(databaseHelper.ExecuteScalar(query, commandtype, connectionstate));
}
public DbDataReader ExecuteReader(string query, DBEnum.DatabaseConnectionState connectionstate)
{
this.dbDataReader = databaseHelper.ExecuteReader(query, connectionstate);
return(this.dbDataReader);
}
internal DataSet ExecuteDataSet(string query, DBEnum.DatabaseConnectionState connectionstate)
{
return(ExecuteDataSet(query, connectionstate));
}
internal DbDataReader ExecuteReader(string query, DBEnum.DatabaseConnectionState connectionstate)
{
return(ExecuteReader(query, CommandType.Text, connectionstate));
}
internal object ExecuteScalar(string query, DBEnum.DatabaseConnectionState connectionstate)
{
return(ExecuteScalar(query, CommandType.Text, connectionstate));
}
internal int ExecuteNonQuery(string query, DBEnum.DatabaseConnectionState connectionstate)
{
return(ExecuteNonQuery(query, CommandType.Text, connectionstate));
}
