public BEArticles SelectByArticleTypeIDWithROColumns(int articleTypeID) { BEArticles ds = new BEArticles(); DAArticles da = new DAArticles(); da.SelectByArticleTypeIDWithROColumns(articleTypeID, ds.tbl_Articles); return ds; }
public BEArticles SelectActiveByArticleCategoryID(int articleCategoryID) { BEArticles ds = new BEArticles(); DAArticles da = new DAArticles(); da.SelectActiveByArticleCategoryID(articleCategoryID, ds.tbl_Articles); return ds; }
public BEArticles SelectAllInactive() { BEArticles ds = new BEArticles(); DAArticles da = new DAArticles(); da.SelectAllInactive(ds.tbl_Articles); return ds; }
public BEArticles SelectAll() { BEArticles ds = new BEArticles(); DAArticleCategories da = new DAArticleCategories(); da.SelectAll(ds.tbl_ArticleCategories); return ds; }
public BEArticles SelectArticleByID(int articleID) { BEArticles ds = new BEArticles(); DAArticles da = new DAArticles(); da.SelectByID(articleID.ToString(), ds.tbl_Articles); return ds; }
private void BindTitle() { BPArticleTypes bp = new BPArticleTypes(); DSArticleCategories = bp.SelectArticleTypeByID(SubTypeID); if (DSArticleCategories.tbl_ArticleTypes.Count > 0) { BEArticles.tbl_ArticleTypesRow typeRow = DSArticleCategories.tbl_ArticleTypes[0]; lblTitle.Text = "Browse " + typeRow.ArticleTypeName + " Categories"; btnAdd.Text = "Add New"; } }
protected DataView GetData() { BPArticleCategories bp = new BPArticleCategories(); DSArticleCategories = bp.SelectByArticleTypeID(SubTypeID); DSArticleCategories.tbl_ArticleCategories.DefaultView.Sort = DSArticleCategories.tbl_ArticleCategories.ArticleCategoryOrderColumn.ColumnName; BindMoveControl(DSArticleCategories.tbl_ArticleCategories.DefaultView); DSArticleCategories.tbl_ArticleCategories.DefaultView.RowFilter = RowFilter(DSArticleCategories.tbl_ArticleCategories.ArticleCategoryNameColumn.ColumnName, ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, DSArticleCategories.tbl_ArticleCategories.ArticleCategoryActiveColumn.ColumnName, lstActive.SelectedValue); return DSArticleCategories.tbl_ArticleCategories.DefaultView; }
private void SaveCategoryInfo() { bool isNew = false; BPArticleCategories bp = new BPArticleCategories(); BEArticles ds = new BEArticles(); BEArticles.tbl_ArticleCategoriesRow category = null; if (ArticleCategoryID > 0) { ds = bp.SelectByID(ArticleCategoryID); category = ds.tbl_ArticleCategories.FindByArticleCategoryID(ArticleCategoryID); if (category.ArticleCategoryActive && (!chkArticleCategoryActive.Checked)) UpdateCategoryItems(); } if (category == null) { category = ds.tbl_ArticleCategories.Newtbl_ArticleCategoriesRow(); isNew = true; } category.ArticleCategoryName = txtArticleCategoryName.Text.Trim(); if (txtArticleCategoryDescription.Text.Trim() != "") category.ArticleCategoryDescription = txtArticleCategoryDescription.Text.Trim(); else category.SetArticleCategoryDescriptionNull(); category.ArticleTypeID = SubTypeID; category.ArticleCategoryActive = chkArticleCategoryActive.Checked; category.DateModified = DateTime.Now; category.ModifiedByAdminID = PageUserID; if (isNew) { category.ArticleCategoryOrder = bp.GetArticleCategoryMaxOrder(SubTypeID); category.DateCreated = DateTime.Now; ds.tbl_ArticleCategories.Addtbl_ArticleCategoriesRow(category); } bp.Update(ds); }
public void Update(BEArticles ds) { DAArticles da = new DAArticles(); da.Update(ds.tbl_Articles); }
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); }