gp.daoImpl.ListasGeneralesDaoImpl.java Source code

Introduction

Here is the source code for gp.daoImpl.ListasGeneralesDaoImpl.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 gp.daoImpl;

import gp.connectionFactory.MyBatisConnectionFactory;
import gp.dao.ListasGeneralesDAO;
import gp.model.AspectosGenerales;
import gp.model.Dependencias;
import gp.model.HistorialMontos;
import gp.model.MostrarAPG;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

/**
 *
 * @author OGPL
 */
public class ListasGeneralesDaoImpl implements ListasGeneralesDAO {

    private SqlSessionFactory sqlSessionFactory;

    public ListasGeneralesDaoImpl() {
        sqlSessionFactory = MyBatisConnectionFactory.getSqlSessionFactory();
    }

    public ListasGeneralesDaoImpl(SqlSessionFactory sqlSessionFactory) {
        this.sqlSessionFactory = sqlSessionFactory;
    }

    @Override
    public List<MostrarAPG> getProyeco2() {
        SqlSession session = sqlSessionFactory.openSession();
        List<MostrarAPG> ag = null;
        try {
            ag = session.selectList("ListasGenerales.getAspectosGenerales2");
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
        } finally {
            session.close();
        }
        return ag;
    }

    @Override
    public List<MostrarAPG> getProyeco(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        List<MostrarAPG> ag = null;
        try {
            ag = session.selectList("ListasGenerales.getAspectosGenerales1", codigo);
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
        } finally {
            session.close();
        }
        return ag;
    }

    @Override
    public void EliminarProyecto(String codigo) {
        try {
            System.out.println("eliminarnuevosdocus");
            eliminarNuevosDocumentos(codigo);
            System.out.println("eliminarEjecu");
            eliminarEjecucion(codigo);
            System.out.println("eliminarExpTecn");
            eliminarExpedientesTecnicos(codigo);
            System.out.println("eliminarProy");
            eliminarProy(codigo);
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

    public void eliminarNuevosDocumentos(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        try {
            session.delete("EliminarProy.deleteND", codigo);
            session.commit();
        } finally {
            session.close();
        }
    }

    public void eliminarEjecucion(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        try {
            session.delete("EliminarProy.deleteEjecu", codigo);
            session.commit();
        } finally {
            session.close();
        }
    }

    public void eliminarExpedientesTecnicos(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        try {
            session.delete("EliminarProy.deleteET", codigo);
            session.commit();
        } finally {
            session.close();
        }
    }

    public void eliminarProy(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        try {
            session.delete("EliminarProy.deleteProy", codigo);
            session.commit();
        } finally {
            session.close();
        }
    }

    @Override
    public List<String> getExpedientes() {
        SqlSession session = sqlSessionFactory.openSession();
        List<String> list = null;
        try {
            list = session.selectList("ListasGenerales.getExpedientes");
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
            System.out.println("ERROR EN EL IMPL");
        } finally {
            session.close();
        }
        return list;
    }

    @Override
    public List<String> getResoluciones() {
        SqlSession session = sqlSessionFactory.openSession();
        List<String> list = null;
        try {
            list = session.selectList("ListasGenerales.getResoluciones");
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
            System.out.println("ERROR EN EL IMPL");
        } finally {
            session.close();
        }
        return list;
    }

    @Override
    public List<String> getInformes() {
        SqlSession session = sqlSessionFactory.openSession();
        List<String> list = null;
        try {
            list = session.selectList("ListasGenerales.getInformesOPYP");
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
            System.out.println("ERROR EN EL IMPL");
        } finally {
            session.close();
        }
        return list;
    }

    @Override
    public List<HistorialMontos> getMontosHistorial(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        List<HistorialMontos> list = null;
        try {
            list = session.selectList("ListasGenerales.getHistorialMontos", codigo);
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
            System.out.println("ERROR EN EL IMPL");
        } finally {
            session.close();
        }
        return list;
    }

    @Override
    public HistorialMontos getMontoViable(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        HistorialMontos h = null;
        try {
            h = session.selectOne("ListasGenerales.getMontoViable", codigo);
        } catch (Exception e) {
            System.out.println(e.getMessage());
            System.out.println("ERROR EN EL GET USU");
        } finally {
            session.close();
        }
        return h;
    }

    @Override
    public List<String> getDependencias(String codigo) {
        SqlSession session = sqlSessionFactory.openSession();
        List<String> list = null;
        try {
            list = session.selectList("ListasGenerales.getDependencias", codigo);
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
            System.out.println("ERROR EN EL IMPL");
        } finally {
            session.close();
        }
        return list;
    }

    @Override
    public List<String> getTipoUsuario() {
        SqlSession session = sqlSessionFactory.openSession();
        List<String> list = null;
        try {
            list = session.selectList("ListasGenerales.getiposUsuarios");
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
            System.out.println("ERROR EN EL IMPL");
        } finally {
            session.close();
        }
        return list;
    }

    @Override
    public Integer getIdDepencencia(String nombre) {
        SqlSession session = sqlSessionFactory.openSession();
        Integer h = null;
        try {
            h = session.selectOne("ListasGenerales.getIdDependencia", nombre);
        } catch (Exception e) {
            System.out.println(e.getMessage());
            System.out.println("ERROR EN EL GET USU");
        } finally {
            session.close();
        }
        return h;
    }

}