@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;
 }