TournamentRuleFacade.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.EventBean;
import fi.codecrew.moya.model.Role;
import fi.codecrew.moya.model.Role_;
import fi.codecrew.moya.model.TournamentGame;
import fi.codecrew.moya.model.TournamentRule;
import fi.codecrew.moya.model.TournamentRule_;

@Stateless
@LocalBean
public class TournamentRuleFacade extends IntegerPkGenericFacade<TournamentRule> {
	
	public TournamentRuleFacade() {
		super(TournamentRule.class);
	}

	public List<TournamentRule> getRulesByGame(TournamentGame tg) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<TournamentRule> cq = cb.createQuery(TournamentRule.class);
		Root<TournamentRule> root = cq.from(TournamentRule.class);
		cq.where(cb.equal(root.get(TournamentRule_.tournamentGame), tg));

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