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