public IPdfReportData CreatePdfReport(int type,int RequestId)
        {
            return new PdfReport().DocumentPreferences(doc =>
            {
                doc.RunDirection(PdfRunDirection.RightToLeft);
                doc.Orientation(PageOrientation.Portrait);
                doc.PageSize(PdfPageSize.A4);
               
            })
            .DefaultFonts(fonts =>
            {
                fonts.Path(AppPath.ApplicationPath + "\\Fonts\\BNAZANIN.TTF",
                                  AppPath.ApplicationPath + "\\Fonts\\TIMES.TTF");
                fonts.Size(20);
            })
            .PagesFooter(footer =>
            {
                footer.DefaultFooter("");
                footer.PdfFont.Size = 8;

            })
            .PagesHeader(header =>
            {
                if (type == 1)
                {
                    header.CustomHeader(_customHeader);
                }
                else
                {
                    header.DefaultHeader(h => h.Message("mohsen"));
                }

            })
             .MainTableTemplate(template =>
             {
                 template.BasicTemplate(BasicTemplate.SilverTemplate);
             })
            .MainTablePreferences(table =>
            {
                table.ColumnsWidthsType(TableColumnWidthType.Relative);


            })
            .MainTableDataSource(dataSource =>
            {
               
                
                var ctx = new ClearanceEntities();




                var list = (from c in ctx.CLEARANCE_ITEMS
                            where c.CLEARANCE_REQUEST.REQUEST_ID == RequestId
                            select new
                            {
                                c.TARIFF_NO,
                                c.GOODS_DESCRIPTION,
                                vahed = c.QUANTITY,
                                c.PACKING_TYPES.PACKING_NAME,
                                c.GROSS_WEIGHT,
                                arzesh = (c.GOODS_PRICE * c.GOODS_CURRENCY_RATE) + (c.FREIGHT_PRICE * c.FREIGHT_CURRENCY_RATE),
                                hoghogh = " ",
                                sood = " "

                            }).ToList();
               



                dataSource.AnonymousTypeList(list );
            })

            .MainTableColumns(columns =>
            {
                columns.AddColumn(column =>
                {
                    column.PropertyName("TARIFF_NO");

                    column.CellsHorizontalAlignment(HorizontalAlignment.Center);
                    column.IsVisible(true);
                    column.Order(0);
                    column.Width(3);
                    column.HeaderCell("تعرفه");
                });
                columns.AddColumn(column =>
                {
                    column.PropertyName("GOODS_DESCRIPTION");
                    column.CellsHorizontalAlignment(HorizontalAlignment.Center);

                    column.IsVisible(true);
                    column.Order(1);
                    column.Width(5);
                    column.HeaderCell("نام کالا");
                    column.ColumnItemsTemplate(template =>
                        {
                            new CellBasicProperties
                                {
                                  
                                    //PdfFontStyle = DocumentFontStyle.Bold | DocumentFontStyle.Underline,
                                    //FontColor = new BaseColor(System.Drawing.Color.Brown),
                                    //BackgroundColor = new BaseColor(System.Drawing.Color.Yellow)
                                };
                            return;
                        });

                });
                columns.AddColumn(column =>
                {
                    column.PropertyName("vahed");
                    column.CellsHorizontalAlignment(HorizontalAlignment.Center);
                    column.IsVisible(true);
                    column.Order(1);
                    column.Width(5);
                    column.HeaderCell("واحد");

                });
                columns.AddColumn(column =>
                {
                    column.PropertyName("GROSS_WEIGHT");
                    column.CellsHorizontalAlignment(HorizontalAlignment.Center);
                    column.IsVisible(true);
                    column.Order(1);
                    column.Width(5);
                    column.HeaderCell("وزن ناخالص");

                });
                columns.AddColumn(column =>
                {
                    column.PropertyName("arzesh");
                    column.CellsHorizontalAlignment(HorizontalAlignment.Center);
                    column.IsVisible(true);
                    column.Order(1);
                    column.Width(5);
                    column.HeaderCell("ارزش دلاری");

                });
                columns.AddColumn(column =>
                {
                    column.PropertyName("hoghogh");
                    column.CellsHorizontalAlignment(HorizontalAlignment.Center);
                    column.IsVisible(true);
                    column.Order(1);
                    column.Width(3);
                    column.HeaderCell("حقوق گمرکی");

                });
                columns.AddColumn(column =>
                {
                    column.PropertyName("sood");
                    column.CellsHorizontalAlignment(HorizontalAlignment.Center);
                    column.IsVisible(true);
                    column.Order(1);
                    column.Width(3);
                    column.HeaderCell("سود بازرگانی");

                });


            })
            .MainTableEvents(events =>
            {
                events.DataSourceIsEmpty(message: "There is no data available to display.");

}

                 events.DocumentClosing(args =>
            {
                if (HttpContext.Current == null || HttpContext.Current.Response == null) return;

                // close the document without closing the underlying stream
                args.PdfWriter.CloseStream = false;
                args.PdfDoc.Close();
                args.PdfStreamOutput.Position = 0;

                // write pdf bytes to output stream
                var pdf = ((MemoryStream)args.PdfStreamOutput).ToArray();
                string str = Guid.NewGuid().ToString();
                HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
                HttpContext.Current.Response.ContentType = MediaTypeNames.Application.Pdf;
                HttpContext.Current.Response.AddHeader("Content-Length", pdf.Length.ToString());
                HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + str + ".pdf");
                HttpContext.Current.Response.Buffer = true;
                HttpContext.Current.Response.Clear();
                HttpContext.Current.Response.OutputStream.Write(pdf, 0, pdf.Length);
                HttpContext.Current.Response.OutputStream.Flush();
                HttpContext.Current.Response.OutputStream.Close();
                HttpContext.Current.Response.End();
            });
        })

           .Generate(data => data.AsPdfStream(new MemoryStream()));

