private void addProductsToList(int i, int cid) {
    dba.open();
    Cursor mcursor = dba.retriveproductsbycategory(cid);

    //	Log.d("bis"," cat addProductsToList count= "+mcursor.getCount());

    if (mcursor.moveToFirst()) {
      do {

        // Log.d("bis","mcursor.getString(4)=="+mcursor.getString(4));

        // po.setPid(mcursor.getInt(0));
        // po.setCid(mcursor.getInt(1));
        // po.setPinfo(mcursor.getString(3));
        // po.setPname(mcursor.getString(2));
        // po.setPurl(mcursor.getString(4));
        // po.setPcost(mcursor.getString(6));

        // productList.add(po);
        lists_pnames.get(i).add(mcursor.getString(2));
        lists_pids.get(i).add(mcursor.getInt(0));

      } while (mcursor.moveToNext());
    }

    if (mcursor != null && !mcursor.isClosed()) {
      mcursor.close();
    }

    dba.close();
  }
  private void get_list_for_actionbar(String query) {

    apoList = new ArrayList<ActionbarProductObject>();

    dba.open();
    Cursor mcursor = dba.retriveallproductsByMatch(query);
    if (mcursor.moveToFirst()) {
      do {
        Log.d("bis", " mcursor is not empty at PL Sv " + mcursor.getCount());
        ActionbarProductObject apo = new ActionbarProductObject();
        apo.setPid(mcursor.getInt(0));
        apo.setCid(mcursor.getInt(1));
        apo.setPinfo(mcursor.getString(3));
        apo.setPname(mcursor.getString(2));
        apo.setPurl(mcursor.getString(4));
        apo.setPcost(mcursor.getString(6));
        apoList.add(apo);

      } while (mcursor.moveToNext());
    } else {
      Log.d("bis", " mcursor is empty at PL Sv");
    }

    dba.close();
  }
  private void getListOfCategories() {
    // TODO Auto-generated method stub
    dba.open();
    Cursor mCursor = dba.retriveallcategories();
    dba.close();
    // Log.d("bis", "mCursor==" + mCursor.getCount());

    // Log.d("bis"," cat count= "+mCursor.getCount());

    for (int i = 0; i < mCursor.getCount(); i++) {

      // cateObject.setCurl(mCursor.getString(2));
      // cateObject.setCname(mCursor.getString(1));
      // cateObject.setCid(mCursor.getInt(0));
      listDataHeader_catnames.add(mCursor.getString(1));
      listDataHeader_cat_ids.add(mCursor.getInt(0));

      mCursor.moveToNext();
    }
  }
  private void get_list_of_products() {
    dba.open();
    Cursor mcursor = dba.retriveproductsbycategory(cid);

    if (mcursor.moveToFirst()) {
      do {

        // Log.d("bis","mcursor.getString(4)=="+mcursor.getString(4));
        productObject po = new productObject();
        po.setPid(mcursor.getInt(0));
        po.setCid(mcursor.getInt(1));
        po.setPinfo(mcursor.getString(3));
        po.setPname(mcursor.getString(2));
        po.setPurl(mcursor.getString(4));
        po.setPcost(mcursor.getString(6));

        productList.add(po);
      } while (mcursor.moveToNext());
    }

    if (mcursor != null && !mcursor.isClosed()) {
      mcursor.close();
    }

    dba.close();

    pgva = new ProductGridViewAdapter(this, productList);

    // ====================================================

    recList.setHasFixedSize(true);
    GridLayoutManager llm = new GridLayoutManager(this, 4);
    // llm.setOrientation(GridLayoutManager.);
    recList.setLayoutManager(llm);

    recList.setAdapter(pgva);
    recList.setItemAnimator(new DefaultItemAnimator());

    // item click listner
    recList.addOnItemTouchListener(
        new RecyclerItemClickListener(
            getApplicationContext(),
            new RecyclerItemClickListener.OnItemClickListener() {
              @Override
              public void onItemClick(View view, int pos) {

                Constants.pid = productList.get(pos).getPid();
                Constants.pname = productList.get(pos).getPname();
                Constants.pcost = productList.get(pos).getPcost();

                if (InfoTracker.usersessionid > 0) {

                  InfoTracker.resetValuesAtProductLevel();

                  InfoTracker.pid = productList.get(pos).getPid();
                  InfoTracker.pname = productList.get(pos).getPname();
                  InfoTracker.time = System.currentTimeMillis();
                }

                Intent intent = new Intent(context, ProductOverView.class);

                context.startActivity(intent);
              }
            }));
  }