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