public int insertBillInfo(TableFoodDTO table, string food, int quantity)
        {
            bool    check   = false;
            BillBUS busBill = new BillBUS();
            int     idBill  = busBill.getBillUnCheckoutByNameTable(table.Name);

            if (idBill == 0)
            {
                idBill = busBill.getMaxIDBill() + 1;
                DateTime currentDate = DateTime.Now;
                string   nameTable   = table.Name;
                string   status      = "Chưa thanh toán";
                string   staff       = null;
                BillDTO  dtoBill     = new BillDTO(idBill, currentDate, nameTable, status, staff);
                check = busBill.insertBill(dtoBill);
                if (check)
                {
                    int         idBillInfo  = dao.getMaxIDBillInfo() + 1;
                    BillInfoDTO dtoBillInfo = new BillInfoDTO(idBillInfo, idBill, food, quantity);
                    check = dao.insertBillInfo(dtoBillInfo);
                    if (check)
                    {
                        string       statusTable = "Có người";
                        TableFoodBUS busTable    = new TableFoodBUS();
                        check = busTable.updateStatusTable(nameTable, statusTable);
                    }
                }
            }
            else
            {
                BillInfoDTO dtoBillInfo = dao.checkExistFoodInBill(idBill, food);
                if (dtoBillInfo != null)
                {
                    check = dao.updateQuantityBillInfo(dtoBillInfo.Id, quantity + dtoBillInfo.Quantity);
                }
                else
                {
                    int idBillInfo = dao.getMaxIDBillInfo() + 1;
                    dtoBillInfo = new BillInfoDTO(idBillInfo, idBill, food, quantity);
                    check       = dao.insertBillInfo(dtoBillInfo);
                }
            }

            if (!check)
            {
                idBill = -1;
            }


            return(idBill);
        }
        public bool checkoutBill(TableFoodDTO table, string staff, int total)
        {
            BillBUS  busBill      = new BillBUS();
            int      idBill       = busBill.getBillUnCheckoutByNameTable(table.Name);
            DateTime checkOutDate = DateTime.Now;
            string   status       = "Đã thanh toán";
            bool     check        = dao.checkoutBill(idBill, staff, total, status, checkOutDate);

            if (check)
            {
                TableFoodBUS busTable = new TableFoodBUS();
                check = busTable.updateStatusTable(table.Name, "Trống");
            }
            return(check);
        }