public void UpdateListFilterGrade(int employeeListFilterID, string[] gradeID)
{
var filterGrades = AllEmployeeListFilterGrades.Where(e => e.EmployeeListFilterId == employeeListFilterID);
if (gradeID != null)
{
int[] arrayGradeID = gradeID.Select(g => Convert.ToInt32(g)).ToArray();
if (filterGrades != null)
{
foreach (var grade in filterGrades)
{
if (!arrayGradeID.Contains(grade.GradeId))
{
context.EmployeeListFilterGrade.Remove(grade);
}
}
context.SaveChanges();
}
foreach (var id in arrayGradeID)
{
if (!filterGrades.Any(g => g.GradeId == id))
{
context.EmployeeListFilterGrade.Add(new EmployeeListFilterGrade()
{
EmployeeListFilterId = employeeListFilterID,
GradeId = id,
BusinessGroupId = CurrentBusinessGroupId,
CreatedBy = CurrentUserId,
CreatedDate = DateTime.Now
});
}
}
}
else
{
if (filterGrades != null)
{
foreach (var grade in filterGrades)
{
context.EmployeeListFilterGrade.Remove(grade);
}
}
}
context.SaveChanges();
}
public int[] GetFilterGradeID(int employeeListFilterID)
{
var ids = AllEmployeeListFilterGrades.Where(e => e.EmployeeListFilterId == employeeListFilterID).Select(s => s.GradeId).ToArray();
return(ids);
}