@Override
 protected void onDestroy() {
   // TODO Auto-generated method stub
   super.onDestroy();
   if (rvFromDb != null) rvFromDb.closeDb();
 }
  /** Functionality to show the text of the verse to related chapter and book */
  void displayVerseText() {
    // clear the highlighted array list
    EBibleConstants.verseListToHighlight.clear();
    EBibleConstants.paragraphListToHighlight.clear();
    EBibleConstants.contentListToHighlight.clear();

    highlightedMatchedDescriptionArr.clear();
    highlightedMatchedColorCodeArr.clear();
    highlightedMatchedUnderlineArr.clear();
    highlightedMatchedVerseArr.clear();

    // clear the description string
    descriptionString = "";
    // clear the position value
    versePositionToHighlighten = -1;
    verseHighlightedPositionToStore = "";
    int pagenumber;
    if (EBibleConstants.isHighlightedDialogPassed) {
      EBibleConstants.isHighlightedDialogPassed = false;
      pagenumber = EBibleConstants.lastOpenendPagenumber;
    } else {
      // set the text description content with paging
      pagenumber = EBibleConstants.lastOpenendPagenumber = EBibleConstants.pageNumber;
    }
    Log.i("", "page number = " + pagenumber);

    for (int countParagraph = 0;
        countParagraph < EBibleConstants.paragraphList.size();
        countParagraph++) {
      if (EBibleConstants.paragraphList.get(countParagraph).equalsIgnoreCase("" + pagenumber)) {
        String contentTextAtPosition = EBibleConstants.contentList.get(countParagraph);
        if (contentTextAtPosition.contains("<")) {
          contentTextAtPosition = Html.fromHtml(contentTextAtPosition).toString();
        }
        // descriptionString += EBibleConstants.verseList.get(countParagraph)+")
        // "+contentTextAtPosition;
        // versePositionToHighlighten = countParagraph;

        // find if that verse has any highlighted text stored into db
        Cursor cursor =
            rvFromDb.retrieveValues(
                EBibleConstants.verseList.get(countParagraph),
                selectedChapterPosition,
                selectedBookName);
        if (cursor.getCount() > 0) {
          Log.i("", "cursor value = " + cursor.getCount());
          cursor.moveToFirst();
          for (int curCount = 0; curCount < cursor.getCount(); curCount++) {
            String desc = cursor.getString(1);
            Log.i(
                "cursor matched",
                "values = "
                    + desc
                    + "\n"
                    + cursor.getString(2)
                    + "\n"
                    + cursor.getString(3)
                    + "\n"
                    + cursor.getString(4)
                    + "\n"
                    + cursor.getString(5)
                    + "\n"
                    + cursor.getString(6)
                    + "\n"
                    + cursor.getString(7)
                    + "\n");

            /*if(!highlightedMatchedVerseArr.contains(cursor.getString(2)))
            {*/
            highlightedMatchedVerseArr.add(cursor.getString(2));
            // }
            highlightedMatchedColorCodeArr.add(URLDecoder.decode(cursor.getString(5)));
            highlightedMatchedUnderlineArr.add(cursor.getString(7));

            highlightedMatchedDescriptionArr.add(cursor.getString(1));

            cursor.moveToNext();
          }
        }
        Log.i(
            "db desc array",
            ""
                + highlightedMatchedDescriptionArr
                + "\n"
                + highlightedMatchedColorCodeArr
                + "\n"
                + highlightedMatchedUnderlineArr);
        // close the cursor
        if (cursor != null) {
          cursor.close();
          cursor = null;
        }

        // store into array list to highlight on highlighted page
        EBibleConstants.verseListToHighlight.add(EBibleConstants.verseList.get(countParagraph));
        EBibleConstants.paragraphListToHighlight.add(
            EBibleConstants.paragraphList.get(countParagraph));
        EBibleConstants.contentListToHighlight.add(contentTextAtPosition);
      }
    }
    Log.i("", "description = \n" + descriptionString);
    Log.i(
        "",
        "list content to highlight "
            + EBibleConstants.verseListToHighlight
            + "\npara= "
            + EBibleConstants.paragraphListToHighlight
            + "\ncontent = "
            + EBibleConstants.contentListToHighlight);
    // set the description texts
    // description.setText(descriptionString);
    descList.setAdapter(new VersesListAdapter());

    Log.i(
        "",
        "page no = "
            + EBibleConstants.pageNumber
            + "\nlast para value = "
            + EBibleConstants.lastParaValue);

    /*//find the values from the local database for the perticular verses
    String[] coloms = {"DESCRIPTION, VERSENO, CHAPTERNO, BOOKNAME, PARAGRAPHNO, " +
    "SECTIONID, CHARPOSITION, ISHIGHLIGHTED, ISUNDERLINE"};

    String whereCondition = "VERSENO="+verseno+" AND CHAPTERNO="+chapterno+" " +
    		"AND BOOKNAME="+bookname+" AND ISHIGHLIGHTED=true";
    new LocalDatabaseAsync(BookDescriptionActivity.this, EBibleConstants.DESCRIPTION_ACTIVITY,
    						this, EBibleConstants.DATA_RETRIEVE, "TEXTHIGHLIGHT", coloms,
    						whereCondition, null, null, null);*/
    /*if(EBibleConstants.pageNumber < (EBibleConstants.lastParaValue))
    {
    	next.setEnabled(true);
    }
    else
    {
    	next.setEnabled(false);
    }
    if(EBibleConstants.pageNumber == (EBibleConstants.startParaNumber) )
    {
    	previous.setEnabled(false);
    }
    else
    {
        previous.setEnabled(true);
    }

    description.setOnLongClickListener(new View.OnLongClickListener() {

    	@Override
    	public boolean onLongClick(View v) {
    		Log.i("","selected chapter "+selectedChapterName);
    		//start the highlight view dialog
    		new HighlightDialog(BookDescriptionActivity.this, selectedBookName,
    				selectedChapterPosition, versePositionToHighlighten);
    		return false;
    	}
    });*/
  }