public async Task <GoalDto> Handle(GetGoalByIdQuery request, CancellationToken cancellationToken) { using var connection = new SqlConnection(_connectionStringProvider.ConnectionString); connection.Open(); return(await connection.QueryFirstOrDefaultAsync <GoalDto>(sql, new { request.Id })); }
public async Task <IActionResult> GetGoalAsync(Guid id) { var query = new GetGoalByIdQuery() { Id = id }; var goal = await _mediator.Send(query); if (goal == null) { return(NotFound()); } return(Ok(goal)); }