public static ArrayList GetStoreCategoryProducts(int store_id, int category_id)
{
string query = @"SELECT p.* FROM products p, product2category p2c
WHERE p.product_id = p2c.product_id
AND p.store_id = {0}
AND p2c.category_id = {1}";
query = string.Format(query, store_id, category_id);
ArrayList _prods = SBFactory.getDbh().Query(query);
if (_prods == null)
{
return(null);
}
ArrayList prods = new ArrayList();
foreach (Hashtable prod in _prods)
{
SBProduct product = new SBProduct();
product.SetDbData(prod);
product.GetDbMeta();
prods.Add(product);
}
return(prods);
}
/// <summary>
/// Gets the store product.
/// </summary>
/// <returns>
/// The store product.
/// A <see cref="SBProduct"/>
/// </returns>
/// <param name='store_id'>
/// Store_id.
/// </param>
/// <param name='product_code'>
/// Product_code.
/// </param>
public static SBProduct GetStoreProduct(int store_id, string product_code)
{
SBTableProduct tp = new SBTableProduct();
Hashtable prod = tp.getRow(string.Format("store_id = {0} AND product_code = '{1}'", store_id, product_code.Trim()));
if (prod == null)
{
return(null);
}
SBProduct product = new SBProduct();
product.SetDbData(prod);
product.GetDbMeta();
return(product);
}
public static ArrayList GetStoreProducts(int store_id)
{
SBTableProduct tp = new SBTableProduct();
ArrayList _prods = tp.getRows(string.Format("(status = 'publish' OR status = 'initial') AND store_id = {0}", store_id));
if (_prods == null)
{
return(null);
}
ArrayList prods = new ArrayList();
foreach (Hashtable prod in _prods)
{
SBProduct product = new SBProduct();
product.SetDbData(prod);
product.GetDbMeta();
prods.Add(product);
}
return(prods);
}
