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();
        }
        private void BindArticleCategories()
        {
            if (ArticleCategoryID != 0)
            {
                BPArticleCategories bp = new BPArticleCategories();
                BEArticles dsArticleCategories = bp.SelectByID(ArticleCategoryID);
                BEArticles.tbl_ArticleCategoriesRow category = null;
                    
                if (dsArticleCategories.tbl_ArticleCategories.Count > 0)
                {
                    category = dsArticleCategories.tbl_ArticleCategories[0];

                    txtArticleCategoryName.Text = category.ArticleCategoryName;
                    txtArticleCategoryDescription.Text = (category.IsArticleCategoryDescriptionNull()) ? "" : category.ArticleCategoryDescription;
                    chkArticleCategoryActive.Checked = category.ArticleCategoryActive;

                    lblTitle.Text = "Edit " + SubTypeName + " Category - " + category.ArticleCategoryName;

                }
            }
            else
            {
                btnDelete.Visible = false;
                lblTitle.Text = "Add " + SubTypeName + " Category";
            }
        }