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());
}
