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