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