private void insertButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_insertButtonActionPerformed
        java.sql.Date dataInsc = new java.sql.Date(inserirData.getDate().getTime());
        try {
            Integer codEv = EventoBD.getCodeByName(inserirEv.getSelectedItem().toString());
            Integer idPe = PessoaBD.getIdByEmail(inserirBen.getSelectedItem().toString());
            String cnpj = PatrocinadorBD.getCnpjByName(inserirPat.getSelectedItem().toString());
            String valorPat = inserirValor.getText();
            if(valorPat.startsWith("£")||(valorPat.startsWith("$"))||(valorPat.startsWith("€"))){
                System.out.println(valorPat);
                valorPat = valorPat.substring(1);
                if(valorPat.contains(",")){
                    valorPat = valorPat.replace(",", "");
                }
            }
            else if(valorPat.contains("R$ ")){
                valorPat = valorPat.substring(3);
                if(valorPat.contains(",")){
                    valorPat = valorPat.replace(",", ".");
                }
            }
            else if(valorPat.contains(",")){
                valorPat = valorPat.replace(",", "");
            }
            
            System.out.println(valorPat);
            Double valor = Double.parseDouble(valorPat);
            
            AuxilioBD.inserir(cnpj, codEv, Integer.parseInt(inserirEd.getSelectedItem().toString()),
                idPe, valor.toString(), dataInsc.toString(), inserirTipoAux.getSelectedItem().toString());
            JOptionPane.showMessageDialog(null, "Auxilio inserido com sucesso " , "Successo", JOptionPane.INFORMATION_MESSAGE);
            clearFields();
            loadComboBox();
        } catch (SQLException | ParseException ex) {
            Logger.getLogger(TelaAuxilio.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_insertButtonActionPerformed