ahmed salah

ahmed salah

  • 1.1k
  • 603
  • 37.4k

How to append rows data on grid view to header on end event page when

Jul 29 2024 9:23 AM

I work on itextcharp library to export grid view to pdf . I face issue header column display within data and it must

display above of data so my issue data rows display above header exactly .

I need to display header on top then details rows data consistence with header

I need header data display on every page header meaning column headers and

title of pdf and and logo with white boxes display on every page so how to solve this issue .

ON end page event of class pageeventhelper I add header data because i need display header on every page

What I try as below :

[WebMethod]
        public byte[] ExportGridViewToPdf(string[][] gridData, string[] columnNames)
        {
            try
            {

            
                Document document = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
                var ms = new MemoryStream();
                var writer = PdfWriter.GetInstance(document, ms);
                var tahomaFontFile = Path.Combine(
 Environment.GetFolderPath(Environment.SpecialFolder.Fonts),
 "Tahoma.ttf");
                var tahomaBaseFont = BaseFont.CreateFont(tahomaFontFile,
     BaseFont.IDENTITY_H,
     BaseFont.EMBEDDED);
                var tahomaFont = new Font(tahomaBaseFont, 8, Font.NORMAL);
                PageEventHelper pageEventHelper = new PageEventHelper(columnNames, tahomaFont, gridData);
                writer.PageEvent = pageEventHelper;
                document.Open();




                var table = new PdfPTable(columnNames.Length)
                {

                    RunDirection = PdfWriter.RUN_DIRECTION_RTL
                };
                table.WidthPercentage = 100;

            


         
                foreach (var row in gridData)
                {
                    var cells = new PdfPCell[columnNames.Length];
                    for (int i = 0; i < columnNames.Length; i++)
                    {
                        cells[i] = new PdfPCell(new Phrase(row[i], tahomaFont));
                        cells[i].FixedHeight = 25f;
                        table.AddCell(cells[i]); // Add each cell individually
                    }
                }
                Paragraph paragraph = new Paragraph();


                Chunk dateChunk = new Chunk("Print Date :" + DateTime.Now.ToString("dd-MM-yyyy"));
                paragraph.Add(dateChunk);


                paragraph.Add(new Chunk("                                                                         ")); // Adjust the spacing as needed


                Chunk ministryChunk = new Chunk("Ministry of Industry AND Trade");
                paragraph.Add(ministryChunk);


                paragraph.Alignment = Element.ALIGN_LEFT;



                PdfPCell dateCell = new PdfPCell(paragraph)
                {
                    Colspan = columnNames.Length, // Span across all columns
                    BackgroundColor = new BaseColor(System.Drawing.Color.LightGray),
                    HorizontalAlignment = Element.ALIGN_RIGHT,
                    FixedHeight = 30f // Set the desired height (adjust as needed)
                };


                table.AddCell(dateCell);

                document.Add(table);


                document.Close();
                writer.Close();
 
                return ms.ToArray();
            }
            catch (Exception ex)
            {
                
                throw new Exception("Error exporting GridView to PDF: " + ex.Message);
            }
        }
using iText.Kernel.Pdf;
using iTextSharp.text;
using iTextSharp.text.pdf;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Web;

namespace EREG.BusinessLayer
{
    public class PageEventHelper : PdfPageEventHelper
    {
        private int pageNumber = 0;
        private int totalPages = 0;
        PdfTemplate footerTemplate;
        BaseFont bf = null;
        PdfContentByte cb;
        private readonly string[] _columnNames;
        private readonly iTextSharp.text.Font _tahomaFont;
        private readonly string[][] _gridData;
        public PageEventHelper(string[] columnNames, iTextSharp.text.Font tahomaFont, string[][] gridData)
        {
            _columnNames = columnNames;
            _tahomaFont = tahomaFont;
            _gridData = gridData;
        }
        
        public override void OnOpenDocument(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            try
            {
                bf = BaseFont.CreateFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
                cb = writer.DirectContent;
                footerTemplate = cb.CreateTemplate(50, 50);
            }
            catch (DocumentException de)
            {
                //handle exception here
            }
            catch (System.IO.IOException ioe)
            {
                //handle exception here
            }
        }
        public override void OnStartPage(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            base.OnStartPage(writer, document);
            pageNumber++;
        }
        public override void OnCloseDocument(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            base.OnCloseDocument(writer, document);
            //totalPages = writer.PageNumber;
            footerTemplate.BeginText();
            footerTemplate.SetFontAndSize(bf, 12);
            footerTemplate.SetTextMatrix(0, 0);
            footerTemplate.ShowText((writer.PageNumber - 1).ToString());
            footerTemplate.EndText();

        }

