Index: lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/ITransitionDAO.java =================================================================== diff -u -r1a5c1e3865540907cd8f4503b067f111ae63755b -r2ddde5f0607a37105c3219a50515a72f763650e2 --- lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/ITransitionDAO.java (.../ITransitionDAO.java) (revision 1a5c1e3865540907cd8f4503b067f111ae63755b) +++ lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/ITransitionDAO.java (.../ITransitionDAO.java) (revision 2ddde5f0607a37105c3219a50515a72f763650e2) @@ -37,5 +37,7 @@ * @return Returns the list of Transition objects where from_activity_id = activityID */ public List getTransitionByfromActivityID(Long fromActivityID); + + public List getTransitionsByLearningDesignID(Long learningDesignID); } Index: lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/TransitionDAO.java =================================================================== diff -u -r1a5c1e3865540907cd8f4503b067f111ae63755b -r2ddde5f0607a37105c3219a50515a72f763650e2 --- lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/TransitionDAO.java (.../TransitionDAO.java) (revision 1a5c1e3865540907cd8f4503b067f111ae63755b) +++ lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/TransitionDAO.java (.../TransitionDAO.java) (revision 2ddde5f0607a37105c3219a50515a72f763650e2) @@ -25,8 +25,9 @@ private static final String TABLENAME ="lams_learning_transition"; private static final String FIND_BY_TO_ACTIVITY = "from " + TABLENAME +" in class " + Transition.class.getName()+ " where to_activity_id =?"; private static final String FIND_BY_FROM_ACTIVITY = "from " + TABLENAME +" in class " + Transition.class.getName()+ " where from_activity_id =?"; + private static final String FIND_BY_LEARNING_DESIGN_ID = "from " + TABLENAME +" in class " + Transition.class.getName()+ + " where learning_design_id=?"; - /* (non-Javadoc) * @see org.lamsfoundation.lams.learningdesign.dao.ITransitionDAO#getTransitionById(java.lang.Integer) */ @@ -57,5 +58,10 @@ List list = this.getHibernateTemplate().find(FIND_BY_FROM_ACTIVITY,new Object[]{fromActivityID}, new Type[]{Hibernate.LONG}); return list; } + + public List getTransitionsByLearningDesignID(Long learningDesignID){ + List list = this.getHibernateTemplate().find(FIND_BY_LEARNING_DESIGN_ID, new Object[]{learningDesignID}, new Type[]{Hibernate.LONG}); + return list; + } }