public ActionResult MissingCategories(AdminCategoryMissingViewModel model, string[] selections) { if (ModelState.IsValid) { if (model.SelectedCategoryId == 0 || selections == null) { return(View("Error")); } var catList = new List <Category>(); foreach (var catName in selections) { foreach (var cat in db.Categories.Where(m => m.Name == catName).ToList()) { catList.Add(cat); } } foreach (var cat in catList) { cat.KL_CategoryId = model.SelectedCategoryId; db.Entry(cat).State = EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Categories")); } return(RedirectToAction("MissingCategories")); }
public ActionResult MissingCategories() { var model = new AdminCategoryMissingViewModel { AvailableCategories = new Dictionary <string, int>() }; model.MissingCategories = db.Categories .Include(m => m.KL_Category) .Where(m => m.KL_Category.Name == "Other") .Select(m => m.Name) .Distinct() .ToList(); foreach (var cat in db.KL_Categories.ToList()) { model.AvailableCategories.Add(cat.Name, cat.Id); } return(View(model)); }