VoteFacade.java

package fi.insomnia.bortal.facade;

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.model.CompoEntry;
import fi.insomnia.bortal.model.EventUser;
import fi.insomnia.bortal.model.Vote;
import fi.insomnia.bortal.model.Vote_;

@Stateless
@LocalBean
public class VoteFacade extends IntegerPkGenericFacade<Vote> {

	public VoteFacade() {

		super(Vote.class);
	}

	public Vote find(CompoEntry entry, EventUser user) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Vote> cq = cb.createQuery(Vote.class);
		Root<Vote> root = cq.from(Vote.class);
		cq.where(cb.equal(root.get(Vote_.voter), user),
				cb.equal(root.get(Vote_.compoEntry), entry)
				);
		return super.getSingleNullableResult(getEm().createQuery(cq));
	}
}