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(); }