Upload PDF file and display in another page using Generic Handler in ASP.Net

George61...

SOLVED CLOSED ACTIVE ANSWERED
User: George616
Posted: on Nov 17, 2020 03:21 AM
Forum: ASP.Net Thirdparty controls
Answer: 1
Views: 4653
Sample Code: Download

Hello Forum,

I am trying to make it possible for a user to upload a pdf file and create a QR code for the file so that when the QR code is scanned using QR code scanner, it will call the file from the database and redirect the user to the webpage where the PDF file will display.

Here is what I tried but it seems not to work. I need help please

UploadPDF.aspx

          <div class="container" id="centered" style="margin-top: -2%; font-family: Nunito;">
              <div class="form-horizontal">
                  <h1 style="font-size: small; margin-top: 0%; color: red;">ID Card with QR Code</h1>
                  <hr />
                  <div class="mid-cont">
                      <br />
                      <div class="containr-fluid">
                          <asp:FileUpload runat="server" ID="showPreviewBill" />
                          <asp:Button ID="buttonmail" runat="server" CssClass="btn btn-primary navbar-btn" BackColor="SteelBlue" Font-Size="9pt" Text="QR code" OnClick="buttonmail_Click" />
                          <br />
                          <br />
                      </div>
                      <div class="contentt">
                          <canvas id="the-canvas" style="border: 1px solid grey; height: 850px; width: 700px;"></canvas>
                      </div>
                  </div>
                  <asp:Label ID="lblMessage" runat="server" Text=""></asp:Label>
              </div>
          </div>

uploadPDF.aspx.cs

        protected void buttonmail_Click(object sender, EventArgs e)
        {
            string filename = Path.GetFileName(showPreviewBill.PostedFile.FileName);
            string contentType = showPreviewBill.PostedFile.ContentType;
            using (Stream fs = showPreviewBill.PostedFile.InputStream)
            {
                using (BinaryReader br = new BinaryReader(fs))
                {
                    byte[] bytes = br.ReadBytes((Int32)fs.Length);
                    using (SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True"))
                    {
                        string query = "INSERT INTO tableinvoice(email, Name, ContentType, Data, Uid, CreatedBy, Role, CreatedDate, Organization)" +
                    " VALUES(@email, @Name, @ContentType, @Data, @Uid, @CreatedBy, @Role, @CreatedDate, @Organization); SELECT @@IDENTITY";
                        using (SqlCommand cmd = new SqlCommand(query))
                        {
                            cmd.Connection = con;
                            cmd.Parameters.AddWithValue("@email", user.Text.Trim());
                            cmd.Parameters.AddWithValue("@Name", filename);
                            cmd.Parameters.AddWithValue("@ContentType", contentType);
                            cmd.Parameters.AddWithValue("@Data", bytes);
                            cmd.Parameters.AddWithValue("@Uid", labelid.Text.Trim());
                            cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());
                            cmd.Parameters.AddWithValue("@Role", role.Text.Trim());
                            cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
                            cmd.Parameters.AddWithValue("@Organization", named.Text.Trim());
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();
                    
                            Session["paperinv"] = Invoice;
                            Response.Redirect("PDFprint.aspx");
                        }
                    }
                }
            }
       }

In the QR code and print page I dont understand the line of code where it is bold

PDFprint.aspx

          <div class="container" id="centered" style="margin-top: -2%; font-family: Nunito;">
              <div class="form-horizontal">
                  <h1 style="font-size: small; margin-top: 0%; color: red;">ID Card with QR Code</h1>
                  <hr />
                  <br />
              <div class="row">
           <asp:Panel ID="printpanel" runat="server">
               <div class="contentt">
                   <%--<canvas id="the-canvas" style="border: 1px solid black; height: 750px; width: 650px;"></canvas>--%>
                   <asp:Literal ID="ltEmbed" runat="server" />
                   <asp:Image ID="Image1" runat="server" BorderStyle="None" Width="80px" Height="85px" />
               </div>
           </asp:Panel>
                      <br />
                       &nbsp;&nbsp;
                      <div class="print">
                       <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                          <br />
                          <br />
                       <asp:Button ID="btnPrinnt" runat="server" CssClass="btn btn-primary navbar-btn" BackColor="SteelBlue" Font-Size="Small" Text="Send to Mail"/>
                          <br />
                          <br />
                       <asp:Button ID="buttonmail" runat="server" CssClass="btn btn-primary navbar-btn" BackColor="SteelBlue" Font-Size="Small" Text="Download Invoice"/>
                  </div>
                  </div>
              </div>
          </div>

using MessagingToolkit.QRCode.Codec;
using System.Drawing.Imaging;
using System.Drawing;
using System.Diagnostics;
using MessagingToolkit.QRCode.Codec.Data;
 
