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