//edit job experience //for add new job experience of candidate public static int EditData(CandidateJobExperienceDTO Data) { using (DBEntities db = new DBEntities()) { int result = 0; TB_CANDIDATE_JOB_EXPERIENCE DataJob = db.TB_CANDIDATE_JOB_EXPERIENCE.FirstOrDefault(d => d.ID == Data.ID); if (DataJob != null) { DataJob.INDUSTRIES = Data.INDUSTRIES; DataJob.CANDIDATE_POSITION = Data.CANDIDATE_POSITION; DataJob.START_DATE = Data.START_DATE; DataJob.END_DATE = Data.END_DATE; DataJob.CURRENT_SALARY = Data.CURRENT_SALARY; DataJob.JOBDESC = Data.JOBDESC; DataJob.BENEFIT = Data.BENEFIT; DataJob.COMPANY_NAME = Data.COMPANY_NAME; DataJob.PROJCT = Data.PROJECT; DataJob.SKILL_NAME = Data.SKILL_NAME; result = db.SaveChanges(); } return(result); } }
//for add new job experience of candidate public static int AddData(CandidateJobExperienceDTO NewJobExp) { using (DBEntities db = new DBEntities()) { db.TB_CANDIDATE_JOB_EXPERIENCE.Add(new TB_CANDIDATE_JOB_EXPERIENCE { CANDIDATE_ID = NewJobExp.CANDIDATE_ID, INDUSTRIES = NewJobExp.INDUSTRIES, CANDIDATE_POSITION = NewJobExp.CANDIDATE_POSITION, START_DATE = NewJobExp.START_DATE, END_DATE = NewJobExp.END_DATE, CURRENT_SALARY = NewJobExp.CURRENT_SALARY, JOBDESC = NewJobExp.JOBDESC, BENEFIT = NewJobExp.BENEFIT, COMPANY_NAME = NewJobExp.COMPANY_NAME, PROJCT = NewJobExp.PROJECT }); if (db.SaveChanges() > 0) { if (NewJobExp.SKILL_NAME != null || NewJobExp.SKILL_NAME != "" || NewJobExp.BENEFIT != null || NewJobExp.BENEFIT != "") { TB_CANDIDATE_JOB_EXPERIENCE DataJobExp = db.TB_CANDIDATE_JOB_EXPERIENCE.FirstOrDefault(d => d.CANDIDATE_ID == NewJobExp.CANDIDATE_ID && d.COMPANY_NAME == NewJobExp.COMPANY_NAME); string[] Skills = NewJobExp.SKILL_NAME.Split(','); string[] Benefits = NewJobExp.BENEFIT.Split(','); if (Skills.Length > 1) { foreach (string skill in Skills) { db.TB_SKILL_JOB_EXPERIENCE.Add(new TB_SKILL_JOB_EXPERIENCE { ID_JOBEXP = DataJobExp.ID, SKILL_NAME = skill }); } } if (Skills.Length == 0) { db.TB_SKILL_JOB_EXPERIENCE.Add(new TB_SKILL_JOB_EXPERIENCE { ID_JOBEXP = DataJobExp.ID, SKILL_NAME = DataJobExp.SKILL_NAME }); } if (Benefits.Length > 1) { foreach (string benefit in Benefits) { db.TB_BENEFIT_JOB_EXPERIENCE.Add(new TB_BENEFIT_JOB_EXPERIENCE { JOB_EXP_ID = DataJobExp.ID, BENEFIT = benefit }); } } if (Benefits.Length == 0) { db.TB_BENEFIT_JOB_EXPERIENCE.Add(new TB_BENEFIT_JOB_EXPERIENCE { JOB_EXP_ID = DataJobExp.ID, BENEFIT = DataJobExp.BENEFIT }); } } if (db.SaveChanges() > 0) { return(1); } return(0); } } return(1); }
//edit job experience //for add new job experience of candidate public static int EditData(CandidateJobExperienceDTO Data) { using (DBEntities db = new DBEntities()) { db.TB_CANDIDATE_JOB_EXPERIENCE.FirstOrDefault(d => d.ID == Data.ID); if (db.SaveChanges() > 0) { if (Data.SKILL_NAME != null || Data.SKILL_NAME != "" || Data.BENEFIT != null || Data.BENEFIT != "") { TB_CANDIDATE_JOB_EXPERIENCE DataJobExp = db.TB_CANDIDATE_JOB_EXPERIENCE.FirstOrDefault(d => d.CANDIDATE_ID == Data.CANDIDATE_ID && d.COMPANY_NAME == Data.COMPANY_NAME); string[] Skills = Data.SKILL_NAME.Split(','); string[] Benefits = Data.BENEFIT.Split(','); foreach (var d in db.TB_BENEFIT_JOB_EXPERIENCE.Where(d => Benefits.Contains(d.BENEFIT))) { db.TB_BENEFIT_JOB_EXPERIENCE.Remove(d); } foreach (var d in db.TB_SKILL_JOB_EXPERIENCE.Where(d => Skills.Contains(d.SKILL_NAME))) { db.TB_SKILL_JOB_EXPERIENCE.Remove(d); } db.SaveChanges(); if (Skills.Length > 1) { foreach (string skill in Skills) { db.TB_SKILL_JOB_EXPERIENCE.Add(new TB_SKILL_JOB_EXPERIENCE { ID_JOBEXP = DataJobExp.ID, SKILL_NAME = skill }); } } if (Skills.Length == 0) { db.TB_SKILL_JOB_EXPERIENCE.Add(new TB_SKILL_JOB_EXPERIENCE { ID_JOBEXP = DataJobExp.ID, SKILL_NAME = DataJobExp.SKILL_NAME }); } if (Benefits.Length > 1) { foreach (string benefit in Benefits) { db.TB_BENEFIT_JOB_EXPERIENCE.Add(new TB_BENEFIT_JOB_EXPERIENCE { JOB_EXP_ID = DataJobExp.ID, BENEFIT = benefit }); } } if (Benefits.Length == 0) { db.TB_BENEFIT_JOB_EXPERIENCE.Add(new TB_BENEFIT_JOB_EXPERIENCE { JOB_EXP_ID = DataJobExp.ID, BENEFIT = DataJobExp.BENEFIT }); } } if (db.SaveChanges() > 0) { return(1); } return(0); } } return(1); }