I'm looking to customize the store module to display data pertaining to books and act more as a data repository. I've been able to change the source files to create the extra columns in the database, show the new options on the Add Product form, and other various files throughout the module. I've updated the following files in the soure code to reflect my changes: ProductEdit.ascx, ProductEdit.ascx.cs, ProductEdit.ascx.resx, ProductEdit.ascx.designer.cs, SqlDataProvider.cs, and 02.00.06.SqlDataProvider.
I have no problems when I bring up the Add Product form, it shows my changes. When I press Update, I receive the following error:
Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Store.Catalog.SqlDataProvider.AddProduct(Int32 PortalID, Int32 CategoryID, String Manufacturer, String ModelNumber, String ModelName, String ProductImage, Decimal UnitCost, String Summary, String Description, Boolean Featured, Boolean Archived, String CreatedByUser, DateTime CreatedDate, Decimal ProductWeight, Decimal ProductHeight, Decimal ProductLength, Decimal ProductWidth, DateTime SaleStartDate, DateTime SaleEndDate, Decimal SalePrice) at DotNetNuke.Modules.Store.Catalog.ProductController.AddProduct(ProductInfo productInfo) at DotNetNuke.Modules.Store.WebControls.ProductEdit.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
I've been over the DotNetNuke.Modules.Store.Catalog.SqlDataProvider.AddProduct procedure several times, here's how it reads in the source code:
public
{
}
I'm at a loss as to where DNN is pulling the error code from, because I've changed the AddProduct procedure.
Any help is greatly appreciated. I'm at a complete loss and I've been pulling out my hair for 2 days now.
Thanks,
Greg
override int AddProduct(int PortalID, int CategoryID, string Manufacturer, string ModelNumber, string ModelName, string ProductImage, decimal UnitCost, string Summary, string Description, bool Featured, bool Archived, string CreatedByUser, DateTime CreatedDate, string Title, DateTime CoverDate, string Notes, string AmazonLink, string TOWLink, string OverstockLink, string BuyLink, int PageCount, string Publisher, string Solicit, int Related1, int Related2, int Related3, int Related4, DateTime ReleaseDate, int ATCRating, bool MassMarket, bool InPrint, string ATCReview, string ISBN10, string ISBN13, string FrontCover, string BackCover, string IssuesReprinted, string Format, decimal ProductWeight, decimal ProductHeight, decimal ProductLength, decimal ProductWidth, DateTime SaleStartDate, DateTime SaleEndDate, decimal SalePrice)return Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "Store_Products_AddProduct", PortalID, CategoryID, Manufacturer, ModelNumber, ModelName, ProductImage, UnitCost, Summary, Description, Featured, Archived, CreatedByUser, CreatedDate, Title, CoverDate, Notes, AmazonLink, TOWLink, OverstockLink, BuyLink, PageCount, Publisher, Solicit, Related1, Related2, Related3, Related4, ReleaseDate, ATCRating, MassMarket, InPrint, ATCReview, ISBN10, ISBN13, FrontCover, BackCover, IssuesReprinted, Format, ProductWeight, ProductHeight, ProductLength, ProductWidth, SaleStartDate, SaleEndDate, SalePrice));