// Method that archives order, delete from database
public void ArchiveOrder(int orderID)
{
try
{
using (PizzeriaEntities context = new PizzeriaEntities())
{
tblOrder orderToDelete = (from e in context.tblOrders where e.OrderID == orderID select e).First();
context.tblOrders.Remove(orderToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
// Method that add order to database
public void AddOrder(tblOrder order)
{
try
{
using (PizzeriaEntities context = new PizzeriaEntities())
{
tblOrder newOrder = new tblOrder();
newOrder.Name = order.Name;
newOrder.OrderDate = DateTime.Now;
newOrder.Price = order.Price;
newOrder.OrderStatus = "on hold";
newOrder.UserID = userId;
context.tblOrders.Add(newOrder);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}