Suggestions: Batch upload and delete pictures for admin

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
14 years ago
Hi, I have updated some codes to support batch upload and delete pics for administrators, hope it will be helpful.


on Admin/Modules/ProductPictures.ascx

<%@ Control Language="C#" AutoEventWireup="true" Inherits="NopSolutions.NopCommerce.Web.Administration.Modules.ProductPicturesControl"
    CodeBehind="ProductPictures.ascx.cs" %>
<%@ Register TagPrefix="nopCommerce" TagName="NumericTextBox" Src="NumericTextBox.ascx" %>
<%@ Register TagPrefix="nopCommerce" TagName="SimpleTextBox" Src="SimpleTextBox.ascx" %>
<%@ Register TagPrefix="nopCommerce" TagName="ToolTipLabel" Src="ToolTipLabelControl.ascx" %>
<asp:GridView ID="gvwImages" runat="server" AutoGenerateColumns="false" DataKeyNames="ProductPictureID"
    OnRowDeleting="gvwImages_RowDeleting" OnRowDataBound="gvwImages_RowDataBound"
    OnRowCommand="gvwImages_RowCommand" Width="100%">
    <Columns>
        <asp:TemplateField HeaderText="Image" ItemStyle-Width="50%">
            <ItemTemplate>
                <asp:Image ID="iProductPicture" runat="server" />
                <asp:HiddenField ID="hfProductPictureID" runat="server" Value='<%# Eval("ProductPictureID") %>' />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Display order" HeaderStyle-HorizontalAlign="Center"
            ItemStyle-Width="15%" ItemStyle-HorizontalAlign="Center">
            <ItemTemplate>
                <nopCommerce:NumericTextBox runat="server" CssClass="adminInput" Width="50px" ID="txtProductPictureDisplayOrder"
                    Value='<%# Eval("DisplayOrder") %>' RequiredErrorMessage="Display order is required"
                    RangeErrorMessage="The value must be from -99999 to 99999" ValidationGroup="ProductPictures"
                    MinimumValue="-99999" MaximumValue="99999"></nopCommerce:NumericTextBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Update" HeaderStyle-HorizontalAlign="Center" ItemStyle-Width="15%"
            ItemStyle-HorizontalAlign="Center">
            <ItemTemplate>
                <asp:Button ID="btnUpdate" runat="server" CssClass="adminButton" Text="Update" ValidationGroup="ProductPictures"
                    CommandName="UpdateProductPicture" ToolTip="Update this picture" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Delete" HeaderStyle-HorizontalAlign="Center" ItemStyle-Width="15%"
            ItemStyle-HorizontalAlign="Center">
            <ItemTemplate>
                <asp:Button ID="btnDeletePicture" runat="server" CssClass="adminButton" Text="Delete"
                    CausesValidation="false" CommandName="Delete" ToolTip="Delete this picture" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>
<p>
    <strong>Add a new picture </strong>
</p>
<table class="adminContent">
    <asp:Repeater runat="server" ID="UploadRepeater">
        <ItemTemplate>
            <tr>
                <td class="adminTitle">
                    <nopCommerce:ToolTipLabel runat="server" ID="lblSelectPicture" Text="Select picture:"
                        ToolTip="Choose a picture to upload. If the picture size exceeds your stores max image size setting, it will be automatically resized. You can manage resizing from Configuration : Global Settings"
                        ToolTipImage="~/Administration/Common/ico-help.gif" />
                </td>
                <td class="adminData">
                    <asp:FileUpload class="text" ID="fuProductPicture" CssClass="adminInput" runat="server"
                        ToolTip="Choose a file to upload" />
                </td>
            </tr>
            <tr>
                <td class="adminTitle">
                    <nopCommerce:ToolTipLabel runat="server" ID="lblProductDisplayOrder" Text="Display order:"
                        ToolTip="Display order of the picture. 1 represents the top of the list." ToolTipImage="~/Administration/Common/ico-help.gif" />
                </td>
                <td class="adminData">
                    <nopCommerce:NumericTextBox runat="server" CssClass="adminInput" ID="txtProductPictureDisplayOrder"
                        Value="1" RequiredErrorMessage="Display order is required" RangeErrorMessage="The value must be from -99999 to 99999"
                        MinimumValue="-99999" MaximumValue="99999" ValidationGroup="UploadNewProductPicture">
                    </nopCommerce:NumericTextBox>
                </td>
            </tr>
        </ItemTemplate>
    </asp:Repeater>

    <tr>
        <td align="left">
            <asp:Button runat="server" ID="btnUploadProductPicture" CssClass="adminButton" Text="Upload"
                ValidationGroup="UploadNewProductPicture" OnClick="btnUploadProductPicture_Click"
                ToolTip="Upload the picture" />
        </td>
       <td>
            <asp:Button runat="server" CssClass="adminButton" Text="Delete All"
                ValidationGroup="UploadNewProductPicture" OnClick="DeleteAll_Click" OnClientClick="return confirm('Are you sure you want to delete all pictures');"
                ToolTip="Delete all pictures" />
        </td>

    </tr>
</table>


On codebehind file
//------------------------------------------------------------------------------
// The contents of this file are subject to the nopCommerce Public License Version 1.0 ("License"); you may not use this file except in compliance with the License.
// You may obtain a copy of the License at  https://www.nopcommerce.com/License.aspx.
//
// Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied.
// See the License for the specific language governing rights and limitations under the License.
//
// The Original Code is nopCommerce.
// The Initial Developer of the Original Code is NopSolutions.
// All Rights Reserved.
//
// Contributor(s): _______.
//------------------------------------------------------------------------------

