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)); }