/// <summary>
        /// UpdateInsert the Document Upload record
        /// </summary>
        /// <param name="DocumentUploadBO"></param>
        /// <returns>int</returns>
        public void UpdateInsert(DocumentUploadBO duBO)
        {
            // Define Constants
            const string sp = "dbo.Update_Insert_Document_Upload";

            // Set Stored Procedure
            DbCommand dbCommand = _DB.GetStoredProcCommand(sp);

            try
            {
                _DB.AddInParameter(dbCommand, "Project_Id", DbType.Int32, duBO.Project_Id);
                _DB.AddInParameter(dbCommand, "Project_Name", DbType.String, duBO.Project_Name);
                _DB.AddInParameter(dbCommand, "Upload_Criteria_Id", DbType.Int32, duBO.Upload_Criteria_Id);
                _DB.AddInParameter(dbCommand, "Effective_Date", DbType.DateTime, duBO.Effective_Date);
                _DB.AddInParameter(dbCommand, "Ack_Due_Date", DbType.DateTime, duBO.Ack_Due_Date);
                _DB.AddInParameter(dbCommand, "Primary_Barcode", DbType.String, duBO.Primary_Barcode);
                _DB.AddInParameter(dbCommand, "Secondary_Barcode", DbType.String, duBO.Secondary_Barcode);
                _DB.AddInParameter(dbCommand, "Email_Notification", DbType.String, duBO.Email_Notification);
                _DB.AddInParameter(dbCommand, "Email_Reminder", DbType.String, duBO.Email_Reminder);
                _DB.AddInParameter(dbCommand, "Zip_File_Name", DbType.String, duBO.Zip_File_Name);
                _DB.AddInParameter(dbCommand, "Control_File_Name", DbType.String, duBO.Control_File_Name);
                _DB.AddInParameter(dbCommand, "PDF_File_Name", DbType.String, duBO.PDF_File_Name);
                _DB.AddInParameter(dbCommand, "Criteria_Name", DbType.String, duBO.Criteria_Name);
                _DB.AddInParameter(dbCommand, "Project_Created_By", DbType.String, duBO.Project_Created_By);
                _DB.AddInParameter(dbCommand, "Modified_By", DbType.String, duBO.Modified_By);

                _DB.AddOutParameter(dbCommand, "Id", DbType.Int32, 0);
                _DB.ExecuteNonQuery(dbCommand);

                if (duBO.Project_Id == 0)
                {
                    HttpContext.Current.Session["ProjectId"] = Convert.ToInt32(_DB.GetParameterValue(dbCommand, "@Id"));
                }
            }
            catch (InternalException err)
            {
                // Re-Throw the Internal Exception
                throw;
            }
            catch (Exception err)
            {
                // Format the Parameters
                string parms = CommonDA.FormatParmsSQL(dbCommand);

                // Database Error
                ErrMsg = string.Format("{0} - UpdateInsert Document Upload Error - Parameters = {1} - {2}",
                                       GetType().FullName,
                                       parms,
                                       err.Message);

                // Save the Error
                CommonDA.SaveError(ErrMsg, err);
            }
        }
        /// <summary>
        /// Retrieves the Document Upload record for an Project Id
        /// </summary>
        /// <param name="projectId"></param>
        /// <returns>documentUploadBO</returns>
        public DocumentUploadBO GetByProjectId(Int32 projectId)
        {
            // Define Constants
            const string sp = "dbo.Get_DocUpload_By_Project_Id";

            // Set Stored Procedure
            DbCommand dbCommand = _DB.GetStoredProcCommand(sp);

            // Define Variables
            DocumentUploadBO duBO = new DocumentUploadBO();

            try
            {
                // Set Input Parameters
                _DB.AddInParameter(dbCommand, "Project_Id", DbType.Int32, projectId);

                using (IDataReader dr = _DB.ExecuteReader(dbCommand))
                {
                    // Process all the records
                    while (dr.Read())
                    {
                        // Save the DocUpload record
                        duBO.Save(dr);
                    }
                }
            }
            catch (InternalException err)
            {
                // Re-Throw the Internal Exception
                throw;
            }
            catch (Exception err)
            {
                // Format the Parameters
                string parms = CommonDA.FormatParmsSQL(dbCommand);

                // Database Error
                ErrMsg = string.Format("{0} - Get DocUpload By Project Id Error - Parameters = {1} - {2}",
                                       GetType().FullName,
                                       parms,
                                       err.Message);

                // Save the Error
                CommonDA.SaveError(ErrMsg, err);
            }

            return(duBO);
        }