public void UpdateListJobFamily(int JobFamilyID, string[] majorID) { var filterJobFamiliMajors = AllJobFamiliMajors.Where(e => e.JobFamilyId == JobFamilyID); if (majorID != null) { int[] arrayMajorID = majorID.Select(g => Convert.ToInt32(g)).ToArray(); if (filterJobFamiliMajors != null) { foreach (var jobfam in filterJobFamiliMajors) { if (!arrayMajorID.Contains((int)jobfam.MajorId)) { context.JobFamilyMajor.Remove(jobfam); } } context.SaveChanges(); } foreach (var id in arrayMajorID) { if (!filterJobFamiliMajors.Any(g => g.MajorId == id)) { context.JobFamilyMajor.Add(new JobFamilyMajor() { JobFamilyId = JobFamilyID, MajorId = id, BusinessGroupId = businessGroupID, CreatedBy = CurrentUserId, CreatedDate = DateTime.Now }); } } } else { if (filterJobFamiliMajors != null) { foreach (var jobfam in filterJobFamiliMajors) { context.JobFamilyMajor.Remove(jobfam); } } } context.SaveChanges(); }
public int[] GetJobFamilyID(int JobFamilyID) { return(AllJobFamiliMajors.Where(e => e.JobFamilyId == JobFamilyID).Select(s => (int)s.MajorId).ToArray()); }