AccountEventFacade.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.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.TypedQuery;

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

@Stateless
@LocalBean
public class AccountEventFacade extends EventChildGenericFacade<AccountEvent> {

    @PersistenceContext
    private EntityManager em;

    @EJB
    private UserFacade userfacade;

    public AccountEventFacade() {
        super(AccountEvent.class);
    }

    protected EntityManager getEm() {
        return em;
    }

    @Override
    public void create(AccountEvent event) {
        super.create(event);
        userfacade.evict(event.getUser());
    }

    public List<Role> findProvidedRoles(LanEvent event, User u) {
        TypedQuery<Role> q = em.createQuery("select distinct ac.product.provides from AccountEvent ac where ac.id.eventId = :eventid and ac.user = :user and ac.product.provides is not null", Role.class);
        q.setParameter("eventid", event.getId());
        q.setParameter("user", u);
        return q.getResultList();
    }
}