public bool UpdateServiceItem(DataModel_Channel data) { // 1. find the item in DB to update var item = from c in _dbEngine.CmtvDBContext.Service_items where c.ID == data.ID select c; Table_Service t = item.FirstOrDefault(); // 2. assign values t.ServiceName = data.ChannelName; t.Description = data.Description; t.ForFree = data.Free; t.Genre = data.Genre; // 3. submit changes try { _dbEngine.CmtvDBContext.SubmitChanges(); } catch { return(false); } return(true); }
public void ChangeColor() { int count = 0; Table_Service tableservice = new Table_Service(); List <Table> tables = tableservice.GetAllTables(); Reservation_Service service = Reservation_Service.GetReservationService(); foreach (var groupBox in Controls.OfType <GroupBox>()) { foreach (var button in groupBox.Controls.OfType <Button>()) { Table t = tables[count]; if (t.TableStatus == 0) { button.BackColor = Color.Green; button.Enabled = false; } else { button.BackColor = Color.Red; button.Enabled = true; } count++; } } }
public TableInformationUI(Table table, Employee user) { InitializeComponent(); this.table = table; this.user = user; table_Service = new Table_Service(); takeOrder_Service = new TakeOrder_Service(); standardButtons = new List <Button>() { btn_alterOrder, btn_deleteItems, btn_payBill, btn_sendOrder, btn_confirmDelete }; lbl_TableNumber.Text = $"{this.table.TableNumber}"; //hide the unnecessary buttons foreach (Button button in standardButtons) { button.Hide(); } clb_orderItems.Hide(); if (table.Status == 1 || table.Status == 3) { btn_takeOrder.Hide(); lv_Order.Hide(); btn_cancelReservation.Hide(); lbl_orderList.Hide(); } else if (table.Status == 2) { btn_occupy.Hide(); btn_reserve.Hide(); } }
public Afreken() { InitializeComponent(); Table table = Table.GetTable(); Table_Service table_Service = Table_Service.GetTableService(); FillListView(table_Service.GetReservationID(table.currentTable.TableID)); FillCurrentTable(); }
private void CreateOrderButton_Click(object sender, EventArgs e) //creates new order and then gets its ID { { RosaLogic.Order_Service orderserv = new RosaLogic.Order_Service(); Table_Service ts = new Table_Service(); orderserv.AddOrder(table.tableId); ts.UpdateTable(table, false, table.isReserved); SetLatestOrder(); } }
private void FillComboBox() //combobox vullen met alle tafelnummers { Table_Service table_Service = Table_Service.GetTableService(); List <Table> tables = table_Service.GetAllTables(); foreach (Table t in tables) { cmb_Tafelnr.Items.Add(t.TableID); } }
private void btnSaveTableInfo_Click(object sender, EventArgs e) { Table_Service tableService = new Table_Service(); Table tempSelectedTable = new Table() //store the table information into a temp table { isAvailable = selectedTable.isAvailable, isReserved = selectedTable.isReserved }; //set the temp table to the correct information if (btnOccupiedYes.Checked) { tempSelectedTable.isAvailable = false; } else { tempSelectedTable.isAvailable = true; } if (btnReservedYes.Checked) { tempSelectedTable.isReserved = true; } else { tempSelectedTable.isReserved = false; } // this check if changes were actually made (it compares the temp table with the selected table) if (tempSelectedTable.isAvailable != selectedTable.isAvailable || tempSelectedTable.isReserved != selectedTable.isReserved) { if (tempSelectedTable.isAvailable != selectedTable.isAvailable) //if the isAvailable changed { if (selectedTable.status != TableStatus.Ordered) //if the order doesn't have an order, change the availability { selectedTable.isAvailable = tempSelectedTable.isAvailable; } else //if there is an order, give warning message { MessageBox.Show("Can't change info if there is a running order!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } selectedTable.isReserved = tempSelectedTable.isReserved; ShowTableInfo(selectedTable.tableId); //refresh ShowTableInfo panel tableService.UpdateTable(selectedTable, selectedTable.isAvailable, selectedTable.isReserved); // update the table ChangeTableColor(); //change the colors and the icons } // if there were no changes, do nothing }
private void bestelBtn_Click(object sender, EventArgs e) { orderService = new Order_Service(); tableService = new Table_Service(); order.EmployeeId = employee.Id; billService = new Bill_Service(); try { bill = billService.GetBillByTableId(tafel.Number); } catch (Exception d) { orders = new List <Order>(); bill = new Bill(DateTime.Now, tafel, orders, employee, false); billService.AddBill(bill); MessageBox.Show("Bestelling is geplaatst.", "Attentie", MessageBoxButtons.OK, MessageBoxIcon.Information); orderService.AddOrderWhereBillIdIs(order, bill.Id); tafel.Occupied = true; tableService.ModifyTable(tafel); return; } if (bill.Payed == false) { orderService.AddOrderWhereBillIdIs(order, bill.Id); MessageBox.Show("Bestelling is geplaatst.", "Attentie", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { orders = new List <Order>(); bill = new Bill(DateTime.Now, tafel, orders, employee, false); billService.AddBill(bill); MessageBox.Show("Bestelling is geplaatst.", "Attentie", MessageBoxButtons.OK, MessageBoxIcon.Information); orderService.AddOrderWhereBillIdIs(order, bill.Id); tafel.Occupied = true; tableService.ModifyTable(tafel); } foreach (Dish dish in order.Dishes) { dishService = new Dish_Service(); dishService.ModifyStock(dish.Id, dish.Stock - 1); } foreach (Drink drink in order.Drinks) { drinkService = new Drink_Service(); drinkService.ModifyStock(drink.Id, drink.Stock - 1); } order = new Order(); }
private void Btn_BestellingPlaatsen_Click(object sender, EventArgs e) //bestellingen versturen naar db { int recentOrderID = 0; if (listViewWinkelwagen.Items.Count == 0) //check of alle velden zijn ingevuld { MessageBox.Show("Vul alle velden in.", "Foutmelding", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { Table currentTable = Table.GetTable(); MenuItem_Service menuItem_Service = MenuItem_Service.GetMenuItemService(); Table_Service table_Service = Table_Service.GetTableService(); Login_Service s = Login_Service.GetLoginService(); int reservationID = table_Service.GetReservationID(currentTable.currentTable.TableID); //reservationID vinden van betreffende tafel if (reservationID == 0) { MessageBox.Show("Er is geen reservering voor deze tafel.", "Foutmelding", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { Order_Service service = Order_Service.GetOrderService(); if (service.PlaceOrder(reservationID, s.CurrentEmployee.Id)) { recentOrderID = GetMostRecentOrderID(); List <MenuOrder> menuOrders = new List <MenuOrder>(); MenuOrder_DAO menuOrder_DAO = new MenuOrder_DAO(); foreach (ListViewItem li in listViewWinkelwagen.Items) //Lijst met MenuOrders maken vanuit winkelwagen { Model.MenuOrder menuOrder = new MenuOrder(int.Parse(li.SubItems[1].Text), recentOrderID, menuItem_Service.GetMenuItemID(li.Text)); menuOrders.Add(menuOrder); } foreach (MenuOrder menuOrder in menuOrders) //lijst met menuOrders naar db sturen { menuOrder_DAO.PlaceMenuOrder(menuOrder.Amount, menuOrder.OrderID, menuOrder.MenuItemID); menuOrder_DAO.UpdateStock(menuOrder.Amount, menuOrder.MenuItemID); } OrderPlaced(); this.Refresh(); //zet scherm weer op default } else { MessageBox.Show("Niet gelukt om de order te maken.", "Foutmelding", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
public bool SaveServiceData(Table_Service item) { try { //1. 把数据加入到本地Collection中, 这样绑定DataContext的控件就可以直接得到数据了 //this.ServiceCollection.Add(item); // 2. 把数据加到数据库中 _dbEngine.CmtvDBContext.Service_items.InsertOnSubmit(item); _dbEngine.CmtvDBContext.SubmitChanges(); } catch (Exception) { return(false); } return(true); }
private void LoadForm() { //show a Welcome message, "Welcome, firstName!" lblWelcome.Text = $"Welcome, {employee.firstName}!"; Table_Service tableService = new Table_Service(); tables = tableService.GetAllTables(); //return all the tables from the database //add all the table images in a list tableImages = new PictureBox[10] { picTable1, picTable2, picTable3, picTable4, picTable5, picTable6, picTable7, picTable8, picTable9, picTable10 }; ChangeTableColor(); ShowTableInfo(1); }
public TableInformationUI(Table table, Employee user) { InitializeComponent(); lbl_TableNumber.Text = $"{table.TableNumber}"; table_Service = new Table_Service(); takeOrder_Service = new TakeOrder_Service(); this.table = table; this.user = user; //hide the unnecessary buttons HideButtons(new List <Button> { btn_alterOrder, btn_confirmDelete, btn_deleteItems, btn_payBill, btn_sendOrder, btn_OrderServed }); clb_orderItems.Hide(); CheckStatus(); CheckOrder(); }
public TablesOverviewUI(Employee user) { InitializeComponent(); this.user = user; takeOrder_Service = new TakeOrder_Service(); tableService = new Table_Service(); lbl_UserName.Text = user.Name; //hide back button from the waiter if (user.Position == Enum_Employee.Waiter) { btn_Back.Hide(); } //give colors to tables TablesStatus(); //counter start counting timer1.Interval = 10000; timer1.Start(); }