public async Task <IActionResult> Edit(int id, [Bind("MenuId,ConsumptieId")] ConsumptieMenu consumptieMenu)
{
if (id != consumptieMenu.ConsumptieId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(consumptieMenu);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ConsumptieMenuExists(consumptieMenu.ConsumptieId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ConsumptieId"] = new SelectList(_context.Consumpties, "Id", "Naam", consumptieMenu.ConsumptieId);
ViewData["MenuId"] = new SelectList(_context.Menus, "Id", "Menu_naam", consumptieMenu.MenuId);
return(View(consumptieMenu));
}
public async Task <IActionResult> Create([Bind("MenuId,ConsumptieId")] ConsumptieMenu consumptieMenu)
{
if (ModelState.IsValid)
{
_context.Add(consumptieMenu);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ConsumptieId"] = new SelectList(_context.Consumpties, "Id", "Naam", consumptieMenu.ConsumptieId);
ViewData["MenuId"] = new SelectList(_context.Menus, "Id", "Menu_naam", consumptieMenu.MenuId);
return(View(consumptieMenu));
}
public async Task <IActionResult> Create(int[] ConsumptieId, [Bind("Id,Menu_naam,Beschrijving,ConsumptieMenu")] Menu menu)
{
List <ConsumptieMenu> UpdateList = new List <ConsumptieMenu>();
foreach (var item in ConsumptieId)
{
ConsumptieMenu cons = new ConsumptieMenu();
cons.ConsumptieId = item;
cons.MenuId = menu.Id;
UpdateList.Add(cons);
}
menu.ConsumptieMenu = UpdateList;
//List<ConsumptieMenu> list = new List<ConsumptieMenu>();
//ConsumptieMenu iets = new ConsumptieMenu();
//iets.ConsumptieId = 2;
//iets.MenuId = menu.Id;
//list.Add(iets);
//ConsumptieMenu test = new ConsumptieMenu();
//test.ConsumptieId = 1;
//test.MenuId = menu.Id;
//list.Add(test);
//ConsumptieMenu iets2 = new ConsumptieMenu();
//iets.ConsumptieId = 2;
//iets.MenuId = 1;
//list.Add(iets2);
//ConsumptieMenu iets3 = new ConsumptieMenu();
//iets.ConsumptieId = 3;
//iets.MenuId = 1;
//list.Add(iets3);
//menu.ConsumptieMenu = list;
if (ModelState.IsValid)
{
_context.Add(menu);
Console.WriteLine("MENU ID : " + menu.Id);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
//ViewData["ConsumptieId"] = new SelectList(_context.Consumpties, "Id", "Id", consumptieMenu.ConsumptieId);
//ViewData["MenuId"] = new SelectList(_context.Menus, "Id", "Id", consumptieMenu.MenuId);
return(View(menu));
}
public static async Task KoppelMenu(ApplicationDbContext _context)
{
List <ConsumptieMenu> test = new List <ConsumptieMenu>();
ConsumptieMenu menu = new ConsumptieMenu();
menu.ConsumptieId = 2;
menu.MenuId = 2;
//aller.Allergenen = _context.Allergenen.FirstOrDefault();
//aller.Consumptie = _context.Consumpties.FirstOrDefault();
test.Add(menu);
Consumptie consumptie = new Consumptie();
consumptie.ConsumptieMenu = test;
consumptie.CategoryId = 1;
consumptie.Beschrijving = "tset";
consumptie.Naam = "test";
consumptie.Prijs = 1.5;
_context.Consumpties.Add(consumptie);
await _context.SaveChangesAsync();
}
public static async Task UpdateConsumptieMenu(ApplicationDbContext _context)
{
Console.WriteLine("Updating ConsumptieMenu");
List <ConsumptieMenu> consumptiemenu = _context.ConsumptieMenu.ToList();
List <ConsumptieMenu> check = new List <ConsumptieMenu>();
ConsumptieMenu consumptiemenu1 = new ConsumptieMenu
{
MenuId = 1,
ConsumptieId = 1
};
check.Add(consumptiemenu1);
//ConsumptieMenu consumptiemenu2 = new ConsumptieMenu
//{
// MenuId = 1,
// ConsumptieId = 2
//};
//check.Add(consumptiemenu2);
ConsumptieMenu a = new ConsumptieMenu();
a.MenuId = 1;
a.ConsumptieId = 2;
check.Add(a);
//ConsumptieMenu consumptiemenu3 = new ConsumptieMenu
//{
// MenuId = 1,
// ConsumptieId = 3
//};
//check.Add(consumptiemenu3);
ConsumptieMenu b = new ConsumptieMenu();
b.MenuId = 1;
b.ConsumptieId = 3;
check.Add(b);
//ConsumptieMenu consumptiemenu4 = new ConsumptieMenu
//{
// MenuId = 1,
// ConsumptieId = 4
//};
//check.Add(consumptiemenu4);
ConsumptieMenu c = new ConsumptieMenu();
c.MenuId = 1;
c.ConsumptieId = 4;
check.Add(c);
//ConsumptieMenu consumptiemenu5 = new ConsumptieMenu
//{
// MenuId = 2,
// ConsumptieId = 5
//};
//check.Add(consumptiemenu5);
ConsumptieMenu d = new ConsumptieMenu();
d.MenuId = 2;
d.ConsumptieId = 5;
check.Add(d);
//ConsumptieMenu consumptiemenu6 = new ConsumptieMenu
//{
// MenuId = 2,
// ConsumptieId = 6
//};
//check.Add(consumptiemenu6);
ConsumptieMenu e = new ConsumptieMenu();
e.MenuId = 2;
e.ConsumptieId = 6;
check.Add(e);
//ConsumptieMenu consumptiemenu7 = new ConsumptieMenu
//{
// MenuId = 2,
// ConsumptieId = 7
//};
//check.Add(consumptiemenu7);
ConsumptieMenu f = new ConsumptieMenu();
f.MenuId = 2;
f.ConsumptieId = 7;
check.Add(f);
////ConsumptieMenu consumptiemenu8 = new ConsumptieMenu
////{
//// MenuId = 2,
//// ConsumptieId = 8
////};
////check.Add(consumptiemenu8);
ConsumptieMenu g = new ConsumptieMenu();
g.MenuId = 2;
g.ConsumptieId = 8;
check.Add(g);
ConsumptieMenu h = new ConsumptieMenu();
h.MenuId = 3;
h.ConsumptieId = 9;
check.Add(h);
ConsumptieMenu i = new ConsumptieMenu();
i.MenuId = 3;
i.ConsumptieId = 10;
check.Add(i);
ConsumptieMenu j = new ConsumptieMenu();
j.MenuId = 3;
j.ConsumptieId = 11;
check.Add(j);
ConsumptieMenu k = new ConsumptieMenu();
k.MenuId = 3;
k.ConsumptieId = 11;
check.Add(k);
foreach (var item in check)
{
int q = _context.ConsumptieMenu.Where(x => x.ConsumptieId == item.ConsumptieId).Count();
if (q == 0)
{
_context.ConsumptieMenu.Add(item);
await _context.SaveChangesAsync();
}
}
}
