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