public void DecrementPrice(int pizzaId, int price)
{
using (var currentContext = new PizzaSericeContext())
{
Pizza currentPizza = GetPizzaById(pizzaId);
currentPizza.Price -= price;
currentContext.Entry(currentPizza).State = System.Data.Entity.EntityState.Modified;
currentContext.SaveChanges();
}
}
public void DeleteRole(int roleId)
{
using (var context = new PizzaSericeContext())
{
Role role = GetRoleById(roleId);
context.Roles.Attach(role);
context.Entry(role).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public void DecrementCount(int orderId, int pizzaId)
{
using (var currentContext = new PizzaSericeContext())
{
PizzaToOrder pizzaToOrder = GetPizzaToOrderById(orderId, pizzaId);
pizzaToOrder.Count--;
currentContext.Entry(pizzaToOrder).State = EntityState.Modified;
currentContext.SaveChanges();
}
}
public void AddPrice(int orderId, int price)
{
using (var currentContext = new PizzaSericeContext())
{
Order currentOrder = GetOrderById(orderId);
currentOrder.Price += price;
currentContext.Entry(currentOrder).State = EntityState.Modified;
currentContext.SaveChanges();
}
}
public void UpdateStock(int id, int count)
{
using (var currentContext = new PizzaSericeContext())
{
StockIngredient currentIngredient = GetIngredientWithCountById(id);
currentIngredient.Count -= count;
currentContext.Entry(currentIngredient).State = System.Data.Entity.EntityState.Modified;
currentContext.SaveChanges();
}
}
public void EditUserRole(int userId, Role role)
{
using (var context = new PizzaSericeContext())
{
ServiceUser user = GetUserById(userId);
user.RoleId = role.Id;
context.ServiceUsers.Attach(user);
context.Entry(user).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void DecrementCount(int userId, int pizzaId, int ingredientId)
{
using (var currentContext = new PizzaSericeContext())
{
PizzaIngredient pizzaIngredient = GetPizzaIngredientById(pizzaId, ingredientId);
Ingredient ingredient = IngredientRepository.Instance.GetIngredientById(ingredientId);
Order currentOrder = OrderRepository.Instance.GetUnConfirmedOrder(userId);
if (pizzaIngredient.Count == 1)
{
DeleteIngredient(userId, pizzaId, ingredient);
OrderRepository.Instance.DecrementPrice(currentOrder.Id, ingredient.Price);
return;
}
pizzaIngredient.Count--;
OrderRepository.Instance.DecrementPrice(currentOrder.Id, ingredient.Price);
currentContext.Entry(pizzaIngredient).State = EntityState.Modified;
currentContext.SaveChanges();
}
}
public void DeleteOrderPizza(int orderId, Pizza pizza)
{
using (var currentContext = new PizzaSericeContext())
{
PizzaToOrder pizzaToOrder = GetPizzaToOrderById(orderId, pizza.Id);
if (pizzaToOrder.Count == 1)
{
currentContext.PizzaToOrders.Attach(pizzaToOrder);
currentContext.Entry(pizzaToOrder).State = EntityState.Deleted;
}
else
DecrementCount(orderId, pizza.Id);
OrderRepository.Instance.DecrementPrice(orderId, pizza.Price);
currentContext.SaveChanges();
}
}
public void DeleteIngredient(int userId, int pizzaId, Ingredient ingredient)
{
using (var currentContext = new PizzaSericeContext())
{
PizzaIngredient pizzaIngredient = GetPizzaIngredientById(pizzaId, ingredient.Id);
Order currentOrder = OrderRepository.Instance.GetUnConfirmedOrder(userId);
currentContext.PizzaIngredients.Attach(pizzaIngredient);
currentContext.Entry(pizzaIngredient).State = EntityState.Deleted;
PizzaRepository.Instance.DecrementPrice(pizzaId, ingredient.Price);
OrderRepository.Instance.DecrementPrice(currentOrder.Id, ingredient.Price);
currentContext.SaveChanges();
}
}
public void IncrementCount(int userId, int pizzaId, int ingredientId)
{
PizzaIngredient pizzaIngredient = GetPizzaIngredientById(pizzaId, ingredientId);
Ingredient ingredient = IngredientRepository.Instance.GetIngredientById(ingredientId);
Order currentOrder = OrderRepository.Instance.GetUnConfirmedOrder(userId);
using (var currentContext = new PizzaSericeContext())
{
pizzaIngredient.Count++;
OrderRepository.Instance.AddPrice(currentOrder.Id, ingredient.Price);
currentContext.Entry(pizzaIngredient).State = EntityState.Modified;
currentContext.SaveChanges();
}
}
public void ConfirmOrder(int userId)
{
using (var currentContext = new PizzaSericeContext())
{
Order order = GetUnConfirmedOrder(userId);
order.IsConfirmed = true;
currentContext.Entry(order).State = EntityState.Modified;
currentContext.SaveChanges();
}
}
public void DeleteOrder(Order order)
{
using (var currentContext = new PizzaSericeContext())
{
currentContext.Orders.Attach(order);
currentContext.Entry(order).State = EntityState.Deleted;
currentContext.SaveChanges();
}
}