protected void btnDelete_Click(object sender, EventArgs e) { BPArticles bpArticles = new BPArticles(); BEArticles dsArticles = bpArticles.SelectArticleByID(ArticleID); BPPages bpPages = new BPPages(); BEPages dsPages = bpPages.SelectByPageTypeIDAndPageTypeSpecificID(PageTypeID, ArticleID); if (dsArticles.tbl_Articles.Count > 0) { dsArticles.tbl_Articles[0].Delete(); bpArticles.Update(dsArticles); if (dsPages.tbl_Pages.Count > 0) { dsPages.tbl_Pages[0].Delete(); bpPages.Update(dsPages); } } BrowseRedirect(); }
private void UpdateCategoryItems() { //if category is being deleted or deactivated, unassign and deactivate all items belonging to the category BPArticles bpArticles = new BPArticles(); BEArticles dsArticles = bpArticles.SelectByArticleCategoryID(ArticleCategoryID); foreach (BEArticles.tbl_ArticlesRow row in dsArticles.tbl_Articles) { row.ArticleCategoryID = 0; row.ArticleActive = false; } bpArticles.Update(dsArticles); }
private void SaveArticleInfo() { bool isNew = false; BPArticles bp = new BPArticles(); BEArticles dsArticles = new BEArticles(); BEArticles.tbl_ArticlesRow article = null; int tempImageID1 = 0; int tempImageID2 = 0; if (ArticleID > 0) { dsArticles = bp.SelectArticleByID(ArticleID); article = dsArticles.tbl_Articles.FindByArticleID(ArticleID); if (!article.IsArticleImageID1Null()) tempImageID1 = article.ArticleImageID1; if (!article.IsArticleImageID2Null()) tempImageID2 = article.ArticleImageID2; } if (article == null) { article = dsArticles.tbl_Articles.Newtbl_ArticlesRow(); isNew = true; } //page article.ArticleTitle = txtArticleTitle.Text.Trim(); article.ArticleCategoryID = Convert.ToInt32(ddlCategories.SelectedValue); if (dtArticleDate.Date != dtArticleDate.MinDate) article.ArticleDate = dtArticleDate.Date; else article.SetArticleDateNull(); if (edtBody1.Text.Trim() == "" || edtBody1.Text.Trim() == "<p> </p>") article.SetArticleBody1Null(); else article.ArticleBody1 = edtBody1.Text.Trim(); if (edtBody2.Text.Trim() == "" || edtBody2.Text.Trim() == "<p> </p>") article.SetArticleBody2Null(); else article.ArticleBody2 = edtBody2.Text.Trim(); //image 1 if (imgArticleImageID1.SelectedImage > 0) { article.ArticleImageID1 = imgArticleImageID1.SelectedImage; if (ddlArticleImageAlignment1.SelectedValue == "Left" || ddlArticleImageAlignment1.SelectedValue == "Right" || ddlArticleImageAlignment1.SelectedValue == "Top" || ddlArticleImageAlignment1.SelectedValue == "Bottom") article.ArticleImageAlignment1 = Convert.ToInt32(Enum.Parse(typeof(ImageAlignment), ddlArticleImageAlignment1.SelectedValue)); else article.SetArticleImageAlignment1Null(); } else { article.SetArticleImageID1Null(); article.SetArticleImageAlignment1Null(); } //image 2 if (imgArticleImageID2.SelectedImage > 0) { article.ArticleImageID2 = imgArticleImageID2.SelectedImage; if (ddlArticleImageAlignment2.SelectedValue == "Left" || ddlArticleImageAlignment2.SelectedValue == "Right" || ddlArticleImageAlignment2.SelectedValue == "Top" || ddlArticleImageAlignment2.SelectedValue == "Bottom") article.ArticleImageAlignment2 = Convert.ToInt32(Enum.Parse(typeof(ImageAlignment), ddlArticleImageAlignment2.SelectedValue)); else article.SetArticleImageAlignment2Null(); } else { article.SetArticleImageID2Null(); article.SetArticleImageAlignment2Null(); } //external article if (rblExternalArticle.SelectedValue == "True") { article.ExternalArticle = true; if (txtExternalURL.Text.Trim() != "") { if (txtExternalURL.Text.Trim().Length < 8) article.ExternalURL = "http://" + txtExternalURL.Text.Trim(); else if (txtExternalURL.Text.Trim().Substring(0, 7) != "http://" && txtExternalURL.Text.Trim().Substring(0, 8) != "https://") article.ExternalURL = "http://" + txtExternalURL.Text.Trim(); else article.ExternalURL = txtExternalURL.Text.Trim(); } else article.SetExternalURLNull(); } else { article.ExternalArticle = false; article.SetExternalURLNull(); } if (noBrowsePage) article.ArticleActive = true; else article.ArticleActive = chkArticleActive.Checked; article.DateModified = DateTime.Now; article.ModifiedByAdminID = PageUserID; if (isNew) { article.ArticleTypeID = SubTypeID; article.DateCreated = DateTime.Now; dsArticles.tbl_Articles.Addtbl_ArticlesRow(article); } bp.Update(dsArticles); ArticleID = article.ArticleID; if (isNew) { //Add to main Pages table BPPages bpPages = new BPPages(); BEPages dsPages = new BEPages(); BEPages.tbl_PagesRow pageRow = dsPages.tbl_Pages.Newtbl_PagesRow(); pageRow.PageTypeID = PageTypeID; pageRow.PageTypeSpecificID = ArticleID; pageRow.SubTypeID = SubTypeID; dsPages.tbl_Pages.Addtbl_PagesRow(pageRow); bpPages.Update(dsPages); } //Resize images int[] selectedImageIDs = new int[2]; bool doResize = false; if (!article.IsArticleImageID1Null() && (article.ArticleImageID1 != tempImageID1)) { selectedImageIDs[0] = imgArticleImageID1.SelectedImage; doResize = true; } if (!article.IsArticleImageID2Null() && (article.ArticleImageID2 != tempImageID2)) { selectedImageIDs[1] = imgArticleImageID2.SelectedImage; doResize = true; } if (doResize) ResizePageImages(selectedImageIDs); }