/*
 * CadastroFornecedoresManutencao.java
 *
 * Created on 10 de Maio de 2008, 08:39
 */

package sistema;

import java.sql.*;
import javax.swing.JOptionPane;

/**
 *
 * @author  awolf
 */
public class CadastroFornecedoresManutencao extends javax.swing.JDialog {
    
    /** Creates new form CadastroFornecedoresManutencao */
    private Connection conexao=null;
    public CadastroFornecedoresManutencao(java.awt.Frame parent, boolean modal, Connection conexao) {
        super(parent, modal);
        this.conexao=conexao;
        initComponents();
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" Código Gerado ">//GEN-BEGIN:initComponents
    private void initComponents() {
        paDados = new javax.swing.JPanel();
        paCampos = new javax.swing.JPanel();
        paLabels = new javax.swing.JPanel();
        lbCodigo = new javax.swing.JLabel();
        lbNome = new javax.swing.JLabel();
        lbEndereco = new javax.swing.JLabel();
        lbBairro = new javax.swing.JLabel();
        lbCidade = new javax.swing.JLabel();
        lbEmail = new javax.swing.JLabel();
        jLabel1 = new javax.swing.JLabel();
        taDados = new javax.swing.JPanel();
        paTextField = new javax.swing.JPanel();
        tfCodigo = new javax.swing.JTextField();
        tfNome = new javax.swing.JTextField();
        tfEndereco = new javax.swing.JTextField();
        tfBairro = new javax.swing.JTextField();
        tfCidade = new javax.swing.JTextField();
        tfEmail = new javax.swing.JTextField();
        tfTelefone = new javax.swing.JTextField();
        paBotoes = new javax.swing.JPanel();
        paBotoesOkCancelar = new javax.swing.JPanel();
        btOk = new javax.swing.JButton();
        btCancelar = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        paDados.setLayout(new java.awt.BorderLayout(2, 0));

        paCampos.setLayout(new java.awt.BorderLayout(2, 0));

        paLabels.setLayout(new java.awt.GridLayout(7, 1, 2, 7));

        lbCodigo.setText("C\u00f3digo");
        paLabels.add(lbCodigo);

        lbNome.setText("Nome");
        paLabels.add(lbNome);

        lbEndereco.setText("Endere\u00e7o");
        paLabels.add(lbEndereco);

        lbBairro.setText("Bairro");
        paLabels.add(lbBairro);

        lbCidade.setText("Cidade");
        paLabels.add(lbCidade);

        lbEmail.setText("Email");
        paLabels.add(lbEmail);

        jLabel1.setText("Telefone");
        paLabels.add(jLabel1);

        paCampos.add(paLabels, java.awt.BorderLayout.NORTH);

        paDados.add(paCampos, java.awt.BorderLayout.WEST);

        taDados.setLayout(new java.awt.BorderLayout());

        paTextField.setLayout(new java.awt.GridLayout(8, 1, 0, 2));

        paTextField.add(tfCodigo);

        paTextField.add(tfNome);

        paTextField.add(tfEndereco);

        paTextField.add(tfBairro);

        paTextField.add(tfCidade);

        paTextField.add(tfEmail);

        paTextField.add(tfTelefone);

        taDados.add(paTextField, java.awt.BorderLayout.NORTH);

        paDados.add(taDados, java.awt.BorderLayout.CENTER);

        getContentPane().add(paDados, java.awt.BorderLayout.CENTER);

        paBotoes.setLayout(new java.awt.BorderLayout());

        paBotoesOkCancelar.setLayout(new java.awt.GridLayout(1, 2));

        btOk.setText("Ok");
        btOk.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btOkActionPerformed(evt);
            }
        });

        paBotoesOkCancelar.add(btOk);

        btCancelar.setText("Cancelar");
        btCancelar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btCancelarActionPerformed(evt);
            }
        });

        paBotoesOkCancelar.add(btCancelar);

        paBotoes.add(paBotoesOkCancelar, java.awt.BorderLayout.EAST);

        getContentPane().add(paBotoes, java.awt.BorderLayout.SOUTH);

        pack();
    }// </editor-fold>//GEN-END:initComponents
    
    private void btCancelarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btCancelarActionPerformed
        dispose();
    }//GEN-LAST:event_btCancelarActionPerformed
    
    private void btOkActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btOkActionPerformed
        if(tfCodigo.isEditable()){ //incluir
            try {
                Statement st=conexao.createStatement();
                st.execute("Insert into Clientes(codigo, nome, endereco, " +
                        "bairro, cidade, telefone, email)values("+
                        "\""+tfCodigo.getText()+"\","+
                        "\""+tfNome.getText()+"\","+
                        "\""+tfEndereco.getText()+"\","+
                        "\""+tfBairro.getText()+"\","+
                        "\""+tfCidade.getText()+"\","+
                        "\""+tfTelefone.getText()+"\","+
                        "\""+tfEmail.getText()+"\")"
                        );
                
            } catch (SQLException ex) {
                ex.printStackTrace();
                JOptionPane.showMessageDialog(null, "Erro ao cadastrar\n"+ex, "Erro", JOptionPane.ERROR_MESSAGE);
            }
        }else{ //alterar
            try {
                Statement st=conexao.createStatement();
                st.execute("Update Clientes set " +
                        "nome=\""+tfNome.getText()+"\","+
                        "endereco=\""+tfEndereco.getText()+"\","+
                        "bairro=\""+tfBairro.getText()+"\","+
                        "cidade=\""+tfCidade.getText()+"\","+
                        "telefone=\""+tfTelefone.getText()+"\","+
                        "email=\""+tfEmail.getText()+"\" "+
                        "Where codigo=\""+tfCodigo.getText()+"\""
                        );
                
            } catch (SQLException ex) {
                ex.printStackTrace();
                JOptionPane.showMessageDialog(null, "Erro ao alterar\n"+ex, "Erro", JOptionPane.ERROR_MESSAGE);
            }
        }
        dispose();
    }//GEN-LAST:event_btOkActionPerformed
    
    public void setCodigoEditable(boolean b){
        tfCodigo.setEditable(b);
    }
    
    public void carregaDados(String codigo){
        try {
            Statement st=conexao.createStatement();
            ResultSet rs=st.executeQuery(
                    "Select * From Clientes "+
                    "Where codigo=\""+codigo+"\"");
            rs.next();
            tfCodigo.setText(rs.getString("Codigo"));
            tfNome.setText(rs.getString("Nome"));
            tfEndereco.setText(rs.getString("Endereco"));
            tfBairro.setText(rs.getString("Bairro"));
            tfCidade.setText(rs.getString("Cidade"));
            tfEmail.setText(rs.getString("Email"));
            tfTelefone.setText(rs.getString("Telefone"));
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    
    // Declaração de variáveis - não modifique//GEN-BEGIN:variables
    private javax.swing.JButton btCancelar;
    private javax.swing.JButton btOk;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel lbBairro;
    private javax.swing.JLabel lbCidade;
    private javax.swing.JLabel lbCodigo;
    private javax.swing.JLabel lbEmail;
    private javax.swing.JLabel lbEndereco;
    private javax.swing.JLabel lbNome;
    private javax.swing.JPanel paBotoes;
    private javax.swing.JPanel paBotoesOkCancelar;
    private javax.swing.JPanel paCampos;
    private javax.swing.JPanel paDados;
    private javax.swing.JPanel paLabels;
    private javax.swing.JPanel paTextField;
    private javax.swing.JPanel taDados;
    private javax.swing.JTextField tfBairro;
    private javax.swing.JTextField tfCidade;
    private javax.swing.JTextField tfCodigo;
    private javax.swing.JTextField tfEmail;
    private javax.swing.JTextField tfEndereco;
    private javax.swing.JTextField tfNome;
    private javax.swing.JTextField tfTelefone;
    // Fim da declaração de variáveis//GEN-END:variables
    
}