View Javadoc

1   package org.kuali.student.enrollment.class2.courseofferingset.dao;
2   
3   
4   import java.util.List;
5   
6   import org.kuali.student.enrollment.class2.courseofferingset.model.SocEntity;
7   import org.kuali.student.r2.common.dao.GenericEntityDao;
8   
9   public class SocDao extends GenericEntityDao<SocEntity> {
10  
11      @SuppressWarnings("unchecked")
12      public List<SocEntity> getBySocTypeId(String socType) {
13          return (List<SocEntity>) em.createNamedQuery("Soc.getSocsBySocTypeId").setParameter("socType", socType).getResultList();
14      }
15  
16      public List<String> getSocIdsByType(String socType) {
17          return (List<String>) em.createNamedQuery("Soc.getSocIdsByType").setParameter("socType", socType).getResultList();
18      }
19  
20  
21      public List<String> getSocIdsByTerm(String termId) {
22          return (List<String>) em.createNamedQuery("Soc.getSocIdsByTerm").setParameter("termId", termId).getResultList();
23      }
24  
25      public List<SocEntity> getByTerm(String termId) {
26          return (List<SocEntity>) em.createNamedQuery("Soc.getSocsByTerm").setParameter("termId", termId).getResultList();
27  
28      }
29      public List<SocEntity> getByTermAndSubjectArea(String termId, String subjectArea) {
30          return (List<SocEntity>) em.createNamedQuery("Soc.getSocsByTermAndSubjectArea").setParameter("termId", termId).setParameter("subjectArea", subjectArea).getResultList();
31  
32      }
33  
34      public List<String> getSocIdsByTermAndSubjectArea(String termId, String subjectArea) {
35          return (List<String>) em.createNamedQuery("Soc.getSocIdsByTermAndSubjectArea").setParameter("termId", termId).setParameter("subjectArea", subjectArea).getResultList();
36  
37      }
38      public List<SocEntity> getByTermAndUnitsContentOwner(String termId, String unitsContentOwnerId) {
39          return (List<SocEntity>) em.createNamedQuery("Soc.getSocsByTermAndUnitsContentOwner").setParameter("termId", termId).setParameter("unitsContentOwnerId", unitsContentOwnerId).getResultList();
40  
41      }
42  
43      public List<String> getSocIdsByTermAndUnitsContentOwner(String termId, String unitsContentOwnerId) {
44          return (List<String>) em.createNamedQuery("Soc.getSocIdsByTermAndUnitsContentOwner").setParameter("termId", termId).setParameter("unitsContentOwnerId", unitsContentOwnerId).getResultList();
45  
46      }
47  
48      // Although this doesn't look at the SocEntity, it is related to the getCourseOfferingIdsBySoc which looks at the
49      // LuiEntity
50      public Long countLuisByTypeForTermId(String luiTypeId, String termId) {
51         String query = "SELECT COUNT(*) FROM LuiEntity lui " +
52                  "WHERE lui.luiType = :luiTypeId AND lui.atpId = :termId";
53          return (Long) em.createQuery(query).setParameter("luiTypeId", luiTypeId).setParameter("termId", termId).getSingleResult();
54      }
55  }