Nómina

Código Fuente:

//Corona

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.DecimalFormat;

import javax.swing.*;

import javax.swing.table.DefaultTableModel;

/**

*

* @author Edgar Leyva Corona

*/

public class cia_corona extends javax.swing.JFrame {

cia_empleados obj=new cia_empleados();

DecimalFormat d=new DecimalFormat("##########.00");

int retardos,faltas,pro,sp;

double inasistencias,inasistenciast,salario,

sueldo,dt,sd,neta,toti,

infon,imss,isr,subt,pago,resultado;

String nom,tele,cuenta,nut,seg,ape;

String db = "ciacorona_nomina"; //Nombre de la base de datos

String url = "jdbc:mysql://localhost:3306/"+db;

String user = "root"; //Usuario de MySql

String pass = ""; //Password de entrada

DefaultTableModel modelo;

String sSQL = "";

static Connection coneccion;

static Statement instruccion;

DefaultListModel mod;

public cia_corona() {

initComponents();

mod = new DefaultListModel();

calcuiii.setModel(mod);

}

@SuppressWarnings("unchecked")

// <editor-fold defaultstate="collapsed" desc="Generated Code">

private void initComponents() {

Calculo = new javax.swing.JTabbedPane();

jPanel1 = new javax.swing.JPanel();

jLabel2 = new javax.swing.JLabel();

jSeparator1 = new javax.swing.JSeparator();

jLabel3 = new javax.swing.JLabel();

nombre = new javax.swing.JTextField();

jLabel4 = new javax.swing.JLabel();

apellidos = new javax.swing.JTextField();

jLabel5 = new javax.swing.JLabel();

nutra = new javax.swing.JTextField();

jLabel6 = new javax.swing.JLabel();

seguro = new javax.swing.JTextField();

jLabel7 = new javax.swing.JLabel();

tel = new javax.swing.JTextField();

jSeparator3 = new javax.swing.JSeparator();

jLabel8 = new javax.swing.JLabel();

masc = new javax.swing.JRadioButton();

fem = new javax.swing.JRadioButton();

jLabel9 = new javax.swing.JLabel();

deptos = new javax.swing.JComboBox();

jLabel10 = new javax.swing.JLabel();

jLabel11 = new javax.swing.JLabel();

ret = new javax.swing.JTextField();

inas = new javax.swing.JTextField();

jLabel12 = new javax.swing.JLabel();

unobox = new javax.swing.JCheckBox();

tresbox = new javax.swing.JCheckBox();

cincobox = new javax.swing.JCheckBox();

jLabel13 = new javax.swing.JLabel();

cash = new javax.swing.JTextField();

salslider = new javax.swing.JSlider();

salprog = new javax.swing.JProgressBar();

jLabel14 = new javax.swing.JLabel();

jLabel15 = new javax.swing.JLabel();

jLabel16 = new javax.swing.JLabel();

jScrollPane1 = new javax.swing.JScrollPane();

calcuiii = new javax.swing.JList();

blist = new javax.swing.JButton();

calculo = new javax.swing.JButton();

jPanel2 = new javax.swing.JPanel();

jLabel1 = new javax.swing.JLabel();

jSeparator2 = new javax.swing.JSeparator();

jLabel17 = new javax.swing.JLabel();

nomcom = new javax.swing.JTextField();

jLabel18 = new javax.swing.JLabel();

nutrat = new javax.swing.JTextField();

jLabel19 = new javax.swing.JLabel();

seguros = new javax.swing.JTextField();

jLabel20 = new javax.swing.JLabel();

sexo = new javax.swing.JTextField();

jLabel21 = new javax.swing.JLabel();

dep = new javax.swing.JTextField();

jSeparator4 = new javax.swing.JSeparator();

jLabel22 = new javax.swing.JLabel();

totina = new javax.swing.JTextField();

jLabel23 = new javax.swing.JLabel();

desci = new javax.swing.JTextField();

jLabel24 = new javax.swing.JLabel();

info = new javax.swing.JTextField();

jLabel25 = new javax.swing.JLabel();

ims1 = new javax.swing.JTextField();

jLabel26 = new javax.swing.JLabel();

is = new javax.swing.JTextField();

jLabel27 = new javax.swing.JLabel();

sub = new javax.swing.JTextField();

jLabel28 = new javax.swing.JLabel();

neto = new javax.swing.JTextField();

jLabel29 = new javax.swing.JLabel();

jScrollPane2 = new javax.swing.JScrollPane();

ares = new javax.swing.JTextArea();

nuevo = new javax.swing.JButton();

jLabel30 = new javax.swing.JLabel();

dinero = new javax.swing.JTextField();

jPanel3 = new javax.swing.JPanel();

jScrollPane5 = new javax.swing.JScrollPane();

tabdat = new javax.swing.JTable();

jScrollPane7 = new javax.swing.JScrollPane();

tabpag = new javax.swing.JTable();

borrar = new javax.swing.JButton();

modificar = new javax.swing.JButton();

insertar = new javax.swing.JButton();

consulta = new javax.swing.JButton();

modificar1 = new javax.swing.JButton();

borrar1 = new javax.swing.JButton();

consulta1 = new javax.swing.JButton();

insertar1 = new javax.swing.JButton();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

Calculo.setBackground(new java.awt.Color(255, 153, 153));

Calculo.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));

Calculo.setTabPlacement(javax.swing.JTabbedPane.BOTTOM);

Calculo.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

Calculo.setFocusable(false);

Calculo.setFont(new java.awt.Font("Gisha", 1, 18)); // NOI18N

jPanel1.setBackground(new java.awt.Color(102, 102, 102));

jLabel2.setFont(new java.awt.Font("Gadugi", 1, 18)); // NOI18N

jLabel2.setForeground(new java.awt.Color(255, 255, 255));

jLabel2.setText("C.I.A. La Corona");

jLabel3.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel3.setForeground(new java.awt.Color(255, 255, 255));

jLabel3.setText("Nombre:");

jLabel4.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel4.setForeground(new java.awt.Color(255, 255, 255));

jLabel4.setText("Apellidos:");

jLabel5.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel5.setForeground(new java.awt.Color(255, 255, 255));

jLabel5.setText("No.Trabajador:");

jLabel6.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel6.setForeground(new java.awt.Color(255, 255, 255));

jLabel6.setText("Seguro Social:");

jLabel7.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel7.setForeground(new java.awt.Color(255, 255, 255));

jLabel7.setText("Teléfono:");

jLabel8.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel8.setForeground(new java.awt.Color(255, 255, 255));

jLabel8.setText("Sexo:");

masc.setBackground(new java.awt.Color(204, 204, 204));

masc.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N

masc.setForeground(new java.awt.Color(255, 255, 255));

masc.setText("M");

fem.setBackground(new java.awt.Color(204, 204, 204));

fem.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N

fem.setForeground(new java.awt.Color(255, 255, 255));

fem.setText("F");

jLabel9.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel9.setForeground(new java.awt.Color(255, 255, 255));

jLabel9.setText("Depto. :");

deptos.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "Distribuidores", "Oficinas", "Directivos", "Administrativos" }));

jLabel10.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel10.setForeground(new java.awt.Color(255, 255, 255));

jLabel10.setText("Retardos:");

jLabel11.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel11.setForeground(new java.awt.Color(255, 255, 255));

jLabel11.setText("Inasistencias:");

ret.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

retActionPerformed(evt);

}

});

inas.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

inasActionPerformed(evt);

}

});

jLabel12.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel12.setForeground(new java.awt.Color(255, 255, 255));

jLabel12.setText("Porcentaje IMSS:");

unobox.setBackground(new java.awt.Color(204, 204, 204));

unobox.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N

unobox.setForeground(new java.awt.Color(255, 255, 255));

unobox.setText("1%");

unobox.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

unoboxActionPerformed(evt);

}

});

tresbox.setBackground(new java.awt.Color(204, 204, 204));

tresbox.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N

tresbox.setForeground(new java.awt.Color(255, 255, 255));

tresbox.setText("3%");

tresbox.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

tresboxActionPerformed(evt);

}

});

cincobox.setBackground(new java.awt.Color(204, 204, 204));

cincobox.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N

cincobox.setForeground(new java.awt.Color(255, 255, 255));

cincobox.setText("5%");

cincobox.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

cincoboxActionPerformed(evt);

}

});

jLabel13.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel13.setForeground(new java.awt.Color(255, 255, 255));

jLabel13.setText("Salario:");

cash.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

cashActionPerformed(evt);

}

});

salslider.setBackground(new java.awt.Color(204, 204, 204));

salslider.setMajorTickSpacing(1500);

salslider.setMaximum(45000);

salslider.setValue(0);

salslider.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));

salslider.addChangeListener(new javax.swing.event.ChangeListener() {

public void stateChanged(javax.swing.event.ChangeEvent evt) {

salsliderStateChanged(evt);

}

});

salprog.setBackground(new java.awt.Color(255, 51, 51));

salprog.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

salprog.setMaximum(45000);

salprog.setToolTipText("");

salprog.setStringPainted(true);

jLabel14.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel14.setForeground(new java.awt.Color(255, 255, 255));

jLabel14.setText("Salario Máximo:");

jLabel15.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel15.setForeground(new java.awt.Color(255, 255, 255));

jLabel15.setText("$45,000.00");

jLabel16.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel16.setForeground(new java.awt.Color(255, 255, 255));

jLabel16.setText("Cálculo de ISR, IMSS e Infonavit:");

jScrollPane1.setViewportView(calcuiii);

blist.setFont(new java.awt.Font("Trebuchet MS", 1, 12)); // NOI18N

blist.setText("VER");

blist.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

blistActionPerformed(evt);

}

});

calculo.setFont(new java.awt.Font("Trebuchet MS", 1, 18)); // NOI18N

calculo.setText("Calcular");

calculo.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

calculoActionPerformed(evt);

}

});

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);

jPanel1.setLayout(jPanel1Layout);

jPanel1Layout.setHorizontalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addComponent(jLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 190, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(0, 0, Short.MAX_VALUE))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 190, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(blist)

.addGap(102, 102, 102)

.addComponent(calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 156, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jSeparator1)

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel5)

.addComponent(jLabel4)

.addComponent(jLabel3))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(apellidos, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(nutra, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(nombre, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel6)

.addComponent(jLabel7))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(tel, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(seguro, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGroup(jPanel1Layout.createSequentialGroup()

.addComponent(masc)

.addGap(18, 18, 18)

.addComponent(fem))))

.addComponent(jSeparator3))

.addComponent(jLabel8))

.addGap(46, 46, 46)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel9)

.addComponent(jLabel10)

.addComponent(jLabel11))

.addGap(27, 27, 27)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(inas, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(ret, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(deptos, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel12)

.addComponent(jLabel13)

.addComponent(jLabel14)

.addComponent(jLabel15, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addGroup(jPanel1Layout.createSequentialGroup()

.addComponent(unobox)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(tresbox))

.addComponent(cash))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(cincobox))

.addComponent(salslider, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)

.addComponent(salprog, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE))))))

