public tblPizzaOrder AddPizzaOrder(tblPizzaOrder pizzaOrder)
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
tblPizzaOrder newPizzaOrder = new tblPizzaOrder();
newPizzaOrder.Amount = pizzaOrder.Amount;
newPizzaOrder.OrderID = pizzaOrder.OrderID;
newPizzaOrder.PizzaID = pizzaOrder.PizzaID;
context.tblPizzaOrders.Add(newPizzaOrder);
context.SaveChanges();
pizzaOrder.ID = newPizzaOrder.ID;
return(pizzaOrder);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <tblPizzaOrder> GetPizzaOrdersByOrderID(int orderID)
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
List <tblPizzaOrder> list = new List <tblPizzaOrder>();
list = (from x in context.tblPizzaOrders where x.OrderID == orderID select x).ToList();
foreach (var item in list)
{
tblPizza pizza = (from x in context.tblPizzas where x.ID == item.PizzaID select x).First();
tblOrder order = (from x in context.tblOrders where x.ID == item.OrderID select x).First();
item.tblPizza = pizza;
item.tblOrder = order;
}
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <tblOrder> GetOrdersOfGuest(string JMBG)
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
List <tblOrder> list = new List <tblOrder>();
list = (from x in context.tblOrders select x).ToList();
list.Sort((x, y) => DateTime.Compare((DateTime)x.DateAndTimeOfOrder, (DateTime)y.DateAndTimeOfOrder));
//foreach (var item in list)
//{
// tblOrder order = (from e in context.tblOrders where e.ID == item.OrderID select e).First();
// tblPizza pizza = (from e in context.tblPizzas where e.ID == item.PizzaID select e).First();
// item.tblOrder.OrderStatus = order.OrderStatus;
// item.tblOrder.JMBG = order.JMBG;
// item.tblOrder.DateAndTimeOfOrder = order.DateAndTimeOfOrder;
// item.tblPizza.PizzaType = pizza.PizzaType;
// item.tblPizza.Price = pizza.Price;
//}
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblOrder AddOrder(tblOrder order)
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
tblOrder newOrder = new tblOrder();
newOrder.JMBG = order.JMBG;
newOrder.OrderStatus = order.OrderStatus;
newOrder.DateAndTimeOfOrder = order.DateAndTimeOfOrder;
context.tblOrders.Add(newOrder);
context.SaveChanges();
order.ID = newOrder.ID;
return(order);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void DeleteOrder(int id)
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
tblOrder orderToDelete = (from r in context.tblOrders where r.ID == id select r).First();
context.tblOrders.Remove(orderToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public void EditOrder(tblOrder order)
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
tblOrder orderDB = (from x in context.tblOrders where x.ID == order.ID select x).First();
orderDB.OrderStatus = order.OrderStatus;
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public List <tblPizza> GetPizzas()
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
List <tblPizza> list = new List <tblPizza>();
list = (from x in context.tblPizzas select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblOrder GetOrderByID(int id)
{
try
{
using (PizzeriaDBEntities context = new PizzeriaDBEntities())
{
tblOrder order = (from x in context.tblOrders where x.ID == id select x).First();
return(order);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}