public CrossSellCollection FetchAll()
{
CrossSellCollection coll = new CrossSellCollection();
Query qry = new Query(CrossSell.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
/// <summary>
/// Loads the products.
/// </summary>
private void LoadProducts()
{
crossSellCollection = new CrossSellController().FetchByID(productId);
Query query = new Query(Product.Schema).WHERE(Product.Columns.ProductId, Comparison.NotEquals, productId);
ProductCollection productCollection = new ProductController().FetchByQuery(query);
if (productCollection.Count > 0)
{
dgCrossSells.DataSource = productCollection;
dgCrossSells.ItemDataBound += new DataGridItemEventHandler(dgCrossSells_ItemDataBound);
dgCrossSells.Columns[0].HeaderText = LocalizationUtility.GetText("hdrAddRemove");
dgCrossSells.Columns[1].HeaderText = LocalizationUtility.GetText("hdrName");
dgCrossSells.DataBind();
}
}
/// <summary>
/// Loads the products.
/// </summary>
private void LoadProducts()
{
crossSellCollection = new CrossSellController().FetchByID(productId);
Query query = new Query(Product.Schema).WHERE(Product.Columns.ProductId, Comparison.NotEquals, productId);
ProductCollection productCollection = new ProductController().FetchByQuery(query);
if(productCollection.Count > 0) {
dgCrossSells.DataSource = productCollection;
dgCrossSells.ItemDataBound += new DataGridItemEventHandler(dgCrossSells_ItemDataBound);
dgCrossSells.Columns[0].HeaderText = LocalizationUtility.GetText("hdrAddRemove");
dgCrossSells.Columns[1].HeaderText = LocalizationUtility.GetText("hdrName");
dgCrossSells.DataBind();
}
}
public CrossSellCollection FetchByQuery(Query qry)
{
CrossSellCollection coll = new CrossSellCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public CrossSellCollection FetchByID(object ProductId)
{
CrossSellCollection coll = new CrossSellCollection().Where("ProductId", ProductId).Load();
return coll;
}
