public void DeleteAllImages() { BPImages bp = new BPImages(); foreach (BEImages.tbl_ImagesRow image in dsInternal.tbl_Images) { DeleteImageFiles(image); image.Delete(); } bp.Update(dsInternal); }
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(); } }
private bool SaveImageInfo() { bool isNew = false; bool updateExisting = false; string strFileName = null; BPImages bp = new BPImages(); BEImages ds = new BEImages(); BEImages.tbl_ImagesRow image; if (ImageID > 0) { if (inpUpload.PostedFile.FileName == "") updateExisting = true; } else isNew = true; if (!updateExisting) strFileName = UploadFunctions.UploadFile(inpUpload.PostedFile, Server.MapPath(UploadsPath), UploadTypes.Image); if (strFileName != null || updateExisting) { if (isNew) image = ds.tbl_Images.Newtbl_ImagesRow(); else { ds = bp.SelectByID(ImageID); image = ds.tbl_Images.FindByImageID(ImageID); } if (!updateExisting) image.ImageName = strFileName; image.ImageAlias = txtImageAlias.Text; if (txtImageDescription.Text.Trim() != "") image.ImageDescription = txtImageDescription.Text; else image.SetImageDescriptionNull(); image.ImageActive = chkImageActive.Checked; image.DateModified = DateTime.Now; image.ModifiedByAdminID = ((PageBase)this.Page).PageUserID; if (isNew) { image.ImageCategoryID = ImageCategoryID; image.ImageOrder = bp.GetImagesMaxOrder(ImageCategoryID); image.DateCreated = DateTime.Now; ds.tbl_Images.Addtbl_ImagesRow(image); } bp.Update(ds); ResizeImage(image); return true; } else return false; }
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 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); }
private bool SaveImageInfo() { bool isNew = false; bool replacingUploadedFile = false; bool doSave = true; bool categoryChanged = false; string uploadedFileName = null; string originalFileName = ""; int galleryPageTypeID = -1; int originalGalleryPageTypeID = -1; BPImages bp = new BPImages(); BEImages ds = new BEImages(); BEImages.tbl_ImagesRow image; if (ImageID > 0) { if (inpUpload.PostedFile.FileName != "") replacingUploadedFile = true; } else isNew = true; if (isNew || replacingUploadedFile) { uploadedFileName = UploadFunctions.UploadFile(inpUpload.PostedFile, Server.MapPath(ConfigurationManager.AppSettings["UploadsPath"]), UploadTypes.Image); if (uploadedFileName == null) doSave = false; } if (doSave) { if (isNew) image = ds.tbl_Images.Newtbl_ImagesRow(); else { ds = bp.SelectByID(ImageID); image = ds.tbl_Images.FindByImageID(ImageID); } image.ImageAlias = txtImageAlias.Text; if (txtImageDescription.Text.Trim() != "") image.ImageDescription = txtImageDescription.Text; else image.SetImageDescriptionNull(); //for category/gallery re-assignment in edit mode if (!isNew && image.ImageCategoryID != Convert.ToInt32(ddlImageCategories.SelectedValue)) { if (replacingUploadedFile) { errorMessage = "Gallery/Category change is not permitted when replacing the uploaded file - Please save the new file into the original Gallery/Category."; if (ddlImageCategories.Items.FindByValue(image.ImageCategoryID.ToString()) != null) ddlImageCategories.SelectedValue = image.ImageCategoryID.ToString(); return false; } originalGalleryPageTypeID = GetGalleryPageTypeID(image.ImageCategoryID); image.ImageOrder = bp.GetImagesMaxOrder(Convert.ToInt32(ddlImageCategories.SelectedValue)); categoryChanged = true; } image.ImageCategoryID = Convert.ToInt32(ddlImageCategories.SelectedValue); image.ImageActive = chkImageActive.Checked; image.DateModified = DateTime.Now; image.ModifiedByAdminID = PageUserID; if (replacingUploadedFile) { originalFileName = image.ImageName; image.ImageName = uploadedFileName; } if (isNew) { image.ImageName = uploadedFileName; image.ImageOrder = bp.GetImagesMaxOrder(Convert.ToInt32(ddlImageCategories.SelectedValue)); image.DateCreated = DateTime.Now; ds.tbl_Images.Addtbl_ImagesRow(image); } bp.Update(ds); galleryPageTypeID = GetGalleryPageTypeID(image.ImageCategoryID); ManageFiles(image.ImageID, image.ImageName, isNew, replacingUploadedFile, categoryChanged, galleryPageTypeID, originalGalleryPageTypeID, originalFileName); return true; } else return false; }
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(); }