public void Delete()
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) {
SqlTransaction transaction;
cn.Open();
transaction = cn.BeginTransaction();
try {
SqlCommand cmd = new SqlCommand("DELETE FROM cms_DocumentLink WHERE DocumentSerial = @DocumentSerial", cn, transaction);
cmd.Parameters.Add("@DocumentSerial", SqlDbType.Int).Value = _DocumentSerial;
cmd.ExecuteNonQuery();
cmd.CommandText = "DELETE FROM cms_Document WHERE DocumentSerial = @DocumentSerial";
cmd.ExecuteNonQuery();
transaction.Commit();
} catch (SqlException sqlError) {
transaction.Rollback();
Elmah.ErrorLog.GetDefault(HttpContext.Current).Log(new Elmah.Error(sqlError));
}
cn.Close();
}
// Remove from Lucene search index
Indexer.LuceneIndexer li = new Indexer.LuceneIndexer();
li.CreateIndexWriter();
li.Delete(DocumentID.ToString());
li.Close();
}
private void BindToolBarAndButtons()
{
tbView.AddText(LocRM.GetString("QuickTracking"));
// O.R. [2009-05-25]: DisableButtons function doesn't work with CausesValidation property
/*
* btnComplete.Attributes.Add("onclick","DisableButtons(this);");
* btnSuspend.Attributes.Add("onclick","DisableButtons(this);");
* btnUncomplete.Attributes.Add("onclick","DisableButtons(this);");
* btnResume.Attributes.Add("onclick","DisableButtons(this);");
* btnDecline.Attributes.Add("onclick","DisableButtons(this);");
* btnAccept.Attributes.Add("onclick","DisableButtons(this);");
* btnActivate.Attributes.Add("onclick","DisableButtons(this);");
*/
string ContainerKey = "DocumentVers_" + DocumentID.ToString();
string ContainerName = "FileLibrary";
BaseIbnContainer bic = BaseIbnContainer.Create(ContainerName, ContainerKey);
Mediachase.IBN.Business.ControlSystem.FileStorage fs = (Mediachase.IBN.Business.ControlSystem.FileStorage)bic.LoadControl("FileStorage");
string commandLink = (Security.CurrentUser.IsExternal) ? "~/External/FileUpload.aspx" : "~/FileStorage/FileUpload.aspx";
string link = String.Format("javascript:ShowWizard('{0}?ParentFolderId={1}&ContainerKey={2}&ContainerName={3}{4}', 470, 270);return false;",
ResolveUrl(commandLink), fs.Root.Id, ContainerKey, ContainerName,
(Security.CurrentUser.IsExternal) ? ("&ExternalId=" + Security.CurrentUser.UserID) : "");
btnNewVersion.Attributes.Add("onclick", link);
}
/// <summary>
/// Returns parameters according to the upload mode.
/// </summary>
private string GetModeParameters()
{
string[] args;
if (MediaLibraryID > 0)
{
// MediaLibrary mode
args = new[]
{
"MediaLibraryID", MediaLibraryID.ToString(),
"MediaFolderPath", MediaFolderPath,
"MediaFileID", MediaFileID.ToString(),
"IsMediaThumbnail", IsMediaThumbnail.ToString(),
"MediaFileName", MediaFileName
};
return("MediaLibraryArgs=" + GetArgumentsString(args, UploaderHelper.MEDIA_LIBRARY_ARGS_HASHING_PURPOSE));
}
if (ObjectID > 0)
{
// MetaFile mode
args = new[]
{
"MetaFileID", MetaFileID.ToString(),
"ObjectID", ObjectID.ToString(),
"SiteID", SiteID.ToString(),
"ObjectType", ObjectType,
"Category", Category
};
return("MetaFileArgs=" + GetArgumentsString(args, UploaderHelper.META_FILE_ARGS_HASHING_PURPOSE));
}
if ((DocumentID > 0) || (FormGUID != Guid.Empty))
{
// Attachment mode
args = new[]
{
"DocumentID", DocumentID.ToString(),
"DocumentParentNodeID", DocumentParentNodeID.ToString(),
"NodeClassName", NodeClassName,
"AttachmentGUIDColumnName", AttachmentGUIDColumnName,
"AttachmentGUID", AttachmentGUID.ToString(),
"AttachmentGroupGUID", AttachmentGroupGUID.ToString(),
"FormGUID", FormGUID.ToString(),
"IsFieldAttachment", mIsFiledAttachment.ToString(),
"FullRefresh", FullRefresh.ToString()
};
return("AttachmentArgs=" + GetArgumentsString(args, UploaderHelper.ATTACHEMENT_ARGS_HASHING_PURPOSE));
}
return(String.Empty);
}
private void UpdateIndex()
{
// Update Lucene search index
Indexer.LuceneIndexer li = new Indexer.LuceneIndexer();
li.CreateIndexWriter();
if (!string.IsNullOrEmpty(DocumentTitle))
{
li.UpdateWebPage(DocumentID.ToString(), URL, DocumentTitle, Description, "Document");
}
else
{
li.UpdateWebPage(DocumentID.ToString(), URL, LinkText, Description, "Document");
}
li.Close();
li.IndexWords();
}
/// <summary>
/// Builds breadcrumb URL.
/// </summary>
private string GenerateBreadCrumbUrl()
{
string returnUrl;
if (QueryHelper.Contains("productid"))
{
returnUrl = ResolveUrl("~/CMSModules/Ecommerce/Pages/Tools/Products/Product_Edit_Options.aspx");
returnUrl = URLHelper.AddParameterToUrl(returnUrl, "nodeid", NodeID.ToString());
returnUrl = URLHelper.AddParameterToUrl(returnUrl, "documentid", DocumentID.ToString());
returnUrl = URLHelper.AddParameterToUrl(returnUrl, "productid", HTMLHelper.HTMLEncode(QueryHelper.GetString("productid", string.Empty)));
returnUrl = URLHelper.AddParameterToUrl(returnUrl, "dialog", QueryHelper.GetString("dialog", "0"));
}
else
{
returnUrl = "~/CMSModules/Ecommerce/Pages/Tools/ProductOptions/OptionCategory_List.aspx";
}
return(returnUrl);
}
/// <summary>
/// Returns parameters according to the upload mode.
/// </summary>
private string GetModeParameters()
{
string[] args = null;
if (MediaLibraryID > 0)
{
// MediaLibrary mode
args = new string[] {
"MediaLibraryID", MediaLibraryID.ToString(),
"MediaFolderPath", HttpUtility.UrlEncode(MediaFolderPath),
"MediaFileID", MediaFileID.ToString(),
"IsMediaThumbnail", IsMediaThumbnail.ToString(),
"MediaFileName", HttpUtility.UrlEncode(MediaFileName)
};
return("MediaLibraryArgs=" + GetArgumentsString(args));
}
else
{
if ((NodeID > 0) && (SourceType == MediaSourceEnum.Content))
{
// CMS.File mode
args = new string[] {
"NodeID", NodeID.ToString(),
"DocumentCulture", DocumentCulture,
"IncludeExtension", IncludeExtension.ToString(),
"NodeGroupID", NodeGroupID.ToString()
};
return("FileArgs=" + GetArgumentsString(args));
}
else
{
if (ObjectID > 0)
{
// MetaFile mode
args = new string[] {
"MetaFileID", MetaFileID.ToString(),
"ObjectID", ObjectID.ToString(),
"SiteID", SiteID.ToString(),
"ObjectType", ObjectType,
"Category", Category
};
return("MetaFileArgs=" + GetArgumentsString(args));
}
else
{
if (PostForumID > 0)
{
// Forum attachment
args = new string[] {
"PostForumID", PostForumID.ToString(),
"PostID", PostID.ToString()
};
return("ForumArgs=" + GetArgumentsString(args));
}
else
{
if ((DocumentID > 0) || (FormGUID != Guid.Empty))
{
// Attachment mode
args = new string[] {
"DocumentID", DocumentID.ToString(),
"DocumentParentNodeID", DocumentParentNodeID.ToString(),
"NodeClassName", NodeClassName,
"AttachmentGUIDColumnName", AttachmentGUIDColumnName,
"AttachmentGUID", AttachmentGUID.ToString(),
"AttachmentGroupGUID", AttachmentGroupGUID.ToString(),
"FormGUID", FormGUID.ToString(),
"IsFieldAttachment", mIsFiledAttachment.ToString()
};
return("AttachmentArgs=" + GetArgumentsString(args));
}
}
}
}
}
return(String.Empty);
}
