public List <Users> GetUsersByRole(string roleId)
{
var users = (from u in UserRepository.All()
join r in UserRoleRepository.All() on u.Id equals r.UserId
where r.RoleId == roleId
select u).ToList();
return(users);
}
public List <UserDTO> GetUsers()
{
var users = (from u in UserRepository.All()
join ur in UserRoleRepository.All() on u.Id equals ur.UserId
join r in RoleRepository.All() on ur.RoleId equals r.Id
select new UserDTO
{
UserName = u.UserName,
RoleName = r.Name,
Email = u.Email,
Id = u.Id
}).ToList();
return(users);
}
public List <User> getReviewers()
{
return(userRepo.All().Where(user => userRoleRepo.All().Where(role => role.RoleId == roleRepository.getBySlug("reviewer").RoleId).ToList().Where(userRole => userRole.UserId == user.UserId).ToList().Count > 0).ToList());
}
public override IQueryable <UserRole> All(bool canUseCacheIfPossible = true)
{
return(_userRoleRepository.All());
}