Changes to the Database to Support Discount Specials
The most logical place to start, when explaining how this functionality was implemented, is with the changes to the database. At a very high level, some additional data needs to be stored, and some means of accessing this new data needs to be developed. For MyGolfGear.NET, this meant the addition of the ProductSpecial and PromoType tables. It also meant updating the spGetCompleteCatalog stored procedure, which is used in conjunction with the CatalogDS class.
The ProductSpecial and PromoType Tables
To support the notion of discounted items, we needed a new place to store this information. We therefore added the ProductSpecial and PromoType tables to the MyGolfGear database for this purpose. ...
Get Building e-Commerce Sites with the .NET Framework now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
