/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package br.com.ddns.grupotsergio;

import java.sql.*;

/**
 *
 * @author Edson
 */
public class parametrosGS {
        String usalote = null;
        String uascontab = null;
        String usafiscal = null;
        String usacusto = null;
        String usafin = null;
        String alipis = null;
        String alicof = null;
        String aliir = null;
        String alics = null;
        String potaimpress = null;
        String portaleitora = null;
        String descobt = null;
        String jurospass = null;
        String multapass = null;
        String descconced = null;
        String jurosati = null;
        String mutaati = null;
        String retinss = null;
        String retpis = null;
        String retcof = null;
        String retir = null;
        String retcs = null;
        String retiss = null;
        String auditoria = null;
        String alipisret = null;
        String alicofret = null;
        String aliirret = null;
        String alicsret = null;
        String entretinss = null;
        String entretpis = null;
        String entretcof = null;
        String entretir = null;
        String entretcs = null;
        String entretiss = null;
        int filiais_idfiliais = 0;

    private static PreparedStatement stm = null;
    private static ResultSet rs = null;
    private static Statement stmt;

    public parametrosGS(){
    }

    public String getAlicof() {
        return alicof;
    }

    public void setAlicof(String alicof) {
        this.alicof = alicof;
    }

    public String getAlicofret() {
        return alicofret;
    }

    public void setAlicofret(String alicofret) {
        this.alicofret = alicofret;
    }

    public String getAlics() {
        return alics;
    }

    public void setAlics(String alics) {
        this.alics = alics;
    }

    public String getAlicsret() {
        return alicsret;
    }

    public void setAlicsret(String alicsret) {
        this.alicsret = alicsret;
    }

    public String getAliir() {
        return aliir;
    }

    public void setAliir(String aliir) {
        this.aliir = aliir;
    }

    public String getAliirret() {
        return aliirret;
    }

    public void setAliirret(String aliirret) {
        this.aliirret = aliirret;
    }

    public String getAlipis() {
        return alipis;
    }

    public void setAlipis(String alipis) {
        this.alipis = alipis;
    }

    public String getAlipisret() {
        return alipisret;
    }

    public void setAlipisret(String alipisret) {
        this.alipisret = alipisret;
    }

    public String getAuditoria() {
        return auditoria;
    }

    public void setAuditoria(String auditoria) {
        this.auditoria = auditoria;
    }

    public String getDescconced() {
        return descconced;
    }

    public void setDescconced(String descconced) {
        this.descconced = descconced;
    }

    public String getDescobt() {
        return descobt;
    }

    public void setDescobt(String descobt) {
        this.descobt = descobt;
    }

    public String getEntretcof() {
        return entretcof;
    }

    public void setEntretcof(String entretcof) {
        this.entretcof = entretcof;
    }

    public String getEntretcs() {
        return entretcs;
    }

    public void setEntretcs(String entretcs) {
        this.entretcs = entretcs;
    }

    public String getEntretinss() {
        return entretinss;
    }

    public void setEntretinss(String entretinss) {
        this.entretinss = entretinss;
    }

    public String getEntretir() {
        return entretir;
    }

    public void setEntretir(String entretir) {
        this.entretir = entretir;
    }

    public String getEntretiss() {
        return entretiss;
    }

    public void setEntretiss(String entretiss) {
        this.entretiss = entretiss;
    }

    public String getEntretpis() {
        return entretpis;
    }

    public void setEntretpis(String entretpis) {
        this.entretpis = entretpis;
    }

    public int getFiliais_idfiliais() {
        return filiais_idfiliais;
    }

    public void setFiliais_idfiliais(int filiais_idfiliais) {
        this.filiais_idfiliais = filiais_idfiliais;
    }

    public String getJurosati() {
        return jurosati;
    }

    public void setJurosati(String jurosati) {
        this.jurosati = jurosati;
    }

    public String getJurospass() {
        return jurospass;
    }

    public void setJurospass(String jurospass) {
        this.jurospass = jurospass;
    }

    public String getMultapass() {
        return multapass;
    }

    public void setMultapass(String multapass) {
        this.multapass = multapass;
    }

    public String getMutaati() {
        return mutaati;
    }

    public void setMutaati(String mutaati) {
        this.mutaati = mutaati;
    }

    public String getPortaleitora() {
        return portaleitora;
    }

    public void setPortaleitora(String portaleitora) {
        this.portaleitora = portaleitora;
    }

    public String getPotaimpress() {
        return potaimpress;
    }

    public void setPotaimpress(String potaimpress) {
        this.potaimpress = potaimpress;
    }

    public String getRetcof() {
        return retcof;
    }

    public void setRetcof(String retcof) {
        this.retcof = retcof;
    }

    public String getRetcs() {
        return retcs;
    }

    public void setRetcs(String retcs) {
        this.retcs = retcs;
    }

    public String getRetinss() {
        return retinss;
    }

    public void setRetinss(String retinss) {
        this.retinss = retinss;
    }

    public String getRetir() {
        return retir;
    }

    public void setRetir(String retir) {
        this.retir = retir;
    }

