public tblPizzaOrder AddPizzaOrder(tblPizzaOrder pizzaOrder)
{
try
{
using (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1())
{
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 tblOrder AddOrder(tblOrder order)
{
try
{
using (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1())
{
tblOrder newOrder = new tblOrder();
newOrder.JMBG = order.JMBG;
newOrder.OrderStatus = order.OrderStatus;
newOrder.DateAndTimeOfOrder = order.DateAndTimeOfOrder;
newOrder.TotalPrice = order.TotalPrice;
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 (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1())
{
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 (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1())
{
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());
}
}