private void jbtAgreagarActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jbtAgreagarActionPerformed try { rs = con.Listar( "Id_Categoria", "categoria_mdo", "where Nombre_Categoria='" + jtfCategoria.getText() + "'"); while (rs.next()) { this.id = rs.getString("Id_Categoria"); } if (con.Altas( "mano_de_obra", "", "('" + jtfCodigo.getText() + "','" + id + "','" + jtfPrecio.getText() + "', '" + jtfItem.getText() + "','" + jtfDetalles.getText() + "', '" + jtfMinutos.getText() + "')")) { JOptionPane.showMessageDialog( rootPane, "Se ha registrado la mano de obra", "Éxito", JOptionPane.INFORMATION_MESSAGE); this.dispose(); } else { JOptionPane.showMessageDialog( rootPane, "No se ha podido registrar la mano de obra", "Error", JOptionPane.ERROR_MESSAGE); } } catch (SQLException ex) { Logger.getLogger(JDNMDO.class.getName()).log(Level.SEVERE, null, ex); } } // GEN-LAST:event_jbtAgreagarActionPerformed
private void jbtAgregarActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jbtAgregarActionPerformed try { rs = con.Listar( "Id_proveedor", "proveedor", "where Nom_proveedor='" + jtfProveedor.getText() + "'"); while (rs.next()) { this.prov = rs.getString("Id_proveedor"); } if (prov.equalsIgnoreCase("")) { JOptionPane.showMessageDialog( rootPane, "No existe tal proveedor", "Error", JOptionPane.ERROR_MESSAGE); jtfProveedor.requestFocus(); } rs = con.Listar( "Id_categoria_Insumo", "categoria_insumo", "where Nombre_categoria='" + jcbCategoria.getSelectedItem() + "'"); while (rs.next()) { this.id = rs.getString("Id_categoria_Insumo"); } if (id.equalsIgnoreCase("")) { JOptionPane.showMessageDialog( rootPane, "No existe tal insumo", "Error", JOptionPane.ERROR_MESSAGE); jcbCategoria.requestFocus(); } if (con.Altas( "insumos", "", "('" + jtfCodigo.getText() + "','" + prov + "','" + id + "','" + jtfNombre.getText() + "','" + jtfDescripcion.getText() + "','" + jtfCantidad.getText() + "','" + jtfPago.getText() + "','" + jtfPrecio.getText() + "')")) { JOptionPane.showMessageDialog( rootPane, "Se ha registrado el insumo", "Éxito", JOptionPane.INFORMATION_MESSAGE); this.dispose(); } else { JOptionPane.showMessageDialog( rootPane, "No se ha podido registrar el insumo", "Error", JOptionPane.ERROR_MESSAGE); } // Traer id proveedor e id categoria } catch (SQLException ex) { Logger.getLogger(JDNInsumo.class.getName()).log(Level.SEVERE, null, ex); } } // GEN-LAST:event_jbtAgregarActionPerformed