/// <summary>
        /// This uploads a file which generates a GUID name, uses original image extension as save type. 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        /// <remarks></remarks>
        protected void cmdUpload_Click(System.Object sender, System.EventArgs e)
        {
            lblMessage.Text = string.Empty;
            try {
                // if no file is selected exit
                if (fuFile.PostedFile.FileName == string.Empty) {
                    return;
                }

                // Maximum attachment filesize = 5MB
                if (fuFile.PostedFile.InputStream.Length > (/*objConfig.MaxAttachmentSize*/5000 * 1024)) {
                    lblMessage.Text = Localization.GetString("MaxFileSize", this.LocalResourceFile) /*+ objConfig.MaxAttachmentSize.ToString()*/ + "5 MB";
                    return;
                }

                string FileName = System.IO.Path.GetFileName(fuFile.PostedFile.FileName);

                //Get destination folder as mappath
                string ParentFolderName = PortalSettings.HomeDirectoryMapPath;
                //ParentFolderName += BaseFolder;
                ParentFolderName = ParentFolderName.Replace("/", "\\");
                if (ParentFolderName.EndsWith("\\") == false)
                    ParentFolderName += "\\";

                string strExtension = System.IO.Path.GetExtension(fuFile.PostedFile.FileName).Replace(".", "");
                if (_fileFilter != string.Empty /*& Strings.InStr("," + _fileFilter.ToLower(), "," + strExtension.ToLower()) == 0*/) {
                    // trying to upload a file not allowed for current filter
                    lblMessage.Text = string.Format(Localization.GetString("UploadError", this.LocalResourceFile), _fileFilter, strExtension);
                }

                if (lblMessage.Text == string.Empty) {
                    //ParentFolderName = "C:\\inetpub\\wwwroot\\DNN6\\Portals\\0\\";
                    string destFileName = Guid.NewGuid().ToString().Replace("-", "") + "." + strExtension;
                    //lblMessage.Text = DotNetNuke.Common.Utilities.FileSystemUtils.UploadFile(ParentFolderName, fuFile.PostedFile, false);

                    if (lblMessage.Text != string.Empty)
                        return;

                    //Rename the file using the GUID model
                    //FileSystemUtils.MoveFile(ParentFolderName + FileName, ParentFolderName + destFileName, PortalSettings);

                    destFileName = FileName;

                    //Now get the FileID from DNN Filesystem
                    int myFileID = 0;
                    ArrayList fileList = Globals.GetFileList(PortalId, strExtension);//, false, ParentFolderName, false);
                    foreach (FileItem objFile in fileList) {
                        if (objFile.Text == destFileName) {
                            myFileID = Convert.ToInt32(objFile.Value);
                        }
                    }

                    if (myFileID > 0) {
                        //Now save the Attachment info
                        AttachmentInfo objAttach = new AttachmentInfo();
                        var _with1 = objAttach;
                        _with1.PostID = PostId;
                        _with1.UserID = UserId;
                        _with1.FileID = myFileID;
                        _with1.LocalFileName = FileName;
                        _with1.Inline = false;

                        AttachmentController cntAttachment = new AttachmentController();
                        cntAttachment.Update(objAttach);
                        BindFileList();
                    }
                }
            } catch (Exception exc) {
                //ProcessModuleLoadException(this, exc);
                Response.Write(exc);
            }
        }
 /// <summary>
 /// Adds an AttachmentInfo object
 /// </summary>
 /// <param name="objAttachment"></param>
 /// <remarks></remarks>
 public void Update(AttachmentInfo objAttachment)
 {
     DataProvider pro = new DotNetNuke.Modules.uDebate.Data.DataProvider();
     pro.Attachment_Update(objAttachment);
 }
        /// <summary>
        /// Hydrates the AttachmentInfo object
        /// </summary>
        /// <param name="dr"></param>
        /// <returns></returns>
        /// <remarks>
        /// </remarks>
        /// <history>
        /// 	[skeel]	12/22/2008	Created
        /// </history>
        private AttachmentInfo FillAttachmentInfo(IDataReader dr)
        {
            AttachmentInfo objAttachment = new AttachmentInfo();
            try
            {
                objAttachment.AttachmentID = Convert.ToInt32(dr["AttachmentID"]);
            }
            catch
            {
            }
            try {
                objAttachment.FileID = Convert.ToInt32(dr["FileID"]);
            } catch {
            }
            try {
                objAttachment.PostID = Convert.ToInt32(dr["PostID"]);
            } catch {
            }
            try {
                objAttachment.UserID = Convert.ToInt32(dr["UserID"]);
            } catch {
            }
            try {
                objAttachment.LocalFileName = Convert.ToString(dr["LocalFileName"]);
            } catch {
            }
            try {
                objAttachment.FileName = Convert.ToString(dr["FileName"]);
            } catch {
            }
            try {
                objAttachment.Extension = Convert.ToString(dr["Extension"]);
            } catch {
            }
            try {
                objAttachment.Size = Convert.ToInt32(dr["Size"]);
            } catch {
            }
            try {
                objAttachment.Inline = Convert.ToBoolean(dr["Inline"]);
            } catch {
            }
            try {
                objAttachment.Width = Convert.ToInt32(dr["Width"]);
            } catch {
            }
            try {
                objAttachment.Height = Convert.ToInt32(dr["Height"]);
            } catch {
            }

            return objAttachment;
        }
 public void Attachment_Update(AttachmentInfo objAttachment)
 {
     SqlHelper.ExecuteNonQuery(_connectionString,  "uDebate_Attachment_Update", objAttachment.AttachmentID, objAttachment.FileID, objAttachment.PostID, objAttachment.UserID, objAttachment.LocalFileName, objAttachment.Inline);
 }