using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using NopSolutions.NopCommerce.Common.Categories;
using NopSolutions.NopCommerce.Common.Manufacturers;
using NopSolutions.NopCommerce.Common.Media;
using NopSolutions.NopCommerce.Common.Products;
using NopSolutions.NopCommerce.Common.Products.Specs;
using NopSolutions.NopCommerce.Common.Templates;
using NopSolutions.NopCommerce.Common.Utils;
using NopSolutions.NopCommerce.Web.Administration.Modules;

namespace NopSolutions.NopCommerce.Web.Administration.Modules
{
    public partial class ProductPicturesControl : BaseNopAdministrationUserControl
    {
        private void BindData()
        {
            Product product = ProductManager.GetProductByID(this.ProductID);
            if (product != null)
            {
                ProductPictureCollection productPictures = product.ProductPictures;
                if (productPictures.Count > 0)
                {
                    gvwImages.Visible = true;
                    gvwImages.DataSource = productPictures;
                    gvwImages.DataBind();
                }
                else
                    gvwImages.Visible = false;
            }
        }

        protected void DeleteAll_Click(object sender, EventArgs e)
        {
            Product product = ProductManager.GetProductByID(this.ProductID);
            if (product != null)
            {
                if (product.ProductPictures.Count > 0)
                {
                    foreach (ProductPicture productPicture in product.ProductPictures)
                    {
                        if (productPicture != null)
                        {
                            PictureManager.DeletePicture(productPicture.PictureID);
                            ProductManager.DeleteProductPicture(productPicture.ProductPictureID);
                        }
                    }
                    BindData();
                }
            }
        }


        private void BindUploadRepeater()
        {
            UploadRepeater.DataSource = new object[9];
            UploadRepeater.DataBind();
        }


        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                this.BindData();
                this.BindUploadRepeater();
            }
        }

        public void SaveInfo()
        {
        }

       protected void btnUploadProductPicture_Click(object sender, EventArgs e)
        {
            try
            {
                Product product = ProductManager.GetProductByID(this.ProductID);
                if (product != null)
                {
                    foreach (RepeaterItem item in UploadRepeater.Items)
                    {
                        Picture picture = null;
                        FileUpload fuProductPicture = item.FindControl("fuProductPicture") as FileUpload;
                        NumericTextBox txtProductPictureDisplayOrder = item.FindControl("txtProductPictureDisplayOrder") as NumericTextBox;
                        if (fuProductPicture != null && txtProductPictureDisplayOrder != null)
                        {
                            HttpPostedFile productPictureFile = fuProductPicture.PostedFile;
                            if ((productPictureFile != null) && (!String.IsNullOrEmpty(productPictureFile.FileName)))
                            {
                                byte[] productPictureBinary = PictureManager.GetPictureBits(productPictureFile.InputStream, productPictureFile.ContentLength);
                                picture = PictureManager.InsertPicture(productPictureBinary, productPictureFile.ContentType, true);
                            }
                            if (picture != null)
                            {
                                ProductPicture productPicture = ProductManager.InsertProductPicture(product.ProductID, picture.PictureID, txtProductPictureDisplayOrder.Value);
                            }
                        }

                    }
                    BindData();
                }
            }
            catch (Exception exc)
            {
                ProcessException(exc);
            }
        }

        protected void gvwImages_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "UpdateProductPicture")
            {
                int index = Convert.ToInt32(e.CommandArgument);
                GridViewRow row = gvwImages.Rows[index];
                NumericTextBox txtProductPictureDisplayOrder = row.FindControl("txtProductPictureDisplayOrder") as NumericTextBox;
                HiddenField hfProductPictureID = row.FindControl("hfProductPictureID") as HiddenField;

                int displayOrder = txtProductPictureDisplayOrder.Value;
                int productPictureID = int.Parse(hfProductPictureID.Value);
                ProductPicture productPicture = ProductManager.GetProductPictureByID(productPictureID);

                if (productPicture != null)
                    ProductManager.UpdateProductPicture(productPicture.ProductPictureID,
                       productPicture.ProductID, productPicture.PictureID, displayOrder);

                BindData();
            }
        }

        protected void gvwImages_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                ProductPicture productPicture = (ProductPicture)e.Row.DataItem;
                Image iProductPicture = e.Row.FindControl("iProductPicture") as Image;
                if (iProductPicture != null)
                    iProductPicture.ImageUrl = PictureManager.GetPictureUrl(productPicture.PictureID);

                Button btnUpdate = e.Row.FindControl("btnUpdate") as Button;
                if (btnUpdate != null)
                    btnUpdate.CommandArgument = e.Row.RowIndex.ToString();
            }
        }

        protected void gvwImages_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int productPictureID = (int)gvwImages.DataKeys[e.RowIndex]["ProductPictureID"];
            ProductPicture productPicture = ProductManager.GetProductPictureByID(productPictureID);
            if (productPicture != null)
            {
                PictureManager.DeletePicture(productPicture.PictureID);
                ProductManager.DeleteProductPicture(productPicture.ProductPictureID);
                BindData();
            }
        }

        public int ProductID
        {
            get
            {
                return CommonHelper.QueryStringInt("ProductID");
            }
        }
    }
}
14 years ago
Thanks! ;)
13 years ago
Does this work in 1.8? or am I missing something.  I just want to delete the pictures from the sample catalog -- can I just delete the select rows from the pictures table in the database and the files written to the hard drive?
13 years ago
renzoz wrote:
Does this work in 1.8?


no, it would have been 1.3 or earlier
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.