public IActionResult Create(SubCategory subCategory) { if (ModelState.IsValid) { var doesSubExist = db.SubCategories.Include(x => x.Category).Where(x => x.Name == subCategory.Name && subCategory.CategoryId == x.CategoryId).ToList(); if (doesSubExist.Count > 0) { statusmessage = $"Error : subCategory exist in {doesSubExist.First().Category.Name}"; } else { db.SubCategories.Add(subCategory); db.SaveChanges(); return(RedirectToAction(nameof(Index))); } } ViewBag.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); SubCategoryandCategory model = new SubCategoryandCategory() { categories = db.Categories.ToList(), subCategoryList = db.SubCategories.Select(x => x.Name).ToList(), status = statusmessage }; return(View(model)); }
public IActionResult Create() { ViewBag.Categories = new SelectList(db.Categories.ToList(), "Id", "Name"); SubCategoryandCategory model = new SubCategoryandCategory() { categories = db.Categories.ToList(), subCategoryList = db.SubCategories.Select(x => x.Name).ToList(), subCategory = new SubCategory() }; return(View(model)); }