@Override
public Response updateRecords(
int[] rowNumbers, ArrayList oldPersistentObjects, ArrayList persistentObjects)
throws Exception {
Response r = super.updateRecords(rowNumbers, oldPersistentObjects, persistentObjects);
for (Object e : persistentObjects) {
DireccionPersona d = (DireccionPersona) e;
if (d.getTipoDireccion().getNombre().toLowerCase().contains("fiscal")) {
Session s = null;
try {
s = HibernateUtil.getSessionFactory().openSession();
Transaction tr = s.beginTransaction();
Persona p = (Persona) beanVO;
p.setDireccionFiscal(d);
s.update(beanVO);
tr.commit();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
s.close();
}
break;
}
}
return r;
}
public static void main(String[] args) {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
session.beginTransaction();
// CREATE
for (int i = 1; i <= 30; i++) {
UserInfo user = new UserInfo();
user.setName("User" + i);
session.save(user);
}
session.getTransaction().commit();
session.close();
UserInfo user = new UserInfo();
session = sessionFactory.openSession();
session.beginTransaction();
// Retreive
user = (UserInfo) session.get(UserInfo.class, 6);
// Update
user.setName("Updated User Name");
session.update(user);
// Delete
user = (UserInfo) session.get(UserInfo.class, 5);
session.delete(user);
session.getTransaction().commit();
session.close();
// System.out.println("User Object retrieved is: " + user);
}
public void testBroken() throws Exception {
if (getDialect() instanceof Oracle9Dialect) return;
Session s = openSession();
Transaction t = s.beginTransaction();
Broken b = new Fixed();
b.setId(new Long(123));
b.setOtherId("foobar");
s.save(b);
s.flush();
b.setTimestamp(new Date());
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
s.update(b);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
b = (Broken) s.load(Broken.class, b);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
s.delete(b);
t.commit();
s.close();
}
public void testCachedQuery() throws Exception {
Session s = openSession();
Transaction t = s.beginTransaction();
Simple simple = new Simple();
simple.setName("Simple 1");
s.save(simple, new Long(10));
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
Query q = s.createQuery("from Simple s where s.name=?");
q.setCacheable(true);
q.setString(0, "Simple 1");
assertTrue(q.list().size() == 1);
assertTrue(q.list().size() == 1);
assertTrue(q.list().size() == 1);
q = s.createQuery("from Simple s where s.name=:name");
q.setCacheable(true);
q.setString("name", "Simple 1");
assertTrue(q.list().size() == 1);
simple = (Simple) q.list().get(0);
q.setString("name", "Simple 2");
assertTrue(q.list().size() == 0);
assertTrue(q.list().size() == 0);
simple.setName("Simple 2");
assertTrue(q.list().size() == 1);
assertTrue(q.list().size() == 1);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
q = s.createQuery("from Simple s where s.name=:name");
q.setString("name", "Simple 2");
q.setCacheable(true);
assertTrue(q.list().size() == 1);
assertTrue(q.list().size() == 1);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
s.update(simple, new Long(10));
s.delete(simple);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
q = s.createQuery("from Simple s where s.name=?");
q.setCacheable(true);
q.setString(0, "Simple 1");
assertTrue(q.list().size() == 0);
assertTrue(q.list().size() == 0);
t.commit();
s.close();
}
@Override
public void addToFavorites(List<Favorite> favorites, Poem poem) {
Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
Poem p = (Poem) session.get(Poem.class, poem.getPid());
Set<Favorite> set = new HashSet<Favorite>(favorites);
p.setFavoriteLists(set);
session.update(p);
tx.commit();
session.close();
}
public void testCRUD() throws HibernateException, SQLException {
if (isUsingIdentity()) {
reportSkip("hand sql expecting non-identity id gen", "Custom SQL");
return;
}
Person p = new Person();
p.setName("Max");
p.setLastName("Andersen");
p.setNationalID("110974XYZ�");
p.setAddress("P. P. Street 8");
Session s = openSession();
s.save(p);
s.flush();
s.connection().commit();
s.close();
getSessions().evict(Person.class);
s = openSession();
Person p2 = (Person) s.get(Person.class, p.getId());
assertNotSame(p, p2);
assertEquals(p2.getId(), p.getId());
assertEquals(p2.getLastName(), p.getLastName());
s.flush();
List list = s.createQuery("select p from Party as p").list();
assertTrue(list.size() == 1);
s.connection().commit();
s.close();
s = openSession();
list = s.createQuery("select p from Person as p where p.address = 'L�rkev�nget 1'").list();
assertTrue(list.size() == 0);
p.setAddress("L�rkev�nget 1");
s.update(p);
list = s.createQuery("select p from Person as p where p.address = 'L�rkev�nget 1'").list();
assertTrue(list.size() == 1);
list = s.createQuery("select p from Party as p where p.address = 'P. P. Street 8'").list();
assertTrue(list.size() == 0);
s.delete(p);
list = s.createQuery("select p from Person as p").list();
assertTrue(list.size() == 0);
s.connection().commit();
s.close();
}
public void testNothinToUpdate() throws Exception {
Session s = openSession();
Transaction t = s.beginTransaction();
Simple simple = new Simple();
simple.setName("Simple 1");
s.save(simple, new Long(10));
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
s.update(simple, new Long(10));
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
s.update(simple, new Long(10));
s.delete(simple);
t.commit();
s.close();
}
public static int update(Session session, Object objectForUpdate) {
try {
session.update(objectForUpdate);
return 1;
} catch (HibernateException e) {
LOGGER.error(
"Update Exception. Record can't be updated for object="
+ objectForUpdate
+ " for class "
+ objectForUpdate.getClass()
+ " on session "
+ session
+ ". Method update return 0.",
e);
return 0;
}
}
// ADD A EMPLOYEE BANK DETAILS IN tblempbank
@Override
public int addEmployeeBank(EmployeeBank employeebank)
throws HibernateException, ConstraintViolationException {
Session session = SessionFactoryUtil.getSessionFactory().openSession();
int status = 0;
try {
session.beginTransaction();
java.sql.Timestamp date = new java.sql.Timestamp(new java.util.Date().getTime());
Criteria criteria = session.createCriteria(EmployeeBank.class);
criteria.add(Restrictions.eq("organizationId", employeebank.getOrganizationId()));
criteria.add(
Restrictions.eq("employee", new Employee(employeebank.getEmployee().getEmployeeId())));
criteria.add(Restrictions.eq("bank", new Bank(employeebank.getBank().getBankId())));
if (criteria.list().size() == 0) {
employeebank.setInsertDate(date.toString());
employeebank.setUpdateDate(date.toString());
session.save(employeebank);
status = 1;
} else {
Iterator<EmployeeBank> iterator = criteria.list().iterator();
while (iterator.hasNext()) {
EmployeeBank empbank = iterator.next();
if (empbank.getDeleteFlag() == true) {
empbank.setDeleteFlag(false);
empbank.setInsertDate(date.toString());
empbank.setUpdateDate(date.toString());
session.update(empbank);
status = 1;
} else {
return 5;
}
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
session.getTransaction().commit();
session.close();
}
return status;
}
// UPDATE A EMPLOYEE BANK DETAILS IN tblempbank
@Override
public int updateEmployeeBank(EmployeeBank employeebank)
throws HibernateException, ConstraintViolationException {
Session session = SessionFactoryUtil.getSessionFactory().openSession();
int status = 0;
try {
session.beginTransaction();
java.sql.Timestamp date = new java.sql.Timestamp(new java.util.Date().getTime());
EmployeeBank empbank = getEmployeeBankId(employeebank.getEmpbankId());
Criteria criteria = session.createCriteria(EmployeeBank.class);
criteria.add(Restrictions.eq("organizationId", employeebank.getOrganizationId()));
criteria.add(
Restrictions.eq("employee", new Employee(empbank.getEmployee().getEmployeeId())));
criteria.add(
Restrictions.ne("employee", new Employee(employeebank.getEmployee().getEmployeeId())));
criteria.add(Restrictions.eq("bank", new Bank(employeebank.getBank().getBankId())));
if ((empbank != null) && (criteria.list().size() == 0)) {
employeebank.setInsertBy(empbank.getInsertBy());
employeebank.setInsertDate(empbank.getInsertDate());
employeebank.setUpdateDate(date.toString());
session.update(employeebank);
status = 1;
} else {
return 5;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
session.getTransaction().commit();
session.close();
}
return status;
}
public void testDialectSQLFunctions() throws Exception {
Session s = openSession();
Transaction t = s.beginTransaction();
Iterator iter = s.iterate("select max(s.count) from Simple s");
if (getDialect() instanceof MySQLDialect) assertTrue(iter.hasNext() && iter.next() == null);
Simple simple = new Simple();
simple.setName("Simple Dialect Function Test");
simple.setAddress("Simple Address");
simple.setPay(new Float(45.8));
simple.setCount(2);
s.save(simple, new Long(10));
// Test to make sure allocating an specified object operates correctly.
assertTrue(
s.find("select new org.hibernate.test.legacy.S(s.count, s.address) from Simple s").size()
== 1);
// Quick check the base dialect functions operate correctly
assertTrue(s.find("select max(s.count) from Simple s").size() == 1);
assertTrue(s.find("select count(*) from Simple s").size() == 1);
if (getDialect() instanceof OracleDialect) {
// Check Oracle Dialect mix of dialect functions - no args (no parenthesis and single arg
// functions
java.util.List rset =
s.find("select s.name, sysdate(), trunc(s.pay), round(s.pay) from Simple s");
assertNotNull("Name string should have been returned", (((Object[]) rset.get(0))[0]));
assertNotNull("Todays Date should have been returned", (((Object[]) rset.get(0))[1]));
assertEquals("trunc(45.8) result was incorrect ", new Float(45), ((Object[]) rset.get(0))[2]);
assertEquals("round(45.8) result was incorrect ", new Float(46), ((Object[]) rset.get(0))[3]);
simple.setPay(new Float(-45.8));
s.update(simple);
// Test type conversions while using nested functions (Float to Int).
rset = s.find("select abs(round(s.pay)) from Simple s");
assertEquals("abs(round(-45.8)) result was incorrect ", new Float(46), rset.get(0));
// Test a larger depth 3 function example - Not a useful combo other than for testing
assertTrue(s.find("select trunc(round(sysdate())) from Simple s").size() == 1);
// Test the oracle standard NVL funtion as a test of multi-param functions...
simple.setPay(null);
s.update(simple);
Integer value =
(Integer)
s.find("select MOD( NVL(s.pay, 5000), 2 ) from Simple as s where s.id = 10").get(0);
assertTrue(0 == value.intValue());
}
if ((getDialect() instanceof HSQLDialect)) {
// Test the hsql standard MOD funtion as a test of multi-param functions...
Integer value =
(Integer) s.find("select MOD(s.count, 2) from Simple as s where s.id = 10").get(0);
assertTrue(0 == value.intValue());
}
s.delete(simple);
t.commit();
s.close();
}
@Override
public void actionPerformed(ActionEvent e) {
if (e.getSource() instanceof InsertButton) {
// <editor-fold defaultstate="collapsed" desc="Crear nuevo">
if (beanVO != null) {
if (((Siniestro) beanVO)
.getCertificado()
.getPoliza()
.getVigenciaHasta()
.before(new Date())) {
JOptionPane.showMessageDialog(
gridControl,
ClientSettings.getInstance()
.getResources()
.getResource(
"No se Permite Realizar el Siniestro a Este Asegurado\n"
+ "La Poliza no esta Vigente"),
General.edition,
JOptionPane.INFORMATION_MESSAGE);
return;
}
if (!((Siniestro) beanVO).getAsegurado().getAuditoria().getActivo()) {
JOptionPane.showMessageDialog(
gridControl,
ClientSettings.getInstance()
.getResources()
.getResource(
"No se Permite Realizar el Siniestro a Este Asegurado\n"
+ "El Asegurado no está Activo"),
General.edition,
JOptionPane.INFORMATION_MESSAGE);
return;
}
if (!((Siniestro) beanVO).getCertificado().getAuditoria().getActivo()) {
JOptionPane.showMessageDialog(
gridControl,
ClientSettings.getInstance()
.getResources()
.getResource(
"No se Permite Realizar el Siniestro a Este Asegurado\n"
+ "El Certificado no está Activo"),
General.edition,
JOptionPane.INFORMATION_MESSAGE);
return;
}
if (!((Siniestro) beanVO).getCertificado().getPoliza().getAuditoria().getActivo()) {
JOptionPane.showMessageDialog(
gridControl,
ClientSettings.getInstance()
.getResources()
.getResource(
"No se Permite Realizar el Siniestro a Este Asegurado\n"
+ "El Poliza no está Activo"),
General.edition,
JOptionPane.INFORMATION_MESSAGE);
return;
}
if (!((Siniestro) beanVO).getCertificado().getTitular().getAuditoria().getActivo()) {
JOptionPane.showMessageDialog(
gridControl,
ClientSettings.getInstance()
.getResources()
.getResource(
"No se Permite Realizar el Siniestro a Este Asegurado\n"
+ "El Titular del certificado no está Activo"),
General.edition,
JOptionPane.INFORMATION_MESSAGE);
return;
}
Class c = DetalleSiniestroChousser.showDialog();
if (c != null && c.getClass() != null) {
if (c.equals(Vida.class)) {
new DetalleVidaNuevoDetrailController(
DetalleVidaNuevoDetailFrame.class.getName(),
((SiniestroDetailFrame) vista).getGridData(),
null,
(Siniestro) beanVO,
false);
} else {
new DetalleSiniestroDetailFrameController(
DetalleSiniestroDetailFrame.class.getName(),
((SiniestroDetailFrame) vista).getGridData(),
null,
true,
(Siniestro) beanVO,
c);
}
}
}
// </editor-fold>
} else if (e.getSource() == ((SiniestroDetailFrame) vista).getEstadoButton()) {
// <editor-fold defaultstate="collapsed" desc="Cambiar Estado">
if (vista.getMainPanel().getMode() == Consts.READONLY) {
Siniestro ss = ((Siniestro) beanVO);
switch (((Siniestro) beanVO).getEstadoSiniestro()) {
case ABIERTO:
int op =
JOptionPane.showConfirmDialog(
MDIFrame.getInstance(),
"Si Cierra el siniestro necesitara privilegios de Super usuario para poder abrirlo nuevamente. Desea Cerralo?",
"Cerrar Sinietro",
JOptionPane.YES_NO_OPTION,
JOptionPane.INFORMATION_MESSAGE);
if (op == JOptionPane.YES_OPTION) {
ss.setEstadoSiniestro(Dominios.EstadoSiniestro.CERRADO);
((SiniestroDetailFrame) vista).validarEstadoSiniestro(ss.getEstadoSiniestro());
}
break;
case CERRADO:
if (SuperusuarioLoginDialog.VerificarSuperusuario()) {
ss.setEstadoSiniestro(Dominios.EstadoSiniestro.ABIERTO);
((SiniestroDetailFrame) vista).validarEstadoSiniestro(ss.getEstadoSiniestro());
} else {
return;
}
break;
}
Session s = null;
try {
s = HibernateUtil.getSessionFactory().openSession();
Transaction t = s.beginTransaction();
s.update(ss);
t.commit();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
s.close();
}
((SiniestroDetailFrame) vista).validarEstado(ss);
} else {
JOptionPane.showMessageDialog(vista, "Debes guardar primero el Registro");
}
// </editor-fold>
}
}
public void update(Bureau a) {
Transaction tr2 = session.beginTransaction();
session.update(a);
tr2.commit();
}
