CompoFacade.java

package fi.insomnia.bortal.facade;

import java.util.List;

import javax.ejb.EJB;
import javax.ejb.LocalBean;
import javax.ejb.Stateless;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

import fi.insomnia.bortal.beans.EventBeanLocal;
import fi.insomnia.bortal.model.Compo;
import fi.insomnia.bortal.model.Compo_;
import fi.insomnia.bortal.model.NewsGroup;
import fi.insomnia.bortal.model.NewsGroup_;

@Stateless
@LocalBean
public class CompoFacade extends IntegerPkGenericFacade<Compo> {
	@EJB
	private EventBeanLocal eventbean;
	
    public CompoFacade() {
        super(Compo.class);
    }

	public List<Compo> getList() {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Compo> cq = cb.createQuery(Compo.class);
		Root<Compo> root = cq.from(Compo.class);
		cq.where(cb.equal(root.get(Compo_.event), eventbean.getCurrentEvent()));
		cq.orderBy(cb.desc(root.get(Compo_.startTime)));
		List<Compo> ret = getEm().createQuery(cq).getResultList();
		return ret;
	}
}