Search in sources :

Example 6 with TurmaPlanejada

use of com.tomasio.projects.trainning.model.TurmaPlanejada in project trainning by fernandotomasio.

the class HibernateTurmaDAO method findAllTurmasPlanejadas.

@Override
public List<TurmaPlanejadaDTO> findAllTurmasPlanejadas(Long planejamentoId, Long planoId, Long cursoId, Long responsavelId) throws DAOException {
    Session session = sessionFactory.getCurrentSession();
    try {
        Criteria criteria = session.createCriteria(TurmaPlanejada.class);
        criteria.createAlias("itemPlanejamento", "item");
        criteria.createAlias("curso", "c");
        if (planejamentoId != null && planejamentoId > 0L) {
            criteria.add(Restrictions.eq("item.planejamento.id", planejamentoId));
        }
        if (cursoId != null && cursoId > 0L) {
            criteria.add(Restrictions.eq("curso.id", cursoId));
        }
        if (responsavelId != null && responsavelId > 0L) {
            criteria.add(Restrictions.eq("responsavelId", responsavelId));
        }
        if (planoId != null && planoId > 0L) {
            criteria.add(Restrictions.eq("c.plano.id", planoId));
        }
        criteria.addOrder(Order.asc("numeroTurma"));
        @SuppressWarnings("unchecked") List<TurmaPlanejada> turmas = criteria.list();
        List<TurmaPlanejadaDTO> dto = new ArrayList<TurmaPlanejadaDTO>();
        for (TurmaPlanejada turma : turmas) {
            dto.add(turma.createDTOWithoutDependencies());
        }
        return dto;
    } catch (HibernateException e) {
        Logger.getLogger(HibernateTurmaDAO.class.getName()).log(Level.SEVERE, null, e);
        throw new DAOException(MessageHelper.getMessage("turmas.find.list.error"));
    }
}
Also used : TurmaPlanejada(com.tomasio.projects.trainning.model.TurmaPlanejada) DAOException(com.tomasio.projects.trainning.exception.DAOException) HibernateException(org.hibernate.HibernateException) ArrayList(java.util.ArrayList) Criteria(org.hibernate.Criteria) Session(org.hibernate.Session) TurmaPlanejadaDTO(com.tomasio.projects.trainning.dto.TurmaPlanejadaDTO)

Aggregations

TurmaPlanejada (com.tomasio.projects.trainning.model.TurmaPlanejada)6 DAOException (com.tomasio.projects.trainning.exception.DAOException)5 TurmaPlanejadaDTO (com.tomasio.projects.trainning.dto.TurmaPlanejadaDTO)3 CoreException (com.tomasio.projects.trainning.exeption.CoreException)2 Turma (com.tomasio.projects.trainning.model.Turma)2 ArrayList (java.util.ArrayList)2 Criteria (org.hibernate.Criteria)2 HibernateException (org.hibernate.HibernateException)2 Session (org.hibernate.Session)2 Transactional (org.springframework.transaction.annotation.Transactional)2 TurmaEfetivaDTO (com.tomasio.projects.trainning.dto.TurmaEfetivaDTO)1 Curso (com.tomasio.projects.trainning.model.Curso)1 Fase (com.tomasio.projects.trainning.model.Fase)1 ItemPlanejamento (com.tomasio.projects.trainning.model.ItemPlanejamento)1 Organizacao (com.tomasio.projects.trainning.model.Organizacao)1 Planejamento (com.tomasio.projects.trainning.model.Planejamento)1 StatusTurmaEfetiva (com.tomasio.projects.trainning.model.StatusTurmaEfetiva)1 TurmaEfetiva (com.tomasio.projects.trainning.model.TurmaEfetiva)1 HashSet (java.util.HashSet)1 Disjunction (org.hibernate.criterion.Disjunction)1