public List <Employee> Displaypendingtasks()
{
ProjectMgrModel context = new ProjectMgrModel();
var EmployeesWithFullTasks = from task in context.Tasks
group task by task.EmployeeId into grp
where grp.Count() >= 5
select grp.Key;
var query2 = from emp in context.Employees
from t in context.Tasks
where emp.EmployeeDesignation == "Developer" && !EmployeesWithFullTasks.Contains(emp.EmployeeId) &&
t.TaskStatus == "pending" || t.EmployeeId == emp.EmployeeId
select emp;
return(query2.ToList().Distinct(new EmployeeComparer()).ToList());
}
public List <Employee> DisplayDesignation()
{
try
{
ProjectMgrModel context = new ProjectMgrModel();
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 TaskRepository()
{
objContext = new ProjectMgrModel();
}
public EmployeeRepository()
{
_dbContext = new ProjectMgrModel();
}