.addContainerGap(196, Short.MAX_VALUE))))

);

jPanel1Layout.setVerticalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(salslider, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGroup(jPanel1Layout.createSequentialGroup()

.addComponent(jLabel2)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel3)

.addComponent(nombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel9)

.addComponent(deptos, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel4)

.addComponent(apellidos, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel10)

.addComponent(ret, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(9, 9, 9)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel5)

.addComponent(nutra, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel11)

.addComponent(inas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel6)

.addComponent(seguro, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel12)

.addComponent(unobox)

.addComponent(tresbox)

.addComponent(cincobox))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel7)

.addComponent(tel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(cash, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel8)

.addComponent(masc)

.addComponent(fem))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jSeparator3, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGap(17, 17, 17)

.addComponent(jLabel14)))))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(salprog, javax.swing.GroupLayout.DEFAULT_SIZE, 24, Short.MAX_VALUE)

.addComponent(jLabel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addGap(2, 2, 2)

.addComponent(jLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(blist)

.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 85, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(340, 340, 340))

);

Calculo.addTab("Datos ", jPanel1);

jPanel2.setBackground(new java.awt.Color(153, 153, 153));

jLabel1.setFont(new java.awt.Font("Gadugi", 1, 18)); // NOI18N

jLabel1.setForeground(new java.awt.Color(255, 255, 255));

jLabel1.setText("C.I.A. La Corona");

jLabel17.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel17.setForeground(new java.awt.Color(255, 255, 255));

jLabel17.setText("Nombre:");

nomcom.setEditable(false);

nomcom.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

nomcomActionPerformed(evt);

}

});

jLabel18.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel18.setForeground(new java.awt.Color(255, 255, 255));

jLabel18.setText("No.Trabajador:");

nutrat.setEditable(false);

nutrat.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

nutratActionPerformed(evt);

}

});

jLabel19.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel19.setForeground(new java.awt.Color(255, 255, 255));

jLabel19.setText("Seguro Social:");

seguros.setEditable(false);

seguros.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

segurosActionPerformed(evt);

}

});

jLabel20.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel20.setForeground(new java.awt.Color(255, 255, 255));

jLabel20.setText("Sexo:");

sexo.setEditable(false);

sexo.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

sexoActionPerformed(evt);

}

});

jLabel21.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel21.setForeground(new java.awt.Color(255, 255, 255));

jLabel21.setText("Departamento:");

dep.setEditable(false);

jLabel22.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel22.setForeground(new java.awt.Color(255, 255, 255));

jLabel22.setText("Total de Inasistencias:");

totina.setEditable(false);

totina.setText("0");

jLabel23.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel23.setForeground(new java.awt.Color(255, 255, 255));

jLabel23.setText("Descuento por Inasistencias:");

desci.setEditable(false);

desci.setText("0");

desci.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

desciActionPerformed(evt);

}

});

jLabel24.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel24.setForeground(new java.awt.Color(255, 255, 255));

jLabel24.setText("Infonavit:");

info.setText("0");

jLabel25.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel25.setForeground(new java.awt.Color(255, 255, 255));

jLabel25.setText("IMSS:");

ims1.setText("0");

ims1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

ims1ActionPerformed(evt);

}

});

jLabel26.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel26.setForeground(new java.awt.Color(255, 255, 255));

jLabel26.setText("ISR:");

is.setText("0");

is.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

isActionPerformed(evt);

}

});

jLabel27.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel27.setForeground(new java.awt.Color(255, 255, 255));

jLabel27.setText("Subtotal:");

sub.setText("0");

jLabel28.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel28.setForeground(new java.awt.Color(255, 255, 255));

jLabel28.setText("Salario Neto:");

neto.setText("0");

jLabel29.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel29.setForeground(new java.awt.Color(255, 255, 255));

jLabel29.setText("Resumen:");

ares.setEditable(false);

ares.setBackground(new java.awt.Color(102, 102, 102));

ares.setColumns(20);

ares.setFont(new java.awt.Font("Bitstream Vera Sans Mono", 0, 10)); // NOI18N

ares.setForeground(new java.awt.Color(255, 255, 255));

ares.setRows(5);

ares.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));

jScrollPane2.setViewportView(ares);

nuevo.setFont(new java.awt.Font("Trebuchet MS", 1, 12)); // NOI18N

nuevo.setText("Nuevo");

nuevo.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

nuevoActionPerformed(evt);

}

});

jLabel30.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N

jLabel30.setForeground(new java.awt.Color(255, 255, 255));

jLabel30.setText("Salario:");

dinero.setText("0");

javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);

jPanel2.setLayout(jPanel2Layout);

jPanel2Layout.setHorizontalGroup(

jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(jScrollPane2)

.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jSeparator2)

.addGroup(jPanel2Layout.createSequentialGroup()

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel18)

.addComponent(jLabel17))

.addGap(18, 18, 18)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(nomcom, javax.swing.GroupLayout.PREFERRED_SIZE, 135, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(nutrat, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addGroup(jPanel2Layout.createSequentialGroup()

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel19)

.addComponent(jLabel20))

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addGap(18, 18, 18)

.addComponent(seguros, javax.swing.GroupLayout.PREFERRED_SIZE, 107, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(jPanel2Layout.createSequentialGroup()

.addGap(20, 20, 20)

.addComponent(sexo, javax.swing.GroupLayout.PREFERRED_SIZE, 107, javax.swing.GroupLayout.PREFERRED_SIZE))))

.addGroup(jPanel2Layout.createSequentialGroup()

.addComponent(jLabel21)

.addGap(18, 18, 18)

.addComponent(dep))

.addComponent(jSeparator4)

.addComponent(jLabel29))

.addGap(63, 63, 63)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addComponent(jLabel22)

.addGap(50, 50, 50)

.addComponent(totina, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(jPanel2Layout.createSequentialGroup()

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel23)

.addComponent(jLabel24)

.addComponent(jLabel25)

.addComponent(jLabel26)

.addComponent(jLabel27)

.addComponent(jLabel28)

.addComponent(jLabel30))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(desci)

.addComponent(info)

.addComponent(ims1)

.addComponent(is)

.addComponent(sub)

.addComponent(neto)

.addComponent(nuevo, javax.swing.GroupLayout.DEFAULT_SIZE, 104, Short.MAX_VALUE)

.addComponent(dinero))))

.addContainerGap(127, Short.MAX_VALUE))

);

jPanel2Layout.setVerticalGroup(

jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel1)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel17)

.addComponent(nomcom, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel22)

.addComponent(totina, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel18)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(nutrat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel23)

.addComponent(desci, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel19)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(seguros, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel24)))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel20)

.addComponent(sexo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel25))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel21)

.addComponent(dep, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel26))

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addGap(11, 11, 11)

.addComponent(jSeparator4, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jLabel30))))

.addGroup(jPanel2Layout.createSequentialGroup()

.addComponent(info, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(ims1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(is, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(dinero, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel29)

.addComponent(jLabel27))

.addComponent(sub, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel28)

.addComponent(neto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(10, 10, 10)

.addComponent(nuevo, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE))

.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))

.addContainerGap(53, Short.MAX_VALUE))

);

Calculo.addTab("Cálculo", jPanel2);

jPanel3.setBackground(new java.awt.Color(153, 153, 153));

tabdat.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] {

{null, null, null, null},

{null, null, null, null},

{null, null, null, null},

{null, null, null, null}

},

new String [] {

"Nombre", "No. Trbajador", "Seguro ", "Departamento"

}

) {

boolean[] canEdit = new boolean [] {

false, false, false, false

};

public boolean isCellEditable(int rowIndex, int columnIndex) {

return canEdit [columnIndex];

}

});

jScrollPane5.setViewportView(tabdat);

tabpag.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] {

{null, null, null, null, null, null, null},

{null, null, null, null, null, null, null},

{null, null, null, null, null, null, null},

{null, null, null, null, null, null, null}

},

new String [] {

"No. Trabajador", "Desc. Inas.", "Infonavit", "IMSS", "ISR", "Salario", "Salario Neto"

}

) {

boolean[] canEdit = new boolean [] {

false, false, false, false, false, true, true

};

public boolean isCellEditable(int rowIndex, int columnIndex) {

return canEdit [columnIndex];

}

});

jScrollPane7.setViewportView(tabpag);

borrar.setText("Borrar");

borrar.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

borrarActionPerformed(evt);

}

});

modificar.setText("Modificar");

modificar.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

modificarActionPerformed(evt);

}

});

insertar.setText("Insertar");

insertar.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

insertarActionPerformed(evt);

}

});

consulta.setText("Consulta");

consulta.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

consultaActionPerformed(evt);

}

});

modificar1.setText("Modificar");

modificar1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

modificar1ActionPerformed(evt);

}

});

borrar1.setText("Borrar");

borrar1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

borrar1ActionPerformed(evt);

}

});

consulta1.setText("Consulta");

consulta1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

consulta1ActionPerformed(evt);

}

});

insertar1.setText("Insertar");

insertar1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

insertar1ActionPerformed(evt);

}

});

javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);

jPanel3.setLayout(jPanel3Layout);

jPanel3Layout.setHorizontalGroup(

jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel3Layout.createSequentialGroup()

.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel3Layout.createSequentialGroup()

.addGap(125, 125, 125)

.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel3Layout.createSequentialGroup()

.addComponent(insertar)

.addGap(18, 18, 18)

.addComponent(consulta)

.addGap(18, 18, 18)

.addComponent(borrar)

.addGap(18, 18, 18)

.addComponent(modificar))

.addGroup(jPanel3Layout.createSequentialGroup()

.addComponent(insertar1)

.addGap(18, 18, 18)

.addComponent(consulta1)

.addGap(18, 18, 18)

.addComponent(borrar1)

.addGap(18, 18, 18)

.addComponent(modificar1))))

.addGroup(jPanel3Layout.createSequentialGroup()

.addGap(30, 30, 30)

.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(jScrollPane7, javax.swing.GroupLayout.DEFAULT_SIZE, 653, Short.MAX_VALUE)

.addComponent(jScrollPane5))))

.addContainerGap(32, Short.MAX_VALUE))

);

jPanel3Layout.setVerticalGroup(

jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel3Layout.createSequentialGroup()

.addGap(34, 34, 34)

.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(insertar)

.addComponent(consulta)

.addComponent(borrar)

.addComponent(modificar))

.addGap(18, 18, 18)

.addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 56, Short.MAX_VALUE)

.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(modificar1)

.addComponent(borrar1)

.addComponent(consulta1)

.addComponent(insertar1))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jScrollPane7, javax.swing.GroupLayout.PREFERRED_SIZE, 112, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(46, 46, 46))

);

Calculo.addTab("Base de Datos", jPanel3);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());

getContentPane().setLayout(layout);

