public async Task <IActionResult> GetDistinctJudgeNamesAsync()
{
_logger.LogDebug("GetDistinctJudgeNames");
var query = new GetDistinctJudgeListByFirstNameQuery();
var judgeFirstNames = await _queryHandler.Handle <GetDistinctJudgeListByFirstNameQuery, List <string> >(query);
return(Ok(new JudgeNameListResponse {
FirstNames = judgeFirstNames
}));
}
public async Task <List <string> > Handle(GetDistinctJudgeListByFirstNameQuery query)
{
var participants = await _context.Participants
.AsNoTracking()
.Where(p => p.UserRole == UserRole.Judge && !string.IsNullOrEmpty(p.FirstName))
.Where(p => !p.Username.Contains("@hmcts.net1") && !p.Username.Contains("@email.net"))
.Select(x => x.FirstName)
.Distinct()
.ToListAsync();
return(participants);
}
