public void Speichern(PizzaEntity pizza)
{
using (var ctx = new PizzaContext())
{
var entity = ctx.Entry(pizza);
entity.State = pizza.Id == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
public List<PizzaEntity> Pizzen()
{
using (var ctx = new PizzaContext())
{
return ctx.Pizzen.ToList();
}
}
public void Bestellen(string besteller, List<PizzaEntity> pizzen)
{
using (var ctx = new PizzaContext())
{
var pizzenById = pizzen.ToLookup(p => p.Id);
foreach (var pizza in pizzenById)
{
var entity = ctx.Entry(pizza.First());
entity.State = System.Data.Entity.EntityState.Unchanged;
}
var bestellung = new BestellungEntity
{
Datum = DateTime.Now,
Besteller = besteller,
Pizzen = new List<BestellungPositionEntity>(pizzen.Select(p => new BestellungPositionEntity { Pizza = pizzenById[p.Id].First() }))
};
ctx.Bestellungen.Add(bestellung);
ctx.SaveChanges();
}
}
public List<BestellungEntity> Bestellungen(string von)
{
using (var ctx = new PizzaContext())
{
return ctx.Bestellungen.Include("Pizzen.Pizza").Where(b => b.Besteller == von).ToList();
}
}
public List<BestellungEntity> AlleBestellungen()
{
using (var ctx = new PizzaContext())
{
return ctx.Bestellungen.Include("Pizzen.Pizza").ToList();
}
}