public bool DeletePizza(Pizza pizza)
{
bool result = false;
using (DAL.DbContext db = new DAL.DbContext())
{
var dbPizza = db.Pizzas.FirstOrDefault(u => u.Name.Equals(pizza.Name));
db.Pizzas.Remove(dbPizza);
result = db.Save();
}
return(result);
}
public IEnumerable <Topping> GetToppings()
{
IEnumerable <Topping> results;
using (DAL.DbContext db = new DAL.DbContext())
{
results = db.Toppings.Select(u => new Topping()
{
Name = u.Name
}).ToList();
}
return(results);
}
public bool DeleteTopping(Topping topping)
{
bool result = false;
using (DAL.DbContext db = new DAL.DbContext())
{
var dbTopping = db.Toppings.FirstOrDefault(u => u.Name.Equals(topping.Name));
db.Toppings.Remove(dbTopping);
result = db.Save();
}
return(result);
}
public bool AddTopping(Topping topping)
{
bool result = false;
using (DAL.DbContext db = new DAL.DbContext())
{
db.Toppings.Add(new DAL.Topping()
{
Name = topping.Name
});
result = db.Save();
}
return(result);
}
public bool AddPizza(Pizza pizza)
{
bool result = false;
using (DAL.DbContext db = new DAL.DbContext())
{
var newPizza = new DAL.Pizza()
{
Name = pizza.Name
};
db.Pizzas.Add(newPizza);
result = db.Save();
}
return(result);
}
public IEnumerable <Topping> GetToppings(Pizza pizza)
{
IEnumerable <Topping> results = null;
using (DAL.DbContext db = new DAL.DbContext())
{
var dbPizza = db.Pizzas.FirstOrDefault(u => u.Name == pizza.Name);
if (dbPizza != null)
{
results = db.Toppings.Where(u => u.PizzaId == dbPizza.Id).Select(u => new Topping()
{
Name = u.Name
}).ToList();
}
}
return(results);
}
public bool DeleteToppingFromPizza(Topping topping, Pizza pizza)
{
bool result = false;
using (DAL.DbContext db = new DAL.DbContext())
{
var dbPizza = db.Pizzas.FirstOrDefault(u => u.Name.Equals(pizza.Name));
var dbTopping = db.Toppings.FirstOrDefault(u => u.PizzaId == dbPizza.Id && u.Name == topping.Name);
if (dbTopping != null)
{
dbTopping.PizzaId = null;
result = db.Save();
}
}
return(result);
}
public Topping GetTopping(string name)
{
Topping result = null;
using (DAL.DbContext db = new DAL.DbContext())
{
var topping = db.Toppings.FirstOrDefault(u => u.Name == name);
if (topping != null)
{
result = new Topping()
{
Name = topping.Name
}
}
;
}
return(result);
}
public Pizza GetPizza(string Name)
{
Pizza result = null;
using (DAL.DbContext db = new DAL.DbContext())
{
var pizza = db.Pizzas.FirstOrDefault(u => u.Name.Equals(Name, StringComparison.OrdinalIgnoreCase));
if (pizza != null)
{
result = new Pizza()
{
Name = pizza.Name
};
result.Toppings = db.Toppings.Where(u => u.PizzaId == pizza.Id).Select(u => new Topping()
{
Name = u.Name
}).ToList();
}
}
return(result);
}
public bool AddTopping(Topping topping, Pizza pizza)
{
bool result = false;
using (DAL.DbContext db = new DAL.DbContext())
{
var dbPizza = db.Pizzas.FirstOrDefault(u => u.Name == pizza.Name);
if (dbPizza != null)
{
if (db.Toppings.Any(u => u.PizzaId == dbPizza.Id && u.Name == topping.Name))
{
result = false;
}
else
{
var dbTopping = db.Toppings.FirstOrDefault(u => u.Name == topping.Name);
if (dbTopping == null)
{
db.Toppings.Add(new DAL.Topping()
{
Name = topping.Name, PizzaId = dbPizza.Id
});
}
else
{
dbTopping.PizzaId = dbPizza.Id;
}
result = db.Save();
}
}
}
return(result);
}
public IEnumerable <Pizza> GetPizzas()
{
IEnumerable <DAL.Pizza> pizzas;
List <Pizza> results = new List <Pizza>();
using (DAL.DbContext db = new DAL.DbContext())
{
pizzas = db.Pizzas;
foreach (var pizza in pizzas)
{
results.Add(new Pizza()
{
Name = pizza.Name,
Toppings = db.Toppings.Where(u => u.PizzaId == pizza.Id).Select(u => new Topping()
{
Name = u.Name
}).ToList()
});
}
}
return(results);
}