public static void UpdateOrder(int orderid, string custname, int foodid, int size, string chilli, string moresalt, string pepper) { using (ShopOrders so = new ShopOrders()) { Order orderUpdate = so.Orders.Where(o => o.OrderId == orderid).ToList().FirstOrDefault(); // orderUpdate.UserName = custname; orderUpdate.FoodID = foodid; orderUpdate.Size = size; orderUpdate.Chilli = chilli; orderUpdate.MoreSalt = moresalt; orderUpdate.Pepper = pepper; //so.Orders.AddOrUpdate(od); so.SaveChanges(); } }
public static bool DeleteOrder(int orderid) { using (ShopOrders so = new ShopOrders()) { Order order = so.Orders.Where(o => o.OrderId == orderid).First(); try { so.Orders.Remove(order); so.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } } }