public static void CreateResizedImage(int ImageID, string fullPrefix, string thumbPrefix, int fullSize, int thumbSize, Page page) { string UploadName = ""; if (ImageID > 0) { BEImages DSImages; BPImages bpImages = new BPImages(); DSImages = bpImages.SelectByID(ImageID); BEImages.tbl_ImagesRow image = DSImages.tbl_Images[0]; if (DSImages.tbl_Images.Count > 0) UploadName = image.ImageName; } if (UploadName != null && UploadName != "") { string path = System.Configuration.ConfigurationManager.AppSettings["UploadsPath"]; ImageResizer imgRes = new ImageResizer(page); if (!imgRes.GenerateResizedImages(@path + UploadName, @path, thumbSize, fullSize, fullPrefix, thumbPrefix)) { //throw new Exception(imgRes.ResizeErrorMessage); } } }
public static void CreateResizedImage(int imageID, int maxSize, int maxWidth, int maxHeight, string prefix, Page page, bool widthPriority, bool heightPriority) { string imageFileName = ""; if (imageID > 0) { BPImages bpImages = new BPImages(); BEImages dsImages = bpImages.SelectByID(imageID); if (dsImages.tbl_Images.Count > 0) imageFileName = dsImages.tbl_Images[0].ImageName; } if (imageFileName != "") { string savePath = System.Configuration.ConfigurationManager.AppSettings["UploadsPath"]; string imageFilePath; bool resizedImageExists = true; //Handle prefix with or without underscore prefix = prefix.TrimEnd('_'); imageFilePath = @savePath + prefix + "_" + imageFileName; if (!File.Exists(page.Server.MapPath(imageFilePath))) { ImageResizer resizer = new ImageResizer(page); if (maxSize > 0) { resizedImageExists = resizer.GenerateResizedImages(@savePath + imageFileName, @savePath, 0, maxSize, prefix, ""); } else if (maxWidth > 0 && maxHeight > 0) { resizedImageExists = resizer.GenerateResizedImages(@savePath + imageFileName, @savePath, 0, maxWidth, maxHeight, prefix, "", widthPriority, heightPriority); } } if (!resizedImageExists) { //throw new Exception(imgRes.ResizeErrorMessage); } } }
protected void BindImages() { BPImages bpu = new BPImages(); DSImages = new BEImages(); if (FilterID != -1 && FilterID != 0) { DSImages.Merge(bpu.SelectActiveByImageCategoryID(FilterID)); } else { DSImages.Merge(bpu.SelectActiveNonGalleryWithImageCategories()); } int ImageCategoryID = -1; Boolean blnNew = true; StringBuilder returnImages = new StringBuilder(10000); returnImages.Append("none,No Image|"); foreach(DataRow dr in DSImages.tbl_Images.Rows) { if ((int) dr["ImageCategoryID"] != ImageCategoryID) { ImageCategoryID = (int) dr["ImageCategoryID"]; blnNew = true; } if (blnNew) { returnImages.Append(",-- " + dr["ImageCategoryName"] + " --|"); blnNew = false; } returnImages.Append(dr["ImageID"].ToString() + "," + HttpUtility.HtmlDecode(" ") + dr["ImageAlias"].ToString() + "|"); } lblScript.Text = "<script Language=\"Javascript\">window.parent.handleResponse('" + returnImages + "', 'Image')</script>"; }
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(); } }
public void DeleteAllImages() { BPImages bp = new BPImages(); foreach (BEImages.tbl_ImagesRow image in dsInternal.tbl_Images) { DeleteImageFiles(image); image.Delete(); } bp.Update(dsInternal); }
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 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)); }
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 BindImages() { BPImages bpu = new BPImages(); DSImages = new BEImages(); if (ddlImageCategories.SelectedValue != "-1") { DSImages.Merge(bpu.SelectActiveByImageCategoryID(Convert.ToInt32(ddlImageCategories.SelectedValue))); } else { DSImages.Merge(bpu.SelectActiveNonGalleryWithImageCategories()); } int ImageCategoryID = -1; Boolean blnNew = true; ddlImages.Items.Clear(); ddlImages.Items.Add(new ListItem("No Image", "0")); foreach(DataRow dr in DSImages.tbl_Images.Rows) { if ((int) dr["ImageCategoryID"] != ImageCategoryID) { ImageCategoryID = (int) dr["ImageCategoryID"]; blnNew = true; } if (blnNew) { ddlImages.Items.Add(new ListItem("-- " + dr["ImageCategoryName"] + " --", "")); blnNew = false; } ddlImages.Items.Add(new ListItem(HttpUtility.HtmlDecode(" ") + dr["ImageAlias"], dr["ImageID"].ToString())); } if (SelectedImage != 0) ddlImages.SelectedValue = SelectedImage.ToString(); }
public static string GetImageName(object strImageID, string prefix) { prefix = prefix.TrimEnd('_'); if (!Convert.IsDBNull(strImageID)) { BEImages DSImageName; int ImageID = Convert.ToInt32(strImageID); BPImages bpImages = new BPImages(); DSImageName = bpImages.SelectAll(); BEImages.tbl_ImagesRow row = DSImageName.tbl_Images.FindByImageID(ImageID); if (row != null) return System.Configuration.ConfigurationManager.AppSettings["UploadsPath"] + prefix + "_" + row.ImageName; else return ""; } else return ""; }
private void BindImages() { if (ImageID != 0) { BPImages bp = new BPImages(); BEImages dsImages = bp.SelectByID(ImageID); BEImages.tbl_ImagesRow image = dsImages.tbl_Images.FindByImageID(ImageID); txtImageAlias.Text = image.ImageAlias; txtImageDescription.Text = (image.IsImageDescriptionNull()) ? "" : image.ImageDescription; if (ddlImageCategories.Items.FindByValue(image.ImageCategoryID.ToString()) != null) ddlImageCategories.SelectedValue = image.ImageCategoryID.ToString(); txtFileName.Text = image.ImageName; chkImageActive.Checked = image.ImageActive; lblTitle.Text = "Edit Image - " + image.ImageAlias; } else { btnDelete.Visible = false; lblTitle.Text = "Upload Image"; if (ddlImageCategories.Items.FindByValue(FilterCatID) != null) ddlImageCategories.SelectedValue = FilterCatID; } }
private int GetGalleryPageTypeID(int imageCategoryID) { BPImages bpImages = new BPImages(); return bpImages.GetGalleryPageTypeIDByCategoryID(imageCategoryID); }
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 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; }
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(); }