public partial class PDFprint: System.Web.UI.Page
{
    SqlCommand cmd = new SqlCommand();
    SqlDataAdapter sda = new SqlDataAdapter();
    DataSet ds = new DataSet();
    SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");
    private string imgBytes;
 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["user"] == null)
        {
            // Response.Redirect("LoginForm.aspx");
        }
        if (!this.IsPostBack)
        {
            BindCardAndQR();
        }
    }
    private void BindCardAndQR()
    {
        if (Session["paperinv"] != null)
        {
            int id = Convert.ToInt32(Session["paperinv"]);
            // Binding PDF file in Literal control
            string embed = "<object data=\"{0}{1}\" type=\"application/pdf\" width=\"650px\" height=\"750px\"></object>";
            ltEmbed.Text = string.Format(embed, ResolveUrl("Invoiceprint.aspx?Id="), id);
 
            //This is where I Bind Image1 control for the QR code generated
            byte[] QRBytes = GetQRCodeBytes(Server.MapPath("/Invoiceprint.aspx") + "?Id=" + id);
            Image1.ImageUrl = "data:image/jpg;base64," + Convert.ToBase64String(QRBytes);
        }
    }
    public byte[] GetQRCodeBytes(string url)
    {
        //QR code generated here
        QRCodeEncoder encoder = new QRCodeEncoder();
        Bitmap bi = encoder.Encode(url);
        MemoryStream tmpSteam = new MemoryStream();
        bi.Save(tmpSteam, ImageFormat.Jpeg);
        return tmpSteam.ToArray();
    }
}

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 15

Reply
ANSWER
User: dharmendr
Replied: on Nov 21, 2020 03:21 AM
Report

Use generic Handler to display the pdf.

Refer below code.

UploadPDF.aspx

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div class="container" id="centered" style="margin-top: -2%; font-family: Nunito;">
            <div class="form-horizontal">
                <h1 style="font-size: small; margin-top: 0%; color: red;">ID Card with QR Code</h1>
                <hr />
                <div class="mid-cont">
                    <br />
                    <div class="containr-fluid">
                        <asp:FileUpload runat="server" ID="showPreviewBill" />
                        <asp:Button ID="buttonmail" runat="server" CssClass="btn btn-primary navbar-btn"
                            BackColor="SteelBlue" Font-Size="9pt" Text="QR code" OnClick="buttonmail_Click" />
                        <br />
                        <%--<br />--%>
                    </div>
                    <div class="contentt">
                        <canvas id="the-canvas" style="border: 1px solid grey; height: 850px; width: 700px;"></canvas>
                    </div>
                </div>
                <asp:Label ID="lblMessage" runat="server" Text=""></asp:Label>
            </div>
        </div>
    </form>
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" />
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/malihu-custom-scrollbar-plugin/3.1.5/jquery.mCustomScrollbar.concat.min.js"></script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdf.js/2.0.943/pdf.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $("#showPreviewBill").change(function () {
                if (this.files && this.files[0]) {
                    var reader = new FileReader();
                    reader.onload = function (e) {
                        showInCanvas(e.target.result);
                    }
                    reader.readAsDataURL(this.files[0]);
                }
            });

            function convertDataURIToBinary(dataURI) {
                var BASE64_MARKER = ';base64,';
                var base64Index = dataURI.indexOf(BASE64_MARKER) + BASE64_MARKER.length;
                var base64 = dataURI.substring(base64Index);
                var raw = window.atob(base64);
                var rawLength = raw.length;
                var array = new Uint8Array(new ArrayBuffer(rawLength));

                for (i = 0; i < rawLength; i++) {
                    array[i] = raw.charCodeAt(i);
                }
                return array;
            }

            function showInCanvas(url) {
                'use strict';
                var pdfAsArray = convertDataURIToBinary(url);
                pdfjsLib.getDocument(pdfAsArray).then(function (pdf) {
                    pdf.getPage(1).then(function (page) {
                        var scale = 1.5;
                        var viewport = page.getViewport(scale);
                        var canvas = document.getElementById('the-canvas');
                        var context = canvas.getContext('2d');
                        canvas.height = viewport.height;
                        canvas.width = viewport.width;
                        var renderContext = {
                            canvasContext: context,
                            viewport: viewport
                        };
                        page.render(renderContext);
                    });
                });
            }
        });
    </script>
</body>
</html>

