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