public async Task <IActionResult> GetAll([FromQuery] PaginationRequest paginationRequest) { var paginationFilter = mapper.Map <PaginationFilter>(paginationRequest); var query = new GetAppointmentsListQuery(paginationFilter); var result = await mediator.Send(query); var pagedResponse = PaginationService .CreatePaginatedResponse(uriService, paginationFilter, result); return(Ok(pagedResponse)); }
public async Task <List <AppointmentListModel> > Handle(GetAppointmentsListQuery request, CancellationToken cancellationToken) { var sql = @"select A.Id, A.AppointmentType, A.StartsAt, C.CandidateName_FirstName + ' ' + C.CandidateName_LastName as CandidateName, V.Title as VacancyTitle from Appointments as A join Candidates as C on A.CandidateId = C.Id join Vacancies as V on A.VacancyId = V.Id order by A.StartsAt desc"; using (var conn = new SqlConnection(_connectionString.Value)) { var dbResult = await conn.QueryAsync <AppointmentListModel>(sql); return(dbResult.ToList()); } }
public async Task <ListModel <AppointmentModel> > Handle(GetAppointmentsListQuery request, CancellationToken cancellationToken) { var defaultSort = BuildSortList <Appointment>(i => i.AppointmentId); return(await RetrieveListResults <Appointment, AppointmentModel>(null, defaultSort, request, cancellationToken)); }
public async Task <ActionResult <ListModel <AppointmentModel> > > GetAll([FromQuery] GetAppointmentsListQuery request) { return(Ok(await Mediator.Send(request))); }