/**
   * @param req
   * @return
   */
  public String serviceGroup(HttpServletRequest req) {
    // AshaLogger.logInfo(logger, this.getClass().getName(), "lovValues", "Entered");
    Session session = null;
    ArrayList<ValueName> detailsArrayList = new ArrayList<ValueName>();
    List list = null;
    ValueName valueName = null;
    Object obj[] = {};
    try {
      session = HibernateUtil.currentSession();
      session.beginTransaction();
      Query detailsQuery =
          session.createSQLQuery(
              "select SG_Code, SG_ServiceGroup FROM service_group where Delete_Flag=1 and sg_code!=5");

      list = detailsQuery.list();

      for (int i = 0; i < list.size(); i++) {
        valueName = new ValueName();
        obj = (Object[]) list.get(i);
        valueName.setCode(obj[0].toString());
        valueName.setName((String) obj[1].toString());
        detailsArrayList.add(valueName);
      }
      req.setAttribute("1", detailsArrayList);

      status = "lovs";
    } catch (HibernateException e) {
      status = "error";
      logger.error("Exception", e);
    } finally {
      session.beginTransaction().commit();
    }
    return status;
  }
  /**
   * @param req
   * @return
   */
  public String lovValues(HttpServletRequest req, String values) {
    AshaLogger.logInfo(logger, this.getClass().getName(), "lovValues", "Entered");
    Session session = null;
    ArrayList<ListofvaluesId> detailsArrayList = new ArrayList<ListofvaluesId>();
    List list = null;
    ListofvaluesId lov = null;
    Object obj[] = {};
    try {
      session = HibernateUtil.currentSession();
      session.beginTransaction();
      Query detailsQuery =
          session.createSQLQuery(
              "select List_Id, Value_id, Value_Name FROM listofvalues where List_Id IN ("
                  + values
                  + ") and Value_id!=0  and delete_flag=1 order by List_Id");

      list = detailsQuery.list();
      int listid = 0;
      int check_listid = 0;
      for (int i = 0; i < list.size(); i++) {
        lov = new ListofvaluesId();
        obj = (Object[]) list.get(i);
        check_listid = (Integer) obj[0];
        lov.setValueId((Integer) obj[1]);
        lov.setValueName((String) obj[2]);

        if (check_listid != listid) {
          if (i != 0) {
            req.setAttribute((new Integer(listid)).toString(), detailsArrayList);
            detailsArrayList = null;
            detailsArrayList = new ArrayList<ListofvaluesId>();
          }
        }
        detailsArrayList.add(lov);
        listid = check_listid;
      }
      req.setAttribute((new Integer(listid)).toString(), detailsArrayList);

      status = "lovs";
    } catch (HibernateException e) {
      status = "error";
      logger.error("Exception", e);
    } finally {
      session.beginTransaction().commit();
    }
    return status;
  }