RoleFacade.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.EventUser;
import fi.insomnia.bortal.model.LanEvent;
import fi.insomnia.bortal.model.Role;
import fi.insomnia.bortal.model.Role_;

@Stateless
@LocalBean
public class RoleFacade extends IntegerPkGenericFacade<Role> {

	@EJB
	private EventBeanLocal eventbean;

	public RoleFacade() {

		super(Role.class);
	}

	// public Role findByName(String name, LanEvent event) {
	// TypedQuery<Role> q = em.createNamedQuery("Role.findByRoleName",
	// Role.class);
	// q.setParameter("name", name);
	// q.setParameter("event", event);
	// return getSingleNullableResult(q);
	// }

	public List<Role> findForUser(EventUser user) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Role> cq = cb.createQuery(Role.class);
		Root<Role> root = cq.from(Role.class);
		cq.where(cb.equal(root.get(Role_.event), eventbean.getCurrentEvent()), cb.isMember(user, root.get(Role_.users)));

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

	public Role createRole(LanEvent event, String rolename) {
		Role ret = new Role(event);
		ret.setName(rolename);
		create(ret);
		return ret;
	}

	public List<Role> findAll() {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Role> cq = cb.createQuery(Role.class);
		Root<Role> root = cq.from(Role.class);
		cq.where(cb.equal(root.get(Role_.event), eventbean.getCurrentEvent()));

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

}