Index: lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/OrganisationDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/OrganisationDAO.java,v diff -u -r1.7 -r1.8 --- lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/OrganisationDAO.java 2 Jun 2006 06:57:27 -0000 1.7 +++ lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/OrganisationDAO.java 7 Jun 2006 02:48:52 -0000 1.8 @@ -90,7 +90,7 @@ childOrganisation.setParentOrganisation(parentOrganisation); iter.remove(); } - getHibernateTemplate().delete(organisation); + delete(organisation); } /** @@ -107,4 +107,9 @@ return null; } + public List getOrganisationsByType(Integer organisationTypeId) { + String queryString = "from Organisation o where o.organisationType.organisationTypeId=?"; + return getHibernateTemplate().find(queryString,organisationTypeId); + } + } Index: lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserOrganisationDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserOrganisationDAO.java,v diff -u -r1.7 -r1.8 --- lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserOrganisationDAO.java 2 Jun 2006 06:57:27 -0000 1.7 +++ lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserOrganisationDAO.java 7 Jun 2006 02:48:52 -0000 1.8 @@ -113,4 +113,9 @@ delete(getUserOrganisationById(userOrganisationId)); } + public List getUserOrganisationsByType(Integer organisationTypeId) { + String queryString = "from UserOrganisation uo where uo.organisation.organisationType.organisationTypeId=?"; + return getHibernateTemplate().find(queryString,organisationTypeId); + } + }