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" }));
}