package br.com.ddns.grupotsergio;

import java.sql.*;

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

/**
 *
 * @author Edson
 */
public class condicoesGS {
    public int chave = 0;
    public String descricao = null;
    public String parcelas = null;
    public String intervalo = null;
    public String auditoria = null;

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

    public condicoesGS(){
    }

    public String getAuditoria() {
        return auditoria;
    }

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

    public int getChave() {
        return chave;
    }

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

    public String getDescricao() {
        return descricao;
    }

    public void setDescricao(String descricao) {
        this.descricao = descricao;
    }

    public String getIntervalo() {
        return intervalo;
    }

    public void setIntervalo(String intervalo) {
        this.intervalo = intervalo;
    }

    public String getParcelas() {
        return parcelas;
    }

    public void setParcelas(String parcelas) {
        this.parcelas = parcelas;
    }

    public static boolean inserirCondicoes (condicoesGS condicoes){
        try{
            stm = Conexao.conectar().prepareStatement("insert into condicoes(idcondicoes, descricao, "
                    + "parcelas, intervalo, auditoria) values (?,?,?,?,?)");
            stm.setInt(1, condicoes.getChave());
            stm.setString(2, condicoes.getDescricao());
            stm.setString(3, condicoes.getParcelas());
            stm.setString(4, condicoes.getIntervalo());
            stm.setString(5, condicoes.getAuditoria());
            stm.executeUpdate();
            stm.close();
            return true;
        }catch(Exception e){
            System.out.println("Erro ao inserir");
            return false;
        }
    }

    public static boolean alterarCondicoes (condicoesGS condicoes){
        boolean testa = false;
        try{
            stm = Conexao.conectar().prepareStatement("update condicoes set "
                    + "descricao = ?, parcelas = ?, intervalo = ?, auditoria = ? "
                    + "where idcondicoes = ?");
            stm.setString(1, condicoes.getDescricao());
            stm.setString(2, condicoes.getParcelas());
            stm.setString(3, condicoes.getIntervalo());
            stm.setString(4, condicoes.getAuditoria());
            stm.setInt(5, condicoes.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 excluiCondicoes (condicoesGS condicoes){
        boolean testa = false;
        try {
            stm = Conexao.conectar().prepareStatement("delete from condicoes "
                    + "where idcondicoes = ?");
            stm.setInt(1, condicoes.getChave());
            int executeUpdate = stm.executeUpdate();

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

    public void selCondicoes(String Id) {
        try {
            condicoesGS scid = null;
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("Select * From condicoes Where idcondicoes ='"+Id+"'");
            if (rs.next()) {
                scid = new condicoesGS();
                scid.setChave(rs.getInt("chave"));
                scid.setDescricao(rs.getString("descricao"));
                scid.setParcelas(rs.getString("parcelas"));
                scid.setIntervalo(rs.getString("intervalo"));
                scid.setAuditoria(rs.getString("auditoria"));
            }
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

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

    public void listaCondicoes(){
        try{
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("select * from condicoes order by descricao");
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public ResultSet getResultado(){
        return rs;
    }

}