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