//*******************************************************
        //
        // The Page_Load event handler on this Page is used to
        // obtain obtain the contents of a document from the
        // Documents table, construct an HTTP Response of the
        // correct type for the document, and then stream the
        // document contents to the response.  It uses the
        // ASPNetPortal.DocumentDB() data component to encapsulate
        // the data access functionality.
        //
        //*******************************************************

        private void Page_Load(object sender, System.EventArgs e)
        {
            if (Request.Params["DocumentId"] != null)
            {
                documentId = Int32.Parse(Request.Params["DocumentId"]);
            }

            if (documentId != -1)
            {
                // Obtain Document Data from Documents table
                ASPNetPortal.DocumentDB documents = new ASPNetPortal.DocumentDB();

                IDataReader dBContent = documents.GetDocumentContent(documentId);
                dBContent.Read();

                // Serve up the file by name
                Response.AppendHeader("content-disposition", "filename=" + (String)dBContent["filefriendlyname"]);

                // set the content type for the Response to that of the
                // document to display.  For example. "application/msword"
                Response.ContentType = (String)dBContent["contenttype"];

                // output the actual document contents to the response output stream
                Response.OutputStream.Write((byte[])dBContent["content"], 0, (int)dBContent["contentsize"]);


                // end the response
                Response.End();
            }
        }
Esempio n. 2
0
        //*******************************************************
        //
        // The Page_Load event handler on this User Control is used to
        // obtain a SqlDataReader of document information from the
        // Documents table, and then databind the results to a DataGrid
        // server control.  It uses the ASPNetPortal.DocumentDB()
        // data component to encapsulate all data functionality.
        //
        //*******************************************************

        private void Page_Load(object sender, System.EventArgs e)
        {
            // Obtain Document Data from Documents table
            // and bind to the datalist control
            ASPNetPortal.DocumentDB documents = new ASPNetPortal.DocumentDB();

            myDataGrid.DataSource = documents.GetDocuments(ModuleId);
            myDataGrid.DataBind();
        }
        //****************************************************************
        //
        // The DeleteBtn_Click event handler on this Page is used to delete an
        // a document.  It  uses the ASPNetPortal.DocumentsDB()
        // data component to encapsulate all data functionality.
        //
        //****************************************************************

        private void DeleteBtn_Click(Object sender, EventArgs e)
        {
            // Only attempt to delete the item if it is an existing item
            // (new items will have "ItemId" of 0)

            if (itemId != 0)
            {
                ASPNetPortal.DocumentDB documents = new ASPNetPortal.DocumentDB();
                documents.DeleteDocument(itemId);
            }

            // Redirect back to the portal home page
            Response.Redirect((String)ViewState["UrlReferrer"]);
        }
        //****************************************************************
        //
        // The UpdateBtn_Click event handler on this Page is used to either
        // create or update an document.  It  uses the ASPNetPortal.DocumentDB()
        // data component to encapsulate all data functionality.
        //
        //****************************************************************

        private void UpdateBtn_Click(Object sender, EventArgs e)
        {
            // Only Update if Input Data is Valid
            if (Page.IsValid == true)
            {
                // Create an instance of the Document DB component
                ASPNetPortal.DocumentDB documents = new ASPNetPortal.DocumentDB();

                // Determine whether a file was uploaded

                if ((storeInDatabase.Checked == true) && (FileUpload.PostedFile != null))
                {
                    // for web farm support
                    int    length      = (int)FileUpload.PostedFile.InputStream.Length;
                    String contentType = FileUpload.PostedFile.ContentType;
                    byte[] content     = new byte[length];

                    FileUpload.PostedFile.InputStream.Read(content, 0, length);

                    // Update the document within the Documents table
                    documents.UpdateDocument(moduleId, itemId, Context.User.Identity.Name, NameField.Text, PathField.Text, CategoryField.Text, content, length, contentType);
                }
                else
                {
                    if ((Upload.Checked == true) && (FileUpload.PostedFile != null))
                    {
                        // Calculate virtualPath of the newly uploaded file
                        String virtualPath = "~/uploads/" + Path.GetFileName(FileUpload.PostedFile.FileName);

                        // Calculate physical path of the newly uploaded file
                        String phyiscalPath = Server.MapPath(virtualPath);

                        // Save file to uploads directory
                        FileUpload.PostedFile.SaveAs(phyiscalPath);

                        // Update PathFile with uploaded virtual file location
                        PathField.Text = virtualPath;
                    }
                    documents.UpdateDocument(moduleId, itemId, Context.User.Identity.Name, NameField.Text, PathField.Text, CategoryField.Text, new byte[0], 0, "");
                }

                // Redirect back to the portal home page
                Response.Redirect((String)ViewState["UrlReferrer"]);
            }
        }
        //****************************************************************
        //
        // The Page_Load event on this Page is used to obtain the ModuleId
        // and ItemId of the document to edit.
        //
        // It then uses the ASPNetPortal.DocumentDB() data component
        // to populate the page's edit controls with the document details.
        //
        //****************************************************************

        private void Page_Load(object sender, System.EventArgs e)
        {
            // Determine ModuleId of Announcements Portal Module
            moduleId = Int32.Parse(Request.Params["Mid"]);

            // Verify that the current user has access to edit this module
            if (PortalSecurity.HasEditPermissions(moduleId) == false)
            {
                Response.Redirect("~/Admin/EditAccessDenied.aspx");
            }

            // Determine ItemId of Document to Update
            if (Request.Params["ItemId"] != null)
            {
                itemId = Int32.Parse(Request.Params["ItemId"]);
            }

            // If the page is being requested the first time, determine if an
            // document itemId value is specified, and if so populate page
            // contents with the document details

            if (Page.IsPostBack == false)
            {
                if (itemId != 0)
                {
                    // Obtain a single row of document information
                    ASPNetPortal.DocumentDB documents = new ASPNetPortal.DocumentDB();
                    IDataReader             dr        = documents.GetSingleDocument(itemId);

                    // Load first row into Datareader
                    dr.Read();

                    NameField.Text     = (String)dr["filefriendlyname"];
                    PathField.Text     = (String)dr["filenameurl"];
                    CategoryField.Text = (String)dr["category"];
                    CreatedBy.Text     = (String)dr["createdbyuser"];
                    CreatedDate.Text   = ((DateTime)dr["createddate"]).ToShortDateString();

                    dr.Close();
                }

                // Store URL Referrer to return to portal
                ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
            }
        }