layout.setHorizontalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(Calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 722, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(10, 10, 10))

);

layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(Calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 471, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(10, 10, 10))

);

pack();

}// </editor-fold>

private void nuevoActionPerformed(java.awt.event.ActionEvent evt) {

mod.removeAllElements();

nombre.setText("");

apellidos.setText("");

nutra.setText("");

seguro.setText("");

tel.setText("");

ret.setText("");

inas.setText("");

cash.setText("");

nomcom.setText("");

nutrat.setText("");

seguros.setText("");

sexo.setText("");

dep.setText("");

totina.setText("");

info.setText("");

ims1.setText("");

sub.setText("");

is.setText("");

neto.setText("");

desci.setText("");

salprog.setValue(0);

salslider.setValue(0);

unobox.setSelected(false);

tresbox.setSelected(false);

cincobox.setSelected(false);

masc.setSelected(false);

fem.setSelected(false);

dinero.setText("");

deptos.setSelectedIndex(0);

ares.setText("");

}

private void isActionPerformed(java.awt.event.ActionEvent evt) {

}

private void ims1ActionPerformed(java.awt.event.ActionEvent evt) {

}

private void desciActionPerformed(java.awt.event.ActionEvent evt) {

}

private void sexoActionPerformed(java.awt.event.ActionEvent evt) {

}

private void segurosActionPerformed(java.awt.event.ActionEvent evt) {

}

private void nutratActionPerformed(java.awt.event.ActionEvent evt) {

}

private void calculoActionPerformed(java.awt.event.ActionEvent evt) {

cash.getText();

salario=Integer.parseInt(cash.getText());

ret.getText();

retardos=Integer.parseInt(ret.getText());

inas.getText();

inasistencias=Integer.parseInt(inas.getText());

String mensaje="";

if(masc.isSelected()){

mensaje=mensaje+"Masculino";

}else if(fem.isSelected()){

mensaje=mensaje+"Femenino";

}

infon=salario*.05;

sexo.setText(mensaje);

if(unobox.isSelected()==true){

imss=salario*.01;

}else if (tresbox.isSelected()==true){

imss=salario*.03;

}else if(cincobox.isSelected()==true){

imss=salario*.05;

}

nom=nombre.getText();

ape=apellidos.getText();

nomcom.setText(nom+" "+ape);

nutrat.setText(nutra.getText());

seguros.setText(seguro.getText());

Integer DeptIndex=deptos.getSelectedIndex();

String Dept=null;

if(DeptIndex.equals(1)){

Dept="Distribuidores";}

else if(DeptIndex.equals(2)){

Dept="Oficinas";

}else if(DeptIndex.equals(3)){

Dept="Directivos";

}else if(DeptIndex.equals(4)){

Dept="Administrativos";

}else if(DeptIndex.equals(0)){

Dept="No selecciono";

}

dep.setText(Dept);

faltas=retardos/3;

inasistencias=inasistencias+faltas;

sd=salario/15;

dt=15-inasistencias;

sueldo=sd*dt;

isr=(infon+imss)*.03;

pago=subt+isr;

toti=salario-sueldo;

subt=infon+imss+toti+isr;

neta=salario-subt;

totina.setText(""+inasistencias);

info.setText(d.format(infon));

ims1.setText(d.format(imss));

sub.setText(d.format(subt));

is.setText(d.format(isr));

neto.setText(d.format(neta));

desci.setText(d.format(toti));

pro=Integer.parseInt(cash.getText());

dinero.setText(d.format(pro));

int ineto=(int) pro;

sp=ineto;

salprog.setValue(sp);

ares.setText("Resumen del empleado\n"+"Nombre: "+nom+" "+ape+"\n"+"No. de Trabajador: "+nutra.getText()+

"\n"+"Seguro Social: "+seguro.getText()+"\n"+"Departamento: "+Dept+"\n"+"Salario: "+d.format(salario)+"\n"

+"Descuentos totales: -"+d.format(subt)+"\n"+"Sueldo Neto: "+d.format(pro));

}

private void blistActionPerformed(java.awt.event.ActionEvent evt) {

mod.addElement("ISR = (IMSS+INFONAVIT)*(.3)");

mod.addElement("IMSS = salario*(.1), (.3), (.5)");

mod.addElement("INFONAVIT =Salario*(.5)");

}

private void salsliderStateChanged(javax.swing.event.ChangeEvent evt) {

cash.setText(String.valueOf(salslider.getValue()));

int salslide;

salslide = Integer.parseInt(cash.getText());

salprog.setValue(salslide);

}

private void cashActionPerformed(java.awt.event.ActionEvent evt) {

cash.getText();

salario=Integer.parseInt(cash.getText());

}

private void cincoboxActionPerformed(java.awt.event.ActionEvent evt) {

}

private void tresboxActionPerformed(java.awt.event.ActionEvent evt) {

}

private void unoboxActionPerformed(java.awt.event.ActionEvent evt) {

}

private void inasActionPerformed(java.awt.event.ActionEvent evt) {

inas.getText();

inasistencias=Integer.parseInt(inas.getText());

}

private void retActionPerformed(java.awt.event.ActionEvent evt) {

ret.getText();

retardos=Integer.parseInt(ret.getText());

}