    public String getRetiss() {
        return retiss;
    }

    public void setRetiss(String retiss) {
        this.retiss = retiss;
    }

    public String getRetpis() {
        return retpis;
    }

    public void setRetpis(String retpis) {
        this.retpis = retpis;
    }

    public String getUascontab() {
        return uascontab;
    }

    public void setUascontab(String uascontab) {
        this.uascontab = uascontab;
    }

    public String getUsacusto() {
        return usacusto;
    }

    public void setUsacusto(String usacusto) {
        this.usacusto = usacusto;
    }

    public String getUsafin() {
        return usafin;
    }

    public void setUsafin(String usafin) {
        this.usafin = usafin;
    }

    public String getUsafiscal() {
        return usafiscal;
    }

    public void setUsafiscal(String usafiscal) {
        this.usafiscal = usafiscal;
    }

    public String getUsalote() {
        return usalote;
    }

    public void setUsalote(String usalote) {
        this.usalote = usalote;
    }

    public static boolean inserirParam (parametrosGS param){
        try{
            stm = Conexao.conectar().prepareStatement("INSERT INTO parametros("
                    + "filiais_idfiliais,"
                    + "usalote,"
                    + "uascontab,"
                    + "usafiscal,"
                    + "usacusto,"
                    + "usafin,"
                    + "alipis,"
                    + "alicof,"
                    + "aliir,"
                    + "alics,"
                    + "potaimpress,"
                    + "portaleitora,"
                    + "descobt,"
                    + "jurospass,"
                    + "multapass,"
                    + "descconced,"
                    + "jurosati,"
                    + "mutaati,"
                    + "retinss,"
                    + "retpis,"
                    + "retcof,"
                    + "retir,"
                    + "retcs,"
                    + "retiss,"
                    + "auditoria,"
                    + "alipisret,"
                    + "alicofret,"
                    + "aliirret,"
                    + "alicsret,"
                    + "entretinss,"
                    + "entretpis,"
                    + "entretcof,"
                    + "entretir,"
                    + "entretcs,"
                    + "entretiss) VALUES ("
                    + "?,?,?,?,?,?,?,?,?,?,"
                    + "?,?,?,?,?,?,?,?,?,?,"
                    + "?,?,?,?,?,?,?,?,?,?,"
                    + "?,?,?,?,?)");
            stm.setInt(1, param.getFiliais_idfiliais());
            stm.setString(2, param.getUsalote());
            stm.setString(3, param.getUascontab());
            stm.setString(4, param.getUsafiscal());
            stm.setString(5, param.getUsacusto());
            stm.setString(6, param.getUsafin());
            stm.setString(7, param.getAlipis());
            stm.setString(8, param.getAlicof());
            stm.setString(9, param.getAliir());
            stm.setString(10, param.getAlics());
            stm.setString(11, param.getPotaimpress());
            stm.setString(12, param.getPortaleitora());
            stm.setString(13, param.getDescobt());
            stm.setString(14, param.getJurospass());
            stm.setString(15, param.getMultapass());
            stm.setString(16, param.getDescconced());
            stm.setString(17, param.getJurosati());
            stm.setString(18, param.getMutaati());
            stm.setString(19, param.getRetinss());
            stm.setString(20, param.getRetpis());
            stm.setString(21, param.getRetcof());
            stm.setString(22, param.getRetir());
            stm.setString(23, param.getRetcs());
            stm.setString(24, param.getRetiss());
            stm.setString(25, param.getAuditoria());
            stm.setString(26, param.getAlipisret());
            stm.setString(27, param.getAlicofret());
            stm.setString(28, param.getAliirret());
            stm.setString(29, param.getAlicsret());
            stm.setString(30, param.getEntretinss());
            stm.setString(31, param.getEntretpis());
            stm.setString(32, param.getEntretcof());
            stm.setString(33, param.getEntretir());
            stm.setString(34, param.getEntretcs());
            stm.setString(35, param.getEntretiss());

            stm.executeUpdate();
            stm.close();
            return true;
        }catch(Exception e){
            System.out.println("Erro ao inserir");
            return false;
        }
    }

