public boolean insertPersona(
classUsuario prmUsuario, classTipoIdentificacion prmTipoIdentificacion) {
try {
classConection objCon = new classConection();
objCon.setSqlString(
"select * from insertpersona("
+ prmUsuario.getusuid()
+ ",'"
+ this.perCedula
+ "','"
+ this.perNombres
+ "','"
+ this.perApellidos
+ "','"
+ this.perDireccion
+ "','"
+ this.perTelefono
+ "','"
+ this.perCelular
+ "','"
+ this.perEmail
+ "','"
+ prmTipoIdentificacion.gettipoidenid()
+ "')");
objCon.ejecutar();
return true;
} catch (Exception ex) {
JOptionPane.showMessageDialog(
null, ex.toString(), "Datos Personales", JOptionPane.INFORMATION_MESSAGE);
return false;
}
}
public ResultSet recuperarPersonasArrendatarios() {
try {
classConection objCon = new classConection();
objCon.setSqlString("select * from recuperarpersonaarrendatario('" + this.perCedula + "')");
ResultSet rsPer = objCon.consultar();
return rsPer;
} catch (Exception ex) {
JOptionPane.showMessageDialog(
null, ex.toString(), "Impuesto Vehicular GADMT", JOptionPane.INFORMATION_MESSAGE);
return null;
}
}
// funciones creadas por paco
public void llenaCamposPersona(classPersona representanteDifunto) {
try {
classConection objCon = new classConection();
objCon.setSqlString("SELECT * FROM persona WHERE perid=" + representanteDifunto.getperid());
ResultSet rsPersona = objCon.consultar();
if (rsPersona.next()) {
this.perId = Integer.parseInt(rsPersona.getObject("perid").toString());
this.perCedula = rsPersona.getObject("percedularuc").toString();
this.perNombres = rsPersona.getObject("pernombres").toString();
this.perApellidos = rsPersona.getObject("perapellidos").toString();
this.perDireccion = rsPersona.getObject("perdireccion").toString();
this.perTelefono = rsPersona.getObject("pertelefono").toString();
this.perCelular = rsPersona.getObject("percelular").toString();
this.perEmail = rsPersona.getObject("peremail").toString();
}
} catch (Exception e) {
JOptionPane.showMessageDialog(
null,
"Error llenando los campos de persona\n Solicite Sevicio Técnico" + e.toString(),
"CEMENTERIO GADMT",
JOptionPane.INFORMATION_MESSAGE);
}
}
public boolean buscarPersonaCedula() {
try {
classConection objCon = new classConection();
// JOptionPane.showMessageDialog(null, this.perCedula.substring(1, 10),"Datos
// Personales", JOptionPane.INFORMATION_MESSAGE);
if (this.perCedula.length() >= 10) {
objCon.setSqlString(
"select * from buscarpersonacedula('" + this.perCedula.substring(0, 10) + "')");
} else {
objCon.setSqlString("select * from buscarpersonacedula('" + this.perCedula + "')");
}
ResultSet rsUs = objCon.consultar();
if (rsUs.next()) {
this.perId = Integer.parseInt(rsUs.getObject("perid").toString());
this.perCedula = rsUs.getObject("percedularuc").toString();
this.perNombres = rsUs.getObject("pernombres").toString();
this.perApellidos = rsUs.getObject("perapellidos").toString();
this.perDireccion = rsUs.getObject("perdireccion").toString();
this.perTelefono = rsUs.getObject("pertelefono").toString();
this.perCelular = rsUs.getObject("percelular").toString();
this.perEmail = rsUs.getObject("peremail").toString();
return true;
} else {
return false;
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(
null,
"Cédula mal ingresada " + ex.toString(),
"Datos Personales",
JOptionPane.INFORMATION_MESSAGE);
return false;
}
}