public async Task <IActionResult> CreateJobTitle(JobTitleFormModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
await this.hrService.CreateJobTitleAsync(model.Title, model.Description);
TempData.AddSuccessMessage($"The '{model.Title} Job Title' successfully created.");
return(RedirectToAction(
nameof(HRController.Employees),
"HR",
new { area = $"{AdminConstants.HR_AREA}", page = 1 }));
}
public void UpdateJobs()
{
var excel = new ExcelQueryFactory();
string[] ex_names = MvcApplication.Config("excel_name").Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int ex_name = 0; ex_name < ex_names.Length; ex_name++)
{
excel.FileName = ex_names[ex_name];
var result_employees = from c
in excel.WorksheetNoHeader(0)
select c;
List <JobTitle> existing_jobs = (List <JobTitle>)GetSession.QueryOver <JobTitle>().List();
List <string> existing_jobs_list = new List <string>();
foreach (var job in existing_jobs)
{
if (!existing_jobs_list.Contains(job.Name))
{
existing_jobs_list.Add(job.Name);
}
}
foreach (var new_job in result_employees)
{
if (!string.IsNullOrEmpty(new_job[8].ToString().Trim()) && !existing_jobs_list.Contains(new_job[8].ToString().Trim()))
{
JobTitleFormModel model = new JobTitleFormModel()
{
Name = new_job[8].ToString().Trim()
};
var item = Mapper.Map <JobTitleFormModel, JobTitle>(model);
GetSession.Save(item);
existing_jobs_list.Add(new_job[8].ToString().Trim());
}
}
}
}