private void borrarActionPerformed(java.awt.event.ActionEvent evt) {

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// eliminar desde la base de datos

int emp=Integer.parseInt(nutrat.getText());

instruccion.executeUpdate("delete from datos where d_notrabajador='"+emp+"'");

JOptionPane.showMessageDialog(null," Registro Eliminado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void modificarActionPerformed(java.awt.event.ActionEvent evt) {

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

int a=Integer.parseInt(nutrat.getText());

try{

instruccion.executeUpdate(" update datos "

+ "set d_nombre='"+nomcom.getText()+"',"

+ " d_segurosoc='"+seguros.getText()+"'"

+ " d_depto='"+dep.getText()+"'"

+ "where d_notrabajador='"+a+"'");

JOptionPane.showMessageDialog(null,"Registro Modificado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"No existe Registro",JOptionPane.ERROR_MESSAGE);

}

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al modificar datos",JOptionPane.ERROR_MESSAGE);

}

catch(ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void insertarActionPerformed(java.awt.event.ActionEvent evt) {

String d_nombre=nomcom.getText();

String d_notrabajador=nutra.getText();

String d_segurosoc=seguro.getText();

String d_depto=dep.getText();

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

instruccion.executeUpdate

("insert into datos values('"+d_nombre+"','"+d_notrabajador+"','"+d_segurosoc+"','"+d_depto+"')");

JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"no se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

}

private void consultaActionPerformed(java.awt.event.ActionEvent evt) {

modelo = new DefaultTableModel();

// Creamos las columnas.

modelo.addColumn("Nombre");

modelo.addColumn("No. Trabajador");

modelo.addColumn("Seguro");

modelo.addColumn("Departamento");

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

ResultSet result=instruccion.executeQuery("select * FROM datos ORDER BY d_notrabajador");

while(result.next()){

//son 4 columnas, la dimesion del objeto datos de 4

Object[] datos = new Object[4];

for (int i = 0; i < 4; i++) {

datos[i] = result.getObject(i+1);

}

modelo.addRow(datos);

}

tabdat.setModel(modelo);

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error en la base de datos",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void modificar1ActionPerformed(java.awt.event.ActionEvent evt) {

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

int a=Integer.parseInt(nutrat.getText());

try{

instruccion.executeUpdate(" update calculo "

+ "set c_desinas='"+desci.getText()+"',"

+ " c_info='"+info.getText()+"'"

+ " c_imss='"+ims1.getText()+"'"

+ " c_isr='"+is.getText()+"'"

+ " c_sal='"+cash.getText()+"'"

+ " c_neto='"+neto.getText()+"'"

+ "where d_notrabajador='"+a+"'");

JOptionPane.showMessageDialog(null,"Registro Modificado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"No existe Registro",JOptionPane.ERROR_MESSAGE);

}

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al modificar datos",JOptionPane.ERROR_MESSAGE);

}

catch(ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void borrar1ActionPerformed(java.awt.event.ActionEvent evt) {

//Borrar1

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// eliminar desde la base de datos

int emp=Integer.parseInt(nutrat.getText());

instruccion.executeUpdate("delete from calculo where c_notrabajador='"+emp+"'");

JOptionPane.showMessageDialog(null,"Registro Eliminado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void consulta1ActionPerformed(java.awt.event.ActionEvent evt) {

modelo = new DefaultTableModel();

// Creamos las columnas. MODIFICAME

modelo.addColumn("No. Trabajador");

modelo.addColumn("Desc. Inas.");

modelo.addColumn("Infonavit");

modelo.addColumn("IMSS");

modelo.addColumn("ISR");

modelo.addColumn("Salario");

modelo.addColumn("Salario Neto");

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

ResultSet result=instruccion.executeQuery("select * FROM calculo ORDER BY c_notrabajador");

while(result.next()){

//son 8 columnas, la dimesion del objeto datos de 7

Object[] datos = new Object[7];

for (int i = 0; i < 7; i++) {

datos[i] = result.getObject(i+1);

}

modelo.addRow(datos);

}

tabpag.setModel(modelo);

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error en la base de datos",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void insertar1ActionPerformed(java.awt.event.ActionEvent evt) {

String c_notrabajador=nutrat.getText();

String c_desinas=desci.getText();

String c_info=info.getText();

String c_imss=ims1.getText();

String c_isr=is.getText();

String c_sal=cash.getText();

String c_neto=neto.getText();

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

instruccion.executeUpdate

("insert into calculo values"

+ "('"+c_notrabajador+"','"+c_desinas+"','"+c_info+"','"+c_imss+"','"

+c_isr+"','"+c_sal+"','"+c_neto+"')");

JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

}

private void nomcomActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

/**

* @param args the command line arguments

*/

public static void main(String args[]) {

/* Set the Nimbus look and feel */

//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">

/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.

* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html

*/

try {

for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {

if ("Nimbus".equals(info.getName())) {

javax.swing.UIManager.setLookAndFeel(info.getClassName());

break;

}

}

} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

}

//</editor-fold>

/* Create and display the form */

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new cia_corona().setVisible(true);

}

});

}

// Variables declaration - do not modify

private javax.swing.JTabbedPane Calculo;

private javax.swing.JTextField apellidos;

private javax.swing.JTextArea ares;

private javax.swing.JButton blist;

private javax.swing.JButton borrar;

private javax.swing.JButton borrar1;

private javax.swing.JList calcuiii;

private javax.swing.JButton calculo;

private javax.swing.JTextField cash;

private javax.swing.JCheckBox cincobox;

private javax.swing.JButton consulta;

private javax.swing.JButton consulta1;

private javax.swing.JTextField dep;

private javax.swing.JComboBox deptos;

private javax.swing.JTextField desci;

private javax.swing.JTextField dinero;

private javax.swing.JRadioButton fem;

private javax.swing.JTextField ims1;

private javax.swing.JTextField inas;

private javax.swing.JTextField info;

private javax.swing.JButton insertar;

private javax.swing.JButton insertar1;

private javax.swing.JTextField is;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel10;

private javax.swing.JLabel jLabel11;

private javax.swing.JLabel jLabel12;

private javax.swing.JLabel jLabel13;

private javax.swing.JLabel jLabel14;

private javax.swing.JLabel jLabel15;

private javax.swing.JLabel jLabel16;

private javax.swing.JLabel jLabel17;

private javax.swing.JLabel jLabel18;

private javax.swing.JLabel jLabel19;

private javax.swing.JLabel jLabel2;

private javax.swing.JLabel jLabel20;

private javax.swing.JLabel jLabel21;

private javax.swing.JLabel jLabel22;

private javax.swing.JLabel jLabel23;

private javax.swing.JLabel jLabel24;

private javax.swing.JLabel jLabel25;

private javax.swing.JLabel jLabel26;

private javax.swing.JLabel jLabel27;

private javax.swing.JLabel jLabel28;

private javax.swing.JLabel jLabel29;

private javax.swing.JLabel jLabel3;

private javax.swing.JLabel jLabel30;

private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel5;

private javax.swing.JLabel jLabel6;

private javax.swing.JLabel jLabel7;

private javax.swing.JLabel jLabel8;

private javax.swing.JLabel jLabel9;

private javax.swing.JPanel jPanel1;

private javax.swing.JPanel jPanel2;

private javax.swing.JPanel jPanel3;

private javax.swing.JScrollPane jScrollPane1;

private javax.swing.JScrollPane jScrollPane2;

private javax.swing.JScrollPane jScrollPane5;

private javax.swing.JScrollPane jScrollPane7;

private javax.swing.JSeparator jSeparator1;

private javax.swing.JSeparator jSeparator2;

private javax.swing.JSeparator jSeparator3;

private javax.swing.JSeparator jSeparator4;

private javax.swing.JRadioButton masc;

private javax.swing.JButton modificar;

private javax.swing.JButton modificar1;

private javax.swing.JTextField neto;

private javax.swing.JTextField nombre;

private javax.swing.JTextField nomcom;

private javax.swing.JButton nuevo;

private javax.swing.JTextField nutra;

private javax.swing.JTextField nutrat;

private javax.swing.JTextField ret;

private javax.swing.JProgressBar salprog;

private javax.swing.JSlider salslider;

private javax.swing.JTextField seguro;

private javax.swing.JTextField seguros;

private javax.swing.JTextField sexo;

private javax.swing.JTextField sub;

private javax.swing.JTable tabdat;

private javax.swing.JTable tabpag;

private javax.swing.JTextField tel;

private javax.swing.JTextField totina;

private javax.swing.JCheckBox tresbox;

private javax.swing.JCheckBox unobox;

// End of variables declaration

}

Código Fuente, Segundo programa:

import java.text.DecimalFormat;

import java.sql.*;

import javax.swing.*;

import javax.swing.table.DefaultTableModel;

public class nominas extends javax.swing.JFrame {

empleado obj=new empleado();

int retardos, faltas, inasistencias, salaryProgress, empnum;

double inasistenciast, salario, sueldo, dt,sd ,

neto, tot, infon, imss, isr, subt, pago, resultado;

String Nom, ApPat, ApMat;

String db = "sagn"; //Nombre de la base de datos

String url = "jdbc:mysql://localhost:3306/"+db;

String user = "root"; //Usuario de MySql

String pass = ""; //Password de entrada

DefaultTableModel modelo;

String sSQL = "";

static Connection coneccion;

static Statement instruccion;

public nominas() {

setResizable(false);

initComponents();

setLocation(300,50);

}

/**

* 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.

*/

@SuppressWarnings("unchecked")

// <editor-fold defaultstate="collapsed" desc="Generated Code">

private void initComponents() {

jMenuItem1 = new javax.swing.JMenuItem();

jPanel1 = new javax.swing.JPanel();

Gender = new javax.swing.ButtonGroup();

MainFrame = new javax.swing.JTabbedPane();

CalcPanel = new javax.swing.JPanel();

Name = new javax.swing.JTextField();

NameLabel = new javax.swing.JLabel();

Retard = new javax.swing.JTextField();

RetLabel = new javax.swing.JLabel();

FaultLabel = new javax.swing.JLabel();

Fault = new javax.swing.JTextField();

Salary = new javax.swing.JTextField();

SalaryLabel = new javax.swing.JLabel();

TotalFaultLabel = new javax.swing.JLabel();

TotalFault = new javax.swing.JTextField();

Cotizar = new javax.swing.JButton();

Copyright1 = new javax.swing.JLabel();

Header1 = new javax.swing.JLabel();

SAGN1 = new javax.swing.JLabel();

jSeparator1 = new javax.swing.JSeparator();

SAGN01 = new javax.swing.JLabel();

APat = new javax.swing.JTextField();

APaternoLabel = new javax.swing.JLabel();

AMat = new javax.swing.JTextField();

AMaterno = new javax.swing.JLabel();

Copyright3 = new javax.swing.JLabel();

EmpNo = new javax.swing.JTextField();

EmpNoLabel = new javax.swing.JLabel();

GenderLabel = new javax.swing.JLabel();

jRadioButtonM = new javax.swing.JRadioButton();

jRadioButtonF = new javax.swing.JRadioButton();

DepLabel = new javax.swing.JLabel();

DepComboBox = new javax.swing.JComboBox();

BonoPunt = new javax.swing.JCheckBox();

BonoProd = new javax.swing.JCheckBox();

BonoCap = new javax.swing.JCheckBox();

jScrollPane1 = new javax.swing.JScrollPane();

Listado = new javax.swing.JTextArea();

ListadoHeader = new javax.swing.JTextField();

ClearCalc = new javax.swing.JButton();

SalarySlider = new javax.swing.JSlider();

SalaryBar = new javax.swing.JProgressBar();

jScrollPane2 = new javax.swing.JScrollPane();

jTree = new javax.swing.JTree();

ListadoHeader1 = new javax.swing.JTextField();

loadPic = new javax.swing.JButton();

photoContainer = new javax.swing.JPanel();

Kain = new javax.swing.JLabel();

ResPanel = new javax.swing.JPanel();

jSeparator2 = new javax.swing.JSeparator();

Name2 = new javax.swing.JTextField();

NameLabel2 = new javax.swing.JLabel();

DescFaultLabel = new javax.swing.JLabel();

DescFault = new javax.swing.JTextField();

Infonavit = new javax.swing.JTextField();

InfonavitLabel = new javax.swing.JLabel();

IMSSLabel = new javax.swing.JLabel();

IMSS = new javax.swing.JTextField();

ISR = new javax.swing.JTextField();

ISRLabel = new javax.swing.JLabel();

SubTotalLabel = new javax.swing.JLabel();

SubTotal = new javax.swing.JTextField();

SalaryNetoLabel = new javax.swing.JLabel();

SalaryNeto = new javax.swing.JTextField();

TotalFaultLabel2 = new javax.swing.JLabel();

TotalFault2 = new javax.swing.JTextField();

Header2 = new javax.swing.JLabel();

SAGN2 = new javax.swing.JLabel();

SAGN02 = new javax.swing.JLabel();

Copyright2 = new javax.swing.JLabel();

Copyright4 = new javax.swing.JLabel();

EmpNo2 = new javax.swing.JTextField();

EmpNoLabel2 = new javax.swing.JLabel();

GenderLabel2 = new javax.swing.JLabel();

Gender1 = new javax.swing.JTextField();

DescFaultLabel1 = new javax.swing.JLabel();

Departamento = new javax.swing.JTextField();

ClearRes = new javax.swing.JButton();

jScrollPane3 = new javax.swing.JScrollPane();

EmpTable = new javax.swing.JTable();

HeaderEmpTable = new javax.swing.JTextField();

HeaderNominaTable = new javax.swing.JTextField();

ClrEmpTable = new javax.swing.JButton();

InsEmpTable = new javax.swing.JButton();

UpdEmpTable = new javax.swing.JButton();

QryEmpTable = new javax.swing.JButton();

ClrNomTable = new javax.swing.JButton();

InsNomTable = new javax.swing.JButton();

UpdNomTable = new javax.swing.JButton();

QryNomTable = new javax.swing.JButton();

$a = new javax.swing.JTextField();

$b = new javax.swing.JTextField();

$c = new javax.swing.JTextField();

$d = new javax.swing.JTextField();

$e = new javax.swing.JTextField();

f = new javax.swing.JTextField();

jScrollPane4 = new javax.swing.JScrollPane();

NomTable = new javax.swing.JTable();

jMenuItem1.setText("jMenuItem1");

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);

jPanel1.setLayout(jPanel1Layout);

jPanel1Layout.setHorizontalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGap(0, 100, Short.MAX_VALUE)

);

jPanel1Layout.setVerticalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGap(0, 100, Short.MAX_VALUE)

);

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

setTitle("S.A.G.N. - C.I.A. LA CORONA S.A. de C.V");

setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

MainFrame.setBackground(new java.awt.Color(204, 204, 204));

MainFrame.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.gray, java.awt.Color.darkGray, java.awt.Color.gray, java.awt.Color.lightGray));

MainFrame.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

MainFrame.setFocusable(false);

MainFrame.setPreferredSize(new java.awt.Dimension(820, 500));

CalcPanel.setBackground(new java.awt.Color(204, 204, 204));

CalcPanel.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

CalcPanel.setFocusCycleRoot(true);

Name.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

NameActionPerformed(evt);

}

});

NameLabel.setText("Nombre:");

Retard.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

RetardActionPerformed(evt);

}

});

RetLabel.setText("Retardos:");

FaultLabel.setText("Inasistencias:");

Fault.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

FaultActionPerformed(evt);

}

});

Salary.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

SalaryActionPerformed(evt);

}

});

SalaryLabel.setText("Salario Quincenal:");

TotalFaultLabel.setText("Total de Inasistencias:");

TotalFault.setEditable(false);

TotalFault.setBackground(new java.awt.Color(204, 204, 204));

TotalFault.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TotalFaultActionPerformed(evt);

}

});

Cotizar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

Cotizar.setText("COTIZAR");

Cotizar.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

CotizarActionPerformed(evt);

}

});

Cotizar.addKeyListener(new java.awt.event.KeyAdapter() {

public void keyPressed(java.awt.event.KeyEvent evt) {

CotizarKeyPressed(evt);

}

});

Copyright1.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N

Copyright1.setForeground(new java.awt.Color(51, 51, 51));

Copyright1.setText("Developed by Ing. Al Franco - 2013 copyright (c).");

Header1.setFont(new java.awt.Font("Bauhaus 93", 2, 24)); // NOI18N

Header1.setForeground(new java.awt.Color(51, 51, 51));

Header1.setText("C.I.A. LA CORONA S.A. de C.V.");

