/// <summary> /// This method deletes ordered item from DbSet and saves changes to database. /// </summary> /// <param name="orderItemID">ID of order.</param> public void RemoveItem(int orderItemID) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblOrderItem itemToDelete = context.tblOrderItems.Where(x => x.ID == orderItemID).FirstOrDefault(); context.tblOrderItems.Remove(itemToDelete); context.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
/// <summary> /// This method adds ordered item to DbSet and saves changes to database. /// </summary> /// <param name="menuItem">Item from menu.</param> /// <param name="order">Which order to add item.</param> /// <param name="quantity">Quatity of item.</param> public void AddOrderItem(vwMenu menuItem, vwOrder order, int quantity) { try { using (PizzeriaEntities context = new PizzeriaEntities()) { tblOrderItem itemToAdd = new tblOrderItem { FoodID = menuItem.FoodID, Quantity = quantity, OrderID = order.OrderID }; context.tblOrderItems.Add(itemToAdd); context.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }