@Override public int countListTrustDistrict(Boolean checkbox, String search) throws Exception { logger.info( "Execute function countListTrustDistrict with checkbox= " + checkbox + " search= " + search); session = HibernateUtil.getSessionFactory().openSession(); int count = 0; try { String sql = "SELECT count(row_trustdistrictid) FROM TrustDistrict WHERE 1=1 "; if (!checkbox || checkbox == null) { sql += " AND ROW_ISACTIVE = true "; } if (!"".equals(search) || search == null) { sql += SearchLib.addSql(search, " row_name "); } Query query = session.createQuery(sql); count = Integer.parseInt(query.list().get(0).toString()); } catch (HibernateException he) { logger.error("Error HibernateException in countListTrustDistrict", he); throw new Exception(); } catch (Exception e) { logger.error("Error exception in countListTrustDistrict", e); throw new Exception(); } finally { session.close(); } return count; }
@Override public List<TrustDistrict> getListTrustDistrict(int pages, Boolean checkbox, String search) throws Exception { logger.info( "Execute function getListTrustDistrict with page =" + pages + " checkbox= " + checkbox + " search= " + search); session = HibernateUtil.getSessionFactory().openSession(); try { String sql = "FROM TrustDistrict WHERE 1=1 "; if (!checkbox || checkbox == null) { sql += " AND ROW_ISACTIVE = true "; } if (!"".equals(search) || search == null) { sql += SearchLib.addSql(search, " row_name "); } Query query = session.createQuery(sql); query.setFirstResult((pages - 1) * UtilityFuntion.NUMBER_PAGE); query.setMaxResults(UtilityFuntion.NUMBER_PAGE); arrTrustDistrict = query.list(); } catch (HibernateException he) { logger.error("Error HibernateException in getListTrustDistrict" + he); throw new Exception(); } catch (Exception e) { logger.error("Error Exception in getListTrustDistrict" + e); throw new Exception(); } finally { session.close(); } return arrTrustDistrict; }
@Override public boolean updateTrustDistrict(TrustDistrict district, int id) throws Exception { logger.info("Execute function getTrustDistrictById with district= " + district + " id=" + id); session = HibernateUtil.getSessionFactory().openSession(); try { transaction = session.beginTransaction(); trustDistrict = (TrustDistrict) session.get(TrustDistrict.class, id); trustDistrict.setName(district.getName()); trustDistrict.setDescription(district.getDescription()); trustDistrict.setTrustRegion(district.getTrustRegion()); trustDistrict.setActive(district.isActive()); session.update(trustDistrict); transaction.commit(); } catch (HibernateException he) { logger.error("Error HibernateException in updateTrustDistrict " + he); throw new Exception(); } catch (Exception e) { logger.error("Error Exception in updateTrustDistrict" + e); throw new Exception(); } finally { if (session != null) { session.close(); } } return true; }
@Override public TrustDistrict getTrustDistrictById(int id) throws Exception { logger.info("Execute function getTrustDistrictById with id=" + id); session = HibernateUtil.getSessionFactory().openSession(); try { trustDistrict = (TrustDistrict) session.get(TrustDistrict.class, id); } catch (HibernateException he) { logger.error("Error HibernateException in getTrustDistrictById " + he); throw new Exception(); } catch (Exception e) { logger.error("Error Exception in getTrustDistrictById" + e); throw new Exception(); } finally { session.close(); } return trustDistrict; }
@Override public List<TrustDistrict> listTrustDistrict() throws Exception { logger.info("Execute function listTrustDistrict"); session = HibernateUtil.getSessionFactory().openSession(); try { String sql = "FROM TrustDistrict"; Query query = session.createQuery(sql); arrTrustDistrict = query.list(); } catch (HibernateException he) { logger.error("Error HibernateException in listTrustDistrict" + he); throw new Exception(); } catch (Exception e) { logger.error("Error in listTrustDistrict" + e); throw new Exception(); } finally { session.close(); } return arrTrustDistrict; }
@Override public boolean insertTrustDistrict(TrustDistrict district) throws Exception { logger.info("Execute function insertTrustDistrict with name=" + district.getName()); session = HibernateUtil.getSessionFactory().openSession(); try { transaction = session.beginTransaction(); session.save(district); transaction.commit(); } catch (HibernateException he) { logger.error("Error HibernateException in insertTrustDistrict " + he); throw new Exception(); } catch (Exception he) { logger.error("Error Exception in insertTrustDistrict" + he); throw new Exception(); } finally { if (session != null) { session.close(); } } return true; }