public ActionResult Create([Bind(Include = "ApproachRouteId,RouteName")] ApproachRoute approachRoute) { if (ModelState.IsValid) { db.ApproachRoutes.Add(approachRoute); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(approachRoute)); }
public ActionResult Create([Bind(Include = "RouteDetailID,ApproachRouteId,ApproachOrder,ApproachID")] ApproachRouteDetail approachRouteDetail) { if (ModelState.IsValid) { db.ApproachRouteDetails.Add(approachRouteDetail); db.SaveChanges(); return(RedirectToAction("Index", new { id = approachRouteDetail.ApproachRouteId })); } ViewBag.ApproachID = new SelectList(db.Approaches, "ApproachID", "ApproachRouteDescription", approachRouteDetail.ApproachID); ViewBag.ApproachRouteId = new SelectList(db.ApproachRoutes, "ApproachRouteId", "RouteName", approachRouteDetail.ApproachRouteId); return(View(approachRouteDetail)); }
public ActionResult Edit(Models.UserViewModel sPMUser) { if (ModelState.IsValid) { SPMUser user; using (var context = new MOE.Common.Models.SPM()) { try { var userStore = new UserStore <SPMUser>(context); var userManager = new UserManager <SPMUser>(userStore); user = userManager.Users.Where(u => u.Id == sPMUser.User.Id).FirstOrDefault(); user.ReceiveAlerts = sPMUser.User.ReceiveAlerts; user.Email = sPMUser.User.Email; user.UserName = sPMUser.User.Email; context.SaveChanges(); } catch (Exception ex) { return(Content("<h1>" + ex.Message + "</h1>")); } } return(RedirectToAction("Index")); } return(View(sPMUser)); }
public ActionResult AddRoleToUser(string roleName, string userName) { using (var context = new MOE.Common.Models.SPM()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var userStore = new UserStore <SPMUser>(context); var userManager = new UserManager <SPMUser>(userStore); var user = userManager.FindByName(userName); if (user == null) { return(Content("User not found")); } var role = roleManager.FindByName(roleName); if (role == null) { return(Content("Role not found")); } if (userManager.IsInRole(user.Id, role.Name)) { return(Content("This user already has this role assigned")); } userManager.AddToRole(user.Id, role.Name); context.SaveChanges(); return(Content("Role Added")); } }
public ActionResult RemoveRoleFromUser(string roleName, string userName) { using (var context = new MOE.Common.Models.SPM()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var userStore = new UserStore <SPMUser>(context); var userManager = new UserManager <SPMUser>(userStore); var user = userManager.FindByName(userName); if (user == null) { return(Content("User not found")); } var role = roleManager.FindByName(roleName); if (role == null) { return(Content("Role not found")); } if (!userManager.IsInRole(user.Id, role.Name)) { return(Content("This user does not have this role assigned")); } else { userManager.RemoveFromRole(user.Id, role.Name); context.SaveChanges(); return(Content("Role Removed")); } } }
public ActionResult RoleCreate(string roleName) { using (var context = new MOE.Common.Models.SPM()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); roleManager.Create(new IdentityRole(roleName)); context.SaveChanges(); } ViewBag.ResultMessage = "Role created successfully !"; return(RedirectToAction("RoleIndex", "Account")); }
public ActionResult DeleteRoleForUser(string userName, string roleName) { List <string> userRoles; List <string> roles; List <string> users; using (var context = new MOE.Common.Models.SPM()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); roles = (from r in roleManager.Roles select r.Name).ToList(); var userStore = new UserStore <SPMUser>(context); var userManager = new UserManager <SPMUser>(userStore); users = (from u in userManager.Users select u.UserName).ToList(); var user = userManager.FindByName(userName); if (user == null) { throw new Exception("User not found!"); } if (userManager.IsInRole(user.Id, roleName)) { userManager.RemoveFromRole(user.Id, roleName); context.SaveChanges(); ViewBag.ResultMessage = "Role removed from this user successfully !"; } else { ViewBag.ResultMessage = "This user doesn't belong to selected role."; } var userRoleIds = (from r in user.Roles select r.RoleId); userRoles = (from id in userRoleIds let r = roleManager.FindById(id) select r.Name).ToList(); } ViewBag.RolesForThisUser = userRoles; ViewBag.Roles = new SelectList(roles); ViewBag.Users = new SelectList(users); return(View("RoleAddToUser")); }
public ActionResult RoleAddToUser(string roleName, string userName) { List <string> roles; List <string> users; using (var context = new MOE.Common.Models.SPM()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var userStore = new UserStore <SPMUser>(context); var userManager = new UserManager <SPMUser>(userStore); users = (from u in userManager.Users select u.UserName).ToList(); var user = userManager.FindByName(userName); if (user == null) { throw new Exception("User not found!"); } var role = roleManager.FindByName(roleName); if (role == null) { throw new Exception("Role not found!"); } if (userManager.IsInRole(user.Id, role.Name)) { ViewBag.ResultMessage = "This user already has the role specified !"; } else { userManager.AddToRole(user.Id, role.Name); context.SaveChanges(); ViewBag.ResultMessage = "Username added to the role succesfully !"; } roles = (from r in roleManager.Roles select r.Name).ToList(); } ViewBag.Roles = new SelectList(roles); ViewBag.Users = new SelectList(users); return(View()); }
public static void PopulateApproachesWithDetectors(MOE.Common.Models.SPM db) { foreach (var signal in db.Signals) { signal.Approaches = (from r in db.Approaches where r.VersionID == signal.VersionID select r).ToList(); int i = 1; foreach (var appr in signal.Approaches) { MOE.Common.Models.Detector a = new Detector() { ApproachID = appr.ApproachID, DetChannel = appr.ProtectedPhaseNumber, DetectionHardwareID = 1, DateAdded = DateTime.Today, LaneNumber = 1, MovementTypeID = 1, DetectorID = appr.SignalID + "00" + appr.ProtectedPhaseNumber.ToString(), }; db.Detectors.Add(a); i++; } } try { db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } }
public void PopulateSignal(MOE.Common.Models.SPM db) { for (int i = 1; i < 6; i++) { MOE.Common.Models.Signal s = new Signal(); s.SignalID = "10" + i.ToString(); s.Start = s.FirstDate; s.PrimaryName = "Primary: " + i.ToString(); s.SecondaryName = "Secondary: " + i.ToString(); s.Note = "Create Dummy"; s.IPAddress = "10.10.10.10"; s.Latitude = "0.01"; s.Longitude = "0.01"; s.ControllerTypeID = 1; s.RegionID = 1; s.Enabled = true; s.VersionActionId = 10; db.Signals.Add(s); } try { db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } }
public void PopulateSignalsWithApproaches(MOE.Common.Models.SPM db) { int i = 1; foreach (var s in db.Signals) { Approach a = new Approach { ApproachID = (s.VersionID * 1020) + 1, Description = "NB Approach for Signal " + s.SignalID, DirectionType = (from r in db.DirectionTypes where r.Abbreviation == "NB" select r).FirstOrDefault(), ProtectedPhaseNumber = 2, SignalID = s.SignalID, MPH = 40, VersionID = s.VersionID, Signal = s }; db.Approaches.Add(a); Approach b = new Approach { ApproachID = (s.VersionID * 1040) + 1, Description = "SB Approach for Signal " + s.SignalID, DirectionType = (from r in db.DirectionTypes where r.Abbreviation == "SB" select r).FirstOrDefault(), ProtectedPhaseNumber = 4, SignalID = s.SignalID, MPH = 40, VersionID = s.VersionID, Signal = s }; db.Approaches.Add(b); Approach c = new Approach { ApproachID = (s.VersionID * 1060) + 1, Description = "SB Approach for Signal " + s.SignalID, DirectionType = (from r in db.DirectionTypes where r.Abbreviation == "EB" select r).FirstOrDefault(), ProtectedPhaseNumber = 6, SignalID = s.SignalID, MPH = 40, VersionID = s.VersionID, Signal = s }; db.Approaches.Add(c); Approach d = new Approach { Description = "SB Approach for Signal " + s.SignalID, DirectionType = (from r in db.DirectionTypes where r.Abbreviation == "WB" select r).FirstOrDefault(), ProtectedPhaseNumber = 8, SignalID = s.SignalID, MPH = 40, VersionID = s.VersionID, Signal = s }; db.Approaches.Add(d); i++; } try { db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } }