public DataSet GetCategory(string Category, string TableName)
{
DataSet DS = new DataSet();
DBParameterCollection paramcollection = new DataAcess.DBParameterCollection();
paramcollection.Add(new DBParameter("@Category", Category));
paramcollection.Add(new DBParameter("@TableName", TableName));
return(_DBHelper.ExecuteDataSet("GetCategory", paramcollection, CommandType.StoredProcedure));
}
public DataSet GetIncentiveTariff(string QCat, string TableName)
{
DataSet DS = new DataSet();
DBParameterCollection paramcollection = new DataAcess.DBParameterCollection();
paramcollection.Add(new DBParameter("@Category", QCat));
//paramcollection.Add(new DBParameter("@ID", ID));
paramcollection.Add(new DBParameter("@TableName", TableName));
return(_DBHelper.ExecuteDataSet("GetIncentiveTariff", paramcollection, CommandType.StoredProcedure));
}
/// <summary>
/// Executes the Sql Command and returns the DataReader.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="con">Database Connection object (DBHelper.GetConnObject() may be used)</param>
/// <param name="paramCollection">Parameter to be associated with the Sql Command or Stored Procedure.</param>
/// <returns>DataReader</returns>
public IDataReader ExecuteDataReader(string commandText, IDbConnection con, DBParameterCollection paramCollection)
{
return(ExecuteDataReader(commandText, con, paramCollection, CommandType.Text));
}
/// <summary>
/// Executes the Sql Command and return resultset in the form of DataTable.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Parameter collection to be associated with the Command.</param>
/// <returns>Result in the form of DataTable</returns>
public DataTable ExecuteDataTable(string commandText, DBParameterCollection paramCollection)
{
return(ExecuteDataTable(commandText, string.Empty, paramCollection, CommandType.Text));
}
/// <summary>
/// Executes the Sql Command and return resultset in the form of DataSet.
/// </summary>
/// <param name="commandText">Sql Command </param>
/// <param name="paramCollection">Parameter collection to be associated with the command</param>
/// <returns>Result in the form of DataSet</returns>
public DataSet ExecuteDataSet(string commandText, DBParameterCollection paramCollection)
{
return(ExecuteDataSet(commandText, paramCollection, CommandType.Text));
}
/// <summary>
/// Executes Sql Command and returns number of rows effected.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Parameter Collection to be associated with the command</param>
/// <returns>Number of rows effected.</returns>
public int ExecuteNonQuery(string commandText, DBParameterCollection paramCollection)
{
return(ExecuteNonQuery(commandText, paramCollection, CommandType.Text));
}
/// <summary>
/// Executes the Sql Command and returns result.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Parameter collection to be associated.</param>
/// <returns>A single value. (First row's first cell value, if more than one row and column is returned.)</returns>
public object ExecuteScalar(string commandText, DBParameterCollection paramCollection)
{
return(ExecuteScalar(commandText, paramCollection, CommandType.Text));
}