View Javadoc

1   /*
2    * Copyright 2007 The International Moth Class Association (IMCA)
3    *
4    * Licensed under the Apache License, Version 2.0 (the "License");
5    * you may not use this file except in compliance with the License.
6    * You may obtain a copy of the License at
7    *
8    *     http://www.apache.org/licenses/LICENSE-2.0
9    *
10   * Unless required by applicable law or agreed to in writing, software
11   * distributed under the License is distributed on an "AS IS" BASIS,
12   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13   * See the License for the specific language governing permissions and
14   * limitations under the License.
15   */
16  package net.sf.imca.model.entities;
17  
18  import java.util.List;
19  import javax.persistence.EntityManager;
20  import javax.persistence.Query;
21  
22  public class CommitteeMemberDAO {
23  
24      @SuppressWarnings("unchecked")
25      public CommitteeMemberEntity find(EntityManager em, String positionName,
26              AssociationEntity association) {
27  
28          Query query = em.createNamedQuery("findCommitteeMember");
29          query.setParameter("positionName", positionName);
30          query.setParameter("assosiation", association);
31  
32          List<CommitteeMemberEntity> list = query.getResultList();
33          if (list.size() != 0) {
34              return list.get(0);
35          }
36          CommitteeMemberEntity cmEnt = new CommitteeMemberEntity();
37          cmEnt.setPositionName(positionName);
38          cmEnt.setAssosiation(association);
39          return cmEnt;
40      }
41      
42      public List<CommitteeMemberEntity> getAssociationsComitteeInCountry(
43              EntityManager em, String countryCode, String area) {
44          Query query = em.createNamedQuery("findAssociationsCommitteeMembers");
45          query.setParameter("countryCode", countryCode);
46          query.setParameter("area", area);
47          return query.getResultList();
48      }
49  }