CustomSKUInfoProvider

Top  Previous  Next

This provider manages the products (SKUs). It uses the SKUInfo class.

 

object GetSKUInfo(int sKUId) returns the SKUInfo object selected by given ID.
object GetSKUInfo(Guid sKUGuid) - returns the SKUInfo object selected by given GUID.
void SetSKUInfo(object sKU) updates/inserts the SKU record from given SKUInfo object. If SKUID is set, updates, else inserts a new record.
void DeleteSKUInfo(int sKUId) deletes specified SKU record.
bool CheckDependencies(int sKUId) returns true if some objects depend on given SKU.
DataSet GetSKUs() returns the DataSet of all products. See database reference for detailed column information
DataSet GetSKUs(string where, string orderBy) returns DataSet of products selected with condition and order.
DataSet GetSKUs(bool products, bool productOptions, string where, string orderBy) returns DataSet of products and/or product options selected with condition and order.
DataSet GetSKUList(string where, string orderBy) returns the DataSet of product list. Result contains the SKU data and public and internal status display name.
DataSet GetTopNProductsBySales(int topN, int siteId, string where) - returns the DataSet with top N products by sales for the specified site and according to the where condition.
void AddSKUToWishlist(int userId, int skuId, int siteId) adds specified SKU to user's wishlist.
void RemoveSKUFromWishlist(int userId, int skuId, int siteId) removes specified SKU from the wishlist of the given  user.
bool IsSKUInWishlist(int userId, int skuId, int siteId) - returns true if the given SKU is present in the user's wish list.
DataSet GetWishlist(int userId, int siteId) - returns the content of wish list for the given user as a DataSet.
DataSet GetOptionCategorySKUs(int categoryId, string where) returns the DataSet of all product options from the specified product option category filtered by specified where condition.
void MoveSKUOptionUp(int skuId) moves specified product option up within the parent product option category.
void MoveSKUOptionDown(int skuId)- moves specified product option down within the parent product option category.

 

Read also: Using the Product datalist web part