public async Task OnGetAsync(int?id) { UserData = new UserIndexData(); var users = _context.accUser .Include(i => i.UserZones) .ThenInclude(i => i.zone) //.ThenInclude(i => i.Terminals) .AsNoTracking(); if (!string.IsNullOrEmpty(SearchString)) { users = users.Where(s => s.FirstName.Contains(SearchString) || s.LastName.Contains(SearchString) || s.Uid.Contains(SearchString)); } UserData.Users = await users .OrderBy(i => i.LastName) .ToListAsync(); if (id != null) { UserID = id.Value; accUser user = UserData.Users .Where(i => i.idUser == id.Value).Single(); UserData.Zones = user.UserZones.Select(s => s.zone); } }
public async Task <IActionResult> Index(string id, int?IdRegion, int?IdTrail, int?IdShelter, int?IdParty) { var viewModel = new UserIndexData(); viewModel.Users = await _appDbContext.Users .Include(i => i.PermissionRegions) .ThenInclude(i => i.Region) .Include(i => i.PermissionTrails) .ThenInclude(i => i.Trail) .Include(i => i.PermissionShelters) .ThenInclude(i => i.Shelter) .Include(i => i.PermissionPartys) .ThenInclude(i => i.Party) .OrderBy(i => i.UserName) .ToListAsync(); if (id != null) { ViewData["IdUser"] = id; AppUser user = viewModel.Users.Where(i => i.Id == id).Single(); viewModel.Partys = user.PermissionPartys.Select(s => s.Party); viewModel.Regions = user.PermissionRegions.Select(s => s.Region); viewModel.Shelters = user.PermissionShelters.Select(s => s.Shelter); viewModel.Trails = user.PermissionTrails.Select(s => s.Trail); } /* * foreach(var user in _appDbContext.Users) * { * if(user.PermissionPartys == null) * { * user.PermissionPartys = new List<PermissionParty>(); * PopulateUser(user); * } * } * await _appDbContext.SaveChangesAsync(); */ /* * if(IdRegion != null) * { * ViewData["IdRegion"] = IdRegion.Value; * var selectedRegion = viewModel.Regions.Where(x => x.IdRegion == IdRegion).Single(); * * } */ return(View(viewModel)); }
public ActionResult UserList(int?id) { UserIndexData viewModel = new UserIndexData { Users = _db.Users .Include(u => u.Blogposts) .Include(u => u.Comments) .OrderBy(u => u.UserName) }; // Gets id from the details link in order to display details of a specific user from the list if (id != null) { ViewBag.UserId = id.Value; viewModel.Blogposts = viewModel.Users.Single(u => u.BlogpostId == id.Value).Blogposts; } return(View("~/Views/Account/UserList.cshtml", viewModel)); }
public async Task OnGetAsync(int?id) { UserData = new UserIndexData(); UserData.Users = await _context.Users .Include(i => i.UsersRoles) .ThenInclude(i => i.Role) .OrderBy(i => i.LoginName) .ToListAsync() ; if (id != null) { UserID = id.Value; User User = UserData.Users .Where(i => i.UserId == id.Value).Single(); UserData.Roles = User.UsersRoles.Select(s => s.Role); } }