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