br.endemics.dao.AreaDAO.java Source code

Introduction

Here is the source code for br.endemics.dao.AreaDAO.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package br.endemics.dao;

import br.endemics.model.Area;
import br.endemics.util.GenericDAO;
import br.endemics.util.HibernateUtil;
import br.endemics.util.UsuarioAtivo;
import java.util.List;
import javax.swing.JOptionPane;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import br.endemics.bean.ContextBean;

/**
 *
 * @author Pedro Saraiva
 */
public class AreaDAO extends GenericDAO<Area> {

    public AreaDAO() {
        super(Area.class);
    }

    public List<Area> list() {
        List<Area> lista = null;
        try {
            this.setSessao(HibernateUtil.getSessionFactory().openSession());
            setTransacao(getSessao().beginTransaction());
            lista = this.getSessao().createCriteria(Area.class)
                    .add(Restrictions.eq("city", UsuarioAtivo.getUser().getCity()))
                    .addOrder(Order.asc("description")).list();

        } catch (Throwable e) {
            if (getTransacao().isActive()) {
                getTransacao().rollback();
            }
            JOptionPane.showMessageDialog(null, "No foi possvel listar: " + e.getMessage());
        } finally {
            getSessao().close();
        }
        return lista;
    }

    public List<Area> pesquisarArea(String campo, String valor) {
        List<Area> lista = null;
        try {
            this.setSessao(HibernateUtil.getSessionFactory().openSession());
            setTransacao(getSessao().beginTransaction());
            lista = this.getSessao().createCriteria(Area.class)
                    .add(Restrictions.like(campo, valor, MatchMode.START))
                    .add(Restrictions.eq("city", UsuarioAtivo.getUser().getCity()))
                    .addOrder(Order.asc("description")).list();

        } catch (Throwable e) {
            if (getTransacao().isActive()) {
                getTransacao().rollback();
            }
            JOptionPane.showMessageDialog(null, "No foi possvel listar: " + e.getMessage());
        } finally {
            getSessao().close();
        }
        return lista;

    }

}