Hi,

I have created a custom module for my client. This module is more of a reporting module. It has a few dropdown lists at the top to filter data that is returned below. All of this works fine but for each record that is returned, I display a hyperlink for a .pdf document that is associated to this record. This document is stored in the database and when I click on the link, nothing happens.

The code that I'm using to retrieve the document from the database works fine in another web app that I've created for this client but that web app is not a DNN site. Here is the code I use to retrieve the document:

  public static bool openDocument(int iDocID, int languageID)
        {
            using (var ctx = Components.Data.Model.ArchivesModel.Instance())
            {
                var doc = from d in ctx.DocumentLanguages.Include("Document").Where(dd => dd.DocumentID == iDocID && dd.LanguageID == languageID)
                          select d;

                var document = doc.FirstOrDefault();

                HttpContext.Current.Response.Buffer = false;
                HttpContext.Current.Response.Clear();
                if (document.Document.FileSize > 0)
                {
                    string strFileName = document.Document.FileName;
                    HttpContext.Current.Response.ContentType = document.Document.ContentType;
                    HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + strFileName.ToString());
                    HttpContext.Current.Response.OutputStream.Write(document.FileContent, 0, ((int)document.Document.FileSize));

                    if (HttpContext.Current.Response.IsClientConnected)
                    {
                        HttpContext.Current.Response.Flush();
                        HttpContext.Current.Response.Close();
                        HttpContext.Current.Response.End();

                        return true;
                    }
                }
                return false;
            }
        }

This code is called upon the click of the link and works fine in the other application but does nothing in my dnn module. Can you open up a document in DNN this way? If not, is there a better way of doing this?

Thanks