internal bool IsExistingMeal(int mealID)
{
using (var context = new PizzaRestaurantEntities())
{
return(context.tblMeals.Any(e => e.MealID == mealID));
}
}
internal bool IsExistingOrder(int orderID)
{
using (var context = new PizzaRestaurantEntities())
{
return(context.tblOrders.Any(e => e.OrderID == orderID));
}
}
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 List <tblOrder> LoadOrders()
{
using (var conn = new PizzaRestaurantEntities())
{
var orders = new List <tblOrder>();
if (conn.tblOrders.Any())
{
return(conn.tblOrders.ToList());
}
return(orders);
}
}
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();
}
}
}
internal List <string> LoadPersonalNumbers()
{
using (var context = new PizzaRestaurantEntities())
{
var personalNumbers = new List <string>();
if (context.tblOrders.Any())
{
foreach (var item in context.tblOrders)
{
personalNumbers.Add(item.OrdererPersonalNo);
}
return(personalNumbers);
}
return(personalNumbers);
}
}
internal List <tblOrder> LoadOrders(string ordererPersonalNo)
{
using (var context = new PizzaRestaurantEntities())
{
var orders = new List <tblOrder>();
if (context.tblOrders.Any(x => x.OrdererPersonalNo == ordererPersonalNo))
{
foreach (var item in context.tblOrders.Where(x => x.OrdererPersonalNo == ordererPersonalNo))
{
orders.Add(item);
}
return(orders);
}
return(orders);
}
}
internal List <tblOrder> LoadAllOrders()
{
using (var context = new PizzaRestaurantEntities())
{
var orders = new List <tblOrder>();
if (context.tblOrders.Any())
{
foreach (var item in context.tblOrders)
{
orders.Add(item);
}
return(orders);
}
return(orders);
}
}
internal List <tblMeal> LoadMeals()
{
using (var context = new PizzaRestaurantEntities())
{
var meals = new List <tblMeal>();
if (context.tblMeals.Any())
{
foreach (var item in context.tblMeals)
{
meals.Add(item);
}
return(meals);
}
return(meals);
}
}
internal List <tblMealOrder> LoadOrderedMeals(int orderID)
{
using (var conn = new PizzaRestaurantEntities())
{
var orderedMeals = new List <tblMealOrder>();
if (conn.tblOrders.Any(x => x.OrderID == orderID))
{
foreach (var item in conn.tblMealOrders.Where(x => x.OrderID == orderID))
{
orderedMeals.Add(item);
}
return(orderedMeals);
}
return(orderedMeals);
}
}