public static List <Order> GetOrder(int orderId)
 {
     using (ShopOrders entities = new ShopOrders())
     {
         return(entities.Orders.Where(p => p.OrderID == orderId).ToList <Order>());
     }
 }
 public static List <Food> ListFood()
 {
     using (ShopOrders entities = new ShopOrders())
     {
         return(entities.Foods.ToList <Food>());
     }
 }
 public static List <Size> ListSize()
 {
     using (ShopOrders entities = new ShopOrders())
     {
         return(entities.Sizes.ToList <Size>());
     }
 }
 public static List <Order> ListOrdersBy(string name)
 {
     using (ShopOrders entities = new ShopOrders())
     {
         return(entities.Orders.Where(p => p.Username == name).ToList <Order>());
     }
 }
Esempio n. 5
0
 public static string GetFood(int id)
 {
     using (ShopOrders entities = new ShopOrders())
     {
         Food f = entities.Foods.Where(p => p.ID == id).First<Food>();
         return (f.Name);
     }
 }
 public static void DeleteOrder(int orderId)
 {
     using (ShopOrders entities = new ShopOrders())
     {
         Order order = entities.Orders.Where(p => p.OrderID == orderId).First <Order>();
         entities.Orders.Remove(order);
         entities.SaveChanges();
     }
 }
Esempio n. 7
0
 protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
 {
     int orderId = (int)GridView1.SelectedDataKey.Value;
     using (ShopOrders entities = new ShopOrders())
     {
         Order order = entities.Orders.Where(p => p.OrderID == orderId).First<Order>();
         DetailsView1.DataSource = new Order[] { order };
         DetailsView1.DataBind();
     }
 }
Esempio n. 8
0
 public static void UpdateOrder(int orderId, int foodid,
     string size, string chilli, string salt, string pepper)
 {
     using (ShopOrders entities = new ShopOrders())
     {
         Order order = entities.Orders.Where(p => p.OrderID == orderId).First<Order>();
         order.FoodID = foodid;
         order.FoodName = GetFood(foodid);
         order.Size = size;
         order.Chilli = chilli;
         order.MoreSalt = salt;
         order.Pepper = pepper;
         entities.SaveChanges();
     }
 }
 public static void AddOrder(string user, int foodID, string foodname,
                             string size, string chilli, string salt, string pepper)
 {
     using (ShopOrders entities = new ShopOrders())
     {
         Order order = new Order
         {
             Username = user,
             FoodID   = foodID,
             FoodName = foodname,
             Size     = size,
             Chilli   = chilli,
             MoreSalt = salt,
             Pepper   = pepper
         };
         entities.Orders.Add(order);
         entities.SaveChanges();
     }
 }