public async Task RunAtTimeOf(DateTime now) { var config = _ctx.JobGettingConfig.FirstOrDefault(); if (config == null) { return; } _logger.LogInformation("SummaryGeneratorJob Starts... "); string connectionString = Secrets.GetDBConnectionString(_configuration); using (MySqlConnection connection = new MySqlConnection(connectionString)) { // Create the Command and Parameter objects. MySqlCommand command = new MySqlCommand(@" SELECT Id, Description FROM `jobtransparency`.`JobPostings` WHERE Description = '' ", connection); command.CommandTimeout = config.SQLCommandTimeOut; try { connection.Open(); var reader = await command.ExecuteReaderAsync(); while (reader.Read()) { var Id = (int)reader[0]; var Description = (string)reader[1]; Description = new string(Description.Where(c => !char.IsPunctuation(c)).ToArray()); SummaryDTO nltkSummary = await _nltkService.ExtractSummary(Description); var Job = await _jobPostingRepository.GetById(Id); Job.Summary = nltkSummary.SummaryText; await _jobPostingRepository.Put(Job.Id, Job); } reader.Close(); } catch (Exception ex) { _logger.LogInformation(ex, "SummaryGeneratorJob Ends... "); } } _logger.LogInformation("SummaryGeneratorJob Ends... "); }
// GET: JobPostings/Details/5 public async Task <IActionResult> Details(int id) { JobPosting jobPosting = await _jobPostingRepository.GetById(id); if (jobPosting == null) { return(NotFound()); } jobPosting = await _jobPostingRepository.IncrementNumberOfViews(jobPosting); return(View(new JobPostingDetailViewModel() { CurrentJobPosting = jobPosting, })); }
public async Task <ActionResult <JobPosting> > GetJobPosting(int id) { JobPosting jobposting = await _JobPostingRepository.GetById(id); return(jobposting); }