public ArrayList<PricingGroupBean> getAllPricingGroups() {

    ArrayList<PricingGroupBean> arrPricingGroupBean = new ArrayList<PricingGroupBean>();

    String sQuery = "select * from GTPRICEGROUP GPG";

    ArrayList<Object> aParams = new ArrayList<Object>();

    ArrayList<HashMap<String, String>> arrResult =
        DBDAO.getDBData(
            ADMIN_DB, sQuery, aParams, false, "PricingGroupData.java", "getPricingGroups()");

    if (arrResult != null && !arrResult.isEmpty()) {
      for (HashMap<String, String> hmResult : arrResult) {
        PricingGroupBean pricingGroupBean = new PricingGroupBean(hmResult);

        arrPricingGroupBean.add(pricingGroupBean);
      }
    }
    return arrPricingGroupBean;
  }
  public PricingGroupBean getPricingGroup(String sPricingGroupId) {

    PricingGroupBean pricingGroupBean = new PricingGroupBean();
    if (sPricingGroupId != null && !"".equalsIgnoreCase(sPricingGroupId)) {
      String sQuery = "select * " + " from GTPRICEGROUP GPG WHERE PRICEGROUPID = ?";

      ArrayList<Object> aParams = new ArrayList<Object>();
      aParams.add(sPricingGroupId);

      ArrayList<HashMap<String, String>> arrResult =
          DBDAO.getDBData(
              ADMIN_DB, sQuery, aParams, false, "PricingGroupData.java", "getPricingGroups()");

      if (arrResult != null && !arrResult.isEmpty()) {
        for (HashMap<String, String> hmResult : arrResult) {

          pricingGroupBean = new PricingGroupBean(hmResult);
          break;
        }
      }
    }
    return pricingGroupBean;
  }