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); }
protected void btnDelete_Click(object sender, EventArgs e) { BPArticleCategories bp = new BPArticleCategories(); BEArticles ds = bp.SelectByID(ArticleCategoryID); BEArticles.tbl_ArticleCategoriesRow category = ds.tbl_ArticleCategories.FindByArticleCategoryID(ArticleCategoryID); if (category != null) { UpdateCategoryItems(); category.Delete(); bp.Update(ds); } BrowseRedirect(); }
protected void btnMove_Click(object sender, EventArgs e) { bool found1 = false, found2 = false; int Position = Convert.ToInt32(ddlPosition.SelectedValue); int ItemToMove = Convert.ToInt32(ddlItemToMove.SelectedValue); BPArticleCategories bp = new BPArticleCategories(); BEArticles ds = bp.SelectByArticleTypeID(SubTypeID); BEArticles.tbl_ArticleCategoriesRow[] categoryRows = (BEArticles.tbl_ArticleCategoriesRow[])ds.tbl_ArticleCategories.Select("", ds.tbl_ArticleCategories.ArticleCategoryOrderColumn.ColumnName); BEArticles.tbl_ArticleCategoriesRow moveCategory = ds.tbl_ArticleCategories.FindByArticleCategoryID(ItemToMove); foreach (BEArticles.tbl_ArticleCategoriesRow category in categoryRows) { if (found1 && found2) break; if (category.ArticleCategoryID == moveCategory.ArticleCategoryID) { found1 = true; if (category.ArticleCategoryID == Position) found2 = true; } else if (category.ArticleCategoryID == Position) { found2 = true; if (rblBeforeAfter.SelectedValue == "0") { moveCategory.ArticleCategoryOrder = category.ArticleCategoryOrder; category.ArticleCategoryOrder++; } else { if (found1) category.ArticleCategoryOrder--; moveCategory.ArticleCategoryOrder = category.ArticleCategoryOrder + 1; } } else if (found1 && !found2) category.ArticleCategoryOrder--; else if (found2 && !found1) category.ArticleCategoryOrder++; } bp.Update(ds); dgArticleCategories.DataSource = GetData(); dgArticleCategories.DataBind(); }