public ActionResult EditCrewRol(Models.CrewRolModel model) { if (ModelState.IsValid) { try { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var queryCetification = (from p in _dbContext.T_CrewRoles where p.vCrewRoleName == model.crewRoleName select p).FirstOrDefault(); queryCetification.vCrewRoleDescription = model.crewRoleDescription; _dbContext.SaveChanges(); return(RedirectToAction("CrewRolesList", "Maintenance")); } catch (Exception error) { ModelState.AddModelError(string.Empty, error.Message); return(View()); } } return(View()); }
public ActionResult CreateCrewRol(Models.CrewRolModel model) { if (ModelState.IsValid) { try { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var existCrewRole = (from p in _dbContext.T_CrewRoles where p.vCrewRoleName == model.crewRoleName select p).FirstOrDefault(); if (existCrewRole != null) { ModelState.AddModelError(string.Empty, "The crew role already exist"); return(View()); } var queryCrewRole = (from p in _dbContext.AspNetRoles where p.Name == "CrewRole" select p).FirstOrDefault(); JneCommSitesDataLayer.T_CrewRoles newCrewRole = new JneCommSitesDataLayer.T_CrewRoles(); newCrewRole.vCrewRoleName = model.crewRoleName; newCrewRole.vCrewRoleDescription = model.crewRoleDescription; newCrewRole.Id = queryCrewRole.Id; _dbContext.T_CrewRoles.Add(newCrewRole); _dbContext.SaveChanges(); return(RedirectToAction("CrewRolesList", "Maintenance")); } catch (Exception error) { ModelState.AddModelError(string.Empty, error.Message); return(View()); } } return(View()); }