//เพิ่ม 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(); } } }