No problem, here it is.
public
static
IEnumerable<EmployeeMasterView> GetEmployees()
{
// List<EmployeeMasterView> theEmployees = new List<EmployeeMasterView>();
var model = CompanyContextFactory.GetContextPerRequest();
var ees = model.Employees.Where(e => e.CompanyID == GlobalVariables.CompanyID && e.ClientID == GlobalVariables.Client).ToList();
var securityEEs = GlobalVariables.SecurityEmployees;
ees = ees.Where(e => securityEEs.Any(sec => sec == e.EmployeeID)).ToList();
return
ees.OrderBy(emp => emp.LastName).Select(employee =>
new
EmployeeMasterView
{
FirstName = employee.FirstName ??
string
.Empty,
LastName = employee.LastName ??
string
.Empty,
MiddleName = employee.MiddleName ??
string
.Empty,
EmployeeID = employee.EmployeeID,
Email = EmployeeEmail(employee.EmployeeID, employee.CompanyID),
Department = employee.Department,
StartDate = employee.StartDate,
EmergencyPhone = employee.EmergencyPhone,
DnetUserID = employee.DnetUserID,
EmployeePicture = GetEmployeePhoto(employee.EmployeeID),
CompanyID = employee.CompanyID,
Gender = employee.Gender,
Position = employee.Position,
EthnicOrigin = employee.EthnicOrigin,
dispEthnicity = FieldTranslation.GetEnumDescription(
typeof
(enEthnicOrigin), employee.EthnicOrigin ?? 0),
OriginalHireDate = employee.OriginalHireDate,
BirthDate = employee.BirthDate,
I9Versified = employee.I9Verified,
SSN = FieldTranslation.GetMaskSSN(employee.SSN),
StrGender = GetGender(employee.Gender),
BlnInactive = employee.Inactive,
dispDept = FieldTranslation.GetDepartmentDesciption(employee.Department),
dispPos = FieldTranslation.GetJobTitleDesciption(employee.Position),
Address1 =(employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.Address1).FirstOrDefault() ??
string
.Empty),
Address2 =(employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.Address2).FirstOrDefault() ??
string
.Empty),
City =employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.City).FirstOrDefault(),
State =employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.State).FirstOrDefault(),
Zip =employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.Zip).FirstOrDefault(),
EmployeementStatus =FieldTranslation.GetEnumDescription(
typeof
(enEmploymentType), (employee.PartTime ?? 0)),
phone1 =FieldTranslation.FormatPhone(employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.Phone1).FirstOrDefault() ??
string
.Empty),
phone2 =FieldTranslation.FormatPhone(employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.Phone2).FirstOrDefault() ??
string
.Empty),
phone3 =FieldTranslation.FormatPhone(employee.EmployeeAddresses.Where(ea =>ea.CompanyID == employee.CompanyID && ea.EmployeeID == employee.EmployeeID &&ea.AddressCode == employee.AddressCode).Select(ea => ea.Phone3).FirstOrDefault() ??
string
.Empty),
disbStartDate = FieldTranslation.ToShortDate(Convert.ToDateTime(employee.StartDate)),
dispBirthDate = FieldTranslation.ToShortDate(Convert.ToDateTime(employee.BirthDate)),
dispDOH = FieldTranslation.ToShortDate(Convert.ToDateTime(employee.OriginalHireDate)),
DateEmpInactivated = FieldTranslation.ToShortDate(Convert.ToDateTime(employee.DateEmployeeInactivated)),
InactivatedReason = employee.ReasonEmployeeInactivated,
JobCategory =(employee.JobCategory !=
null
)? FieldTranslation.GetEnumDescription(
typeof
(enJobCategories), (
int
)employee.JobCategory): FieldTranslation.GetEnumDescription(
typeof
(enJobCategories), 0),
WorkSiteID = employee.WorksiteID,
WorkSiteLocation = employee.WorksiteLocation.ToString(),
EmployeeWorkAddress = employee.EmployeeWorkAddress,
TerminationDate = FieldTranslation.ToShortDate(Convert.ToDateTime(employee.TerminationDate)),
dispEmployeeID = FieldTranslation.EmployeeIDFormatted(employee.EmployeeID)
});
}