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)));
}
