public async Task <IActionResult> Index()
{
var cmd = new GetCandidateListQuery();
var result = await _mediator.Send(cmd);
return(View(result));
}
public async Task <List <CandidateListVm> > Handle(
GetCandidateListQuery request,
CancellationToken cancellationToken)
{
var allCandidates = await _candidateRepository.GetCandidatesWithInclude();
var checkMapping = _mapper.Map <List <CandidateListVm> >(allCandidates);
return(checkMapping);
}
public async Task <IActionResult> GetCandidates([FromQuery] ResourceParameters resourceParameters)
{
var query = new GetCandidateListQuery()
{
ResourceParameters = resourceParameters
};
var candidates = await _mediator.Send(query);
return(Ok(candidates));
}
public async Task <List <CandidateListModel> > Handle(GetCandidateListQuery request, CancellationToken cancellationToken)
{
var sql = @"select Id, (CandidateName_FirstName + ' ' + CandidateName_LastName) as [Name], Birthday, CurrentPosition, Note from candidates";
using (var conn = new SqlConnection(_connectionString.Value))
{
var dbData = await conn.QueryAsync <CandidateListModel>(sql);
return(dbData.ToList());
}
}