SAGN1.setFont(new java.awt.Font("Bauhaus 93", 2, 18)); // NOI18N

SAGN1.setForeground(new java.awt.Color(51, 51, 51));

SAGN1.setText("S.A.G.N.");

SAGN01.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N

SAGN01.setForeground(new java.awt.Color(51, 51, 51));

SAGN01.setText("Sistema automatizado de gestión de nomina.");

APat.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

APatActionPerformed(evt);

}

});

APaternoLabel.setText("A. Paterno:");

AMat.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

AMatActionPerformed(evt);

}

});

AMaterno.setText("A. Materno:");

Copyright3.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N

Copyright3.setForeground(new java.awt.Color(51, 51, 51));

Copyright3.setText("Ver. a0.24.04.13");

EmpNo.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

EmpNoActionPerformed(evt);

}

});

EmpNoLabel.setText("Numero de Empleado:");

GenderLabel.setText("Sexo:");

jRadioButtonM.setBackground(new java.awt.Color(204, 204, 204));

Gender.add(jRadioButtonM);

jRadioButtonM.setText("Masculino");

jRadioButtonF.setBackground(new java.awt.Color(204, 204, 204));

Gender.add(jRadioButtonF);

jRadioButtonF.setText("Femenino");

jRadioButtonF.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jRadioButtonFActionPerformed(evt);

}

});

DepLabel.setText("Departamento:");

DepComboBox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { " ", "Calidad", "Sistemas", "Administrativo", "Rescursos Humanos" }));

DepComboBox.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

DepComboBoxActionPerformed(evt);

}

});

BonoPunt.setBackground(new java.awt.Color(204, 204, 204));

BonoPunt.setText("Bono Puntualidad");

BonoPunt.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

BonoPuntActionPerformed(evt);

}

});

BonoProd.setBackground(new java.awt.Color(204, 204, 204));

BonoProd.setText("Bono Productividad");

BonoCap.setBackground(new java.awt.Color(204, 204, 204));

BonoCap.setText("Bono Certificación");

BonoCap.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

BonoCapActionPerformed(evt);

}

});

Listado.setEditable(false);

Listado.setColumns(20);

Listado.setFont(new java.awt.Font("Lucida Console", 0, 13)); // NOI18N

Listado.setRows(5);

Listado.setText("+-------------------------------+\n| CALIDAD: |\n|-------------------------------|\n| * Puntualidad: $ 600.00 |\n| * Productividad: $ 1000.00 |\n| * Certificación: $ 2500.00 |\n|-------------------------------|\n| SISTEMAS: |\n|-------------------------------|\n| * Puntualidad: $ 400.00 |\n| * Productividad: $ 1500.00 |\n| * Certificación: $ 3500.00 |\n|-------------------------------|\n| ADMINISTRATIVO: |\n|-------------------------------|\n| * Puntualidad: $ 600.00 |\n| * Productividad: $ 2500.00 |\n| * Certificación: $ 5000.00 |\n|-------------------------------|\n| RECURSOS HUMANOS: |\n|-------------------------------|\n| * Puntualidad: $ 550.00 |\n| * Productividad: $ 2000.00 |\n| * Certificación: $ 3000.00 |\n+-------------------------------+");

jScrollPane1.setViewportView(Listado);

ListadoHeader.setEditable(false);

ListadoHeader.setBackground(new java.awt.Color(204, 204, 204));

ListadoHeader.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N

ListadoHeader.setForeground(new java.awt.Color(51, 51, 51));

ListadoHeader.setHorizontalAlignment(javax.swing.JTextField.CENTER);

ListadoHeader.setText("LISTADO DE BONOS POR DEPARTAMENTO");

ListadoHeader.setToolTipText("");

ListadoHeader.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));

ClearCalc.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

ClearCalc.setText("BORRAR");

ClearCalc.setPreferredSize(new java.awt.Dimension(80, 23));

ClearCalc.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

ClearCalcActionPerformed(evt);

}

});

SalarySlider.setBackground(new java.awt.Color(204, 204, 204));

SalarySlider.setMajorTickSpacing(1000);

SalarySlider.setMaximum(30000);

SalarySlider.addChangeListener(new javax.swing.event.ChangeListener() {

public void stateChanged(javax.swing.event.ChangeEvent evt) {

SalarySliderStateChanged(evt);

}

});

SalaryBar.setBackground(new java.awt.Color(204, 204, 204));

SalaryBar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

SalaryBar.setForeground(new java.awt.Color(0, 0, 0));

SalaryBar.setMaximum(30000);

SalaryBar.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

SalaryBar.setString("Max: $ 30,000.00");

SalaryBar.setStringPainted(true);

javax.swing.tree.DefaultMutableTreeNode treeNode1 = new javax.swing.tree.DefaultMutableTreeNode("Expedientes");

javax.swing.tree.DefaultMutableTreeNode treeNode2 = new javax.swing.tree.DefaultMutableTreeNode("Departamentos");

javax.swing.tree.DefaultMutableTreeNode treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Calidad");

javax.swing.tree.DefaultMutableTreeNode treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026443");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026444");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026445");

treeNode3.add(treeNode4);

treeNode2.add(treeNode3);

treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Sistemas");

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026446");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026447");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026448");

treeNode3.add(treeNode4);

treeNode2.add(treeNode3);

treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Administrativo");

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026449");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026450");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026451");

treeNode3.add(treeNode4);

treeNode2.add(treeNode3);

treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("RH");

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026452");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026453");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026454");

treeNode3.add(treeNode4);

treeNode2.add(treeNode3);

treeNode1.add(treeNode2);

treeNode2 = new javax.swing.tree.DefaultMutableTreeNode("Externos");

treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Varios");

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("00000001");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("00000002");

treeNode3.add(treeNode4);

treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("00000003");

treeNode3.add(treeNode4);

treeNode2.add(treeNode3);

treeNode1.add(treeNode2);

jTree.setModel(new javax.swing.tree.DefaultTreeModel(treeNode1));

jScrollPane2.setViewportView(jTree);

ListadoHeader1.setEditable(false);

ListadoHeader1.setBackground(new java.awt.Color(204, 204, 204));

ListadoHeader1.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N

ListadoHeader1.setForeground(new java.awt.Color(51, 51, 51));

ListadoHeader1.setHorizontalAlignment(javax.swing.JTextField.CENTER);

ListadoHeader1.setText("BUSCAR FOTO");

ListadoHeader1.setToolTipText("");

ListadoHeader1.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));

ListadoHeader1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

ListadoHeader1ActionPerformed(evt);

}

});

loadPic.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

loadPic.setText("CARGAR FOTO");

loadPic.setPreferredSize(new java.awt.Dimension(80, 23));

loadPic.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

loadPicActionPerformed(evt);

}

});

photoContainer.setBackground(new java.awt.Color(204, 204, 204));

photoContainer.setBorder(javax.swing.BorderFactory.createEtchedBorder());

Kain.setIcon(new javax.swing.ImageIcon("C:\\Users\\Al Franco\\Desktop\\kain.jpg")); // NOI18N

Kain.setVerticalAlignment(javax.swing.SwingConstants.TOP);

javax.swing.GroupLayout photoContainerLayout = new javax.swing.GroupLayout(photoContainer);

photoContainer.setLayout(photoContainerLayout);

photoContainerLayout.setHorizontalGroup(

photoContainerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(Kain, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

);

photoContainerLayout.setVerticalGroup(

photoContainerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(Kain, javax.swing.GroupLayout.PREFERRED_SIZE, 263, Short.MAX_VALUE)

);

javax.swing.GroupLayout CalcPanelLayout = new javax.swing.GroupLayout(CalcPanel);

CalcPanel.setLayout(CalcPanelLayout);

CalcPanelLayout.setHorizontalGroup(

CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addContainerGap()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addGroup(javax.swing.GroupLayout.Alignment.LEADING, CalcPanelLayout.createSequentialGroup()

.addComponent(Header1, javax.swing.GroupLayout.PREFERRED_SIZE, 333, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(160, 160, 160)

.addComponent(SAGN1)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(SAGN01))

.addGroup(javax.swing.GroupLayout.Alignment.LEADING, CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(FaultLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(SalaryLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addComponent(RetLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(0, 0, Short.MAX_VALUE))

.addComponent(NameLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(DepLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(Name, javax.swing.GroupLayout.DEFAULT_SIZE, 140, Short.MAX_VALUE)

.addComponent(Fault)

.addComponent(Retard, javax.swing.GroupLayout.DEFAULT_SIZE, 140, Short.MAX_VALUE)

.addComponent(Salary))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(SalarySlider, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)

.addComponent(SalaryBar, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)

.addComponent(DepComboBox, javax.swing.GroupLayout.Alignment.TRAILING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addGap(28, 28, 28))))

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGap(10, 10, 10)

.addComponent(photoContainer, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addComponent(APaternoLabel)

.addGap(30, 30, 30)

.addComponent(APat, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(AMaterno))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, CalcPanelLayout.createSequentialGroup()

.addGap(0, 0, Short.MAX_VALUE)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(TotalFaultLabel)

.addComponent(EmpNoLabel)

.addComponent(GenderLabel)))

.addComponent(BonoPunt)

.addComponent(BonoProd)

.addComponent(BonoCap))

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGap(34, 34, 34)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(AMat, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(EmpNo, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, CalcPanelLayout.createSequentialGroup()

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, CalcPanelLayout.createSequentialGroup()

.addComponent(jRadioButtonM)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jRadioButtonF))

.addComponent(TotalFault, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)))))

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jScrollPane2)

.addComponent(ListadoHeader1)

.addComponent(loadPic, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(ListadoHeader, javax.swing.GroupLayout.DEFAULT_SIZE, 300, Short.MAX_VALUE)

.addComponent(jScrollPane1))))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(Cotizar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(ClearCalc, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))

.addGroup(javax.swing.GroupLayout.Alignment.LEADING, CalcPanelLayout.createSequentialGroup()

.addComponent(Copyright1)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(Copyright3)))

.addContainerGap())

.addComponent(jSeparator1)

);

