/*
 * 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 filialGS {
    public int chave = 0;
    public String razao_social = null;
    public String nome_fantasia = null;
    public String endereco = null;
    public String numero = null;
    public String complemento = null;
    public String bairro = null;
    public String cidade = null;
    public String uf = null;
    public String cep = null;
    public String fone = null;
    public String cnpj = null;
    public String ie = null;
    public String im = null;
    public String cae = null;
    public String contador = null;
    public String crc = null;
    public String cpfconta = null;
    public String cei = null;
    public String natjur = null;
    public String diainiati = null;
    public String capsocial = null;
    public String codempreinss = null;
    public String percfpas = null;
    public String percterc = null;
    public String percacidtrab = null;
    public String fpas = null;
    public String codsat = null;
    public String contafgts = null;
    public String codcentramov = null;
    public String categempregador = null;
    public String codrecfgts = null;
    public String nroproprie = null;
    public String familiares = null;
    public String dtbase = null;
    public String email = null;
    public String audit = null;
    public int idempresa = 0;

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

    public filialGS(){
    }

    public String getAudit() {
        return audit;
    }

    public void setAudit(String audit) {
        this.audit = audit;
    }

    public String getBairro() {
        return bairro;
    }

    public void setBairro(String bairro) {
        this.bairro = bairro;
    }

    public String getCae() {
        return cae;
    }

    public void setCae(String cae) {
        this.cae = cae;
    }

    public String getCapsocial() {
        return capsocial;
    }

    public void setCapsocial(String capsocial) {
        this.capsocial = capsocial;
    }

    public String getCategempregador() {
        return categempregador;
    }

    public void setCategempregador(String categempregador) {
        this.categempregador = categempregador;
    }

    public String getCei() {
        return cei;
    }

    public void setCei(String cei) {
        this.cei = cei;
    }

    public String getCep() {
        return cep;
    }

    public void setCep(String cep) {
        this.cep = cep;
    }

    public int getChave() {
        return chave;
    }

    public void setChave(int chave) {
        this.chave = chave;
    }

    public String getCidade() {
        return cidade;
    }

    public void setCidade(String cidade) {
        this.cidade = cidade;
    }

    public String getCnpj() {
        return cnpj;
    }

    public void setCnpj(String cnpj) {
        this.cnpj = cnpj;
    }

    public String getCodcentramov() {
        return codcentramov;
    }

    public void setCodcentramov(String codcentramov) {
        this.codcentramov = codcentramov;
    }

    public String getCodempreinss() {
        return codempreinss;
    }

    public void setCodempreinss(String codempreinss) {
        this.codempreinss = codempreinss;
    }

    public String getCodrecfgts() {
        return codrecfgts;
    }

    public void setCodrecfgts(String codrecfgts) {
        this.codrecfgts = codrecfgts;
    }

    public String getCodsat() {
        return codsat;
    }

    public void setCodsat(String codsat) {
        this.codsat = codsat;
    }

    public String getComplemento() {
        return complemento;
    }

    public void setComplemento(String complemento) {
        this.complemento = complemento;
    }

    public String getContador() {
        return contador;
    }

    public void setContador(String contador) {
        this.contador = contador;
    }

    public String getContafgts() {
        return contafgts;
    }

    public void setContafgts(String contafgts) {
        this.contafgts = contafgts;
    }

    public String getCpfconta() {
        return cpfconta;
    }

    public void setCpfconta(String cpfconta) {
        this.cpfconta = cpfconta;
    }

    public String getCrc() {
        return crc;
    }

    public void setCrc(String crc) {
        this.crc = crc;
    }

    public String getDiainiati() {
        return diainiati;
    }

    public void setDiainiati(String diainiati) {
        this.diainiati = diainiati;
    }

    public String getDtbase() {
        return dtbase;
    }

    public void setDtbase(String dtbase) {
        this.dtbase = dtbase;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getEndereco() {
        return endereco;
    }

    public void setEndereco(String endereco) {
        this.endereco = endereco;
    }

    public String getFamiliares() {
        return familiares;
    }

    public void setFamiliares(String familiares) {
        this.familiares = familiares;
    }

    public String getFone() {
        return fone;
    }

    public void setFone(String fone) {
        this.fone = fone;
    }

    public String getFpas() {
        return fpas;
    }

    public void setFpas(String fpas) {
        this.fpas = fpas;
    }

    public int getIdempresa() {
        return idempresa;
    }

    public void setIdempresa(int idempresa) {
        this.idempresa = idempresa;
    }

    public String getIe() {
        return ie;
    }

    public void setIe(String ie) {
        this.ie = ie;
    }

    public String getIm() {
        return im;
    }

    public void setIm(String im) {
        this.im = im;
    }

    public String getNatjur() {
        return natjur;
    }

    public void setNatjur(String natjur) {
        this.natjur = natjur;
    }

    public String getNome_fantasia() {
        return nome_fantasia;
    }

    public void setNome_fantasia(String nome_fantasia) {
        this.nome_fantasia = nome_fantasia;
    }

    public String getNroproprie() {
        return nroproprie;
    }

    public void setNroproprie(String nroproprie) {
        this.nroproprie = nroproprie;
    }

    public String getNumero() {
        return numero;
    }

    public void setNumero(String numero) {
        this.numero = numero;
    }

    public String getPercacidtrab() {
        return percacidtrab;
    }

    public void setPercacidtrab(String percacidtrab) {
        this.percacidtrab = percacidtrab;
    }

    public String getPercfpas() {
        return percfpas;
    }

    public void setPercfpas(String percfpas) {
        this.percfpas = percfpas;
    }

    public String getPercterc() {
        return percterc;
    }

    public void setPercterc(String percterc) {
        this.percterc = percterc;
    }

    public String getRazao_social() {
        return razao_social;
    }

    public void setRazao_social(String razao_social) {
        this.razao_social = razao_social;
    }

    public String getUf() {
        return uf;
    }

    public void setUf(String uf) {
        this.uf = uf;
    }

    public static boolean inserirFilial (filialGS filial){
        try{
            stm = Conexao.conectar().prepareStatement("insert into filiais(idfiliais, razao_social,"
		+ "nome_fantasia, endereco, numero, complemento, bairro, cidade, "
		+ "uf, cep, fone, cnpj, ie, im, cae, contador, crc, cpfconta, "
		+ "cei, natjur, dtiniativ, cap_social, cod_empr_inss, perc_fpas, "
		+ "perc_terc, perc_acid_trab, fpas, cod_sat, conta_fgts, cond_centra_mov,"
		+ "categ_empregador, cod_rec_fgts, nro_Propriet, fimiliares, "
		+ "dt_base, email, auditoria, empresa_idempresa) values "
                + "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
            stm.setInt(1, filial.getChave());
            stm.setString(2, filial.getRazao_social());
            stm.setString(3, filial.getNome_fantasia());
            stm.setString(4, filial.getEndereco());
            stm.setString(5, filial.getNumero());
            stm.setString(6, filial.getComplemento());
            stm.setString(7, filial.getBairro());
            stm.setString(8, filial.getCidade());
            stm.setString(9, filial.getUf());
            stm.setString(10, filial.getCep());
            stm.setString(11, filial.getFone());
            stm.setString(12, filial.getCnpj());
            stm.setString(13, filial.getIe());
            stm.setString(14, filial.getIm());
            stm.setString(15, filial.getCae());
            stm.setString(16, filial.getContador());
            stm.setString(17, filial.getCrc());
            stm.setString(18, filial.getCpfconta());
            stm.setString(19, filial.getCei());
            stm.setString(20, filial.getNatjur());
            stm.setString(21, filial.getDiainiati());
            stm.setString(22, filial.getCapsocial());
            stm.setString(23, filial.getCodempreinss());
            stm.setString(24, filial.getPercfpas());
            stm.setString(25, filial.getPercterc());
            stm.setString(26, filial.getPercacidtrab());
            stm.setString(27, filial.getFpas());
            stm.setString(28, filial.getCodsat());
            stm.setString(29, filial.getContafgts());
            stm.setString(30, filial.getCodcentramov());
            stm.setString(31, filial.getCategempregador());
            stm.setString(32, filial.getCodrecfgts());
            stm.setString(33, filial.getNroproprie());
            stm.setString(34, filial.getFamiliares());
            stm.setString(35, filial.getDtbase());
            stm.setString(36, filial.getEmail());
            stm.setString(37, filial.getAudit());
            stm.setInt(38, filial.getIdempresa());

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

    public static boolean alterarFilial (filialGS filial){
        boolean testa = false;
        try{
            stm = Conexao.conectar().prepareStatement("update filiais set razao_social=?,"
		+ "nome_fantasia=?, endereco=?, numero=?, complemento=?, bairro=?, cidade=?, "
		+ "uf=?, cep=?, fone=?, cnpj=?, ie=?, im=?, cae=?, contador=?, crc=?, cpfconta=?, "
		+ "cei=?, natjur=?, dtiniativ=?, cap_social=?, cod_empr_inss=?, perc_fpas=?, "
		+ "perc_terc=?, perc_acid_trab=?, fpas=?, cod_sat=?, conta_fgts=?, cond_centra_mov=?,"
		+ "categ_empregador=?, cod_rec_fgts=?, nro_Propriet=?, fimiliares=?, "
		+ "dt_base=?, email=?, auditoria=? "
                + "where idfiliais = ?");
            stm.setString(1, filial.getRazao_social());
            stm.setString(2, filial.getNome_fantasia());
            stm.setString(3, filial.getEndereco());
            stm.setString(4, filial.getNumero());
            stm.setString(5, filial.getComplemento());
            stm.setString(6, filial.getBairro());
            stm.setString(7, filial.getCidade());
            stm.setString(8, filial.getUf());
            stm.setString(9, filial.getCep());
            stm.setString(10, filial.getFone());
            stm.setString(11, filial.getCnpj());
            stm.setString(12, filial.getIe());
            stm.setString(13, filial.getIm());
            stm.setString(14, filial.getCae());
            stm.setString(15, filial.getContador());
            stm.setString(16, filial.getCrc());
            stm.setString(17, filial.getCpfconta());
            stm.setString(18, filial.getCei());
            stm.setString(19, filial.getNatjur());
            stm.setString(20, filial.getDiainiati());
            stm.setString(21, filial.getCapsocial());
            stm.setString(22, filial.getCodempreinss());
            stm.setString(23, filial.getPercfpas());
            stm.setString(24, filial.getPercterc());
            stm.setString(25, filial.getPercacidtrab());
            stm.setString(26, filial.getFpas());
            stm.setString(27, filial.getCodsat());
            stm.setString(28, filial.getContafgts());
            stm.setString(29, filial.getCodcentramov());
            stm.setString(30, filial.getCategempregador());
            stm.setString(31, filial.getCodrecfgts());
            stm.setString(32, filial.getNroproprie());
            stm.setString(33, filial.getFamiliares());
            stm.setString(34, filial.getDtbase());
            stm.setString(35, filial.getEmail());
            stm.setString(36, filial.getAudit());
            stm.setInt(37, filial.getChave());
            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 excluiFilial (filialGS filial){
        boolean testa = false;
        try {
            stm = Conexao.conectar().prepareStatement("delete from filiais "
                    + "where idfiliais = ?");
            stm.setInt(1, filial.getChave());
            int executeUpdate = stm.executeUpdate();

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

    public void selFilial(String Id) {
        try {
            filialGS scid = null;
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("Select * From filiais Where idfiliais ='"+Id+"'");
            if (rs.next()) {
                scid = new filialGS();
                scid.setChave(rs.getInt("chave"));
                scid.setRazao_social(rs.getString("razao_social"));
                scid.setNome_fantasia(rs.getString("nome_fantasia"));
                scid.setAudit(rs.getString("audit"));
                scid.setBairro(rs.getString("bairro"));
                scid.setCae(rs.getString("cae"));
                scid.setCapsocial(rs.getString("cap_social"));
                scid.setCategempregador(rs.getString("categ_empregador"));
                scid.setCei(rs.getString("cei"));
                scid.setCep(rs.getString("cep"));
                scid.setChave(rs.getInt("chave"));
                scid.setCidade(rs.getString("cidade"));
                scid.setCnpj(rs.getString("cnpj"));
                scid.setCodcentramov(rs.getString("cond_centra_mov"));
                scid.setCodempreinss(rs.getString("cod_empre_inss"));
                scid.setCodrecfgts(rs.getString("cod_rec_fgts"));
                scid.setCodsat(rs.getString("codsat"));
                scid.setComplemento(rs.getString("complemento"));
                scid.setContador(rs.getString("contador"));
                scid.setContafgts(rs.getString("conta_fgts"));
                scid.setCpfconta(rs.getString("cpfconta"));
                scid.setCrc(rs.getString("crc"));
                scid.setDiainiati(rs.getString("diainiati"));
                scid.setDtbase(rs.getString("dtbase"));
                scid.setEmail(rs.getString("email"));
                scid.setEndereco(rs.getString("endereco"));
                scid.setFamiliares(rs.getString("familiares"));
                scid.setFone(rs.getString(fone));
                scid.setFpas(rs.getString("fpas"));
                scid.setIdempresa(rs.getInt("empresa_idempresa"));
                scid.setIe(rs.getString("ie"));
                scid.setIm(rs.getString("im"));
                scid.setNatjur(rs.getString("natjur"));
                scid.setNome_fantasia(rs.getString("nome_fantasia"));
                scid.setNroproprie(rs.getString("nro_proprie"));
                scid.setNumero(rs.getString("numero"));
                scid.setPercacidtrab(rs.getString("perc_acid_trab"));
                scid.setPercfpas(rs.getString("perc_fpas"));
                scid.setPercterc(rs.getString("perc_terc"));
                scid.setRazao_social(rs.getString("razao_social"));
                scid.setUf(rs.getString("uf"));
            }
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static int getAutoInc(String Generator) {
        int Codigo = 0;
        try {
            PreparedStatement pstmt = Conexao.conectar().prepareStatement(
                    "Select max(idfiliais) From filiais");
            ResultSet rss = pstmt.executeQuery();
            rss.next();
            Codigo = rss.getInt(1) + 1;
        }
        catch (Exception e) {
            e.printStackTrace();
        }
        return Codigo;
    }

    public void listaFilial(String Id){
        try{
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("select * from filiais where "
                    +"empresa_idempresa = '"+Id+"' order by razao_social");
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public ResultSet getResultado(){
        return rs;
    }

}