public async Task <IActionResult> GetRunners()
{
var query = new GetRunnersQuery();
var result = await queryDispatcher.ExecuteAsync(query);
return(Ok(result));
}
public List <RunnerModel> Handle(GetRunnersQuery query)
{
try
{
var runners = _context.Runners.Select(model => new RunnerModel
{
IsAllowed = model.IsAllowed,
DeviceName = model.DeviceName,
LastAction = model.LastAction,
Id = model.Id,
CreateDate = model.CreateDate
}).ToList();
return(runners);
}
catch (Exception)
{
return(null);
}
}
public async Task <IEnumerable <RunnerViewModel> > HandleAsync(GetRunnersQuery query, CancellationToken cancellationToken = default)
{
var coachId = httpContext.HttpContext.User.FindFirst(ClaimTypes.NameIdentifier)?.Value;
var sql = @"SELECT [Id],
[FirstName],
[LastName],
[Email]
FROM [Core].[Runners]
WHERE [CoachId] = @coachId";
using (var connection = new SqlConnection(databaseProvider.ConnectionStrings.DefaultConnection))
{
connection.Open();
var runners = await connection.QueryAsync <RunnerViewModel>
(sql, new { coachId });
return(await connection.QueryAsync <RunnerViewModel>(sql, new { coachId }));
}
}
