public object ExecuteScalar(string query, DBHelperConnectionState connectionState)
{
return ExecuteScalar(query, CommandType.Text, connectionState);
}
public DbDataReader ExecuteReader(string query, DBHelperConnectionState connectionState)
{
return ExecuteReader(query, CommandType.Text, connectionState);
}
public object ExecuteScalar(string query, CommandType commandType, DBHelperConnectionState connectionState)
{
objCommand.CommandText = query;
objCommand.CommandType = commandType;
object o = null;
try
{
if (objConnection.State == System.Data.ConnectionState.Closed)
objConnection.Open();
o = objCommand.ExecuteScalar();
}
catch (Exception ex)
{
HandleExceptions(ex);
}
finally
{
objCommand.Parameters.Clear();
if (connectionState == DBHelperConnectionState.CloseOnExit)
objConnection.Close();
}
return o;
}
public DbDataReader ExecuteReader(string query, CommandType commandType, DBHelperConnectionState connectionState)
{
objCommand.CommandText = query;
objCommand.CommandType = commandType;
DbDataReader reader = null;
try
{
if (objConnection.State == System.Data.ConnectionState.Closed)
objConnection.Open();
if (connectionState == DBHelperConnectionState.CloseOnExit)
reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
else
reader = objCommand.ExecuteReader();
}
catch (Exception ex)
{
HandleExceptions(ex);
}
finally
{
objCommand.Parameters.Clear();
}
return reader;
}
public int ExecuteNonQuery(string query, DBHelperConnectionState connectionState)
{
return ExecuteNonQuery(query, CommandType.Text, connectionState);
}
public int ExecuteNonQuery(string query, CommandType commandType, DBHelperConnectionState connectionState)
{
objCommand.CommandText = query;
objCommand.CommandType = commandType;
int i = 0;
try
{
if (objConnection.State == System.Data.ConnectionState.Closed)
{
objConnection.Open();
}
i = objCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
HandleExceptions(ex);
}
finally
{
objCommand.Parameters.Clear();
if (connectionState == DBHelperConnectionState.CloseOnExit)
{
objConnection.Close();
}
}
return i;
}
public DataSet ExecuteDataSet(string query, DBHelperConnectionState connectionState)
{
return ExecuteDataSet(query, CommandType.Text, connectionState);
}
public DataSet ExecuteDataSet(string query, CommandType commandType, DBHelperConnectionState connectionState)
{
DbDataAdapter adapter = objFactory.CreateDataAdapter();
objCommand.CommandText = query;
objCommand.CommandType = commandType;
adapter.SelectCommand = objCommand;
DataSet ds = new DataSet();
try
{
adapter.Fill(ds);
}
catch (Exception ex)
{
HandleExceptions(ex);
}
finally
{
objCommand.Parameters.Clear();
if (connectionState == DBHelperConnectionState.CloseOnExit)
{
if (objConnection.State == System.Data.ConnectionState.Open)
{
objConnection.Close();
}
}
}
return ds;
}
