public int getCountByVacancyTotalAccepted(int vacId)
{
int cnt = 0;
var t = _db.TMS_Applicant.Where(x => x.VacancyID == vacId).ToList();
foreach (var data in t)
{
var vacData = _db.Vacancies.Where(x => x.Id == data.VacancyID).FirstOrDefault();
var RecData = _db.TMS_Setting_RecruitmentProcesses.Where(x => x.Id == vacData.RecruitmentProcessID).FirstOrDefault();
if (RecData.StepCSV != null)
{
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(RecData.StepCSV);
if (steps != null)
{
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
if (s.Id == data.StatusID)
{
if (s.StepName == "Accepted")
{
ss.Id = s.Id;
cnt = cnt + 1;
}
}
}
}
}
}
return(cnt);
}
public ActionResult AddStep(TMSSettingsViewModel model)
{
var id = 0;
List <TMSSettingStepDetails> listdata = new List <TMSSettingStepDetails>();
List <TMSSettingCompetencyDetails> listcompet = new List <TMSSettingCompetencyDetails>();
TMSSettingsViewModel datamodel = returnList(id, listdata, listcompet);
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(model.StepCSV).OrderBy(x => x.SortId);
if (steps.Count() == 0)
{
model.stepCount = 4;
}
else
{
model.stepCount = steps.Count();
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
ss.SortId = s.SortId;
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
model.StepList.Add(ss);
}
}
return(PartialView("_partialAddEditTMSSetting", model));
}
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);
}
public List <TMSSettingStepDetails> UpdateStepMove(string AllStepSegmentJsonm, int SortId, int RecId, int flagUpDown)
{
List <TMSSettingStepDetails> StepsAdd = new List <TMSSettingStepDetails>();
if (flagUpDown == 0)
{
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(AllStepSegmentJsonm);
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
int Totalstep = steps.Count();
int srt = SortId + 1;
if (s.SortId == SortId + 1 && srt != Totalstep)
{
ss.SortId = SortId;
}
else if (s.SortId == SortId && srt != Totalstep)
{
ss.SortId = SortId + 1;
}
else
{
ss.SortId = s.SortId;
}
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
StepsAdd.Add(ss);
}
return(StepsAdd.ToList());
}
//1=Up
else if (flagUpDown == 1)
{
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(AllStepSegmentJsonm);
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
int srt = SortId - 1;
if (s.SortId == srt && srt != 0)
{
ss.SortId = SortId;
}
else if (s.SortId == SortId && srt != 0)
{
ss.SortId = SortId - 1;
}
else
{
ss.SortId = s.SortId;
}
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
StepsAdd.Add(ss);
}
return(StepsAdd.ToList());
}
return(StepsAdd.ToList());
}
public bool UpdateStepMoveOfRecProcess(string AllStepSegmentJsonm, int SortId, int RecId, int flagUpDown)
{
//0=Down
if (flagUpDown == 0)
{
if (RecId != 0)
{
var res = _db.TMS_Setting_RecruitmentProcesses.Where(x => x.Id == RecId && x.Archived == false).FirstOrDefault();
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(AllStepSegmentJsonm);
//var steps = JsonConvert.DeserializeObject<List<TMSSettingStepDetails>>(res.StepCSV);
List <TMSSettingStepDetails> StepsAdd = new List <TMSSettingStepDetails>();
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
int Totalstep = steps.Count();
int srt = SortId + 1;
if (s.SortId == SortId + 1 && srt != Totalstep)
{
ss.SortId = SortId;
}
else if (s.SortId == SortId && srt != Totalstep)
{
ss.SortId = SortId + 1;
}
else
{
ss.SortId = s.SortId;
}
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
StepsAdd.Add(ss);
}
var ConvertJsonStepCSV = JsonConvert.SerializeObject(StepsAdd);
res.StepCSV = ConvertJsonStepCSV;
res.LastModified = DateTime.Now;
_db.SaveChanges();
}
}
//1=Up
else if (flagUpDown == 1)
{
if (RecId != 0)
{
var res = _db.TMS_Setting_RecruitmentProcesses.Where(x => x.Id == RecId && x.Archived == false).FirstOrDefault();
//var steps = JsonConvert.DeserializeObject<List<TMSSettingStepDetails>>(res.StepCSV);
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(AllStepSegmentJsonm);
List <TMSSettingStepDetails> StepsAdd = new List <TMSSettingStepDetails>();
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
int srt = SortId - 1;
if (s.SortId == srt && srt != 0)
{
ss.SortId = SortId;
}
else if (s.SortId == SortId && srt != 0)
{
ss.SortId = SortId - 1;
}
else
{
ss.SortId = s.SortId;
}
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
StepsAdd.Add(ss);
}
var ConvertJsonStepCSV = JsonConvert.SerializeObject(StepsAdd);
res.StepCSV = ConvertJsonStepCSV;
res.LastModified = DateTime.Now;
_db.SaveChanges();
}
}
return(true);
}
public TMSSettingsViewModel returnList(int Id, List <TMSSettingStepDetails> listdata, List <TMSSettingCompetencyDetails> listcompet)
{
TMSSettingsViewModel model = new TMSSettingsViewModel();
var listData = _TMSSettingsMethod.getAllTMSSettingList();
if (listData.Count > 0)
{
foreach (var item in listData)
{
TMSSettingAllDetailsViewModel datamodel = new TMSSettingAllDetailsViewModel();
datamodel.Id = item.Id;
datamodel.Name = item.Name;
model.stepCount = 4;
model.TMSSettingSaveList.Add(datamodel);
}
}
else
{
model.stepCount = 4;
}
if (Id == 0)
{
model.Id = Id;
if (listdata.Count > 0)
{
foreach (var s in listdata)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
ss.SortId = s.SortId;
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
model.StepList.Add(ss);
}
}
else
{
var JsonStepCsv = "[{'Id':1,'SortId':1,'StepName':'Rejected','ColorCode':'#CC4400'},{ 'Id':2,'SortId':2,'StepName':'Talent Pool','ColorCode':'#FF9900'},{ 'Id':3,'SortId':3,'StepName':'New Applicants','ColorCode':'#00CCFF'},{ 'Id':4,'SortId':4,'StepName':'Accepted','ColorCode':'#00CC00'}]";
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(JsonStepCsv);
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
ss.SortId = s.SortId;
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
model.StepList.Add(ss);
}
}
if (listcompet.Count > 0)
{
foreach (var s in listcompet)
{
TMSSettingCompetencyDetails ss = new TMSSettingCompetencyDetails();
ss.Id = s.Id;
ss.SortId = s.SortId;
ss.CompetencyName = s.CompetencyName;
model.CompentecyList.Add(ss);
}
}
}
else
{
var listDatas = _TMSSettingsMethod.getTMSSettingListById(Id);
model.Id = listDatas.Id;
model.Name = listDatas.Name;
if (listDatas.StepCSV != null)
{
var steps = JsonConvert.DeserializeObject <List <TMSSettingStepDetails> >(listDatas.StepCSV).OrderBy(x => x.SortId);
if (steps.Count() == 0)
{
model.stepCount = 4;
}
else
{
model.stepCount = steps.Count();
foreach (var s in steps)
{
TMSSettingStepDetails ss = new TMSSettingStepDetails();
ss.Id = s.Id;
ss.SortId = s.SortId;
ss.StepName = s.StepName;
ss.ColorCode = s.ColorCode;
model.StepList.Add(ss);
}
}
}
if (listDatas.StepCSV != null)
{
var competency = JsonConvert.DeserializeObject <List <TMSSettingCompetencyDetails> >(listDatas.CompetencyCSV);
if (competency.Count > 0)
{
foreach (var c in competency)
{
TMSSettingCompetencyDetails com = new TMSSettingCompetencyDetails();
com.Id = c.Id;
com.SortId = c.SortId;
com.CompetencyName = c.CompetencyName;
com.Description = c.Description;
model.CompentecyList.Add(com);
}
}
}
else
{
var competency = JsonConvert.DeserializeObject <List <TMSSettingCompetencyDetails> >(listDatas.CompetencyCSV);
if (competency.Count > 0)
{
foreach (var c in competency)
{
TMSSettingCompetencyDetails com = new TMSSettingCompetencyDetails();
com.Id = c.Id;
com.SortId = c.SortId;
com.CompetencyName = c.CompetencyName;
com.Description = c.Description;
model.CompentecyList.Add(com);
}
}
}
}
return(model);
}
