public List<PublishedAssessmentFacade> getAllPublishedAssessments(String sortString) { String orderBy = getOrderBy(sortString); List<PublishedAssessmentData> list = (List<PublishedAssessmentData>) getHibernateTemplate().find("from PublishedAssessmentData p order by p." + orderBy); List<PublishedAssessmentFacade> assessmentList = new ArrayList<>(); for (PublishedAssessmentData a : list) { a.setSectionSet(getSectionSetForAssessment(a)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); assessmentList.add(f); } return assessmentList; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(String sortString, final Integer status) { final String orderBy = getOrderBy(sortString); final HibernateCallback<List<PublishedAssessmentData>> hcb = session -> { Query q = session.createQuery("from PublishedAssessmentData as p where p.status = :status order by p." + orderBy); q.setInteger("status", status); return q.list(); }; List<PublishedAssessmentData> list = getHibernateTemplate().execute(hcb); List<PublishedAssessmentFacade> assessmentList = new ArrayList<>(); for (PublishedAssessmentData a : list) { a.setSectionSet(getSectionSetForAssessment(a)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); assessmentList.add(f); } return assessmentList; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(String sortString) { String orderBy = getOrderBy(sortString); List<PublishedAssessmentData> list = (List<PublishedAssessmentData>) getHibernateTemplate().find("from PublishedAssessmentData p order by p." + orderBy); List<PublishedAssessmentFacade> assessmentList = new ArrayList<>(); for (PublishedAssessmentData a : list) { a.setSectionSet(getSectionSetForAssessment(a)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); assessmentList.add(f); } return assessmentList; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(String sortString, final Integer status) { final String orderBy = getOrderBy(sortString); final HibernateCallback<List<PublishedAssessmentData>> hcb = session -> { Query q = session.createQuery("from PublishedAssessmentData as p where p.status = :status order by p." + orderBy); q.setInteger("status", status); return q.list(); }; List<PublishedAssessmentData> list = getHibernateTemplate().execute(hcb); List<PublishedAssessmentFacade> assessmentList = new ArrayList<>(); for (PublishedAssessmentData a : list) { a.setSectionSet(getSectionSetForAssessment(a)); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); assessmentList.add(f); } return assessmentList; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(int pageSize, int pageNumber, String sortString, Integer status) { String orderBy = getOrderBy(sortString); String queryString = "from PublishedAssessmentData p order by p." + orderBy; if (!status.equals(PublishedAssessmentFacade.ANY_STATUS)) { queryString = "from PublishedAssessmentData p where p.status = :status order by p." + orderBy; } PagingUtilQueriesAPI pagingUtilQueries = PersistenceService.getInstance().getPagingUtilQueries(); List<PublishedAssessmentData> pageList = pagingUtilQueries.getAll(pageSize, pageNumber, queryString, status); log.debug("**** pageList=" + pageList); List<PublishedAssessmentFacade> assessmentList = new ArrayList(); for (PublishedAssessmentData a : pageList) { a.setSectionSet(getSectionSetForAssessment(a)); log.debug("**** published assessment=" + a.getTitle()); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); log.debug("**** published assessment title=" + f.getTitle()); assessmentList.add(f); } return assessmentList; }
public List<PublishedAssessmentFacade> getAllPublishedAssessments(int pageSize, int pageNumber, String sortString, Integer status) { String orderBy = getOrderBy(sortString); String queryString = "from PublishedAssessmentData p order by p." + orderBy; if (!status.equals(PublishedAssessmentFacade.ANY_STATUS)) { queryString = "from PublishedAssessmentData p where p.status = :status order by p." + orderBy; } PagingUtilQueriesAPI pagingUtilQueries = PersistenceService.getInstance().getPagingUtilQueries(); List<PublishedAssessmentData> pageList = pagingUtilQueries.getAll(pageSize, pageNumber, queryString, status); log.debug("**** pageList=" + pageList); List<PublishedAssessmentFacade> assessmentList = new ArrayList(); for (PublishedAssessmentData a : pageList) { a.setSectionSet(getSectionSetForAssessment(a)); log.debug("**** published assessment=" + a.getTitle()); PublishedAssessmentFacade f = new PublishedAssessmentFacade(a); log.debug("**** published assessment title=" + f.getTitle()); assessmentList.add(f); } return assessmentList; }
public List<PublishedAssessmentFacade> getBasicInfoOfAllActivePublishedAssessments(String sortString, final String siteAgentId, boolean ascending) { Date currentDate = new Date(); String orderBy = getOrderBy(sortString);
public List<PublishedAssessmentFacade> getBasicInfoOfAllActivePublishedAssessments(String sortString, final String siteAgentId, boolean ascending) { Date currentDate = new Date(); String orderBy = getOrderBy(sortString);
String sortString, final String siteAgentId, boolean ascending) { String orderBy = getOrderBy(sortString); String query = "select new PublishedAssessmentData(p.publishedAssessmentId, p.title," + " c.releaseTo, c.startDate, c.dueDate, c.retractDate, p.status, p.lastModifiedDate, p.lastModifiedBy) from PublishedAssessmentData p,"
String sortString, final String siteAgentId, boolean ascending) { String orderBy = getOrderBy(sortString); String query = "select new PublishedAssessmentData(p.publishedAssessmentId, p.title," + " c.releaseTo, c.startDate, c.dueDate, c.retractDate, p.status, p.lastModifiedDate, p.lastModifiedBy) from PublishedAssessmentData p,"
public List<PublishedAssessmentFacade> getBasicInfoOfAllPublishedAssessments2(String sortString, boolean ascending, final String siteAgentId) { String orderBy = getOrderBy(sortString);
public List<PublishedAssessmentFacade> getBasicInfoOfAllPublishedAssessments2(String sortString, boolean ascending, final String siteAgentId) { String orderBy = getOrderBy(sortString);