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