LanEventPrivatePropertyFacade.java 1.71 KB
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.LanEventPrivateProperty;
import fi.insomnia.bortal.model.LanEventPrivatePropertyKey;
import fi.insomnia.bortal.model.LanEventPrivateProperty_;

/**
 * Session Bean implementation class EventUserFacade
 */
@Stateless
@LocalBean
public class LanEventPrivatePropertyFacade extends IntegerPkGenericFacade<LanEventPrivateProperty> {

	public LanEventPrivatePropertyFacade() {
		super(LanEventPrivateProperty.class);
	}

	@EJB
	private EventBeanLocal eventbean;

	public LanEventPrivateProperty getPropertyForEvent(LanEventPrivatePropertyKey key)
	{
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<LanEventPrivateProperty> cq = cb.createQuery(LanEventPrivateProperty.class);
		Root<LanEventPrivateProperty> root = cq.from(LanEventPrivateProperty.class);
		cq.where(cb.equal(root.get(LanEventPrivateProperty_.event), eventbean.getCurrentEvent()),
				cb.equal(root.get(LanEventPrivateProperty_.key), key));
		return super.getSingleNullableResult(getEm().createQuery(cq));
	}

	public List<LanEventPrivateProperty> findAllForEvent() {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<LanEventPrivateProperty> cq = cb.createQuery(getEntityClass());
		Root<LanEventPrivateProperty> root = cq.from(getEntityClass());
		cq.where(cb.equal(root.get(LanEventPrivateProperty_.event), eventbean.getCurrentEvent()));

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

	}
}