    public static boolean alteraParam(parametrosGS parama){
        boolean testa = false;
        try{
            stm = Conexao.conectar().prepareStatement("update parametros set "
                    + "usalote=?,"
                    + "uascontab=?,"
                    + "usafiscal=?,"
                    + "usacusto=?,"
                    + "alipis=?,"
                    + "alicof=?,"
                    + "aliir=?,"
                    + "alics=?,"
                    + "potaimpress=?,"
                    + "portaleitora=?,"
                    + "descobt=?,"
                    + "jurospass=?,"
                    + "multapass=?,"
                    + "descconced=?,"
                    + "jurosati=?,"
                    + "mutaati=?,"
                    + "retinss=?,"
                    + "retpis=?,"
                    + "retcof=?,"
                    + "retir=?,"
                    + "retcs=?,"
                    + "retiss=?,"
                    + "auditoria=?,"
                    + "alipisret=?,"
                    + "alicofret=?,"
                    + "aliirret=?,"
                    + "alicsret=?,"
                    + "entretinss=?,"
                    + "entretpis=?,"
                    + "entretcof=?,"
                    + "entretir=?,"
                    + "entretcs=?,"
                    + "entretiss=?,"
                    + "usafin=? "
                    + "where filiais_idfiliais=?");
            stm.setString(1, parama.getUsalote());
            stm.setString(2, parama.getUascontab());
            stm.setString(3, parama.getUsafiscal());
            stm.setString(4, parama.getUsacusto());
            stm.setString(5, parama.getAlipis());
            stm.setString(6, parama.getAlicof());
            stm.setString(7, parama.getAliir());
            stm.setString(8, parama.getAlics());
            stm.setString(9, parama.getPotaimpress());
            stm.setString(10, parama.getPortaleitora());
            stm.setString(11, parama.getDescobt());
            stm.setString(12, parama.getJurospass());
            stm.setString(13, parama.getMultapass());
            stm.setString(14, parama.getDescconced());
            stm.setString(15, parama.getJurosati());
            stm.setString(16, parama.getMutaati());
            stm.setString(17, parama.getRetinss());
            stm.setString(18, parama.getRetpis());
            stm.setString(19, parama.getRetcof());
            stm.setString(20, parama.getRetir());
            stm.setString(21, parama.getRetcs());
            stm.setString(22, parama.getRetiss());
            stm.setString(23, parama.getAuditoria());
            stm.setString(24, parama.getAlipisret());
            stm.setString(25, parama.getAlicofret());
            stm.setString(26, parama.getAliirret());
            stm.setString(27, parama.getAlicsret());
            stm.setString(28, parama.getEntretinss());
            stm.setString(29, parama.getEntretpis());
            stm.setString(30, parama.getEntretcof());
            stm.setString(31, parama.getEntretir());
            stm.setString(32, parama.getEntretcs());
            stm.setString(33, parama.getEntretiss());
            stm.setString(34, parama.getUsafin());
            stm.setInt(35, parama.getFiliais_idfiliais());

            int executeUpdate = stm.executeUpdate();

            if(executeUpdate > 0)
                testa = true;
            else
                testa = false;
        }catch(Exception e){
            System.out.println("Erro ao alterar");
        }
        return testa;
    }

    public static boolean excluiParam(parcelascomprasGS parame){
        boolean testa = false;
        try {
            stm = Conexao.conectar().prepareStatement("delete from parametros "
                    + "where filiais_idfiliais = ?");
            stm.setInt(1, parame.getFiliais_idfiliais());
            int executeUpdate = stm.executeUpdate();

            if(executeUpdate > 0)
                testa = true;
            else
                testa = false;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return testa;
    }

    public void selParam(String Id) {
        try {
            parametrosGS scid = null;
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("Select * From parametros Where "
                    + "filiais_idfiliais ='"+Id+"'");
            if (rs.next()) {
                scid = new parametrosGS();
                scid.setAlicof(rs.getString("alicof"));
                scid.setAlicofret(rs.getString("alicofret"));
                scid.setAlics(rs.getString("alics"));
                scid.setAlicsret(rs.getString("alicsret"));
                scid.setAliir(rs.getString("aliir"));
                scid.setAliirret(rs.getString("aliirret"));
                scid.setAlipis(rs.getString("alipis"));
                scid.setAlipisret(rs.getString("alipisret"));
                scid.setAuditoria(rs.getString("auditoria"));
                scid.setDescconced(rs.getString("descconced"));
                scid.setDescobt(rs.getString("descobt"));
                scid.setEntretcof(rs.getString("entretcof"));
                scid.setEntretcs(rs.getString("entretcs"));
                scid.setEntretinss(rs.getString("entretinss"));
                scid.setEntretir(rs.getString("entretir"));
                scid.setEntretiss(rs.getString("entretiss"));
                scid.setEntretpis(rs.getString("entretpis"));
                scid.setFiliais_idfiliais(rs.getInt("filiais_idfiliais"));
                scid.setJurosati(rs.getString("jurosati"));
                scid.setJurospass(rs.getString("jurospass"));
                scid.setMutaati(rs.getString("mutaati"));
                scid.setMultapass(rs.getString("multapass"));
                scid.setPortaleitora(rs.getString("portaleitora"));
                scid.setPotaimpress(rs.getString("potaimpress"));
                scid.setRetcof(rs.getString("retcof"));
                scid.setRetcs(rs.getString("retcs"));
                scid.setRetinss(rs.getString("retinss"));
                scid.setRetir(rs.getString("retir"));
                scid.setRetiss(rs.getString("retiss"));
                scid.setRetpis(rs.getString("retpis"));
                scid.setUascontab(rs.getString("uascontab"));
                scid.setUsacusto(rs.getString("usacusto"));
                scid.setUsafin(rs.getString("usafin"));
                scid.setUsafiscal(rs.getString("usafiscal"));
                scid.setUsalote(rs.getString("usalote"));
            }
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void listaParam(String Id){
        try{
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("select * from parametros where "
                    + "filiais_idfiliais = '"+Id+"'");
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public ResultSet getResultado(){
        return rs;
    }

}