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