コード例 #1
0
ファイル: DBManager.java プロジェクト: vongrad/EESS_BackEnd
  //    //Returns all the electives proposed by students and teachears!
  //    @Override
  //    public Collection<ElectiveDTO> getProposedElectives() {
  //        ArrayList< ElectiveDTO> electiveDTOs = new ArrayList<>();
  //        Query query = entityManager.createNamedQuery("Elective.findAll");
  //        List<Elective> electives = query.getResultList();
  //        for (Elective e : electives) {
  //            if (e.getProposed().equals("0")) {
  //                electiveDTOs.add(new ElectiveDTO(e.getElectiveId(), e.getTitle(),
  // e.getDescription(), e.getCreationDate(), e.getProposed()));
  //            }
  //        }
  //        return electiveDTOs;
  //    }
  // Returns electives that has been approved by the head of program to go for the first round
  @Override
  public Collection<ElectiveFirstDTO> getFirstRndElectives() {

    ArrayList<ElectiveFirstDTO> electiveDTOs = new ArrayList<>();
    Query query = entityManager.createNamedQuery("Elective.findByProposed");
    Query q1, q2;
    query.setParameter("proposed", "1");
    List<Elective> electives = query.getResultList();

    int firstPriorityCount;
    int secondPriorityCount;

    for (Elective e : electives) {
      if (e.getPool() == null) {
        q1 = entityManager.createNamedQuery("FirstRoundVote.count_priority1");
        q1.setParameter("elective", e);
        firstPriorityCount = Integer.parseInt(q1.getSingleResult().toString());

        q2 = entityManager.createNamedQuery("FirstRoundVote.count_priority2");
        q2.setParameter("elective", e);
        secondPriorityCount = Integer.parseInt(q2.getSingleResult().toString());
        electiveDTOs.add(
            new ElectiveFirstDTO(
                e.getElectiveId(),
                e.getTitle(),
                e.getDescription(),
                e.getCreationDate(),
                e.getProposed(),
                firstPriorityCount,
                secondPriorityCount));
      }
    }
    return electiveDTOs;
  }
コード例 #2
0
ファイル: DBManager.java プロジェクト: vongrad/EESS_BackEnd
  @Override
  public Collection<ElectiveSecondDTO> getSecondRndElectivesB() {

    ArrayList<ElectiveSecondDTO> electiveDTOsB = new ArrayList<>();
    Query query = entityManager.createNamedQuery("Elective.findByPool");
    query.setParameter("pool", "b");
    List<Elective> electives = query.getResultList();

    for (Elective e : electives) {
      electiveDTOsB.add(
          new ElectiveSecondDTO(
              e.getElectiveId(),
              e.getTitle(),
              e.getDescription(),
              e.getCreationDate(),
              e.getProposed(),
              e.getPool()));
    }

    return electiveDTOsB;
  }