Retrive pfd from database in ASP.NET using C#

Question

0.00/5 (No votes)

See more:

C#

using Common;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Web;

namespace BootStrap.fa
{
    /// <summary>
    /// Summary description for ProductCatalogHandler
    /// 
    public class ProductCatalogHandler : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            int productId;
            if (int.TryParse(context.Request.QueryString["ci"], out productId))
            {
                try
                {
                    using (var db = new Data.ModelContainer1())
                    {
                        var catalog = db.Catalogs.Where(c => c.Product != null && c.Product.Id == productId).FirstOrDefault();
                        if (catalog == null || catalog.CatalogFile == null)
                        {
                            var returnUrl = context.Request.QueryString["ReturnURL2"];
                            context.Response.Redirect(returnUrl);
                            return;
                        }
                        else
                        {
                            var content = (catalog.CatalogFileExt != null) ? catalog.CatalogFileExt : "application/pdf";
                            var filename = (catalog.CatalogFileName != null) ? catalog.CatalogFileName : "Catalog.pdf";
                            filename = filename.Replace(" ", "");

                            context.Response.Buffer = true;
                            context.Response.Charset = "";
                            context.Response.Clear();

                            context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
                            context.Response.AddHeader("Content-Length", catalog.CatalogFile.Length.ToString());
                            context.Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);

                            MemoryStream memory = new MemoryStream(catalog.CatalogFile);
                            context.Response.OutputStream.Write(memory.ToArray(), 0, memory.ToArray().Length);

                            HttpContext.Current.Response.Flush(); HttpContext.Current.Response.Close(); HttpContext.Current.ApplicationInstance.CompleteRequest();
                        }
                    }
                }
                catch { }
            }
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}

What I have tried:

When I download (open) pdf directly in Chrome or Firefox , browser show invalid code and in address bar show downloaded file with "htm" extensions.

Please Help me.
Thanks

Posted 12-Sep-17 19:28pm

Nader Barman

Updated 13-Sep-17 12:39pm

Graeme_Grant

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

an0ther1 · Answer 1 · 2017-09-13T12:39:00

I use the following to pass a Report from server to client - the report is a Crystal Report that is exported to a System.IO.Stream - which is basically what you have - and is successful on all browsers I have tested with;

C#

// create a byte array to store your memory stream
byte[] fileArray = new byte[memory.Length];
memory.Read(fileArray, 0, Convert.ToInt32(memory.Length));
// clear content & headers
context.Response.ClearContent();
context.Response.ClearHeaders();
// the actual string you require is ".pdf","application/pdf"
// The additional '\' are used to escape the quotes within the string
context.Response.ContentType = "\".pdf\",\"application/pdf\""
context.Response.AddHeader("Content-Length", catalog.CatalogFile.Length.ToString());
context.Response.AddHeader("Content-disposition", "attachment;filename=" + fileName);
context.Response.BinaryWrite(fileArray);
// end the response
context.Response.Flush();
context.Response.Clear();
context.Response.Close();
context.Response.End();

Hope this helps

Kind Regards