public bool SaveVacancyData(TMSVacancyViewModel Model, int UserId)
        {
            var data = _db.Vacancies.Where(x => x.Title == Model.Title && x.Id != Model.Id && x.Archived == false).ToList();

            if (data.Count < 0)
            {
                return(false);
            }
            else
            {
                DateTime StDate            = new DateTime();
                var      startDateToString = DateTime.ParseExact(Model.ClosingDate, inputFormat, CultureInfo.InvariantCulture);
                StDate = Convert.ToDateTime(startDateToString.ToString(outputFormat));
                if (Model.Id == 0)
                {
                    Vacancy save = new Vacancy();
                    save.Title                       = Model.Title;
                    save.Summary                     = Model.Summary;
                    save.StatusID                    = Model.StatusID;
                    save.ClosingDate                 = StDate;
                    save.RecruitmentProcessID        = Model.RecruitmentProcessID;
                    save.Salary                      = Model.Salary;
                    save.Location                    = Model.Location;
                    save.BusinessID                  = Model.BusinessID;
                    save.DivisionID                  = Model.DivisionID;
                    save.PoolID                      = Model.PoolID;
                    save.FunctionID                  = Model.FunctionID;
                    save.JobDescription              = Model.JobDescription;
                    save.HiringLeadID                = Model.HiringLeadID;
                    save.MustUploadCoverLetter       = Model.MustUploadCoverLetter;
                    save.MustUploadResumeCV          = Model.MustUploadResumeCV;
                    save.ApplicationFormPathOriginal = Model.ApplicationFormPathOriginal;
                    save.ApplicationFormPath         = Model.ApplicationFormPath;
                    save.Question1On                 = Model.Question1On;
                    save.Question1Text               = Model.Question1Text;
                    save.Question2On                 = Model.Question2On;
                    save.Question2Text               = Model.Question2Text;
                    save.Question3On                 = Model.Question3On;
                    save.Question3Text               = Model.Question3Text;
                    save.Question4On                 = Model.Question4On;
                    save.Question4Text               = Model.Question4Text;
                    save.Question5On                 = Model.Question5On;
                    save.Question5Text               = Model.Question5Text;
                    save.SourceID                    = Model.SourceID;
                    save.CreatedDate                 = DateTime.Now;
                    save.Archived                    = false;
                    save.IsReadVacancy               = false;
                    save.UserIDCreatedBy             = UserId;
                    save.UserIDLastModifiedBy        = UserId;
                    save.LastModified                = DateTime.Now;
                    _db.Vacancies.Add(save);
                    _db.SaveChanges();
                    return(true);
                }
                else
                {
                    var update = _db.Vacancies.Where(x => x.Id == Model.Id).FirstOrDefault();
                    update.Title                       = Model.Title;
                    update.Summary                     = Model.Summary;
                    update.StatusID                    = Model.StatusID;
                    update.ClosingDate                 = StDate;
                    update.RecruitmentProcessID        = Model.RecruitmentProcessID;
                    update.Salary                      = Model.Salary;
                    update.Location                    = Model.Location;
                    update.BusinessID                  = Model.BusinessID;
                    update.DivisionID                  = Model.DivisionID;
                    update.PoolID                      = Model.PoolID;
                    update.FunctionID                  = Model.FunctionID;
                    update.JobDescription              = Model.JobDescription;
                    update.HiringLeadID                = Model.HiringLeadID;
                    update.MustUploadCoverLetter       = Model.MustUploadCoverLetter;
                    update.MustUploadResumeCV          = Model.MustUploadResumeCV;
                    update.ApplicationFormPathOriginal = Model.ApplicationFormPathOriginal;
                    update.ApplicationFormPath         = Model.ApplicationFormPath;
                    update.Question1On                 = Model.Question1On;
                    update.Question1Text               = Model.Question1Text;
                    update.Question2On                 = Model.Question2On;
                    update.Question2Text               = Model.Question2Text;
                    update.Question3On                 = Model.Question3On;
                    update.Question3Text               = Model.Question3Text;
                    update.Question4On                 = Model.Question4On;
                    update.Question4Text               = Model.Question4Text;
                    update.Question5On                 = Model.Question5On;
                    update.Question5Text               = Model.Question5Text;
                    update.SourceID                    = Model.SourceID;
                    update.IsReadVacancy               = false;
                    update.IsRead                      = false;
                    update.UserIDLastModifiedBy        = UserId;
                    update.LastModified                = DateTime.Now;
                    _db.SaveChanges();
                    return(true);
                }
            }
        }
        public TMSApplicantViewModel returnApplicantList(int Id, int VacancyId)
        {
            TMSApplicantViewModel datamodel = new TMSApplicantViewModel();

            foreach (var item in _otherSettingMethod.getAllSystemValueListByKeyName("Gender List"))
            {
                datamodel.GenderList.Add(new SelectListItem()
                {
                    Text = item.Value, Value = item.Id.ToString()
                });
            }
            foreach (var item in _otherSettingMethod.getAllSystemValueListByKeyName("Vacancy Source List"))
            {
                datamodel.SourceList.Add(new SelectListItem()
                {
                    Text = item.Value, Value = item.Id.ToString()
                });
            }
            var data = _AdminTMSMethod.getVacancyDetailsById(VacancyId);

            datamodel.GenderName = datamodel.GenderList[0].Value;
            datamodel.DownloadApplicationFormLink = data.ApplicationFormPath;
            TMSVacancyViewModel vacancyDetailsModel = new TMSVacancyViewModel();

            vacancyDetailsModel.Id = data.Id;
            vacancyDetailsModel.MustUploadCoverLetter       = data.MustUploadCoverLetter;
            vacancyDetailsModel.MustUploadResumeCV          = data.MustUploadResumeCV;
            vacancyDetailsModel.ApplicationFormPathOriginal = data.ApplicationFormPathOriginal;
            vacancyDetailsModel.ApplicationFormPath         = data.ApplicationFormPath;
            vacancyDetailsModel.Question1On   = data.Question1On;
            vacancyDetailsModel.Question1Text = data.Question1Text;
            vacancyDetailsModel.Question2On   = data.Question2On;
            vacancyDetailsModel.Question2Text = data.Question2Text;
            vacancyDetailsModel.Question3On   = data.Question3On;
            vacancyDetailsModel.Question3Text = data.Question3Text;
            vacancyDetailsModel.Question4On   = data.Question4On;
            vacancyDetailsModel.Question4Text = data.Question4Text;
            vacancyDetailsModel.Question5On   = data.Question5On;
            vacancyDetailsModel.Question5Text = data.Question5Text;
            datamodel.VacancyDetails          = vacancyDetailsModel;
            if (data.RecruitmentProcessID != 0)
            {
                var res = _TMSSettingsMethod.getTMSSettingListById(data.RecruitmentProcessID);
                if (res.StepCSV != "1")
                {
                    var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(res.StepCSV);
                    if (steps != null)
                    {
                        foreach (var s in steps)
                        {
                            TMSSettingStepDetails ss = new TMSSettingStepDetails();
                            ss.Id        = s.Id;
                            ss.StepName  = s.StepName;
                            ss.ColorCode = s.ColorCode;
                            datamodel.StatusList.Add(ss);
                            if (s.StepName == "New Applicants")
                            {
                                datamodel.StatusID = s.Id;
                            }
                        }
                    }
                }
            }
            //DateTime today = DateTime.Now;
            //datamodel.DateOfBirth = String.Format("{0:dd-MM-yyyy}", today);
            return(datamodel);
        }