/*
 * 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 orcavendasGS {
    int chave = 0;
    int idnaturfiscal = 0;
    int idcondicoes = 0;
    int idclifor = 0;
    int idrepres = 0;
    int idctto = 0;
    String dtemissao = null;
    String dtvcto = null;
    String baseicms = null;
    String vlricms = null;
    String baseicmss = null;
    String vlricmssub = null;
    String vlripi = null;
    String vlrfrete = null;
    String vlrseg = null;
    String vlroutras = null;
    String subtotal = null;
    String vlrdesc = null;
    String total = null;
    String obs = null;
    int filiais_idfiliais = 0;
    String prazoentrega = null;
    String localentrega = null;
    String titpedido = null;
    String impriimp = null;
    String auditoria = null;

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

    public orcavendasGS(){
    }

    public String getBaseicms() {
        return baseicms;
    }

    public void setBaseicms(String baseicms) {
        this.baseicms = baseicms;
    }

    public String getBaseicmss() {
        return baseicmss;
    }

    public void setBaseicmss(String baseicmss) {
        this.baseicmss = baseicmss;
    }

    public int getChave() {
        return chave;
    }

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

    public String getDtemissao() {
        return dtemissao;
    }

    public void setDtemissao(String dtemissao) {
        this.dtemissao = dtemissao;
    }

    public String getDtvcto() {
        return dtvcto;
    }

    public void setDtvcto(String dtvcto) {
        this.dtvcto = dtvcto;
    }

    public int getFiliais_idfiliais() {
        return filiais_idfiliais;
    }

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

    public int getIdclifor() {
        return idclifor;
    }

    public void setIdclifor(int idclifor) {
        this.idclifor = idclifor;
    }

    public int getIdcondicoes() {
        return idcondicoes;
    }

    public void setIdcondicoes(int idcondicoes) {
        this.idcondicoes = idcondicoes;
    }

    public int getIdctto() {
        return idctto;
    }

    public void setIdctto(int idctto) {
        this.idctto = idctto;
    }

    public int getIdnaturfiscal() {
        return idnaturfiscal;
    }

    public void setIdnaturfiscal(int idnaturfiscal) {
        this.idnaturfiscal = idnaturfiscal;
    }

    public int getIdrepres() {
        return idrepres;
    }

    public void setIdrepres(int idrepres) {
        this.idrepres = idrepres;
    }

    public String getObs() {
        return obs;
    }

    public void setObs(String obs) {
        this.obs = obs;
    }

    public String getSubtotal() {
        return subtotal;
    }

    public void setSubtotal(String subtotal) {
        this.subtotal = subtotal;
    }

    public String getTotal() {
        return total;
    }

    public void setTotal(String total) {
        this.total = total;
    }

    public String getVlrdesc() {
        return vlrdesc;
    }

    public void setVlrdesc(String vlrdesc) {
        this.vlrdesc = vlrdesc;
    }

    public String getVlrfrete() {
        return vlrfrete;
    }

    public void setVlrfrete(String vlrfrete) {
        this.vlrfrete = vlrfrete;
    }

    public String getVlricms() {
        return vlricms;
    }

    public void setVlricms(String vlricms) {
        this.vlricms = vlricms;
    }

    public String getVlricmssub() {
        return vlricmssub;
    }

    public void setVlricmssub(String vlricmssub) {
        this.vlricmssub = vlricmssub;
    }

    public String getVlripi() {
        return vlripi;
    }

    public void setVlripi(String vlripi) {
        this.vlripi = vlripi;
    }

    public String getVlroutras() {
        return vlroutras;
    }

    public void setVlroutras(String vlroutras) {
        this.vlroutras = vlroutras;
    }

    public String getVlrseg() {
        return vlrseg;
    }

    public void setVlrseg(String vlrseg) {
        this.vlrseg = vlrseg;
    }

    public String getImpriimp() {
        return impriimp;
    }

    public void setImpriimp(String impriimp) {
        this.impriimp = impriimp;
    }

    public String getLocalentrega() {
        return localentrega;
    }

    public void setLocalentrega(String localentrega) {
        this.localentrega = localentrega;
    }

    public String getPrazoentrega() {
        return prazoentrega;
    }

    public void setPrazoentrega(String prazoentrega) {
        this.prazoentrega = prazoentrega;
    }

    public String getTitpedido() {
        return titpedido;
    }

    public void setTitpedido(String titpedido) {
        this.titpedido = titpedido;
    }

    public String getAuditoria() {
        return auditoria;
    }

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

    public static boolean inserirOrcavenda (orcavendasGS compras){
        try{
            stm = Conexao.conectar().prepareStatement("insert into orcavendas(idvorcaendas,"
            + "idnaturfiscal,idcondicoes,idclifor,idrepres,idctto,dtemissao,"
            + "dtvcto,obs,filiais_idfiliais,prazoentrega,localentrega,"
            + "titpedido,impriimp,auditoria) "
            + "values ( "
            + "?,?,?,?,?,?,?,?,?,?,"
            + "?,?,?,?,?)");
            stm.setInt(1, compras.getChave());
            stm.setInt(2, compras.getIdnaturfiscal());
            stm.setInt(3, compras.getIdcondicoes());
            stm.setInt(4, compras.getIdclifor());
            stm.setInt(5, compras.getIdrepres());
            stm.setInt(6, compras.getIdctto());
            stm.setString(7, compras.getDtemissao());
            stm.setString(8, compras.getDtvcto());
            stm.setString(9, compras.getObs());
            stm.setInt(10, compras.getFiliais_idfiliais());
            stm.setString(11, compras.getPrazoentrega());
            stm.setString(12, compras.getLocalentrega());
            stm.setString(13, compras.getTitpedido());
            stm.setString(14, compras.getImpriimp());
            stm.setString(15, compras.getAuditoria());

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

    public static boolean alterarOrcavenda (orcavendasGS compras){
        boolean testa = false;
        try{
            stm = Conexao.conectar().prepareStatement("update orcavendas set idnaturfiscal=?,"
            + "idcondicoes=?,idclifor=?,idrepres=?,idctto=?,dtemissao=?,"
            + "dtvcto=?,baseicms=?,vlricms=?,baseicmss=?,vlricmssub=?,vlripi=?,"
            + "vlrfrete=?,vlrseg=?,vlroutras=?,subtotal=?,vlrdesc=?,total=?,"
            + "obs=?,filiais_idfiliais=?,prazoentrega=?,localentrega=?,"
            + "titpedido=?,impriimp=?,auditoria=? where idvorcaendas=?");
            stm.setInt(1, compras.getIdnaturfiscal());
            stm.setInt(2, compras.getIdcondicoes());
            stm.setInt(3, compras.getIdclifor());
            stm.setInt(4, compras.getIdrepres());
            stm.setInt(5, compras.getIdctto());
            stm.setString(6, compras.getDtemissao());
            stm.setString(7, compras.getDtvcto());
            stm.setString(8, compras.getBaseicms());
            stm.setString(9, compras.getVlricms());
            stm.setString(10, compras.getBaseicmss());
            stm.setString(11, compras.getVlricmssub());
            stm.setString(12, compras.getVlripi());
            stm.setString(13, compras.getVlrfrete());
            stm.setString(14, compras.getVlrseg());
            stm.setString(15, compras.getVlroutras());
            stm.setString(16, compras.getSubtotal());
            stm.setString(17, compras.getVlrdesc());
            stm.setString(18, compras.getTotal());
            stm.setString(19, compras.getObs());
            stm.setInt(20, compras.getFiliais_idfiliais());
            stm.setString(21, compras.getPrazoentrega());
            stm.setString(22, compras.getLocalentrega());
            stm.setString(23, compras.getTitpedido());
            stm.setString(24, compras.getImpriimp());
            stm.setString(25, compras.getAuditoria());
            stm.setInt(26, compras.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 excluiOrcavenda (orcavendasGS compras){
        boolean testa = false;
        try {
            stm = Conexao.conectar().prepareStatement("delete from orcavendas "
                    + "where idvorcaendas = ?");
            stm.setInt(1, compras.getChave());
            int executeUpdate = stm.executeUpdate();

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

    public void selOrcavenda(String Id) {
        try {
            orcavendasGS scid = null;
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("Select * From orcavendas Where "
                    + "idvorcaendas ='"+Id+"'");
            if (rs.next()) {
                scid = new orcavendasGS();
                scid.setChave(rs.getInt("chave"));
                scid.setIdclifor(rs.getInt("idclifor"));
                scid.setIdnaturfiscal(rs.getInt("idnaturfiscal"));
                scid.setIdcondicoes(rs.getInt("idcondicoes"));
                scid.setIdctto(rs.getInt("idctto"));
                scid.setIdrepres(rs.getInt("idrepres"));
                scid.setDtemissao(rs.getString("dtemissao"));
                scid.setDtvcto(rs.getString("dtvcto"));
                scid.setBaseicms(rs.getString("baseicms"));
                scid.setVlricms(rs.getString("vlricms"));
                scid.setBaseicms(rs.getString("baseicmss"));
                scid.setVlricmssub(rs.getString("vlricmssub"));
                scid.setVlripi(rs.getString("vlripi"));
                scid.setVlrfrete(rs.getString("vlrfrete"));
                scid.setVlrseg(rs.getString("vlrseg"));
                scid.setVlroutras(rs.getString("vlroutras"));
                scid.setSubtotal(rs.getString("subtotal"));
                scid.setVlrdesc(rs.getString("vlrdesc"));
                scid.setTotal(rs.getString("total"));
                scid.setPrazoentrega(rs.getString("prazoentrega"));
                scid.setLocalentrega(rs.getString("localentrega"));
                scid.setTitpedido(rs.getString("titpedido"));
                scid.setImpriimp(rs.getString("impriimp"));
                scid.setObs(rs.getString("obs"));
                scid.setAuditoria(rs.getString("auditoria"));
                scid.setFiliais_idfiliais(rs.getInt("filiais_idfiliais"));
            }
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

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

    public void listaOrcavenda(String Id){
        try{
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("select c.*, nome from orcavendas c, clifor f "
                    + "where c.idclifor=f.idclifor and "
                    + "filiais_idfiliais='"+Id+"' order by nome, idvorcaendas");
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public ResultSet getResultado(){
        return rs;
    }

}