October 4, 2002 - IBuySpy's ProductsDB Component | WebReference

October 4, 2002 - IBuySpy's ProductsDB Component

Yehuda Shiran October 4, 2002
IBuySpy's ProductsDB Component
Tips: October 2002

Yehuda Shiran, Ph.D.
Doc JavaScript

The JScript .NET component ProductsDB.js handles the business logic of the IBuySpy Store products. In particular, it extracts products and categories from the database, according to different criteria and cross sections.

All IBuySpy components share the same IBuySpy namespace. The ProdjctsDB.js component includes two classes: ProductDetails and ProductsDB. The ProductDetails class includes only parameters:

  public class ProductDetails {
    public var ModelNumber : String;
    public var ModelName : String;
    public var ProductImage : String;
    public var UnitCost : decimal;
    public var Description : String;
  }
The ProductsDB class is the main class. It includes the following method declarations:

  public class ProductsDB { 
    public function GetProductCategories() : SqlDataReader {...}
    public function GetProducts(categoryID: int) : SqlDataReader {...}
    public function GetProductDetails(productID: int) : ProductDetails {...}
    public function GetProductDetails(productID: int) : ProductDetails {...}
    public function GetMostPopularProductsOfWeek() : SqlDataReader{...}
    public function SearchProductDescriptions(searchString : String) : SqlDataReader {...}
  }