protected void BindImages()
{
BPImages bpu = new BPImages();
DSImages = new BEImages();
if (ddlImageCategories.SelectedValue != "-1")
{
DSImages.Merge(bpu.SelectAllByImageCategoryID(Convert.ToInt32(ddlImageCategories.SelectedValue)));
}
else
{
DSImages.Merge(bpu.SelectAllWithImageCategories());
}
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"].ToString(), dr["ImageID"].ToString()));
}
if (SelectedImage != 0)
{
ddlImages.SelectedValue = SelectedImage.ToString();
}
}
protected void BindImages()
{
BPImages bpu = new BPImages();
DSImages = new BEImages();
if (FilterID != -1 && FilterID != 0)
{
DSImages.Merge(bpu.SelectAllByImageCategoryID(FilterID));
}
else
{
DSImages.Merge(bpu.SelectAllWithImageCategories());
}
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 string GetImageName(object strImageID, string prefix)
{
if (!Convert.IsDBNull(strImageID))
{
int ImageID = Convert.ToInt32(strImageID);
BPImages bpImages = new BPImages();
DSImages = bpImages.SelectAll();
BEImages.tbl_ImagesRow row = DSImages.tbl_Images.FindByImageID(ImageID);
if (row != null)
{
return "Uploads/" + prefix + row.ImageName;
}
else
{
return "";
}
}
else
{
return "";
}
}
private void Page_Load(object sender, EventArgs e)
{
this.AuthenticatePage(new string[] {PermissionLevels.EditImages, PermissionLevels.AddImages, PermissionLevels.ViewImages});
if (ImageID > 0)
{
if (this.CarrielUser.RolePermission(PermissionLevels.EditImages) != 2)
{
btnSubmit.Visible = false;
btnDelete.Visible = false;
}
else
{
btnSubmit.Visible = true;
btnDelete.Visible = true;
}
}
else
{
if (this.CarrielUser.RolePermission(PermissionLevels.AddImages) != 2)
{
btnSubmit.Visible = false;
}
}
if (IsNewSession)
{
AddToListIfAdmin();
IsNewSession = false;
}
if (!Page.IsPostBack)
{
BindImageCategories();
BPImages bp = new BPImages();
if (ImageID != 0)
{
DSImages = bp.SelectByID(ImageID);
Image = DSImages.tbl_Images.FindByImageID(ImageID);
//ddlExtranetClients.SelectedValue = Image.ClientID.ToString();
lblImageName.Text = Image.ImageName.ToString();
txtAlias.Text = Image.ImageAlias;
chkSingle.Checked = Image.ImageActive;
txtDesc.Text = (Image.IsImageDescriptionNull())? string.Empty : Image.ImageDescription;
if (ddlImageCategory.Items.FindByValue(Image.ImageCategoryID.ToString()) != null)
{
ddlImageCategory.SelectedValue = Image.ImageCategoryID.ToString();
}
lblTitle.Text = "Edit Image - " + Image.ImageAlias;
}
else
{
btnDelete.Visible = false;
lblTitle.Text = "Upload Image";
}
}
}
// private void ddlCategories_SelectedIndexChanged(object sender, System.EventArgs e)
// {
// BindSubCategories();
// }
private void btnDelete_Click(object sender, EventArgs e)
{
BPImages bp = new BPImages();
BEImages.tbl_ImagesRow Image;
DSImages = bp.SelectByID(ImageID);
Image = DSImages.tbl_Images.FindByImageID(ImageID);
// File.Delete(Server.MapPath(@"\Uploads\" + Image.ImageName));
File.Delete(Server.MapPath(@System.Configuration.ConfigurationSettings.AppSettings["UploadsPath"] + Image.ImageName));
Image.Delete();
bp.Update(DSImages);
//remove all instances of this image in Products
BPProducts bpProducts = new BPProducts();
bpProducts.RemoveImagesByImageID(ImageID);
Response.Redirect("BrowseImages.aspx");
}
private bool UploadFile()
{
//string tmpFileLocation = DoUploadByFileExtension(inpUpload, @"\Uploads\");
string tmpFileLocation = DoUploadByFileExtension(inpUpload, @System.Configuration.ConfigurationSettings.AppSettings["UploadsPath"]);
if(tmpFileLocation != null)
{
string fileName = tmpFileLocation.Substring(tmpFileLocation.LastIndexOf(@"\")+1);
BPImages bp = new BPImages();
BEImages ds = bp.SelectAll();
BEImages.tbl_ImagesRow ImageRow;
if(ImageID <= 0)
{
ImageRow = ds.tbl_Images.Newtbl_ImagesRow();
}
else
{
ImageRow = ds.tbl_Images.FindByImageID(ImageID);
}
//ImageRow.SubCategoryID = Convert.ToInt32(ddlSubCategories.SelectedValue);
ImageRow.ImageAlias = txtAlias.Text;
ImageRow.ImageName = Server.UrlDecode(fileName);
ImageRow.ImageActive = chkSingle.Checked;
ImageRow.ImageDescription = txtDesc.Text;
//ImageRow.ClientID = Convert.ToInt32(ddlExtranetClients.SelectedValue);
ImageRow.ImageCategoryID = Convert.ToInt32(ddlImageCategory.SelectedValue);
ImageRow.DateModified = DateTime.Now;
ImageRow.ModifiedByAdminID = 1;
if(ImageID <= 0)
{
ImageRow.DateCreated = DateTime.Now;
ds.tbl_Images.Addtbl_ImagesRow(ImageRow);
}
bp.Update(ds);
return true;
}
else
{
pnlError.Visible = true;
return false;
}
}
private bool UpdateRecordWithExistingFile()
{
try
{
BPImages bp = new BPImages();
BEImages ds = bp.SelectByID(ImageID);
BEImages.tbl_ImagesRow ImageRow = ds.tbl_Images.FindByImageID(ImageID);
//ImageRow.SubCategoryID = Convert.ToInt32(ddlSubCategories.SelectedValue);
ImageRow.ImageAlias = txtAlias.Text;
ImageRow.ImageActive = chkSingle.Checked;
ImageRow.ImageDescription = txtDesc.Text;
//ImageRow.ClientID = Convert.ToInt32(ddlExtranetClients.SelectedValue);
ImageRow.ImageCategoryID = Convert.ToInt32(ddlImageCategory.SelectedValue);
bp.Update(ds);
return true;
}
catch (Exception)
{
pnlError.Visible = true;
lblError.Text = "Some of the data you have entered maybe invalid, please check all fields and try again.";
return false;
}
}
