franta-hg@39: package cz.frantovo.nekurak.dao;
franta-hg@39: 
franta-hg@39: import cz.frantovo.nekurak.dto.Podnik;
franta-hg@39: import java.util.Collection;
franta-hg@49: import java.util.Date;
franta-hg@39: import javax.ejb.LocalBean;
franta-hg@39: import javax.ejb.Stateless;
franta-hg@39: import javax.persistence.EntityManager;
franta-hg@39: import javax.persistence.PersistenceContext;
franta-hg@39: import javax.persistence.Query;
franta-hg@39: 
franta-hg@39: /**
franta-hg@39:  *
franta-hg@39:  * @author fiki
franta-hg@39:  */
franta-hg@39: @Stateless
franta-hg@39: @LocalBean
franta-hg@48: public class PodnikDAO {
franta-hg@39: 
franta-hg@67:     @PersistenceContext(unitName = DAO.PU)
franta-hg@39:     private EntityManager em;
franta-hg@39: 
franta-hg@39:     public Collection<Podnik> getPodniky() {
franta-hg@67: 	Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " o ORDER BY datum DESC");
franta-hg@39: 	return dotaz.getResultList();
franta-hg@39:     }
franta-hg@39: 
franta-hg@100:     /**
franta-hg@100:      * @return podniky, které nemají souřadnice (null, null)
franta-hg@100:      */
franta-hg@100:     public Collection<Podnik> getPodnikyBezSouradnic() {
franta-hg@100: 	Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " o WHERE sirka IS NULL AND delka IS NULL");
franta-hg@100: 	return dotaz.getResultList();
franta-hg@100:     }
franta-hg@100: 
franta-hg@100:     public Podnik getPodnik(int id) {
franta-hg@100: 	return em.find(Podnik.class, id);
franta-hg@100:     }
franta-hg@100: 
franta-hg@56:     public void zaloz(Podnik p) {
franta-hg@49: 	if (p.getDatum() == null) {
franta-hg@49: 	    p.setDatum(new Date());
franta-hg@49: 	}
franta-hg@49: 
franta-hg@40: 	em.persist(p);
franta-hg@40:     }
franta-hg@40: 
franta-hg@56:     public void uloz(Podnik p) {
franta-hg@56: 	if (p.getDatum() == null) {
franta-hg@56: 	    p.setDatum(new Date());
franta-hg@56: 	}
franta-hg@56: 
franta-hg@56: 	em.merge(p);
franta-hg@56:     }
franta-hg@39: }