/*
 * MaterialDAO.java
 *
 * Created on 25 de Junho de 2007, 08:26
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package dao;

import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.PersistenceContextType;
import javax.persistence.Query;
import s3e.Material;

/**
 *
 * @author aluno
 */
public class MaterialDAO {
    
    @PersistenceContext(unitName="ProjetoS3EPU", type=PersistenceContextType.EXTENDED)
    protected EntityManager em;	
    
    private static MaterialDAO instance = null;
    
    public static MaterialDAO getInstance() {
        if(instance == null) {
            instance = new MaterialDAO();
        }
        return instance;
    }
    
    /** Creates a new instance of MaterialDAO */
    public MaterialDAO() {
    }
    
    
    public List<Material> obterMateriais(Long idEvento){
        EntityManager em = FacadeJPA.getInstance().emf.createEntityManager();
        Query query = em.createQuery("SELECT e.materiais FROM Evento e WHERE e.id = :idEvento");
        query.setParameter("idEvento", idEvento);
        return query.getResultList();
    }

    public void inserirMaterial(Material material) {
        EntityManager em = FacadeJPA.getInstance().emf.createEntityManager();
        em.getTransaction().begin();
        em.persist(material);
        em.getTransaction().commit();
        em.close();
    }
}