The busItem class controls the inventory in the Web Store application. It provides features for the online store in accessing items and showing list of items as well as providing limited stock updat functionality.

Inventory items by default are assumed to be non-physical which means stock updates do not occur. If the Physical flag is set on the DataRow member/table field the item increases and decreases inventory through the UpdateInventoryCount() method. Inventory can be checked through the CheckStock() method.

Note: The Web store implementation of inventory updates inventory only when an order is saved to keep inline with the Web metaphor where orders are virtual until saved. Only when an invoice is written to disk is the inventory updated.

The underlying table is wws_items

System.Object
  Westwind.BusinessObjects.wwBusiness
    Westwind.BusinessObjects.wwBusiness<wws_itemsRow>
      Westwind.WebStore.busItem

public class busItem : wwBusiness<wws_itemsRow>

Class Members

Member		Description
	Constructor
	AddUpsellitem	public bool AddUpsellitem( int ItemPk, wws_itemupsellRow UpsellItem );
	AutoFillAbstract	Automatically fills in the abstract from the long Description by retrieving the first paragraph of the long description. public void AutoFillAbstract( bool ForceOverwrite, int Length ); public bool AutoFillAbstract( bool UpdateAllRows, bool ForceOverwrite, int Length );
	CheckStock	Checks the stock level against the current loaded item public bool CheckStock( decimal Quantity );
	CopyItem	Copies the current Inventory item and returns a new item with a new SKU. Note: New Item is returned but has not been saved to disk yet! public busItem CopyItem( string NewSku );
	GetItemByDescription	This method retrieves an item by its exact description. public bool GetItemByDescription( string Description );
	GetItemBySku	Retrieves an item into the DataRow member by Sku rather than PK public bool GetItemBySku( string Sku );
	GetItemList	Retrieves a list of items suitable for display in lists. public int GetItemList( string Fields, string Filter, string Order, IDbDataParameter[] Parameters ); public int GetItemList( string Category, string FieldList ); public int GetItemList( string Category );
	GetItemListReader	Returns an Item List as a DataReader public IDataReader GetItemListReader( string Fields, string Filter, string Order ); public IDataReader GetItemListReader( string Category, string FieldList );
	GetManufacturers	Creates a Table named Manufacturers with all the unique manufacturers public int GetManufacturers();
	GetPkFromSku	Returns a pk from a sku value public int GetPkFromSku( string Sku );
	GetSearchItemList	Retrieves a list of items for display based on a search string in Descript and lDescript fields. public int GetSearchItemList( string SearchFor, string FieldList );
	GetSearchItemListReader	Retrieves a list of items for display based on a search string in Descript and lDescript fields. public IDataReader GetSearchItemListReader( string SearchFor, string FieldList );
	GetSkuFromPk	Returns a sku from a pk value public string GetSkuFromPk( int Pk );
	GetSpecials	Returns all the specials - items that have the Special flag set to non-zero. Order by the Specials flag in descending order. Return ItemList table. public int GetSpecials( string Fields );
	GetSubItems	Returns a list of child items for a given Sku. Tablename: TSubItems public int GetSubItems( string Sku, string Fields );
	GetTypedDataRow	public wws_itemsRow GetTypedDataRow( bool LoadColumns ); public wws_itemsRow GetTypedDataRow();
	GetUpsellItems	Returns a table of Upsell Items for a specific Item Tablename: TRelatedItems public int GetUpsellItems( int ItemPk, string Tablename ); public int GetUpsellItems( string Tablename );
	RemoveUpsellItem	Removes an Upsell Pk from the list of related items for a given item public bool RemoveUpsellItem( int ItemPk, int UpsellPk ); public bool RemoveUpsellItem( int UpsellPk );
	ResortSpecials	Rearranges Specials by ordering the specials order and offsetting the sort orders by 10 each. public void ResortSpecials();
	SubItemHtmlList	Create an HTML select list of all the child skus. public string SubItemHtmlList( string Sku );
	UpdateInventoryCount	Updates the Inventory count on the currently loaded item in memory. public bool UpdateInventoryCount( decimal Qty );
	Validate	Validates for empty and duplicate skus and empty descriptions public virtual bool Validate();

Requirements

Namespace: Westwind.WebStore
Assembly: westwind.webstore.business.dll