/** * Returns all the existing tasks for that are owned by the projectIdOfLists and are linked to the * projectIdToBookmark * * @param db - the database connection * @param projectIdOfLists - this is the main project where the lists are stored against * @param projectIdToBookmark - the project that has been linked (bookmarked) to the above project * by a list * @return taskList - the list of existing tasks matching the parameters * @throws SQLException - generated trying to retrieve data */ private TaskList findExistingTasksForProjects( Connection db, int projectIdOfLists, int projectIdToBookmark) throws SQLException { TaskList taskList = new TaskList(); taskList.setLinkModuleId(Constants.TASK_CATEGORY_PROJECTS); taskList.setLinkItemId(projectIdToBookmark); taskList.setProjectId(projectIdOfLists); taskList.buildList(db); return taskList; }