protected void dgImages_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "Edit") { BEImages.tbl_ImagesRow image = dsInternal.tbl_Images.FindByImageID(Convert.ToInt32(e.CommandArgument)); if (image != null) { ImageID = image.ImageID; txtImageAlias.Text = image.ImageAlias; txtImageDescription.Text = (image.IsImageDescriptionNull()) ? "" : image.ImageDescription; txtFileName.Text = image.ImageName; chkImageActive.Checked = image.ImageActive; lblEditTitle.Text = "Edit Image"; SetSaveButtonText(); SetPanelsVisibility(false); } } else if (e.CommandName == "Delete") { BPImages bp = new BPImages(); BEImages ds = bp.SelectByID(Convert.ToInt32(e.CommandArgument)); BEImages.tbl_ImagesRow image = ds.tbl_Images.FindByImageID(Convert.ToInt32(e.CommandArgument)); if (image != null) { int imageCategoryID = image.ImageCategoryID; DeleteImageFiles(image); image.Delete(); bp.Update(ds); bp.ReOrderImages(imageCategoryID); GetImageInfo(); BindGrid(); ClearControls(); } } else if (e.CommandName == "Up" || e.CommandName == "Down") { dsInternal.tbl_Images.DefaultView.Sort = "ImageOrder"; int TotalCount = 0; foreach (DataRowView row in dsInternal.tbl_Images.DefaultView) { row["ImageOrder"] = TotalCount; TotalCount++; } int CurrentPosition = e.Item.DataSetIndex; int CurrentOrder = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[CurrentPosition]["ImageOrder"]); int CurrentID = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[CurrentPosition]["ImageID"]); if (e.CommandName == "Up") { //Swap Up int PrevOrder; int PrevID; if (CurrentPosition > 0) { PrevOrder = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[CurrentPosition - 1]["ImageOrder"]); PrevID = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[CurrentPosition - 1]["ImageID"]); dsInternal.tbl_Images.Select("ImageID = " + PrevID)[0]["ImageOrder"] = CurrentOrder; dsInternal.tbl_Images.Select("ImageID = " + CurrentID)[0]["ImageOrder"] = PrevOrder; } else { //PrevOrder = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[TotalCount - 1]["ImageOrder"]); //PrevID = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[TotalCount - 1]["ImageID"]); dsInternal.tbl_Images.Select("ImageID = " + CurrentID)[0]["ImageOrder"] = 999999; } } else if (e.CommandName == "Down") { //Swap Down int NextOrder; int NextID; if (CurrentPosition < TotalCount - 1) { NextOrder = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[CurrentPosition + 1]["ImageOrder"]); NextID = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[CurrentPosition + 1]["ImageID"]); dsInternal.tbl_Images.Select("ImageID = " + NextID)[0]["ImageOrder"] = CurrentOrder; dsInternal.tbl_Images.Select("ImageID = " + CurrentID)[0]["ImageOrder"] = NextOrder; } else { //NextOrder = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[0]["ImageOrder"]); //NextID = Convert.ToInt32(dsInternal.tbl_Images.DefaultView[0]["ImageID"]); dsInternal.tbl_Images.Select("ImageID = " + CurrentID)[0]["ImageOrder"] = -1; } } dsInternal.tbl_Images.DefaultView.Sort = "ImageOrder"; TotalCount = 0; foreach (DataRowView row in dsInternal.tbl_Images.DefaultView) { row["ImageOrder"] = TotalCount; TotalCount++; } BPImages bpImages = new BPImages(); bpImages.Update(dsInternal); GetImageInfo(); BindGrid(); } }
protected void btnDelete_Click(object sender, EventArgs e) { BPImages bp = new BPImages(); BEImages ds = bp.SelectByID(ImageID); BEImages.tbl_ImagesRow image = ds.tbl_Images.FindByImageID(ImageID); if (image != null) { int imageCategoryID = image.ImageCategoryID; DeleteImageFiles(image.ImageName, GetGalleryPageTypeID(imageCategoryID), true); image.Delete(); bp.Update(ds); if (imageCategoryID > 0) bp.ReOrderImages(imageCategoryID); } Response.Redirect("BrowseImages.aspx?CatID=" + FilterCatID); }