private void GetImageInfo() { BPImages bpImages = new BPImages(); BPResizeInfo bpResize = new BPResizeInfo(); dsInternal.Clear(); if (ImageCategoryID > 0) dsInternal = bpImages.SelectByImageCategoryID(ImageCategoryID); if(PageTypeID > 0) dsInternal.Merge(bpResize.SelectResizeInfoForGalleryByPageTypeID(PageTypeID)); }
protected DataView GetData() { BPImages bp = new BPImages(); if(FilterCatID == "-1") DSImages = bp.SelectWithImageCategories(); else { DSImages = bp.SelectByImageCategoryID(Convert.ToInt32(FilterCatID)); DSImages.tbl_Images.DefaultView.Sort = "ImageOrder"; } BindMoveControl(DSImages.tbl_Images.DefaultView); DSImages.tbl_Images.DefaultView.RowFilter = RowFilter("ImageAlias", ((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName, "ImageActive", lstActive.SelectedValue); return DSImages.tbl_Images.DefaultView; }
private void UpdateCategoryItems() { //if category is being deleted or deactivated, unassign and deactivate all items belonging to the category BPImages bpImages = new BPImages(); BEImages dsImages = bpImages.SelectByImageCategoryID(ImageCategoryID); foreach (BEImages.tbl_ImagesRow row in dsImages.tbl_Images) { row.ImageCategoryID = 0; row.ImageActive = false; } bpImages.Update(dsImages); }
protected void btnMove_Click(object sender, EventArgs e) { bool found1 = false, found2 = false; int Position = Convert.ToInt32(ddlPosition.SelectedValue); int ItemToMove = Convert.ToInt32(ddlItemToMove.SelectedValue); BPImages bp = new BPImages(); BEImages ds = bp.SelectByImageCategoryID(Convert.ToInt32(FilterCatID)); BEImages.tbl_ImagesRow[] imagerows = (BEImages.tbl_ImagesRow[])ds.tbl_Images.Select("", "ImageOrder"); BEImages.tbl_ImagesRow moveimage = ds.tbl_Images.FindByImageID(ItemToMove); foreach (BEImages.tbl_ImagesRow image in imagerows) { if (found1 && found2) break; if (image.ImageID == moveimage.ImageID) { found1 = true; if (image.ImageID == Position) found2 = true; } else if (image.ImageID == Position) { found2 = true; if (rblBeforeAfter.SelectedValue == "0") { moveimage.ImageOrder = image.ImageOrder; image.ImageOrder++; } else { if (found1) image.ImageOrder--; moveimage.ImageOrder = image.ImageOrder + 1; } } else if (found1 && !found2) image.ImageOrder--; else if (found2 && !found1) image.ImageOrder++; } bp.Update(ds); dgImages.DataSource = GetData(); dgImages.DataBind(); }