1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 package net.sf.imca.model.entities;
17
18 import java.util.Date;
19 import java.util.List;
20 import javax.persistence.EntityManager;
21 import javax.persistence.Query;
22
23 import net.sf.imca.model.MembershipTypeBO;
24
25 public class MembershipDAO {
26
27 @SuppressWarnings("unchecked")
28 public List<MembershipEntity> findActiveMembersOnDate(EntityManager em, Date date) {
29
30 Query query = em.createNamedQuery("findActiveMembersOnDate");
31 query.setParameter("date", date);
32 List<MembershipEntity> list = query.getResultList();
33
34 return list;
35
36 }
37
38 public boolean getHasLinkedMemberships(EntityManager em,
39 MembershipTypeEntity membershipType) {
40
41 Query query = em.createNamedQuery("findMembersForMembershipType");
42 query.setParameter("membershipType", membershipType);
43 List<MembershipEntity> list = query.getResultList();
44
45 return (list.size() > 0);
46 }
47
48 }