public Gerecht GetOne(int Id)
{
using (var ctx = new SuperSushiContext())
{
return(ctx.Gerechten.FirstOrDefault(m => m.Id == Id));
}
}
public List <Menu> GetAll()
{
using (var ctx = new SuperSushiContext())
{
return(ctx.Menus.ToList());
}
}
public List <Gerecht> GetAll()
{
using (var ctx = new SuperSushiContext())
{
return(ctx.Gerechten.ToList());
}
}
public Menu GetOne(int id)
{
using (var ctx = new SuperSushiContext())
{
// load attached items by first loading the
// relation table and then the Gerechten listed in that
return(ctx.Menus.FirstOrDefault(m => m.Id == id));
}
}
public Menu Create(Menu menu)
{
using (var ctx = new SuperSushiContext())
{
ctx.Menus.Add(menu);
ctx.SaveChanges();
return(menu);
}
}
public Gerecht Create(Gerecht gerecht)
{
using (var ctx = new SuperSushiContext())
{
ctx.Gerechten.Add(gerecht);
ctx.SaveChanges();
return(gerecht);
}
}
public Gerecht Update(Gerecht gerecht)
{
using (var ctx = new SuperSushiContext())
{
ctx.Attach(gerecht);
ctx.Gerechten.Update(gerecht);
ctx.SaveChanges();
return(gerecht);
}
}
public Menu Update(Menu menu)
{
using (var ctx = new SuperSushiContext())
{
// Attach -> menu item must be known to the context so it can
// check whether stuff has changed in it.
ctx.Attach(menu);
// Load the old set of gerechten for this menu
ctx.Menus.Update(menu);
ctx.SaveChanges();
return(menu);
}
}
public bool Delete(int id)
{
using (var ctx = new SuperSushiContext())
{
var toRemove = ctx.Menus.Find(id);
if (toRemove != null)
{
ctx.Menus.Remove(toRemove);
ctx.SaveChanges();
return(true);
}
return(false);
}
}
public GerechtRepositorySql(SuperSushiContext context)
{
ctx = context;
}
public MenuRepositorySql(SuperSushiContext context)
{
ctx = context;
}
