public List <ReceiptBillInfo> GetListById(int id)
{
List <ReceiptBillInfo> list = new List <ReceiptBillInfo>();
string query = "select * from ReceiptBillInfo where idReceiptBill = " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ReceiptBillInfo receiptbillinfo = new ReceiptBillInfo(item);
list.Add(receiptbillinfo);
}
return(list);
}
public int GetTotalById(int id)
{
int total = 0;
string query = "select * from ReceiptBillInfo where idReceiptBill = " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ReceiptBillInfo receiptbillinfo = new ReceiptBillInfo(item);
total += Convert.ToInt32((receiptbillinfo.Amount * receiptbillinfo.Price) * (1 - receiptbillinfo.Discount / 100.0));
}
return(total);
}
