BillFacade.java

package fi.insomnia.bortal.facade;

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.Bill;
import fi.insomnia.bortal.model.LanEvent;

@Stateless
@LocalBean
public class BillFacade extends EventChildGenericFacade<Bill> {

    @PersistenceContext
    private EntityManager em;

    public BillFacade() {
        super(Bill.class);
    }

    protected EntityManager getEm() {
        return em;
    }

    public int getBiggestBillNumber(LanEvent e) {
        TypedQuery<Integer> q = getEm().createNamedQuery("Bill.findbiggestBillNumber", Integer.class);
        q.setParameter("event", e);
        return q.getSingleResult();
    }

}