public Employee GetEmployeeById(string id)
 {
     OrdersManagementDataSet.EmployeesRow employeeRow = repository.Employees.FindByEmployeeId(id);
     if (employeeRow == null || !employeeRow.EmployeeId.Equals(id, System.StringComparison.InvariantCultureIgnoreCase))
     {
         return(null);
     }
     return(TranslateFromEmployeesRowToEmployeeEntity(employeeRow));
 }
        private static Employee TranslateFromEmployeesRowToEmployeeEntity(OrdersManagementDataSet.EmployeesRow employeeRow)
        {
            Employee employee = new Employee();

            employee.EmployeeId = employeeRow.EmployeeId;
            employee.FirstName  = employeeRow.FirstName;
            employee.LastName   = employeeRow.LastName;

            return(employee);
        }