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