internal void AddNewOrder(tblOrder newOrder)
{
using (var conn = new PizzaRestaurantEntities())
{
conn.tblOrders.Add(newOrder);
conn.SaveChanges();
}
}
internal void UpdateOrder(tblOrder orderToUpdate)
{
using (var context = new PizzaRestaurantEntities())
{
context.tblOrders.First(e => e.OrderID == orderToUpdate.OrderID).IsApproved = orderToUpdate.IsApproved;
context.SaveChanges();
}
}
internal void DeleteOrderedMeal(tblMealOrder mealOrder)
{
using (var context = new PizzaRestaurantEntities())
{
var orderToRemove = context.tblMealOrders.FirstOrDefault(e => e.MealOrderID == mealOrder.MealOrderID);
if (orderToRemove != null)
{
context.tblMealOrders.Remove(orderToRemove);
context.SaveChanges();
}
}
}
