public void UpdateUser(string code, List <EmployeeDTO> users)
{
List <PjEmployee> CheckUser = Context.PjEmployee.Where(x => x.ProjectCode == code).ToList();
foreach (EmployeeDTO user in users)
{
PjEmployee result = CheckUser.Where(x => x.SystemCode == user.SystemCode).FirstOrDefault();
if (result == null)
{
result = new PjEmployee()
{
ProjectCode = code,
SystemCode = user.SystemCode,
Firstname = user.Firstname,
Lastname = user.Lastname,
Leader = user.Leader,
Role = user.Role,
Department = user.Department,
CreatedBy = "SA",
CreatedDate = DateTime.Now,
UpdatedBy = "SA",
UpdatedDate = DateTime.Now,
};
Context.Entry(result).State = EntityState.Added;
Context.SaveChanges();
}
}
foreach (PjEmployee user in CheckUser)
{
EmployeeDTO result = users.Where(x => x.SystemCode == user.SystemCode).FirstOrDefault();
if (result == null)
{
Context.Entry(user).State = EntityState.Deleted;
Context.SaveChanges();
}
}
}
