RoleFacade.java

package fi.insomnia.bortal.facade;

import java.util.List;

import javax.ejb.LocalBean;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

import fi.insomnia.bortal.model.LanEvent;
import fi.insomnia.bortal.model.Role;
import fi.insomnia.bortal.model.Role_;
import fi.insomnia.bortal.model.User;

@Stateless
@LocalBean
public class RoleFacade extends GenericFacade<Integer, Role> {

	@PersistenceContext
	private EntityManager em;

	public RoleFacade() {
		super(Role.class);
	}

	@Override
	protected EntityManager getEm() {
		return em;
	}

	// 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(User user, LanEvent event) {
		CriteriaBuilder cb = em.getCriteriaBuilder();
		CriteriaQuery<Role> cq = cb.createQuery(Role.class);
		Root<Role> root = cq.from(Role.class);
		cq.where(cb.equal(root.get(Role_.event), event), cb.isMember(user, root.get(Role_.users)));

		return em.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(LanEvent event) {
		CriteriaBuilder cb = em.getCriteriaBuilder();
		CriteriaQuery<Role> cq = cb.createQuery(Role.class);
		Root<Role> root = cq.from(Role.class);
		cq.where(cb.equal(root.get(Role_.event), event));

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

}