public void generatePdf(java.lang.String memNo) {

    java.lang.Process wait_for_Pdf2Show;

    java.util.Calendar cal = java.util.Calendar.getInstance();

    java.util.Date dateStampPdf = cal.getTime();

    java.lang.String pdfDateStamp = dateStampPdf.toString();

    try {

      java.io.File tempFile =
          java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf");

      tempFile.deleteOnExit();

      java.lang.Runtime rt = java.lang.Runtime.getRuntime();

      java.lang.String debitTotal = null;

      java.lang.String creditTotal = null;

      //   com.lowagie.text.Document docPdf = new com.lowagie.text.Document(new
      // Rectangle(java.lang.Float.parseFloat(System.getProperty("papersize_width")),
      // java.lang.Float.parseFloat(System.getProperty("papersize_legnth"))));
      com.lowagie.text.Document docPdf = new com.lowagie.text.Document();

      try {

        try {

          com.lowagie.text.pdf.PdfWriter.getInstance(
              docPdf, new java.io.FileOutputStream(tempFile));

          try {

            java.sql.Statement st3 = connectDB.createStatement();
            java.sql.Statement st4 = connectDB.createStatement();
            java.sql.Statement st2x = connectDB.createStatement();

            java.sql.ResultSet rset2x =
                st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile");
            while (rset2x.next()) {
              ks = rset2x.getObject(1).toString();
            }

            com.lowagie.text.HeaderFooter footer =
                new com.lowagie.text.HeaderFooter(
                    new Phrase(
                        "Withholding Tax, where applicable,has been deducted and will be remitted to the Tax Authorities"),
                    false);
            // : "), true);// FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12,
            // Font.BOLDITALIC,java.awt.Color.blue));

            // docPdf.setFooter(footer);

          } catch (java.sql.SQLException SqlExec) {

            javax.swing.JOptionPane.showMessageDialog(
                new javax.swing.JFrame(), SqlExec.getMessage());
          }

          docPdf.open();

          try {

            com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(6);

            int headerwidths[] = {20, 25, 25, 20, 20, 30};

            table.setWidths(headerwidths);

            table.setWidthPercentage((100));

            com.lowagie.text.pdf.PdfPTable table1 = new com.lowagie.text.pdf.PdfPTable(1);

            int headerwidths1[] = {100};

            table1.setWidths(headerwidths1);

            com.lowagie.text.pdf.PdfPTable table2 = new com.lowagie.text.pdf.PdfPTable(2);

            int headerwidths2[] = {40, 60};

            table2.setWidths(headerwidths2);

            // table.getDefaultCell().setBorder(Rectangle.BOTTOM);

            table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
            table.getDefaultCell().setColspan(1);
            table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE);
            table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);

            try {

              java.sql.Statement st = connectDB.createStatement();

              java.sql.Statement st7 = connectDB.createStatement();

              java.sql.Statement st3 = connectDB.createStatement();
              java.sql.Statement st33 = connectDB.createStatement();

              java.sql.ResultSet rset3 =
                  st3.executeQuery(
                      "select hospital_name,postal_code||' '||box_no||' '||town,main_telno||' '||other_telno,initcap(street),main_faxno,email,website,room_no,pin_no,vat_no  from pb_hospitalprofile");

              Phrase phrase = new Phrase("");

              table.getDefaultCell().setColspan(2);

              Image img = Image.getInstance(com.afrisoftech.lib.CompanyLogo.getPath2Logo());
              // Image imgWaterMark = Image.getInstance(System.getProperty("company.watermark"));
              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
              table.getDefaultCell().setFixedHeight(45);
              table.addCell(Image.getInstance(com.afrisoftech.lib.CompanyLogo.getPath2Logo()));
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              table.getDefaultCell().setFixedHeight(20);
              // java.sql.Statement st3 = connectDB.createStatement();
              java.sql.ResultSet rs =
                  st.executeQuery(
                      "SELECT DISTINCT hospital_name,box_no,main_telno,main_faxno FROM pb_hospitalprofile");
              while (rs.next()) {

                table.getDefaultCell().setColspan(5);

                table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
                phrase =
                    new Phrase(
                        rs.getObject(1).toString()
                            + " \nP.O. Box "
                            + rs.getObject(2).toString()
                            + " - Tel: "
                            + rs.getObject(3).toString()
                            + " - Fax "
                            + rs.getObject(3).toString(),
                        pFontHeader31);
                table.addCell(phrase);
                table.getDefaultCell().setColspan(6);
                // phrase = new Phrase("P.O. Box " + rs.getObject(2).toString() + " - Tel: " +
                // rs.getObject(3).toString() + " - Fax " + rs.getObject(3).toString(),
                // pFontHeader1);
                // table.addCell(phrase);

              }

              java.sql.ResultSet rset1 =
                  st33.executeQuery(
                      "SELECT postal_address,pin_no,vat_no FROM st_suppliers WHERE supplier_name ILIKE '"
                          + suppName
                          + "'");

              System.out.println(MNo);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              table.getDefaultCell().setColspan(6);
              phrase = new Phrase("PATIENT REFUND VOUCHER", pFontHeader31p);
              table.addCell(phrase);

              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);

              java.sql.Statement st5 = connectDB.createStatement();
              java.sql.ResultSet rset81 =
                  st5.executeQuery("select * from ac_bills where voucher_no = '" + vouchNo + "'");

              while (rset81.next()) {
                name = rset81.getString("dealer");
                reason = rset81.getString("reason");
                amount = rset81.getString("credit");
              }

              table.getDefaultCell().setColspan(5);
              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("(DEPOSITS AND SUSPENSE)", pFontHeader31p);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT);
              phrase = new Phrase("No : " + vouchNo, pFontHeader);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
              phrase = new Phrase("Payee's Name :" + name, pFontHeader);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
              phrase =
                  new Phrase("Payee's Address :...................................", pFontHeader);
              table.addCell(phrase);

              table
                  .getDefaultCell()
                  .setBorder(Rectangle.TOP | Rectangle.BOTTOM | Rectangle.RIGHT | Rectangle.LEFT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(4);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);

              phrase = new Phrase("Particulars", pFontHeader11);
              table.addCell(phrase);
              table.getDefaultCell().setColspan(2);
              phrase = new Phrase("Amount", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.TOP | Rectangle.RIGHT | Rectangle.LEFT);
              table.getDefaultCell().setColspan(4);
              phrase = new Phrase("", pFontHeader11);
              table.addCell(phrase);

              table
                  .getDefaultCell()
                  .setBorder(Rectangle.TOP | Rectangle.BOTTOM | Rectangle.RIGHT | Rectangle.LEFT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(1);
              phrase = new Phrase("Ksh. ", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(1);
              phrase = new Phrase("Cts. ", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.RIGHT | Rectangle.LEFT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
              table.getDefaultCell().setColspan(4);
              table.getDefaultCell().setFixedHeight(60);
              phrase = new Phrase(reason, pFontHeader1);
              table.addCell(phrase);

              table
                  .getDefaultCell()
                  .setBorder(Rectangle.TOP | Rectangle.BOTTOM | Rectangle.RIGHT | Rectangle.LEFT);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(2);
              table.getDefaultCell().setFixedHeight(60);
              phrase = new Phrase(amount, pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              //                            table.getDefaultCell().setColspan(1);
              //                            table.getDefaultCell().setFixedHeight(60);
              //                            phrase = new Phrase("", pFontHeader11);
              //                            table.addCell(phrase);

              table.getDefaultCell().setColspan(4);
              table.getDefaultCell().setFixedHeight(20);
              phrase = new Phrase(" Total", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(2);
              phrase = new Phrase(amount, pFontHeader11);
              table.addCell(phrase);

              String cashWord = "";
              java.sql.ResultSet rset_cash =
                  st7.executeQuery(
                      "select replace(cash_words('"
                          + Double.parseDouble(amount)
                          + "'::money),'dollars',' Kenya Shillings only')");
              if (rset_cash.next()) {
                cashWord = rset_cash.getString(1);
              }

              table.getDefaultCell().setColspan(6);
              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);

              phrase =
                  new Phrase(
                      "Amount payable is Kshs "
                          + amount
                          + " (amount in words) "
                          + cashWord
                          + " only.",
                      pFontHeader1);
              table.addCell(phrase);

              table
                  .getDefaultCell()
                  .setBorder(Rectangle.TOP | Rectangle.BOTTOM | Rectangle.RIGHT | Rectangle.LEFT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(6);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Authority References No.", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.TOP | Rectangle.RIGHT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("EXAMINATION", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.TOP | Rectangle.LEFT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Internal Audit", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "Voucher Examined by...........................................",
                      pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "...............................................................",
                      pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Date :..............................", pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Date :..................................", pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.TOP | Rectangle.RIGHT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("DEPOSITS AND SUSPENSE CERTIFICATE", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.TOP | Rectangle.LEFT);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("AUTHORIZATION", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(40);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "I certify that the amount of payment has been recorded in the relevant register and that adequate funds previously deposited and credited to A/c No ............................... has not been repaid.",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(40);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "I certify that the payment has been made on proper authority. Where appropriate a relevant certificate has been completed in the space provided overleaf",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(50);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "Net Deposit brought forward from previous month.\n\n  A/c No ...........................     Ksh....................... \n Less/Add:",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(50);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "I am satisfied that the amount of payment as shown above is a proper charge to the item shown here below and hereby AUTHORIZE payment thereof without any alteration.",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(30);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "Total payment/receipt current month Ksh.........................\n\n"
                          + "Balance       (+) Kshs.....................",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(30);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("", pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(30);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "I certify that proper reconciliation of above balance has been carried out and that this payment is based on the reconciled balance.",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(20);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "Signature...............................................\n Accounting Officer",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT | Rectangle.BOTTOM);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(30);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase =
                  new Phrase(
                      "Date...............................  Signature...............................\n Accountant I/c Deposits and Suspense",
                      pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT | Rectangle.BOTTOM);
              table.getDefaultCell().setColspan(3);
              table.getDefaultCell().setFixedHeight(20);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Date.........................................", pFontHeader12);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.RIGHT | Rectangle.BOTTOM | Rectangle.TOP);
              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setFixedHeight(45);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Vote", pFontHeader11);
              table.addCell(phrase);

              table
                  .getDefaultCell()
                  .setBorder(Rectangle.RIGHT | Rectangle.BOTTOM | Rectangle.LEFT | Rectangle.TOP);
              table.getDefaultCell().setColspan(2);
              table.getDefaultCell().setFixedHeight(45);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Head", pFontHeader11);
              table.addCell(phrase);

              table
                  .getDefaultCell()
                  .setBorder(Rectangle.RIGHT | Rectangle.BOTTOM | Rectangle.LEFT | Rectangle.TOP);
              table.getDefaultCell().setColspan(2);
              table.getDefaultCell().setFixedHeight(45);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Sub-Head", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorder(Rectangle.LEFT | Rectangle.BOTTOM | Rectangle.TOP);
              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setFixedHeight(45);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Item", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
              table.getDefaultCell().setColspan(6);
              table.getDefaultCell().setFixedHeight(15);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("", pFontHeader11);
              table.addCell(phrase);

              table
                  .getDefaultCell()
                  .setBorder(Rectangle.RIGHT | Rectangle.BOTTOM | Rectangle.LEFT | Rectangle.TOP);
              table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setFixedHeight(20);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Account No.", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Dept. Vch. No.", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Station", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(2);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Cash Book", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Amount.", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setFixedHeight(50);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Vch. No", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("Date", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(1);
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
              phrase = new Phrase("", pFontHeader11);
              table.addCell(phrase);

              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
              table.getDefaultCell().setFixedHeight(0);
              table.getDefaultCell().setColspan(6);
              phrase = new Phrase("", pFontHeader1);
              table.addCell(phrase);
              //
              table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
              table.getDefaultCell().setColspan(3);
              phrase =
                  new Phrase("Name: .......................................... ", pFontHeader1);
              table.addCell(phrase);
              table.getDefaultCell().setColspan(3);
              phrase =
                  new Phrase(
                      "ID No : ............................................... ", pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
              table.getDefaultCell().setFixedHeight(0);
              table.getDefaultCell().setColspan(6);
              phrase = new Phrase("", pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(3);
              phrase =
                  new Phrase(
                      "Signature : .......................................... ", pFontHeader1);
              table.addCell(phrase);
              table.getDefaultCell().setColspan(3);
              phrase =
                  new Phrase(
                      "Date: ............................................... ", pFontHeader1);
              table.addCell(phrase);

              table.getDefaultCell().setColspan(6);
              //
              // table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
              //                             table.getDefaultCell().setBorder(Rectangle.BOTTOM);
              phrase = new Phrase("", pFontHeader1);
              table.addCell(phrase);

              docPdf.add(table);

            } catch (java.sql.SQLException SqlExec) {

              SqlExec.printStackTrace();

              javax.swing.JOptionPane.showMessageDialog(
                  new javax.swing.JFrame(), SqlExec.getMessage());
            }

            // }

          } catch (com.lowagie.text.BadElementException BadElExec) {

            BadElExec.printStackTrace();

            javax.swing.JOptionPane.showMessageDialog(
                new javax.swing.JFrame(), BadElExec.getMessage());
          }

        } catch (java.io.FileNotFoundException fnfExec) {

          fnfExec.printStackTrace();

          javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage());
        }
      } catch (com.lowagie.text.DocumentException lwDocexec) {

        lwDocexec.printStackTrace();

        javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage());
      }

      docPdf.close();

      docPdf.close();
      com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile);

    } catch (java.io.IOException IOexec) {

      IOexec.printStackTrace();

      javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage());
    }
  }