Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
        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));
        }
Ejemplo n.º 3
0
 /// <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));
 }
Ejemplo n.º 4
0
 /// <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));
 }
Ejemplo n.º 5
0
 /// <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));
 }
Ejemplo n.º 6
0
 /// <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));
 }
Ejemplo n.º 7
0
 /// <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));
 }