public void ProcessRequest (HttpContext context) {
        new InMemoryPdfReport().CreatePdfReport();
    }

 $(function() {
            $("#Button3").click(function () {
                //var url = "Default.aspx";
                //$(location).attr('href', url);
                $.ajax({
                    url: 'Handler.ashx',
                    contentType: "application/json; charset=utf-8",
                   dataType: "json",
                    success: function (data) {
                       
                    }
                });
            });
        });

 public PdfPTable RenderingReportHeader(Document pdfDoc, PdfWriter pdfWriter, IList<SummaryCellData> summaryData)
    {
        var httpCookie = HttpContext.Current.Request.Cookies["FinancialMarine"];
          if (httpCookie != null)
          {
              int requestId = int.Parse(httpCookie.Value);
              var ctx = new clearanceEntities();

              var item = (from d in ctx.CLEARANCE_ITEMS
                          where d.REQUEST_ID == requestId
                          select d).FirstOrDefault();
              if (item != null)
              {
                 
                 
                


                  string imagepath = HttpRuntime.AppDomainAppPath + "tir.JPG";
                  string imagepath2 = HttpRuntime.AppDomainAppPath + "tir2.JPG";

                  var fontPath = AppPath.ApplicationPath + "\\Fonts\\BNAZANIN.TTF";
                  //Environment.GetEnvironmentVariable("SystemRoot") + "\\fonts\\tahoma.ttf";
                  var baseFont = BaseFont.CreateFont(fontPath, BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
                  var tahomaFont = new Font(baseFont, 10, Font.NORMAL, BaseColor.BLACK);

                  PdfPTable table = new PdfPTable(numColumns: 3);

                  table.WidthPercentage = 100;
                  table.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  table.ExtendLastRow = false;

                  Image img = Image.GetInstance(imagepath);
                  Image img2 = Image.GetInstance(imagepath2);

                  PdfPCell c = new PdfPCell(img);
                  c.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  c.Border = 0;


                  table.AddCell(c);

                  c = new PdfPCell(img2);
                  c.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  c.Border = 0;
                  c.Padding = 5;
                  table.AddCell(c);

                  ////////////////////////////////////////////////////////////////////////
                  PdfPTable table2 = new PdfPTable(numColumns: 2);
                  table2.WidthPercentage = 100;

                  table2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  table2.ExtendLastRow = false;

                  PdfPCell cell2 = new PdfPCell(new Phrase("تاریخ:", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase(" ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("شماره: ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("TST/F/91-4641 ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("پیوست: ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("مدارک ضمیمه ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  var cell5 = new PdfPCell(table2);
                  cell5.Colspan = 3;
                  cell5.Border = 0;
                  table.AddCell(cell5);
                  ////////////////////////////////////////////////////////////////////////////////////
                  PdfPCell cell = new PdfPCell(new Phrase("شرکت", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);
                  cell = new PdfPCell(new Phrase("اداره محترم بازرگانی / تدارکات کالا", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);

                  cell = new PdfPCell(new Phrase("با سلام", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);

                  cell = new PdfPCell(new Phrase("با احترام به شرح زیر یک فقره صورتحساب مربوط به ترخیص محمولات آن شرکت جهت اطلاع و صدور دستور مقتضی بحضورتان ایفاد می‌گردد.", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);


                  ////////////////////////////////////////////////////////////////
                  
                  PdfPTable table3 = new PdfPTable(numColumns: 6);
                  table3.WidthPercentage = 100;

                  table3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  table3.ExtendLastRow = false;

                  PdfPCell cell3 = new PdfPCell(new Phrase("کشتی/کامیون", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.SHIP_NAME + " " + item.CLEARANCE_REQUEST.TRAVEL_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" تعداد و نوع بسته بندی", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.QUANTITY.ToString(CultureInfo.InvariantCulture) + " " + item.PACKING_TYPES.PACKING_NAME, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" شماره پروانه", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.PERMIT_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase("شماره بارنامه ", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);


                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.WAYBILL_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" وزن(کیلوگرم)", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.TARE_WEIGHT.ToString(CultureInfo.InvariantCulture), tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" شماره درخواست", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.REQUEST_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell = new PdfPCell(table3);
                  cell.Colspan = 3;
                  cell.Border = 0;

                  table.AddCell(cell);
                  return table;
              }
          }
        return null;
        
    }

 .PagesFooter(footer =>
            {
                footer.DefaultFooter("محسن ");
                footer.PdfFont.Size = 6;
            })