public async Task <int> DeleteCommandes(List <int> ids) { List <CdeCli> commandesToDelete = await _pizzaDbContext.CdeCli.Where(c => ids.Contains(c.Num_Cde_Cli)).ToListAsync(); _pizzaDbContext.RemoveRange(commandesToDelete); return(await _pizzaDbContext.SaveChangesAsync()); }
public async Task <IActionResult> Create(int PizzaId, List <int> NewIngredients) { if (ModelState.IsValid) { var oldIngredients = _context.PizzaIngredients.Where(m => m.PizzaId == PizzaId).Select(m => m.IngredientId).ToList(); List <int> deleteIngredientsIds = oldIngredients.Except(NewIngredients).ToList(); List <PizzaIngredient> toDelete = _context.PizzaIngredients.Where(m => m.PizzaId == PizzaId && deleteIngredientsIds.Contains(m.IngredientId)).ToList(); List <int> addIngredientsIds = NewIngredients.Except(oldIngredients).ToList(); List <PizzaIngredient> toAdd = new List <PizzaIngredient>(); foreach (int i in addIngredientsIds) { toAdd.Add(new PizzaIngredient { PizzaId = PizzaId, IngredientId = i }); } _context.RemoveRange(toDelete); _context.AddRange(toAdd); await _context.SaveChangesAsync(); return(RedirectToAction("Index", "Pizzas")); } ViewData["PizzaId"] = new SelectList(_context.Pizzas.Where(x => x.Id == PizzaId), "Id", "Name"); return(View()); }
public async Task <int> DeletePizzas(List <int> ids) { List <Catalogue_Pizza> pizzasToDelete = await _pizzaDbContext.Catalogue_Pizza.Where(p => ids.Contains(p.Num_Pizza)).ToListAsync(); _pizzaDbContext.RemoveRange(pizzasToDelete); return(await _pizzaDbContext.SaveChangesAsync()); }
public async Task <int> DeleteLignesCommande(List <int> ids) { List <Ligne_Cde_Cli> lignesCommandeToDelete = await _pizzaDbContext.Ligne_Cde_Cli.Where(l => ids.Contains(l.Num_Ligne_Cde)).ToListAsync(); _pizzaDbContext.RemoveRange(lignesCommandeToDelete); return(await _pizzaDbContext.SaveChangesAsync()); }
public async Task <int> DeleteLivreurs(List <int> ids) { List <Livreur> livreursToDelete = await _pizzaDbContext.Livreur.Where(l => ids.Contains(l.Num_Liv)).ToListAsync(); _pizzaDbContext.RemoveRange(livreursToDelete); return(await _pizzaDbContext.SaveChangesAsync()); }
public async Task <int> DeleteQuartiers(List <int> ids) { List <Num_Cde_Cli> quartiersToDelete = await _pizzaDbContext.Quartier.Where(q => ids.Contains(q.Num_Quartier)).ToListAsync(); _pizzaDbContext.RemoveRange(quartiersToDelete); return(await _pizzaDbContext.SaveChangesAsync()); }