public async Task <IActionResult> Create(EjeAndCategoryViewModel model) { if (ModelState.IsValid) { var EjeExist = _db.Eje.Include(s => s.Category).Where(s => s.Name == model.Eje.Name && s.CategoryID == model.Eje.CategoryID); if (EjeExist.Count() > 0) { StatusMessage = "Error: Este Eje ya ha sido creado en la Categoria " + EjeExist.First().Category.Name + " Por favor, use otro nombre"; } else { _db.Eje.Add(model.Eje); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } EjeAndCategoryViewModel modelVM = new EjeAndCategoryViewModel() { CategoryList = await _db.Category.ToListAsync(), Eje = model.Eje, EjeList = await _db.Eje.OrderBy(p => p.Name).Select(p => p.Name).ToListAsync(), StatusMessage = StatusMessage }; return(View(modelVM)); }
//GET - CREATE public async Task <IActionResult> Create() { EjeAndCategoryViewModel model = new EjeAndCategoryViewModel() { CategoryList = await _db.Category.ToListAsync(), Eje = new Models.Eje(), EjeList = await _db.Eje.OrderBy(p => p.Name).Select(p => p.Name).Distinct().ToListAsync() }; return(View(model)); }
//GET - DELETE //GET - DETAILS public async Task <IActionResult> Details(int?Id) { if (Id == null) { return(NotFound()); } var eje = await _db.Eje.SingleOrDefaultAsync(m => m.Id == Id); if (eje == null) { return(NotFound()); } EjeAndCategoryViewModel model = new EjeAndCategoryViewModel() { CategoryList = await _db.Category.ToListAsync(), Eje = eje, EjeList = await _db.Eje.OrderBy(p => p.Name).Select(p => p.Name).Distinct().ToListAsync() }; return(View(model)); }