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