package DAO;
import Entidade.ItemPainelDeBordo;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
public class ItemPainelDeBordoDao {
public void salvar(ItemPainelDeBordo ipdb){
Session session = HibernateUtil.getSessionFactory().openSession();
session.beginTransaction();
session.save(ipdb);
session.getTransaction().commit();
session.close();
}
public List<ItemPainelDeBordo> listarPainelDeBordo(){
Session session = HibernateUtil.getSessionFactory().openSession();
session.beginTransaction();
Query lista = session.createQuery("FROM ItemPainelDeBordo WHERE ipdbNumAnobase = cast(year(current_date()) as string)");
List list = lista.list();
session.getTransaction().commit();
session.close();
return list;
}
public List<ItemPainelDeBordo> listarPainelDeBordoAno(String ano){
Session session = HibernateUtil.getSessionFactory().openSession();
session.beginTransaction();
Query lista = session.createQuery("FROM ItemPainelDeBordo WHERE ipdbNumAnobase = :ano");
lista.setString("ano", ano);
List list = lista.list();
session.getTransaction().commit();
session.close();
return list;
}
public List<ItemPainelDeBordo> listarAnoBase(){
Session session = HibernateUtil.getSessionFactory().openSession();
session.beginTransaction();
Query lista = session.createQuery("SELECT DISTINCT ipdbNumAnobase FROM ItemPainelDeBordo");
List list = lista.list();
session.getTransaction().commit();
session.close();
return list;
}
public ItemPainelDeBordo consultarPorId(String codigo) {
Session session = HibernateUtil.getSessionFactory().openSession();
session.beginTransaction();
Query lista = session.createQuery("From ItemPainelDeBordo where ipdbNumAnobase = :ano");
lista.setString("ano", codigo);
ItemPainelDeBordo resultado = (ItemPainelDeBordo) lista.uniqueResult();
session.getTransaction().commit();
session.close();
return resultado;
}
}