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; }