public async Task <IEnumerable <CoachDto> > HandleAsync(GetCoachesQuery query)
{
return(await _dbContext.Coaches.Select(c => new CoachDto()
{
Id = c.Id,
Name = c.Name,
Surname = c.Surname
}).ToListAsync());
}
public async Task <ActionResult> GetCoaches()
{
var query = new GetCoachesQuery();
var result = await _queryDispatcher.QueryAsync <IEnumerable <CoachDto> >(query);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public async Task <List <CoachWithEmailViewModel> > HandleAsync(GetCoachesQuery query, CancellationToken cancellationToken = default)
{
var sql = @"SELECT Id, Email FROM Core.Coaches";
using (var connection = new SqlConnection(databaseProvider.ConnectionStrings.DefaultConnection))
{
await connection.OpenAsync();
var result = await connection.QueryAsync <CoachWithEmailViewModel>(sql);
return(result.ToList());
}
}
