public bool AddNewEmployee(Employee newEmployee) { try { using (var context = new NORTHWNDEntities()) { var employeeToEdit = context.Employees.FirstOrDefault(x => x.EmployeeID == newEmployee.EmployeeID); if (employeeToEdit != null) { employeeToEdit.Address = newEmployee.Address; employeeToEdit.EmployeeID = newEmployee.EmployeeID; employeeToEdit.BirthDate = newEmployee.BirthDate; employeeToEdit.City = newEmployee.City; employeeToEdit.Country = newEmployee.Country; employeeToEdit.Extension = newEmployee.Extension; employeeToEdit.FirstName = newEmployee.FirstName; employeeToEdit.HireDate = newEmployee.HireDate; employeeToEdit.HomePhone = newEmployee.HomePhone; employeeToEdit.LastName = newEmployee.LastName; employeeToEdit.Notes = newEmployee.Notes; employeeToEdit.PostalCode = newEmployee.PostalCode; employeeToEdit.Region = newEmployee.Region; employeeToEdit.ReportsTo = newEmployee.ReportsTo; employeeToEdit.Title = newEmployee.Title; employeeToEdit.TitleOfCourtesy = newEmployee.TitleOfCourtesy; context.SaveChanges(); return true; } return false; } } catch (Exception ex) { throw new FaultException($"Could not update Employee {ex.Message}"); } }
public Employee GetEmployeeById(int id) { using (var context = new NORTHWNDEntities()) { try { var emp = context.Employees.Where(x => x.EmployeeID == id).Select(x => new Employee { Address = x.Address, EmployeeID = x.EmployeeID, BirthDate = x.BirthDate, City = x.City, Country = x.Country, Extension = x.Extension, FirstName = x.FirstName, HireDate = x.HireDate, HomePhone = x.HomePhone, LastName = x.LastName, Notes = x.Notes, PostalCode = x.PostalCode, Region = x.Region, ReportsTo = x.ReportsTo, Title = x.Title, TitleOfCourtesy = x.TitleOfCourtesy, }).FirstOrDefault(); if (emp == null) { throw new FaultException($"No Employee found"); } return emp; } catch (Exception ex) { throw new FaultException($"No Employee found {ex.Message}"); } } }