public async Task <IActionResult> Requirements(Guid client, Guid vacancy)
{
ViewBag.Vacancy = vacancy;
ViewBag.Client = client;
var cmd = new GetRequirementListQuery(vacancy);
var result = await _mediator.Send(cmd);
return(View(result));
}
public async Task <List <RequirementListModel> > Handle(GetRequirementListQuery request, CancellationToken cancellationToken)
{
var sql = @"select Id, SkillType, RequirementType, Content, VacancyId from Requirements where VacancyId = @VacancyId";
using (var connection = new SqlConnection(_connectionString.Value))
{
var dbData = await connection.QueryAsync <RequirementListModel>(sql, new { request.VacancyId });
return(dbData.ToList());
}
}
