LectureGroupFacade.java

package fi.codecrew.moya.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.codecrew.moya.beans.EventBeanLocal;
import fi.codecrew.moya.model.LectureGroup;
import fi.codecrew.moya.model.LectureGroup_;

@Stateless
@LocalBean
public class LectureGroupFacade extends IntegerPkGenericFacade<LectureGroup> {
	public LectureGroupFacade() {
		super(LectureGroup.class);
	}
	
	@EJB
	EventBeanLocal eventBean;

	public List<LectureGroup> getLectureGroups() {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<LectureGroup> cq = cb.createQuery(LectureGroup.class);
		Root<LectureGroup> root = cq.from(LectureGroup.class);
		cq.where(cb.equal(root.get(LectureGroup_.event), eventBean.getCurrentEvent() ) );

		return getEm().createQuery(cq).getResultList();
	}

}