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