public ProductCollection FetchByQuery(Query qry)
{
ProductCollection coll = new ProductCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// Searches the products.
/// </summary>
/// <param name="searchTerm">The search term.</param>
/// <returns></returns>
public ProductCollection SearchProducts(string searchTerm)
{
IDataReader reader = SPs.ProductSearch(searchTerm).GetReader();
ProductCollection productCollection = new ProductCollection();
productCollection.LoadAndCloseReader(reader);
return(productCollection);
}
/// <summary>
/// Fetches all products by category id.
/// </summary>
/// <param name="categoryId">The category id.</param>
/// <returns></returns>
public ProductCollection FetchAllProductsByCategoryId(int categoryId)
{
IDataReader reader = SPs.FetchAllProductsByCategoryId(categoryId).GetReader();
ProductCollection productCollection = new ProductCollection();
productCollection.LoadAndCloseReader(reader);
return(productCollection);
}
/// <summary>
/// Fetches the random products.
/// </summary>
/// <returns></returns>
public ProductCollection FetchRandomProducts()
{
IDataReader reader = SPs.FetchRandomProducts().GetReader();
ProductCollection productCollection = new ProductCollection();
productCollection.LoadAndCloseReader(reader);
return(productCollection);
}
/// <summary>
/// Fetches the most popular products.
/// </summary>
/// <returns></returns>
public ProductCollection FetchMostPopularProducts()
{
IDataReader reader = SPs.FetchMostPopularProducts((int)BrowsingBehaviour.Browsing_Product).GetReader();
ProductCollection productCollection = new ProductCollection();
productCollection.LoadAndCloseReader(reader);
return(productCollection);
}
/// <summary>
/// Fetches the product cross sells.
/// </summary>
/// <param name="productId">The product id.</param>
/// <returns></returns>
public ProductCollection FetchProductCrossSells(int productId)
{
IDataReader reader = SPs.FetchProductCrossSells(productId).GetReader();
ProductCollection productCollection = new ProductCollection();
productCollection.LoadAndCloseReader(reader);
return(productCollection);
}
/// <summary>
/// Fetches the products by category id and price range.
/// </summary>
/// <param name="categoryId">The category id.</param>
/// <param name="priceStart">The price start.</param>
/// <param name="priceEnd">The price end.</param>
/// <returns></returns>
public ProductCollection FetchProductsByCategoryIdAndPriceRange(int categoryId, decimal priceStart, decimal priceEnd)
{
IDataReader reader = SPs.FetchProductsByCategoryIdAndPriceRange(categoryId, priceStart, priceEnd).GetReader();
ProductCollection productCollection = new ProductCollection();
productCollection.LoadAndCloseReader(reader);
return(productCollection);
}
public ProductCollection FetchAll()
{
ProductCollection coll = new ProductCollection();
Query qry = new Query(Product.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static MettleSystems.dashCommerce.Store.ProductCollection GetProductCollection(int varCustomizedProductDisplayTypeId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM dashCommerce_Store_Product INNER JOIN dashCommerce_Store_CustomizedProductDisplayType_Product_Map ON " +
"dashCommerce_Store_Product.ProductId=dashCommerce_Store_CustomizedProductDisplayType_Product_Map.ProductId WHERE dashCommerce_Store_CustomizedProductDisplayType_Product_Map.CustomizedProductDisplayTypeId=@CustomizedProductDisplayTypeId", CustomizedProductDisplayType.Schema.Provider.Name);
cmd.AddParameter("@CustomizedProductDisplayTypeId", varCustomizedProductDisplayTypeId, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
ProductCollection coll = new ProductCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
