public ActionResult AddNew(AddCorridorVM vm)
{
using (var context = new Jacobs_PlayPenEntities())
{
var corridor = new Corridor();
corridor.Description = vm.corridorDescription;
corridor.Name = vm.corridorName;
context.Corridors.Add(corridor);
context.SaveChanges();
foreach (var detector in vm.detectorNumbers)
{
try
{
var id = context.Detectors.Where(x => x.det_num == detector).FirstOrDefault().ID;
var corridorDetector = new CorridorDetector();
corridorDetector.detectorId = id;
corridorDetector.corridorId = corridor.id;
context.CorridorDetectors.Add(corridorDetector);
}
catch (Exception ex)
{
throw;
}
}
context.SaveChanges();
return(Json(corridor, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteUser([DataSourceRequest] DataSourceRequest request, UserViewModel ur)
{
using (var context = new Jacobs_PlayPenEntities())
{
var user = context.ApplicationUsers.Include("ApplicationRole").Where(x => x.domainName == ur.domainName).FirstOrDefault();
var entry = context.Entry(user);
if (entry.State == EntityState.Detached)
{
context.ApplicationUsers.Attach(user);
}
context.ApplicationUsers.Remove(user);
context.SaveChanges();
return(Json(new[] { user }.ToDataSourceResult(request, ModelState)));
}
}
public ActionResult CreateUser([DataSourceRequest] DataSourceRequest request, UserViewModel ur)
{
using (var context = new Jacobs_PlayPenEntities())
{
var user = new ApplicationUser();
user.RoleId = ur.roleId;
user.domainName = ur.domainName;
var entry = context.Entry(user);
if (entry.State == EntityState.Detached)
{
context.ApplicationUsers.Attach(user);
}
context.ApplicationUsers.Add(user);
context.SaveChanges();
return(Json(new[] { user }.ToDataSourceResult(request, ModelState)));
}
}
public ActionResult UpdateUser([DataSourceRequest] DataSourceRequest request, UserViewModel ur)
{
using (var context = new Jacobs_PlayPenEntities())
{
context.Configuration.ProxyCreationEnabled = false;
var user = context.ApplicationUsers.Include("ApplicationRole").Where(x => x.domainName == ur.domainName).FirstOrDefault();
user.RoleId = ur.roleId;
var newRole = context.ApplicationRoles.Where(x => x.id == ur.roleId).FirstOrDefault();
ur.roleName = newRole.name;
var entry = context.Entry(user);
if (entry.State == EntityState.Detached)
{
context.ApplicationUsers.Attach(user);
}
context.SaveChanges();
return(Json(new[] { ur }.ToDataSourceResult(request, ModelState)));
}
}
