Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }