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; } }