        public override void OnEndPage(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            base.OnEndPage(writer, document);

            // Create a new PdfContentByte instance
            PdfContentByte cb = writer.DirectContent;

            // Add page number at the bottom
            string pageNumberText = $"Page {writer.PageNumber} of ";
            float pageNumberWidth = bf.GetWidthPoint(pageNumberText, 12);
            float pageNumberX = (document.PageSize.Width - pageNumberWidth) / 2;
            float pageNumberY = document.BottomMargin;

            cb.BeginText();
            cb.SetFontAndSize(bf, 12);
            cb.SetTextMatrix(pageNumberX, pageNumberY);
            cb.ShowText(pageNumberText);
            cb.EndText();

            // Add the total pages placeholder
            cb.AddTemplate(footerTemplate, pageNumberX + pageNumberWidth, pageNumberY);

            // Create and add the header table
            PdfPTable headerTable = new PdfPTable(_columnNames.Length) { RunDirection = iTextSharp.text.pdf.PdfWriter.RUN_DIRECTION_RTL };

            string imagePath = System.IO.Path.Combine(AppContext.BaseDirectory, "assets", "images", "logo_kw.png");

            System.Drawing.Image logoImage = System.Drawing.Image.FromFile(imagePath);

            iTextSharp.text.Image itextImage = iTextSharp.text.Image.GetInstance(logoImage, BaseColor.LIGHT_GRAY);

            string imagePath2 = System.IO.Path.Combine(AppContext.BaseDirectory, "assets", "images", "favicon.png");

            System.Drawing.Image logoImage2 = System.Drawing.Image.FromFile(imagePath2);

            iTextSharp.text.Image itextImage2 = iTextSharp.text.Image.GetInstance(logoImage2, BaseColor.LIGHT_GRAY);

            //string imagePath3 = System.IO.Path.Combine(AppContext.BaseDirectory, "assets", "images", "logo-newkuwit.png");

            //System.Drawing.Image logoImage3 = System.Drawing.Image.FromFile(imagePath3);

            //iTextSharp.text.Image itextImage3 = iTextSharp.text.Image.GetInstance(logoImage3, BaseColor.LIGHT_GRAY);



            PdfPCell logoCell = new PdfPCell();
            logoCell.Colspan = _columnNames.Length; // Span across all columns
            logoCell.BackgroundColor = new BaseColor(System.Drawing.Color.SkyBlue);
            logoCell.HorizontalAlignment = Element.ALIGN_CENTER;
            logoCell.VerticalAlignment = Element.ALIGN_MIDDLE;
            logoCell.FixedHeight = 100f;





            PdfPTable imageTable = new PdfPTable(2);
            imageTable.WidthPercentage = 100;
            imageTable.DefaultCell.Border = iTextSharp.text.Rectangle.NO_BORDER;

            itextImage.ScaleToFit(logoCell.FixedHeight - 10, logoCell.FixedHeight - 30);
            imageTable.AddCell(new PdfPCell(itextImage) { Colspan = 1, Border = iTextSharp.text.Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, VerticalAlignment = Element.ALIGN_MIDDLE });


            itextImage2.ScaleToFit(logoCell.FixedHeight - 10, logoCell.FixedHeight - 30);
            imageTable.AddCell(new PdfPCell(itextImage2) { Colspan = 1, Border = iTextSharp.text.Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT, VerticalAlignment = Element.ALIGN_MIDDLE });

            //itextImage3.ScaleToFit(logoCell.FixedHeight - 10, logoCell.FixedHeight - 30);
            //imageTable.AddCell(new PdfPCell(itextImage3) { Colspan = 1, Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE });

            logoCell.AddElement(imageTable);
            headerTable.AddCell(logoCell);





            headerTable.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin;
            headerTable.LockedWidth = true;
            string titleText = "??????? ????? ???????? ?????? ????? ????? ????????";
            var titleCell = new PdfPCell(new Phrase(titleText, _tahomaFont))
            {
                Colspan = _columnNames.Length, // Span across all columns
                BackgroundColor = new BaseColor(System.Drawing.Color.LightGray),
                HorizontalAlignment = Element.ALIGN_CENTER,
                FixedHeight = 30f // Set the desired height (adjust as needed)
            };
            headerTable.AddCell(titleCell);
            foreach (var columnName in _columnNames)
            {
                var cell = new PdfPCell(new Phrase(columnName, _tahomaFont));
                cell.BackgroundColor = new BaseColor(System.Drawing.Color.LightGray);
                cell.HorizontalAlignment = Element.ALIGN_CENTER;
                headerTable.AddCell(cell);
            }

           
            headerTable.WriteSelectedRows(0, -1, document.LeftMargin, document.PageSize.Height - document.TopMargin - 20, cb);

          


           


          
        }
        
    }
}

 

image show issue as below


Answers (2)