//เพิ่ม employee ลง DB
public void CreateEmployee(List <EmployeeDTO> users, string projectCode)
{
foreach (EmployeeDTO team in users)
{
PjEmployee employee = new PjEmployee();
employee.ProjectCode = projectCode;
employee.SystemCode = team.SystemCode;
employee.Firstname = team.Firstname;
employee.Lastname = team.Lastname;
employee.Leader = "SQL";
employee.Role = "SA";
employee.Department = ".NET";
employee.CreatedBy = "SQL";
employee.CreatedDate = DateTime.Now;
employee.UpdatedBy = "SQL";
employee.UpdatedDate = DateTime.Now;
Context.PjEmployee.Add(employee);
Context.SaveChanges();
}
}
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();
}
}
}
