Help - List out all Users with his Roles #367

1 Answer(s)

• 

  0

  hole7 created 8 years ago

  Finally, I found the way to solve this.

  var queryUsers = _userRepository.GetAll().Include(u => u.Roles)
                                              .OrderBy(input.Sorting)
                                              .PageBy(input);
  
              var items = (from u in queryUsers
                           join ur in queryUsers.SelectMany(x => x.Roles) on u.Id equals ur.UserId
                           join r in _roleRepository.GetAll() on ur.RoleId equals r.Id
                           group new { u, ur, r } by new
                           {
                               u.Id,
                               u.UserName,
                               u.Name,
                               u.Surname,
                               u.EmailAddress,
                               u.IsEmailConfirmed,
                               u.IsActive,
                               u.LastLoginTime,
                               u.CreationTime
                           } into g
                           select new UserDto()
                           {
                               Id = g.Key.Id,
                               UserName = g.Key.UserName,
                               Name = g.Key.Name,
                               Surname = g.Key.Surname,
                               EmailAddress = g.Key.EmailAddress,
                               IsEmailConfirmed = g.Key.IsEmailConfirmed,
                               IsActive = g.Key.IsActive,
                               LastLoginTime = g.Key.LastLoginTime,
                               CreationTime = g.Key.CreationTime,
                               Roles = g.Select(x => new UserRoleDto()
                               {
                                   RoleId = x.r.Id,
                                   RoleName = x.r.DisplayName
                               }).ToList()
                           }).ToList();
  

  Save Cancel