/// <summary>
/// Return all existing employee records.
/// </summary>
/// <returns></returns>
public List <Employees> getAllEmployees()
{
IQueryable <Employees> content = null;
using (AdventureWorksCyclesEntities dbContext = new AdventureWorksCyclesEntities())
{
content = (from s in dbContext.Employee
select new Employees
{
BusinessEntityID = s.BusinessEntityID,
EmployeeID = s.NationalIDNumber,
FirstName = s.Person.FirstName,
MiddleName = s.Person.MiddleName,
LastName = s.Person.LastName,
LoginID = s.LoginID,
OrganizationLevel = s.OrganizationLevel,
JobTitle = s.JobTitle,
BirthDate = s.BirthDate,
Gender = s.Gender,
HireDate = s.HireDate,
ModificationDate = s.ModifiedDate,
});
return(content.ToList());
}
}
/// <summary>
/// Determination of the employee data record using the passed parameter.
/// </summary>
/// <param name="id"></param>
/// <returns>Employees record</returns>
public Employees getEmployeeNameById(int id)
{
using (AdventureWorksCyclesEntities dbContext = new AdventureWorksCyclesEntities())
{
return(dbContext.Employee.Where(x => x.BusinessEntityID == id).Select(g => new Employees()
{
FirstName = g.Person.FirstName,
MiddleName = g.Person.MiddleName,
LastName = g.Person.LastName
}).FirstOrDefault <Employees>());
}
}
/// <summary>
/// Determination of the employees departmenthistory data records using the passed parameter.
/// </summary>
/// <param name="id"></param>
/// <returns>A list of all found records</returns>
public List <EmployeeDepartmentHistorys> getFullDepartmentHistoryByEmployeeId(int id)
{
IEnumerable <EmployeeDepartmentHistorys> content = null;
using (AdventureWorksCyclesEntities dbContext = new AdventureWorksCyclesEntities())
{
content = (from s in dbContext.EmployeeDepartmentHistory
select new EmployeeDepartmentHistorys
{
BusinessEntityID = s.BusinessEntityID,
DepartmentID = s.DepartmentID,
Name = s.Department.Name,
ShiftId = s.ShiftID,
EndDate = s.EndDate,
StartDate = s.StartDate,
ModificationDate = s.ModifiedDate,
})
.Where(s => s.BusinessEntityID.Equals(id));
return(content.ToList());
}
}
