public async Task <IActionResult> Vacancies(Guid client)
{
var cmd = new GetVacancyListQuery(client);
var result = await _mediator.Send(cmd);
ViewBag.Client = client;
return(View(result));
}
public async Task <List <VacancyListModel> > Handle(GetVacancyListQuery request, CancellationToken cancellationToken)
{
const string sql = @"select Id, Title, Description, OpenDate, CloseDate, ClientId from Vacancies where ClientId = @ClientId";
using (var connection = new SqlConnection(_connectionString.Value))
{
var dbResult = await connection.QueryAsync <VacancyListModel>(sql, new { request.ClientId });
return(dbResult.ToList());
}
}
