public static int GetQuantityDrink(int idbill, int idDrink)
{
//load bảng chi tiết hóa đơn theo mã hóa đơn
List <DetailBillDTO> listDetailBil = new List <DetailBillDTO>();
DataTable data = DataProvider.Instance.ExcuteQuery("Select * from dbo.DETAILBILL as de where IDBill = " + idbill + " and IDDrink = " + idDrink);
if (data.Rows.Count > 0)
{
DetailBillDTO debill = new DetailBillDTO(data.Rows[0]);
return(debill.Quantity);
}
return(0);
}
public static List <DetailBillDTO> GetListDrinkByIDBill(int idBill)
{
List <DetailBillDTO> lstDrink = new List <DetailBillDTO>();
string query = "select * from DETAILBILL WHERE IDBill = @idBill";
DataTable data = DataProvider.Instance.ExcuteQuery(query, new object[] { idBill });
foreach (DataRow item in data.Rows)
{
DetailBillDTO detail = new DetailBillDTO(item);
lstDrink.Add(detail);
}
return(lstDrink);
}
public static int GetTotalDetailBillByIDBill(int idbill)
{
//load bảng chi tiết hóa đơn theo mã hóa đơn
List <DetailBillDTO> listDetailBil = new List <DetailBillDTO>();
DataTable data = DataProvider.Instance.ExcuteQuery("Select * from dbo.DETAILBILL as de where IDBill = " + idbill);
if (data.Rows.Count > 0)
{
int tongtien = 0;
for (int i = 0; i < data.Rows.Count; i++)
{
DetailBillDTO debill = new DetailBillDTO(data.Rows[i]);
tongtien += debill.Quantity;
}
return(tongtien);
}
return(0);
}
