public List <Employee> DisplayDesignation()
{
try
{
ProjectManagerModel context = new ProjectManagerModel();
var Query = from item in context.Projects
select item.EmployeeId;
var q = from Employee in context.Employees
where Employee.EmployeeDesignation == "ProjectManager" && !Query.Contains(Employee.EmployeeId)
select Employee;
return(q.ToList());
}
catch (Exception ex)
{
throw new ProjectManagerException("Error getting data" + ex);
}
}
public EmployeeRepository()
{
_dbContext = new ProjectManagerModel();
}
public ProjectRepository()
{
objContext = new ProjectManagerModel();
}