public IQueryable <Department> GetAllDepartments(int id)
{
ADV2017Entities adv2017Entities = new ADV2017Entities();
return(adv2017Entities.Departments.Where(e => e.DepartmentID == id).Select(e => e));
}
public IQueryable <Employee> GetAllEmployees(int id)
{
ADV2017Entities adv2017Entities = new ADV2017Entities();
return(adv2017Entities.Employees.Where(e => e.BusinessEntityID == id).Select(e => e));
}
public IQueryable <Department> GetAllDepartments()
{
ADV2017Entities adv2017Entities = new ADV2017Entities();
return(adv2017Entities.Departments);
}
public IQueryable <Employee> GetAllEmployees()
{
ADV2017Entities adv2017Entities = new ADV2017Entities();
return(adv2017Entities.Employees);
}