CalcPanelLayout.setVerticalGroup(

CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Header1, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(SAGN1, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(SAGN01, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(3, 3, 3)

.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGap(16, 16, 16)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(APaternoLabel)

.addComponent(APat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(AMat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(Name, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(AMaterno)

.addComponent(NameLabel))

.addGap(3, 3, 3)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(RetLabel)

.addComponent(Retard, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(EmpNoLabel)

.addComponent(EmpNo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(BonoPunt))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(FaultLabel)

.addComponent(Fault, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(BonoProd)

.addComponent(TotalFaultLabel)

.addComponent(TotalFault, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(SalaryLabel)

.addComponent(Salary, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jRadioButtonM)

.addComponent(jRadioButtonF)

.addComponent(GenderLabel)

.addComponent(BonoCap))

.addGap(0, 0, 0)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(ListadoHeader, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(ListadoHeader1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 341, Short.MAX_VALUE)

.addGroup(CalcPanelLayout.createSequentialGroup()

.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(loadPic, javax.swing.GroupLayout.PREFERRED_SIZE, 55, javax.swing.GroupLayout.PREFERRED_SIZE))))

.addGroup(CalcPanelLayout.createSequentialGroup()

.addComponent(SalarySlider, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(0, 0, 0)

.addComponent(SalaryBar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(3, 3, 3)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(DepComboBox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(DepLabel))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(photoContainer, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(0, 39, Short.MAX_VALUE))))

.addGroup(CalcPanelLayout.createSequentialGroup()

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(Cotizar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(ClearCalc, javax.swing.GroupLayout.PREFERRED_SIZE, 55, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Copyright1)

.addComponent(Copyright3)))

);

MainFrame.addTab("Calculador", CalcPanel);

ResPanel.setBackground(new java.awt.Color(204, 204, 204));

Name2.setEditable(false);

Name2.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

Name2ActionPerformed(evt);

}

});

NameLabel2.setText("Nombre:");

DescFaultLabel.setText("Descuento por Inasistencias:");

DescFault.setEditable(false);

DescFault.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

DescFaultActionPerformed(evt);

}

});

Infonavit.setEditable(false);

Infonavit.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

InfonavitActionPerformed(evt);

}

});

InfonavitLabel.setText("Infonavit:");

IMSSLabel.setText("IMSS:");

IMSS.setEditable(false);

IMSS.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

IMSSActionPerformed(evt);

}

});

ISR.setEditable(false);

ISR.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

ISRActionPerformed(evt);

}

});

ISRLabel.setText("ISR:");

SubTotalLabel.setText("Subtotal:");

SubTotal.setEditable(false);

SubTotal.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

SubTotalActionPerformed(evt);

}

});

SalaryNetoLabel.setText("Salario Neto:");

SalaryNeto.setEditable(false);

SalaryNeto.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

SalaryNetoActionPerformed(evt);

}

});

TotalFaultLabel2.setText("Total de Inasistencias:");

TotalFault2.setEditable(false);

TotalFault2.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

TotalFault2ActionPerformed(evt);

}

});

Header2.setFont(new java.awt.Font("Bauhaus 93", 2, 24)); // NOI18N

Header2.setForeground(new java.awt.Color(51, 51, 51));

Header2.setText("C.I.A. LA CORONA S.A. de C.V.");

SAGN2.setFont(new java.awt.Font("Bauhaus 93", 2, 18)); // NOI18N

SAGN2.setForeground(new java.awt.Color(51, 51, 51));

SAGN2.setText("S.A.G.N.");

SAGN02.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N

SAGN02.setForeground(new java.awt.Color(51, 51, 51));

SAGN02.setText("Sistema automatizado de gestión de nomina.");

Copyright2.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N

Copyright2.setForeground(new java.awt.Color(51, 51, 51));

Copyright2.setText("Developed by Ing. Al Franco - 2013 copyright (c).");

Copyright4.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N

Copyright4.setForeground(new java.awt.Color(51, 51, 51));

Copyright4.setText("Ver. a0.24.04.13");

EmpNo2.setEditable(false);

EmpNo2.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

EmpNo2ActionPerformed(evt);

}

});

EmpNoLabel2.setText("Numero de Empleado:");

GenderLabel2.setText("Sexo:");

Gender1.setEditable(false);

Gender1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

Gender1ActionPerformed(evt);

}

});

DescFaultLabel1.setText("Departamento:");

Departamento.setEditable(false);

Departamento.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

DepartamentoActionPerformed(evt);

}

});

ClearRes.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

ClearRes.setText("BORRAR");

ClearRes.setPreferredSize(new java.awt.Dimension(80, 23));

ClearRes.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

ClearResActionPerformed(evt);

}

});

EmpTable.setBackground(new java.awt.Color(204, 204, 204));

EmpTable.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

EmpTable.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] {

{null, null, null, null},

{null, null, null, null},

{null, null, null, null},

{null, null, null, null}

},

new String [] {

"Emp. No.", "Nombre", "Sexo", "Departamento"

}

) {

boolean[] canEdit = new boolean [] {

false, false, false, false

};

public boolean isCellEditable(int rowIndex, int columnIndex) {

return canEdit [columnIndex];

}

});

EmpTable.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

jScrollPane3.setViewportView(EmpTable);

HeaderEmpTable.setEditable(false);

HeaderEmpTable.setBackground(new java.awt.Color(204, 204, 204));

HeaderEmpTable.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N

HeaderEmpTable.setForeground(new java.awt.Color(51, 51, 51));

HeaderEmpTable.setHorizontalAlignment(javax.swing.JTextField.CENTER);

HeaderEmpTable.setText("REGISTRO DE EMPLEADOS");

HeaderEmpTable.setToolTipText("");

HeaderEmpTable.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));

HeaderEmpTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

HeaderEmpTableActionPerformed(evt);

}

});

HeaderNominaTable.setEditable(false);

HeaderNominaTable.setBackground(new java.awt.Color(204, 204, 204));

HeaderNominaTable.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N

HeaderNominaTable.setForeground(new java.awt.Color(51, 51, 51));

HeaderNominaTable.setHorizontalAlignment(javax.swing.JTextField.CENTER);

HeaderNominaTable.setText("REGISTRO DE NOMINAS");

HeaderNominaTable.setToolTipText("");

HeaderNominaTable.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));

HeaderNominaTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

HeaderNominaTableActionPerformed(evt);

}

});

ClrEmpTable.setText("Borrar");

ClrEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));

ClrEmpTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

ClrEmpTableActionPerformed(evt);

}

});

InsEmpTable.setText("Insertar");

InsEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));

InsEmpTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

InsEmpTableActionPerformed(evt);

}

});

UpdEmpTable.setText("Modificar");

UpdEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));

UpdEmpTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

UpdEmpTableActionPerformed(evt);

}

});

QryEmpTable.setText("Consulta");

QryEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));

QryEmpTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

QryEmpTableActionPerformed(evt);

}

});

ClrNomTable.setText("Borrar");

ClrNomTable.setPreferredSize(new java.awt.Dimension(80, 23));

ClrNomTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

ClrNomTableActionPerformed(evt);

}

});

InsNomTable.setText("Insertar");

InsNomTable.setPreferredSize(new java.awt.Dimension(80, 23));

InsNomTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

InsNomTableActionPerformed(evt);

}

});

UpdNomTable.setText("Modificar");

UpdNomTable.setPreferredSize(new java.awt.Dimension(80, 23));

UpdNomTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

UpdNomTableActionPerformed(evt);

}

});

QryNomTable.setText("Consulta");

QryNomTable.setPreferredSize(new java.awt.Dimension(80, 23));

QryNomTable.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

QryNomTableActionPerformed(evt);

}

});

$a.setEditable(false);

$a.setBackground(new java.awt.Color(204, 204, 204));

$a.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

$a.setText("$");

$a.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

$aActionPerformed(evt);

}

});

$b.setEditable(false);

$b.setBackground(new java.awt.Color(204, 204, 204));

$b.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

$b.setText("$");

$b.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

$bActionPerformed(evt);

}

});

$c.setEditable(false);

$c.setBackground(new java.awt.Color(204, 204, 204));

$c.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

$c.setText("$");

$d.setEditable(false);

$d.setBackground(new java.awt.Color(204, 204, 204));

$d.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

$d.setText("$");

$e.setEditable(false);

$e.setBackground(new java.awt.Color(204, 204, 204));

$e.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

$e.setText("$");

f.setEditable(false);

f.setBackground(new java.awt.Color(204, 204, 204));

f.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

f.setText("$");

NomTable.setBackground(new java.awt.Color(204, 204, 204));

NomTable.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N

NomTable.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] {

{null, null, null, null, null, null, null, null},

{null, null, null, null, null, null, null, null},

{null, null, null, null, null, null, null, null},

{null, null, null, null, null, null, null, null}

},

new String [] {

"Emp. No.", "Faltas totales", "Descuento Faltas", "INFONAVIT", "IMSS", "ISR", "Sub Total", "Salario Neto"

}

) {

boolean[] canEdit = new boolean [] {

false, false, false, false, false, false, false, false

};

public boolean isCellEditable(int rowIndex, int columnIndex) {

return canEdit [columnIndex];

}

});

NomTable.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

jScrollPane4.setViewportView(NomTable);

javax.swing.GroupLayout ResPanelLayout = new javax.swing.GroupLayout(ResPanel);

ResPanel.setLayout(ResPanelLayout);

ResPanelLayout.setHorizontalGroup(

ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jSeparator2)

