private void BindImageCategories()
        {
            if (ImageCategoryID != 0)
            {
                BPImageCategories bp = new BPImageCategories();
                BEImages dsImageCategories = bp.SelectByID(ImageCategoryID);
                BEImages.tbl_ImageCategoriesRow category = dsImageCategories.tbl_ImageCategories.FindByImageCategoryID(ImageCategoryID);

                if (category != null)
                {
                    IsGallery = category.PageID > 0;

                    txtImageCategoryName.Text = category.ImageCategoryName;
                    txtImageCategoryDescription.Text = (category.IsImageCategoryDescriptionNull()) ? "" : category.ImageCategoryDescription;
                    chkImageCategoryActive.Checked = category.ImageCategoryActive;

                    if (IsGallery)
                    {
                        lblTitle.Text = "Edit Image Gallery - " + category.ImageCategoryName;
                        lblFieldsetInfo.Text = "Gallery Information";

                        txtImageCategoryName.Enabled = false;
                        txtImageCategoryDescription.Enabled = false;
                        btnDelete.Visible = false;
                    }
                    else
                    {
                        lblTitle.Text = "Edit Image Category - " + category.ImageCategoryName;
                        lblFieldsetInfo.Text = "Category Information";
                    }
                }
            }
            else
            {
                btnDelete.Visible = false;
                lblTitle.Text = "Add Image Category";
                lblFieldsetInfo.Text = "Category Information";
            }
        }
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            BPImageCategories bp = new BPImageCategories();
            BEImages ds = bp.SelectByID(ImageCategoryID);
            BEImages.tbl_ImageCategoriesRow category = ds.tbl_ImageCategories.FindByImageCategoryID(ImageCategoryID);

            if (category != null)
            {
                category.Delete();
                bp.Update(ds);
                UpdateCategoryItems();
            }

            Response.Redirect("BrowseImageCategories.aspx");
        }
        private void SaveImageCategoryInfo()
        {
            bool isNew = false;
            BPImageCategories bp = new BPImageCategories();
            BEImages ds = new BEImages();
            BEImages.tbl_ImageCategoriesRow category = null;

            if (ImageCategoryID > 0)
            {
                ds = bp.SelectByID(ImageCategoryID);
                category = ds.tbl_ImageCategories.FindByImageCategoryID(ImageCategoryID);

                if (!IsGallery && (category.ImageCategoryActive && (!chkImageCategoryActive.Checked)))
                    UpdateCategoryItems(); //update images in standard categories only, not page gallery images
            }

            if (category == null)
            {
                category = ds.tbl_ImageCategories.Newtbl_ImageCategoriesRow();
                isNew = true;
            }

            category.ImageCategoryName = txtImageCategoryName.Text;

            if (txtImageCategoryDescription.Text.Trim() != "")
                category.ImageCategoryDescription = txtImageCategoryDescription.Text;
            else
                category.SetImageCategoryDescriptionNull();

            category.ImageCategoryActive = chkImageCategoryActive.Checked;
            category.DateModified = DateTime.Now;
            category.ModifiedByAdminID = PageUserID;

            if (isNew)
            {
                category.PageID = -1;
                category.ImageCategoryOrder = bp.GetImageCategoryMaxOrder();
                category.DateCreated = DateTime.Now;
                ds.tbl_ImageCategories.Addtbl_ImageCategoriesRow(category);
            }

            bp.Update(ds);
        }