com.asociate.dao.AsociacionDAO.java Source code

Introduction

Here is the source code for com.asociate.dao.AsociacionDAO.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 com.asociate.dao;

import com.asociate.modelo.Asociacion;
import com.asociate.modelo.Persona;
import java.util.List;
import org.hibernate.JDBCException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

/**
 *
 * @author Ventura
 */
public class AsociacionDAO {

    /**
     *
     * @param regAsoc
     * @return
     */
    public boolean registrar(Asociacion regAsoc) {
        Boolean error = false;
        Transaction transaccion = null;
        Session sesion = HibernateUtil.getSessionFactory().openSession();
        try {
            transaccion = sesion.beginTransaction();
            sesion.save(regAsoc);
            transaccion.commit();
        } catch (JDBCException c) {
            c.printStackTrace();
            error = true;
            if (transaccion != null) {
                transaccion.rollback();
            }

        } catch (Exception e) {
            e.printStackTrace();
            error = true;
            if (transaccion != null) {
                transaccion.rollback();
            }
        } finally {
            sesion.flush();
            sesion.close();

        }
        return error;
    }

    /**
     *
     * @param id
     * @return
     */
    public Asociacion getAsociacionById(Long id) {
        Session sesion = HibernateUtil.getSessionFactory().openSession();
        Asociacion salida = null;
        try {

            salida = (Asociacion) sesion.get(Asociacion.class, id);

        } catch (JDBCException c) {
            c.printStackTrace();

        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            sesion.flush();
            sesion.close();

        }

        return salida;
    }

    /**
     *
     * @return
     */
    public List<Asociacion> getListaAsociaciones() {
        Session sesion = HibernateUtil.getSessionFactory().openSession();
        List<Asociacion> salida = null;
        try {

            salida = sesion.createQuery("Select A from Asociacion A where A.completa = 'S'").list();

        } catch (JDBCException c) {
            c.printStackTrace();

        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            sesion.flush();
            sesion.close();

        }

        return salida;
    }

    /**
     *
     * @return
     */
    public List<Asociacion> getListaAsocPendiente() {
        Session sesion = HibernateUtil.getSessionFactory().openSession();
        List<Asociacion> salida = null;
        try {

            salida = sesion.createQuery("Select A from Asociacion A where A.completa = 'N'").list();

        } catch (JDBCException c) {
            c.printStackTrace();

        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            sesion.flush();
            sesion.close();

        }

        return salida;
    }

    /**
     *
     * @param cif
     * @param estado
     */
    public void actualizarAsociacion(String cif, String estado) {
        Session sesion = HibernateUtil.getSessionFactory().openSession();

        try {

            sesion.createQuery("Update Asociacion A set A.completa=:es where A.cif=:cif").setParameter("es", estado)
                    .setParameter("cif", cif).executeUpdate();
            sesion.createQuery(
                    "Update Usuario U set U.bloqueado='S' where U.idUsuario =(Select A.idUsuario.idUsuario from Asociacion A where A.cif=:cif)")
                    .setParameter("cif", cif).executeUpdate();

        } catch (JDBCException c) {
            c.printStackTrace();

        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            sesion.flush();
            sesion.close();

        }
    }

    /**
     *
     * @param value
     * @return
     */
    public boolean comprobarCIF(String value) {
        boolean existe = false;
        Session sesion = HibernateUtil.getSessionFactory().openSession();
        Query qu = sesion.createQuery("Select A.cif from Asociacion A where A.cif=:cif").setString("cif", value);
        Object salida = qu.uniqueResult();

        if (salida != null) {
            existe = true;
        }
        sesion.flush();
        sesion.close();

        return existe;
    }

}