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