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