public async Task <IList <ApplicationUser> > GetUsersForClaimAsync(Claim claim, CancellationToken cancellationToken) { cancellationToken.ThrowIfCancellationRequested(); var getUsersForClaimDto = new GetUsersForClaimDto { ClaimType = claim.Type, ClaimValue = claim.Value }; var usersDto = await _userRepository.GetUsersForClaim(getUsersForClaimDto); var applicationUsers = _mapper.Map <IList <ApplicationUser> >(usersDto); return(applicationUsers); }
public async Task <IList <UserDto> > GetUsersForClaim(GetUsersForClaimDto getUsersForClaimDto) { const string query = @" SELECT [u].* FROM [Users] [u] INNER JOIN [UserClaims] [uc] ON [u].[Id] = [uc].[UserId] WHERE [uc].[ClaimType] = @ClaimType AND [uc].[ClaimValue] = @ClaimValue "; using (var connection = _dbConnectionFactory.GetDbConnection()) { var users = await connection.QueryAsync <User>(query, getUsersForClaimDto); var usersDto = _mapper.Map <IList <UserDto> >(users); return(usersDto); } }