PDFPrint.aspx

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div class="container" id="centered" style="margin-top: -2%; font-family: Nunito;">
            <div class="form-horizontal">
                <h1 style="font-size: small; margin-top: 0%; color: red;">ID Card with QR Code</h1>
                <hr />
                <br />
                <div class="row">
                    <asp:Panel ID="printpanel" runat="server">
                        <div class="contentt">
                            <strong>
                                <asp:Literal ID="ltEmbed" runat="server" /></strong>
                            <asp:Image ID="Image1" runat="server" BorderStyle="None" Width="80px" Height="85px" />
                        </div>
                    </asp:Panel>
                    <br />
                        &nbsp;&nbsp;
                      <div class="print">
                          <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                          <br /><br />
                          <asp:Button ID="btnPrinnt" runat="server" CssClass="btn btn-primary navbar-btn" BackColor="SteelBlue" Font-Size="Small" Text="Send to Mail" />
                          <br /><br />
                          <asp:Button ID="buttonmail" runat="server" CssClass="btn btn-primary navbar-btn" BackColor="SteelBlue" Font-Size="Small" Text="Download Invoice" />
                      </div>
                </div>
            </div>
        </div>
    </form>
</body>
</html>

UploadPDF.aspx.cs

protected void buttonmail_Click(object sender, EventArgs e)
{
    string filename = Path.GetFileName(showPreviewBill.PostedFile.FileName);
    string contentType = showPreviewBill.PostedFile.ContentType;
    using (Stream fs = showPreviewBill.PostedFile.InputStream)
    {
        using (BinaryReader br = new BinaryReader(fs))
        {
            byte[] bytes = br.ReadBytes((Int32)fs.Length);
            using (SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True"))
            {
                string query = "INSERT INTO tableinvoice(email, Name, ContentType, Data, Uid, CreatedBy, Role, CreatedDate, Organization) " +
                                "VALUES(@email, @Name, @ContentType, @Data, @Uid, @CreatedBy, @Role, @CreatedDate, @Organization); SELECT @@IDENTITY";
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@email", user.Text.Trim());
                    cmd.Parameters.AddWithValue("@Name", filename);
                    cmd.Parameters.AddWithValue("@ContentType", contentType);
                    cmd.Parameters.AddWithValue("@Data", bytes);
                    cmd.Parameters.AddWithValue("@Uid", labelid.Text.Trim());
                    cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());
                    cmd.Parameters.AddWithValue("@Role", role.Text.Trim());
                    cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
                    cmd.Parameters.AddWithValue("@Organization", named.Text.Trim());
                    con.Open();
                    object Invoice = cmd.ExecuteScalar();
                    con.Close();
                    Session["paperinv"] = Invoice;
                    Response.Redirect("PDFprint.aspx");
                }
            }
        }
    }
}

PDFPrint.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["user"] == null)
    {
        Response.Redirect("LoginForm.aspx");
    }

    if (!this.IsPostBack)
    {
        BindCardAndQR();
    }
}
private void BindCardAndQR()
{
    if (Session["paperinv"] != null)
    {
        int id = Convert.ToInt32(Session["paperinv"]);
        // Binding PDF file in Literal control
        string embed = "<object data=\"{0}{1}\" type=\"application/pdf\" width=\"400px\" height=\"400px\"></object>";
        ltEmbed.Text = string.Format(embed, ResolveUrl("Handler.ashx?Id="), id);

        // This is where I Bind Image1 control for the QR code generated
        byte[] QRBytes = GetQRCodeBytes(Server.MapPath("~/Invoiceprint.aspx") + "?Id=" + id);
        Image1.ImageUrl = "data:image/jpg;base64," + Convert.ToBase64String(QRBytes);
    }
}
public byte[] GetQRCodeBytes(string url)
{
    //QR code generated here
    QRCodeEncoder encoder = new QRCodeEncoder();
    Bitmap bi = encoder.Encode(url);
    MemoryStream tmpSteam = new MemoryStream();
    bi.Save(tmpSteam, ImageFormat.Jpeg);
    return tmpSteam.ToArray();
}

Handler

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Web.SessionState;
using System.Configuration;
using System.Data.SqlClient;

public class Handler : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        int id = int.Parse(context.Request.QueryString["Id"]);
        byte[] bytes;
        string contentType;
        string constr = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True";
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "SELECT * FROM tableinvoice WHERE Id=@Id";
                cmd.Parameters.AddWithValue("@Id", id);
                cmd.Connection = con;
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    sdr.Read();
                    bytes = (byte[])sdr["Data"];
                    contentType = sdr["ContentType"].ToString();
                }
                con.Close();
            }
        }

        context.Response.Buffer = true;
        context.Response.Charset = "";
        context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
        context.Response.ContentType = contentType;
        context.Response.BinaryWrite(bytes);
        context.Response.Flush();
        context.Response.End();
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Upload PDF file and display in another page using Generic Handler in ASP.Net

Company

Explore

Follow us

Contact Us