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}");
}
}
}
