private void BindImageCategories()
{
BPImageCategories bp = new BPImageCategories();
BEImages dsImageCategories = bp.SelectAllActive();
dsImageCategories.tbl_ImageCategories.DefaultView.Sort = "ImageCategoryName";
ddlImageCategories.DataSource = dsImageCategories.tbl_ImageCategories;
ddlImageCategories.DataTextField = "ImageCategoryName";
ddlImageCategories.DataValueField = "ImageCategoryID";
ddlImageCategories.DataBind();
ddlImageCategories.Items.Insert(0, new ListItem("Select a Gallery or Category", "-1"));
}
protected void BindImageCategories()
{
ddlImageCategories.Attributes.Add("onchange", "callToServer(this.form.name, this.name, 'Image', '" + ddlImages.ClientID + "', 'ImageLoader.aspx');");
BPImageCategories bp = new BPImageCategories();
DSImageCategories = bp.SelectAllActiveNonGallery();
DSImageCategories.tbl_ImageCategories.DefaultView.Sort = "ImageCategoryName";
ddlImageCategories.DataSource = DSImageCategories.tbl_ImageCategories.DefaultView;
ddlImageCategories.DataValueField = DSImageCategories.tbl_ImageCategories.ImageCategoryIDColumn.ColumnName;
ddlImageCategories.DataTextField = DSImageCategories.tbl_ImageCategories.ImageCategoryNameColumn.ColumnName;
ddlImageCategories.DataBind();
ddlImageCategories.Items.Insert(0, new ListItem("(All Image Categories)", "-1"));
}
protected DataView GetData()
{
BPImageCategories bp = new BPImageCategories();
if (ShowGalleries)
DSImages = bp.SelectAllGalleries();
else
DSImages = bp.SelectAllNonGallery();
string rowFilter = "";
rowFilter = RowFilter("ImageCategoryName", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "ImageCategoryActive", lstActive.SelectedValue);
DSImages.tbl_ImageCategories.DefaultView.RowFilter = rowFilter;
DSImages.tbl_ImageCategories.DefaultView.Sort = DSImages.tbl_ImageCategories.ImageCategoryNameColumn.ColumnName;
return DSImages.tbl_ImageCategories.DefaultView;
}
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 BindDropDownFilters()
{
BPImageCategories bp = new BPImageCategories();
BEImages dsImageCategories = new BEImages();
//galleries dropdown
dsImageCategories = bp.SelectAllGalleries();
dsImageCategories.tbl_ImageCategories.DefaultView.Sort = "ImageCategoryName";
ddlImageGalleries.DataSource = dsImageCategories.tbl_ImageCategories.DefaultView;
ddlImageGalleries.DataTextField = "ImageCategoryName";
ddlImageGalleries.DataValueField = "ImageCategoryID";
ddlImageGalleries.DataBind();
ddlImageGalleries.Items.Insert(0, new ListItem(" (All Galleries) ", "-1"));
ddlImageGalleries.Items.Insert(1, new ListItem("Not Assigned", "0"));
if (FilterCatID != "-1")
if (ddlImageGalleries.Items.FindByValue(FilterCatID) != null)
ddlImageGalleries.SelectedValue = FilterCatID;
//categories dropdown
dsImageCategories.Clear();
dsImageCategories = bp.SelectAllActiveNonGallery();
dsImageCategories.tbl_ImageCategories.DefaultView.Sort = "ImageCategoryName";
ddlImageCategories.DataSource = dsImageCategories.tbl_ImageCategories.DefaultView;
ddlImageCategories.DataTextField = "ImageCategoryName";
ddlImageCategories.DataValueField = "ImageCategoryID";
ddlImageCategories.DataBind();
ddlImageCategories.Items.Insert(0, new ListItem("(All Categories)", "-1"));
ddlImageCategories.Items.Insert(1, new ListItem("Not Assigned", "0"));
if (FilterCatID != "-1")
if (ddlImageCategories.Items.FindByValue(FilterCatID) != null)
ddlImageCategories.SelectedValue = FilterCatID;
}
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);
}
private void DeleteImageGallery(int pageID)
{
BPImageCategories bpImageCats = new BPImageCategories();
BEImages dsImageCats = bpImageCats.SelectByPageID(pageID);
if (dsImageCats.tbl_ImageCategories.Count > 0)
{
ucImageGallery.DeleteAllImages();
dsImageCats.tbl_ImageCategories[0].Delete();
bpImageCats.Update(dsImageCats);
}
}
private void AddUpdateImageCategory(string pageTitle)
{
bool isNew = false;
BPImageCategories bpImageCats = new BPImageCategories();
BEImages.tbl_ImageCategoriesRow imageCategory = null;
BEImages dsImageCats = bpImageCats.SelectByPageID(PageID);
if (dsImageCats.tbl_ImageCategories.Count > 0)
imageCategory = dsImageCats.tbl_ImageCategories[0];
else
{
imageCategory = dsImageCats.tbl_ImageCategories.Newtbl_ImageCategoriesRow();
isNew = true;
}
imageCategory.ImageCategoryName = pageTitle;
imageCategory.ImageCategoryDescription = "Image Gallery For: " + pageTitle;
imageCategory.DateModified = DateTime.Now;
imageCategory.ModifiedByAdminID = PageUserID;
if (isNew)
{
imageCategory.PageID = PageID;
imageCategory.ImageCategoryOrder = -1;
imageCategory.ImageCategoryActive = true;
imageCategory.DateCreated = DateTime.Now;
dsImageCats.tbl_ImageCategories.Addtbl_ImageCategoriesRow(imageCategory);
}
bpImageCats.Update(dsImageCats);
}
private void BindImageGalleryUserControl()
{
BPImageCategories bp = new BPImageCategories();
BEImages ds = bp.SelectByPageID(PageID);
BEImages.tbl_ImageCategoriesRow category;
if (ds.tbl_ImageCategories.Count > 0)
{
category = ds.tbl_ImageCategories[0];
ucImageGallery.ImageCategoryID = category.ImageCategoryID;
ucImageGallery.PageTypeID = PageTypeID;
ucImageGallery.Visible = true;
plcNewGalleryMessage.Visible = false;
plcInactiveGalleryMessage.Visible = !category.ImageCategoryActive;
}
else
{
ucImageGallery.Visible = false;
plcNewGalleryMessage.Visible = false;
}
}