.addGroup(ResPanelLayout.createSequentialGroup()

.addContainerGap()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(ResPanelLayout.createSequentialGroup()

.addComponent(jScrollPane3)

.addContainerGap())

.addGroup(ResPanelLayout.createSequentialGroup()

.addComponent(Copyright2)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(Copyright4)

.addGap(7, 7, 7))

.addGroup(ResPanelLayout.createSequentialGroup()

.addComponent(Header2, javax.swing.GroupLayout.PREFERRED_SIZE, 333, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(160, 160, 160)

.addComponent(SAGN2)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(SAGN02)

.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(ResPanelLayout.createSequentialGroup()

.addComponent(HeaderNominaTable, javax.swing.GroupLayout.PREFERRED_SIZE, 506, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(ClrNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(InsNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(UpdNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(QryNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(NameLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)

.addComponent(ISRLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(DescFaultLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(DescFaultLabel1, javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(InfonavitLabel, javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(IMSSLabel, javax.swing.GroupLayout.Alignment.LEADING))

.addGap(18, 18, 18)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(Departamento)

.addComponent(Name2, javax.swing.GroupLayout.PREFERRED_SIZE, 260, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent($a, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent($b, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent($c, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addComponent($d, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(ISR)

.addComponent(DescFault, javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(Infonavit, javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(IMSS, javax.swing.GroupLayout.Alignment.TRAILING))))))

.addGap(18, 18, 18)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(GenderLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(TotalFaultLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(EmpNoLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)

.addComponent(Gender1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 235, Short.MAX_VALUE)

.addComponent(TotalFault2, javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(EmpNo2)))

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(SalaryNetoLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(SubTotalLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)

.addComponent(ClearRes, javax.swing.GroupLayout.PREFERRED_SIZE, 235, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent($e, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(f, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(SalaryNeto)

.addComponent(SubTotal)))))))

.addGroup(ResPanelLayout.createSequentialGroup()

.addComponent(HeaderEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, 506, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(ClrEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(InsEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(UpdEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(QryEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addGap(0, 0, Short.MAX_VALUE))

.addComponent(jScrollPane4)))

);

ResPanelLayout.setVerticalGroup(

ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Header2, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(SAGN2, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(SAGN02, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(3, 3, 3)

.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(16, 16, 16)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Name2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(NameLabel2))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Departamento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(DescFaultLabel1))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(DescFaultLabel)

.addComponent(DescFault, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent($a, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(InfonavitLabel)

.addComponent(Infonavit, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent($b, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(IMSSLabel)

.addComponent(IMSS, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent($c, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(ISRLabel)

.addComponent(ISR, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(ClearRes, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent($d, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addGroup(ResPanelLayout.createSequentialGroup()

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(EmpNo2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(EmpNoLabel2))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(GenderLabel2)

.addComponent(Gender1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(TotalFault2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(TotalFaultLabel2))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(SubTotal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(SubTotalLabel)

.addComponent($e, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(SalaryNeto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(SalaryNetoLabel)

.addComponent(f, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))

.addGap(7, 7, 7)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(HeaderEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(ClrEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(InsEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(UpdEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(QryEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 141, Short.MAX_VALUE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(HeaderNominaTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(ClrNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(InsNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(UpdNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(QryNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(Copyright2)

.addComponent(Copyright4)))

);

MainFrame.addTab("Resultados", ResPanel);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());

getContentPane().setLayout(layout);

layout.setHorizontalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(MainFrame, javax.swing.GroupLayout.PREFERRED_SIZE, 845, javax.swing.GroupLayout.PREFERRED_SIZE)

);

layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(MainFrame, javax.swing.GroupLayout.PREFERRED_SIZE, 573, javax.swing.GroupLayout.PREFERRED_SIZE)

);

pack();

}// </editor-fold>

private void TotalFault2ActionPerformed(java.awt.event.ActionEvent evt) {

}

private void SalaryNetoActionPerformed(java.awt.event.ActionEvent evt) {

}

private void SubTotalActionPerformed(java.awt.event.ActionEvent evt) {

}

private void ISRActionPerformed(java.awt.event.ActionEvent evt) {

}

private void IMSSActionPerformed(java.awt.event.ActionEvent evt) {

}

private void InfonavitActionPerformed(java.awt.event.ActionEvent evt) {

}

private void DescFaultActionPerformed(java.awt.event.ActionEvent evt) {

}

private void Name2ActionPerformed(java.awt.event.ActionEvent evt) {

}

private void EmpNo2ActionPerformed(java.awt.event.ActionEvent evt) {

}

private void Gender1ActionPerformed(java.awt.event.ActionEvent evt) {

}

private void jRadioButtonFActionPerformed(java.awt.event.ActionEvent evt) {

}

private void EmpNoActionPerformed(java.awt.event.ActionEvent evt) {

}

private void AMatActionPerformed(java.awt.event.ActionEvent evt) {

}

private void APatActionPerformed(java.awt.event.ActionEvent evt) {

}

private void CotizarKeyPressed(java.awt.event.KeyEvent evt) {

}

private void CotizarActionPerformed(java.awt.event.ActionEvent evt) {

/*---------------------------------------------------------------------//

// Aqui se captura el nombre del empleado en tres campos separados //

// Nombre, Apellido Paterno y Apellido Materno, para depositarlos en //

// un solo contenedor en la pestaña resultados. //

//---------------------------------------------------------------------*/

Name.getText();

Nom=Name.getText();

APat.getText();

ApPat=APat.getText();

AMat.getText();

ApMat=AMat.getText();

Name2.setText(""+Nom+" "+ApPat+" "+ApMat);

/*---------------------------------------------------------------------//

// Aqui se captura el numero de empleado en el calculador para despues //

// depositarlo dentro del contenedor de la pestaña Resultados. //

//---------------------------------------------------------------------*/

EmpNo.getText();

empnum=Integer.parseInt(EmpNo.getText());

EmpNo2.setText(""+empnum);

/*---------------------------------------------------------------------//

// Aqui se captura el numero de retardos en el calculador para despues //

// depositarlo dentro del contenedor de la pestaña Resultados. //

//---------------------------------------------------------------------*/

Retard.getText();

retardos=Integer.parseInt(Retard.getText());

/*---------------------------------------------------------------------//

// Aqui se captura el numero de faltas en el calculador para despues //

// depositarlo dentro del contenedor de la pestaña Resultados. //

//---------------------------------------------------------------------*/

Fault.getText();

inasistencias=Integer.parseInt(Fault.getText());

/*---------------------------------------------------------------------//

// Aqui se captura el salario en el calculador para despues //

// depositarlo dentro del contenedor de la pestaña Resultados. //

//---------------------------------------------------------------------*/

Salary.getText();

salario=Integer.parseInt(Salary.getText());

/*---------------------------------------------------------------------//

// Aqui se selecciona el genero en el calculador para despues //

// depositarlo dentro del contenedor de la pestaña Resultados. //

//---------------------------------------------------------------------*/

String Genero = null;

if (jRadioButtonM.isSelected()) {

Genero="Masculino";}

else if (jRadioButtonF.isSelected()) {

Genero="Femenino";}

Gender1.setText(Genero);

/*---------------------------------------------------------------------//

// Aqui se selecciona el departamento en el calculador para despues //

// depositarlo dentro del contenedor de la pestaña Resultados. //

//---------------------------------------------------------------------*/

Integer DeptIndex = DepComboBox.getSelectedIndex();

String Dept = null;

if (DeptIndex.equals(1)){

Dept="Calidad";}

else if (DeptIndex.equals(2)){

Dept="Sistemas";}

else if (DeptIndex.equals(3)){

Dept="Administrativo";}

else if (DeptIndex.equals(4)){

Dept="Recursos Humanos";}

else if (DeptIndex.equals(0)){

Dept="No Especificado";}

Departamento.setText(Dept);

/*---------------------------------------------------------------------//

// Aqui se realiza el calculo de bonos en el calculador para despues //

// depositarlo dentro del contenedor de la pestaña Resultados. //

//---------------------------------------------------------------------*/

//Calculo de bonos PUNTUALIDAD

//Bono puntualidad Dept. Calidad

double timeBonus = 0;

if (BonoPunt.isSelected()==true && DeptIndex.equals(1)){

timeBonus = 600;}

//bono puntualidad Dept. Sistemas

else if (BonoPunt.isSelected()==true && DeptIndex.equals(2)){

timeBonus = 400;}

//bono puntualidad Dept. Administrativo

else if (BonoPunt.isSelected()==true && DeptIndex.equals(3)){

timeBonus = 1000;}

//bono puntualidad Dept. RH

else if (BonoPunt.isSelected()==true && DeptIndex.equals(4)){

timeBonus = 550;}

else {timeBonus = 0;}

//Calculo de bonos PRODUCTIVIDAD

double prodBonus = 0;

//Bono productividad Dept. Calidad

if (BonoProd.isSelected()==true && DeptIndex.equals(1)){

prodBonus = 1000;}

//bono productividad Dept. Sistemas

else if (BonoProd.isSelected()==true && DeptIndex.equals(2)){

prodBonus = 1500;}

//bono productividad Dept. Administrativo

else if (BonoProd.isSelected()==true && DeptIndex.equals(3)){

prodBonus = 2500;}

//bono productividad Dept. RH

else if (BonoProd.isSelected()==true && DeptIndex.equals(4)){

prodBonus = 2000;}

else {prodBonus = 0;}

//Calculo de bonos CERTIFICACION

double capBonus = 0;

//Bono productividad Dept. Calidad

if (BonoCap.isSelected()==true && DeptIndex.equals(1)){

capBonus = 2500;}

//bono productividad Dept. Sistemas

else if (BonoCap.isSelected()==true && DeptIndex.equals(2)){

capBonus = 3500;}

//bono productividad Dept. Administrativo

else if (BonoCap.isSelected()==true && DeptIndex.equals(3)){

capBonus = 5000;}

//bono productividad Dept. RH

else if (BonoCap.isSelected()==true && DeptIndex.equals(4)){

capBonus = 3000;}

else {capBonus = 0;}

/*---------------------------------------------------------------------//

// Aqui se realiza el calculo de los datos ingresados en el calculador//

// para despues depositarlo dentro del contenedor de la pestaña //

// Resultados. //

//---------------------------------------------------------------------*/

DecimalFormat monetary = new DecimalFormat("#####0.00"); //"$"+

faltas=retardos/3;

inasistencias=inasistencias+faltas;

sd=salario/15;

dt=15-inasistencias;

sueldo=sd*dt;

infon=salario*.05;

imss=salario*.03;

isr=(infon+imss)*.3;

pago=subt+isr;

tot=salario-sueldo;

subt=infon+imss+tot+isr;

neto=salario-subt;

TotalFault.setText(""+inasistencias);

TotalFault2.setText(""+inasistencias);

Infonavit.setText(monetary.format(infon));

IMSS.setText(monetary.format(imss));

SubTotal.setText(monetary.format(neto));

ISR.setText(monetary.format(isr));

SalaryNeto.setText(monetary.format(neto+capBonus+prodBonus+timeBonus));

//int intSalario = (int) salario; //Se utilizara en siguientes versiones para hacer un progressbar que funcione como slider

int intNeto = (int) neto;

salaryProgress= intNeto;

SalaryBar.setValue(salaryProgress);

DescFault.setText(monetary.format(tot));

}

private void TotalFaultActionPerformed(java.awt.event.ActionEvent evt) {

}

private void SalaryActionPerformed(java.awt.event.ActionEvent evt) {

Salary.getText();

salario=Integer.parseInt(Salary.getText());

}

private void FaultActionPerformed(java.awt.event.ActionEvent evt) {

Fault.getText();

inasistencias=Integer.parseInt(Fault.getText());

}

private void RetardActionPerformed(java.awt.event.ActionEvent evt) {

Retard.getText();

retardos=Integer.parseInt(Retard.getText());

}

private void NameActionPerformed(java.awt.event.ActionEvent evt) {

}

private void DepComboBoxActionPerformed(java.awt.event.ActionEvent evt) {

}

private void DepartamentoActionPerformed(java.awt.event.ActionEvent evt) {

}

private void BonoPuntActionPerformed(java.awt.event.ActionEvent evt) {

}

private void BonoCapActionPerformed(java.awt.event.ActionEvent evt) {

}

private void ClearCalcActionPerformed(java.awt.event.ActionEvent evt) {

Name.setText("");

APat.setText("");

AMat.setText("");

Retard.setText("");

EmpNo.setText("");

Fault.setText("");

TotalFault.setText("");

Salary.setText("");

SalaryBar.setValue(0);

DepComboBox.setSelectedIndex(0);

Gender.clearSelection();

BonoPunt.setSelected(false);

BonoProd.setSelected(false);

BonoCap.setSelected(false);

}

private void ClearResActionPerformed(java.awt.event.ActionEvent evt) {

Name2.setText("");

Departamento.setText("");

DescFault.setText("");

Infonavit.setText("");

IMSS.setText("");

ISR.setText("");

EmpNo2.setText("");

Gender1.setText("");

TotalFault2.setText("");

SubTotal.setText("");

SalaryNeto.setText("");

}

private void ListadoHeader1ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void loadPicActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void SalarySliderStateChanged(javax.swing.event.ChangeEvent evt) {

Salary.setText (String.valueOf(SalarySlider.getValue()));

int SalSlide=Integer.parseInt(Salary.getText());

SalaryBar.setValue(SalSlide);

}

private void HeaderEmpTableActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void HeaderNominaTableActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void ClrEmpTableActionPerformed(java.awt.event.ActionEvent evt) {

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// eliminar desde la base de datos

int emp=Integer.parseInt(EmpNo.getText());

instruccion.executeUpdate("delete from datos_emp where dIEmpNo='"+emp+"'");

JOptionPane.showMessageDialog(null," Registro Eliminado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void InsEmpTableActionPerformed(java.awt.event.ActionEvent evt) {

String dCempName=Name2.getText();

String dIEmpNo=EmpNo2.getText();

String dCSexo=Gender1.getText();

String dCempDep=Departamento.getText();

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

instruccion.executeUpdate

("insert into datos_emp values('"+dCempName+"','"+dIEmpNo+"','"+dCSexo+"','"+dCempDep+"')");

JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"no se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

}

private void UpdEmpTableActionPerformed(java.awt.event.ActionEvent evt) {

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

int a=Integer.parseInt(EmpNo2.getText());

try{

instruccion.executeUpdate(" update datos_emp "

+ "set dCempName='"+Name2.getText()+"',"

+ " dCSexo='"+Gender1.getText()+"'"

+ " dCempDep='"+Gender1.getText()+"'"

+ "where dIEmpNo='"+a+"'");

JOptionPane.showMessageDialog(null,"Registro Modificado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"No existe Registro",JOptionPane.ERROR_MESSAGE);

}

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al modificar datos",JOptionPane.ERROR_MESSAGE);

}

catch(ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void QryEmpTableActionPerformed(java.awt.event.ActionEvent evt) {

modelo = new DefaultTableModel();

// Creamos las columnas.

modelo.addColumn("Nombre");

modelo.addColumn("Emp. No.");

modelo.addColumn("Sexo");

modelo.addColumn("Departamento");

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

ResultSet result=instruccion.executeQuery("select * FROM datos_emp ORDER BY dIEmpNo");

while(result.next()){

//son 4 columnas, la dimesion del objeto datos de 4

Object[] datos = new Object[4];

for (int i = 0; i < 4; i++) {

datos[i] = result.getObject(i+1);

}

modelo.addRow(datos);

}

EmpTable.setModel(modelo);

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error en la base de datos",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void ClrNomTableActionPerformed(java.awt.event.ActionEvent evt) {

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// eliminar desde la base de datos

int emp=Integer.parseInt(EmpNo.getText());

instruccion.executeUpdate("delete from nomina where nomIempNo='"+emp+"'");

JOptionPane.showMessageDialog(null,"Registro Eliminado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void InsNomTableActionPerformed(java.awt.event.ActionEvent evt) {

String nomIempNo=EmpNo2.getText();

String nomItotal_faltas=TotalFault2.getText();

String nomIdesc_faltas=DescFault.getText();

String nomIinfonavit=Infonavit.getText();

String nomIimss=IMSS.getText();

String nomICISR=ISR.getText();

String nomISubTotal=SubTotal.getText();

String nomISalario_Neto=SalaryNeto.getText();

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

instruccion.executeUpdate

("insert into nomina values"

+"('"+nomIempNo+"','"+nomItotal_faltas+"','"+nomIdesc_faltas+"','"+nomIinfonavit+"','"

+nomIimss+"','"+nomICISR+"','"+nomISubTotal+"','"+nomISalario_Neto+"')");

JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

}

private void UpdNomTableActionPerformed(java.awt.event.ActionEvent evt) {

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

int a=Integer.parseInt(EmpNo2.getText());

try{

instruccion.executeUpdate(" update nomina "

+ "set nomItotal_faltas='"+TotalFault2.getText()+"',"

+ " nomIdesc_faltas='"+DescFault.getText()+"'"

+ " nomIinfonavit='"+Infonavit.getText()+"'"

+ " nomIimss='"+IMSS.getText()+"'"

+ " nomICISR='"+ISR.getText()+"'"

+ " nomISubTotal='"+SubTotal.getText()+"'"

+ " nomISalario_Neto='"+SalaryNeto.getText()+"'"

+ "where dIEmpNo='"+a+"'");

JOptionPane.showMessageDialog(null,"Registro Modificado");

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"No existe Registro",JOptionPane.ERROR_MESSAGE);

}

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error al modificar datos",JOptionPane.ERROR_MESSAGE);

}

catch(ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void QryNomTableActionPerformed(java.awt.event.ActionEvent evt) {

modelo = new DefaultTableModel();

// Creamos las columnas.

modelo.addColumn("Emp. No.");

modelo.addColumn("Faltas totales");

modelo.addColumn("Descuento Faltas");

modelo.addColumn("INFONAVIT");

modelo.addColumn("IMSS");

modelo.addColumn("ISR");

modelo.addColumn("Sub Total");

modelo.addColumn("Salario Neto");

try{

Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos

coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");

// establecer conexion ala base de datos

instruccion = coneccion.createStatement();// consultar a la base de datos

// consultar a la base de datos

ResultSet result=instruccion.executeQuery("select * FROM nomina ORDER BY nomIempNo");

while(result.next()){

//son 8 columnas, la dimesion del objeto datos de 8

Object[] datos = new Object[8];

for (int i = 0; i < 8; i++) {

datos[i] = result.getObject(i+1);

}

modelo.addRow(datos);

}

NomTable.setModel(modelo);

}

catch(SQLException exeptionsql){

JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),

"Error en la base de datos",JOptionPane.ERROR_MESSAGE);

}

catch( ClassNotFoundException clasenoencontrada){

JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),

"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);

System.exit(1);

}

finally {

try {

coneccion.close();

instruccion.close();

}

// handle exceptions closing statement and connection

catch ( SQLException sqlException ) {

JOptionPane.showMessageDialog( null,

sqlException.getMessage(), "No cerro correctamente la base de datos",

JOptionPane.ERROR_MESSAGE );

System.exit( 1 );

}

}

}

private void $aActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void $bActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

/**

* @param args the command line arguments

*/

public static void main(String args[]) {

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new nominas().setVisible(true);

}

});

}

// Variables declaration - do not modify

private javax.swing.JTextField $a;

private javax.swing.JTextField $b;

private javax.swing.JTextField $c;

private javax.swing.JTextField $d;

private javax.swing.JTextField $e;

private javax.swing.JTextField AMat;

private javax.swing.JLabel AMaterno;

private javax.swing.JTextField APat;

private javax.swing.JLabel APaternoLabel;

private javax.swing.JCheckBox BonoCap;

private javax.swing.JCheckBox BonoProd;

private javax.swing.JCheckBox BonoPunt;

private javax.swing.JPanel CalcPanel;

private javax.swing.JButton ClearCalc;

private javax.swing.JButton ClearRes;

private javax.swing.JButton ClrEmpTable;

private javax.swing.JButton ClrNomTable;

private javax.swing.JLabel Copyright1;

private javax.swing.JLabel Copyright2;

private javax.swing.JLabel Copyright3;

private javax.swing.JLabel Copyright4;

private javax.swing.JButton Cotizar;

private javax.swing.JComboBox DepComboBox;

private javax.swing.JLabel DepLabel;

private javax.swing.JTextField Departamento;

private javax.swing.JTextField DescFault;

private javax.swing.JLabel DescFaultLabel;

private javax.swing.JLabel DescFaultLabel1;

private javax.swing.JTextField EmpNo;

private javax.swing.JTextField EmpNo2;

private javax.swing.JLabel EmpNoLabel;

private javax.swing.JLabel EmpNoLabel2;

private javax.swing.JTable EmpTable;

private javax.swing.JTextField Fault;

private javax.swing.JLabel FaultLabel;

private javax.swing.ButtonGroup Gender;

private javax.swing.JTextField Gender1;

private javax.swing.JLabel GenderLabel;

private javax.swing.JLabel GenderLabel2;

private javax.swing.JLabel Header1;

private javax.swing.JLabel Header2;

private javax.swing.JTextField HeaderEmpTable;

private javax.swing.JTextField HeaderNominaTable;

private javax.swing.JTextField IMSS;

private javax.swing.JLabel IMSSLabel;

private javax.swing.JTextField ISR;

private javax.swing.JLabel ISRLabel;

private javax.swing.JTextField Infonavit;

private javax.swing.JLabel InfonavitLabel;

private javax.swing.JButton InsEmpTable;

private javax.swing.JButton InsNomTable;

private javax.swing.JLabel Kain;

private javax.swing.JTextArea Listado;

private javax.swing.JTextField ListadoHeader;

private javax.swing.JTextField ListadoHeader1;

private javax.swing.JTabbedPane MainFrame;

private javax.swing.JTextField Name;

private javax.swing.JTextField Name2;

private javax.swing.JLabel NameLabel;

private javax.swing.JLabel NameLabel2;

private javax.swing.JTable NomTable;

private javax.swing.JButton QryEmpTable;

private javax.swing.JButton QryNomTable;

private javax.swing.JPanel ResPanel;

private javax.swing.JLabel RetLabel;

private javax.swing.JTextField Retard;

private javax.swing.JLabel SAGN01;

private javax.swing.JLabel SAGN02;

private javax.swing.JLabel SAGN1;

private javax.swing.JLabel SAGN2;

private javax.swing.JTextField Salary;

private javax.swing.JProgressBar SalaryBar;

private javax.swing.JLabel SalaryLabel;

private javax.swing.JTextField SalaryNeto;

private javax.swing.JLabel SalaryNetoLabel;

private javax.swing.JSlider SalarySlider;

private javax.swing.JTextField SubTotal;

private javax.swing.JLabel SubTotalLabel;

private javax.swing.JTextField TotalFault;

private javax.swing.JTextField TotalFault2;

private javax.swing.JLabel TotalFaultLabel;

private javax.swing.JLabel TotalFaultLabel2;

private javax.swing.JButton UpdEmpTable;

private javax.swing.JButton UpdNomTable;

private javax.swing.JTextField f;

private javax.swing.JMenuItem jMenuItem1;

private javax.swing.JPanel jPanel1;

private javax.swing.JRadioButton jRadioButtonF;

private javax.swing.JRadioButton jRadioButtonM;

private javax.swing.JScrollPane jScrollPane1;

private javax.swing.JScrollPane jScrollPane2;

private javax.swing.JScrollPane jScrollPane3;

private javax.swing.JScrollPane jScrollPane4;

private javax.swing.JSeparator jSeparator1;

private javax.swing.JSeparator jSeparator2;

private javax.swing.JTree jTree;

private javax.swing.JButton loadPic;

private javax.swing.JPanel photoContainer;

// End of variables declaration

}