public SqlDataAdapter getLstProductsAboutToFinish(bool includeFinished = false) { string query = "select * from v_get_products_with_details where stock_quantity <= alert_quantity"; // including finished products if (!includeFinished) { query += " and stock_quantity != 0"; } return(dal.selectDataAdapter(query)); }
public SqlDataAdapter getBillReport(int billID) { SqlParameter[] storedProcParams = new SqlParameter[1]; storedProcParams[0] = new SqlParameter("@bill_id", SqlDbType.Int); storedProcParams[0].Value = billID; return(dal.selectDataAdapter("sp_get_single_bill_with_units", storedProcParams)); }