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);
}
public ArrayList GetProducts(int store_id = 0)
{
ArrayList prods = new ArrayList();
string query = "";
if (store_id == 0)
{
query = @"SELECT * FROM products p, product2category p2c
WHERE p2c.category_id = {0}
AND p.product_id = p2c.product_id";
query = string.Format(query, this.CategoryID);
}
else
{
query = @"SELECT * FROM products p, product2category p2c
WHERE p.store_id = {0}
AND p2c.category_id = {1}
AND p.product_id = p2c.product_id";
query = string.Format(query, store_id, this.CategoryID);
}
ArrayList _prods = SBFactory.getDbh().Query(query);
if (_prods != null)
{
foreach (Hashtable _p in _prods)
{
SBProduct p = new SBProduct();
p.SetDbData(_p);
prods.Add(p);
}
}
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);
}
/// <summary>
/// Gets the category products.
/// The method returns an SBProduct object array
/// </summary>
/// <returns>The category products.</returns>
/// <param name="category_id">Category identifier.</param>
public static ArrayList GetCategoryProducts(int category_id)
{
string query = "SELECT p.* " +
"FROM products p, product2category p2c " +
"WHERE p.product_id = p2c.product_id " +
"AND p2c.category_id = {0}";
query = string.Format(query, category_id);
ArrayList prods = SBFactory.getDbh().Query(query);
ArrayList obj_prods = new ArrayList();
foreach (Hashtable p in prods)
{
SBProduct product = new SBProduct();
product.SetDbData(p);
obj_prods.Add(product);
}
return(obj_prods);
}
/// <summary>
/// Get all Warehouse products and return an ArrayList that contains SMProduct instances
/// </summary>
/// <returns>
/// A <see cref="ArrayList"/>
/// </returns>
public static ArrayList getProducts()
{
SBTableProduct tp = new SBTableProduct();
ArrayList prods = tp.getRows("(status = 'publish' OR status = 'initial') ORDER BY creation_date ASC");
if (prods == null)
{
return(null);
}
ArrayList obj_prods = new ArrayList();
foreach (Hashtable p in prods)
{
SBProduct product = new SBProduct();
product.SetDbData(p);
obj_prods.Add(product);
}
return(obj_prods);
}
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);
}
/// <summary>
/// Gets the product by codebar.
/// </summary>
/// <returns>The product by codebar.</returns>
public static SBProduct GetProductByCodebar(string barcode, int store_id = 0)
{
SBFactory.getDbh().Select("*")
.From("products")
.Where(string.Format("product_barcode = '{0}'", barcode));
if (store_id > 0)
{
SBFactory.getDbh().And(string.Format("store_id = {0}", store_id));
}
Hashtable prod_row = SBFactory.getDbh().QueryRow();
if (prod_row == null)
{
return(null);
}
SBProduct product = new SBProduct();
product.SetDbData(prod_row);
return(product);
}
