public ReceiptBill GetReceiptBillByID(int id) { ReceiptBill bill = null; string query = "select * from ReceiptBill where idReceiptBill = " + id; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { bill = new ReceiptBill(item); return(bill); } return(bill); }
public List <ReceiptBill> GetListReceiptBill() { List <ReceiptBill> list = new List <ReceiptBill>(); string query = "select * from ReceiptBill"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { ReceiptBill receiptBill = new ReceiptBill(item); list.Add(receiptBill); } return(list); }