public async Task Update(Employee employee)
{
var primarySkill = _context.Employees.Where(x => x.EmployeeNumber.Equals(employee.EmployeeNumber)).Select(x => x.PrimarySkill).FirstOrDefault();
if (employee.PrimarySkill != primarySkill)
{
EmployeeWorkstation employeeWorkstation = new EmployeeWorkstation {
};
employeeWorkstation.EmployeeNumber = employee.EmployeeNumber;
employeeWorkstation.WorkstationNumber = employee.PrimarySkill;
_context.EmployeeWorkstations.Update(employeeWorkstation);
await _context.SaveChangesAsync();
}
_context.Update(employee);
await _context.SaveChangesAsync();
}
public async Task CreateEmp(Employee employee)
{
await _context.Employees.AddAsync(employee);
await _context.SaveChangesAsync();
//add entry to the Emp/wrk join table
EmployeeWorkstation employeeWorkstation = new EmployeeWorkstation {
};
employeeWorkstation.EmployeeNumber = employee.EmployeeNumber;
employeeWorkstation.WorkstationNumber = employee.PrimarySkill;
await _context.EmployeeWorkstations.AddAsync(employeeWorkstation);
await _context.SaveChangesAsync();
}
