public void AddToCart(int dishId, string userName, int restaurantId) { var context = new ZderkoDbContext(); var order = context.Orders.Include(o => o.User).ToList().SingleOrDefault(o => o.User.UserName == userName); if (order == null) { var newOrder = new Order() { Dishes = new List <Dish>(), MethodOfPayment = context.MethodsOfPayment.Find(1), OrderNumber = context.Orders.Count() + 1, OrderTime = DateTime.Now, Restaurant = context.Restaurants.Find(restaurantId), User = context.Users.ToList().SingleOrDefault(u => u.UserName == userName) }; var food = context.Dishes.Find(dishId); newOrder.Dishes.Add(food); context.Orders.Add(newOrder); } else { var dish = context.Dishes.Find(dishId); order.Dishes.Add(dish); context.Orders.AddOrUpdate(order); } context.SaveChanges(); context.Dispose(); }
public ActionResult Delete(int id) { var context = new ZderkoDbContext(); Restaurant result = context.Restaurants.Find(id); string userId = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (result.UserId != userId) { return(Json(new { result = "failure" })); } context.Entry(result.Address).State = System.Data.Entity.EntityState.Deleted; foreach (var order in result.Orders.ToList()) { context.Orders.Remove(order); } foreach (var dish in result.Dishes.ToList()) { context.Dishes.Remove(dish); } context.Entry(result).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); context.Dispose(); return(Json(new { result = "success" })); }
// PUT: api/DishData/5 public void Put(int id, [FromBody] Dish data) { var context = new ZderkoDbContext(); context.Dishes.AddOrUpdate(data); context.SaveChanges(); context.Dispose(); }
public void Put([FromBody] Order data) { var context = new ZderkoDbContext(); context.Orders.AddOrUpdate(data); context.SaveChanges(); context.Dispose(); }
// DELETE: api/DishData/5 public void Delete(int id) { var context = new ZderkoDbContext(); var result = context.Dishes.Find(id); if (result != null) { context.Entry(result).State = System.Data.Entity.EntityState.Deleted; } context.SaveChanges(); context.Dispose(); }
public void Delete(string userName) { var context = new ZderkoDbContext(); var result = context.Orders.Include(o => o.User).ToList().SingleOrDefault(o => o.User.UserName == userName); if (result != null) { context.Entry(result).State = System.Data.Entity.EntityState.Deleted; } context.SaveChanges(); context.Dispose(); }
public void RemoveFromCart(int dishId, string userName) { var context = new ZderkoDbContext(); var order = context.Orders.Include(o => o.User).ToList().SingleOrDefault(o => o.User.UserName == userName); var dish = context.Dishes.Find(dishId); order.Dishes.Remove(dish); context.Orders.AddOrUpdate(order); context.SaveChanges(); context.Dispose(); }
public ActionResult Create(Dish dish) { var context = new ZderkoDbContext(); if (ModelState.IsValid) { context.Dishes.Add(dish); context.SaveChanges(); context.Dispose(); return(RedirectToAction("Index")); } return(View(dish)); }
public ActionResult EditPost(int id) { var context = new ZderkoDbContext(); var result = context.Restaurants.Find(id); var didUpdateModelSucceed = this.TryUpdateModel(result); if (didUpdateModelSucceed && ModelState.IsValid) { context.SaveChanges(); context.Dispose(); return(RedirectToAction("Index")); } //this.FillDropDownValues(); return(View(result)); }
public ActionResult Create(Restaurant restaurant) { var context = new ZderkoDbContext(); if (ModelState.IsValid) { string userId = System.Web.HttpContext.Current.User.Identity.GetUserId(); restaurant.UserId = userId; context.Restaurants.Add(restaurant); context.SaveChanges(); context.Dispose(); return(RedirectToAction("Index")); } return(View(restaurant)); }
public ActionResult Delete(int id) { var context = new ZderkoDbContext(); Dish result = context.Dishes.Find(id); string userId = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (result.Restaurant != null) { if (result.Restaurant.UserId != userId) { return(Json(new { result = "failure" })); } } context.Entry(result).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); context.Dispose(); return(Json(new { result = "success" })); }