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... "); }
public async Task <IActionResult> PutJobPosting(int id, JobPosting jobPosting) { if (id != jobPosting.Id) { return(BadRequest()); } JobPosting returnedJobPosting = await _JobPostingRepository.Put(id, jobPosting); if (returnedJobPosting != null) { return(Ok()); } return(BadRequest()); }