Ejemplo n.º 1
0
        /// <summary>
        /// this method will select all active instances of a product inventory given its unique ID
        /// </summary>
        /// <param name="productUID">unique product ID</param>
        /// <param name="includeDisabled">if true, it will return ALL inventory despite the value of IsActive </param>
        /// <returns>Generic List of type Inventory</returns>
        public List <Inventory> GetInventoryListByProductUID(int productUID, bool includeDisabled)
        {
            SkiChairFactory  skiChairFactory = new SkiChairFactory();
            List <Inventory> inventoryList   = new List <Inventory>();

            string selectSQL;

            if (includeDisabled)
            {
                selectSQL = "SELECT * FROM SkiChair_Inventory WHERE ProductUID = " + productUID + " ORDER BY CreateDate DESC";
            }
            else
            {
                selectSQL = "SELECT * FROM SkiChair_Inventory WHERE IsActive = 1 AND ProductUID = " + productUID + " ORDER BY CreateDate DESC";
            }

            DbCommand   cmd = db.GetSqlStringCommand(selectSQL);
            IDataReader rdr = database.ExecuteReader(cmd);

            while (rdr.Read())
            {
                inventoryList.Add(skiChairFactory.CreateInventory(rdr));
            }

            return(inventoryList);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// this method will select an inventory item by its unique ID
        /// </summary>
        /// <param name="inventoryUID">ID if inventory item</param>
        /// <returns>Inventory Entity item</returns>
        public Inventory GetInventoryByInventoryUID(int inventoryUID)
        {
            SkiChairFactory skiChairFactory = new SkiChairFactory();
            Inventory       inventoryItem   = new Inventory();

            string      selectSQL = "SELECT * FROM SkiChair_Inventory WHERE InventoryUID = " + inventoryUID;
            DbCommand   cmd       = db.GetSqlStringCommand(selectSQL);
            IDataReader rdr       = database.ExecuteReader(cmd);

            while (rdr.Read())
            {
                inventoryItem = skiChairFactory.CreateInventory(rdr);
            }

            return(inventoryItem);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// this method will return all SkiChair products
        /// </summary>
        /// <returns>DataSet containing products</returns>
        public List <Product> GetAllProducts()
        {
            SkiChairFactory skiChairFactory = new SkiChairFactory();
            List <Product>  productList     = new List <Product>();

            string      selectSQL = "SELECT * FROM SkiChair_Product";
            DbCommand   cmd       = db.GetSqlStringCommand(selectSQL);
            IDataReader rdr       = database.ExecuteReader(cmd);

            while (rdr.Read())
            {
                productList.Add(skiChairFactory.CreateProduct(rdr));
            }

            return(productList);
        }
Ejemplo n.º 4
0
        /// <summary>
        /// this method will select inventory information given its unique Flickr Image ID
        /// </summary>
        /// <param name="flickrImageUID">Unique Flickr Image ID</param>
        /// <returns>Inventory Entity</returns>
        public Inventory GetInventoryByFlickrImageUID(string flickrImageUID)
        {
            SkiChairFactory skiChairFactory = new SkiChairFactory();
            Inventory       inven           = new Inventory();

            string      selectSQL = "SELECT * FROM SkiChair_Inventory WHERE FlickrImageUID = '" + flickrImageUID + "'";
            DbCommand   cmd       = db.GetSqlStringCommand(selectSQL);
            IDataReader rdr       = database.ExecuteReader(cmd);

            while (rdr.Read())
            {
                inven = skiChairFactory.CreateInventory(rdr);
            }

            return(inven);
        }
Ejemplo n.º 5
0
        /// <summary>
        /// this method will get the product cross sell list of products given the specified product ID
        /// </summary>
        /// <param name="productUID">ID of the product to get the cross sell list for</param>
        /// <returns>Generic List of type Product</returns>
        public List <Product> GetCrossSellProduct(int productUID)
        {
            SkiChairFactory skiChairFactory = new SkiChairFactory();
            List <Product>  productList     = new List <Product>();

            string selectSQL = "SELECT CS.CrossSellProductUID, P.ProductName "
                               + "FROM SkiChair_CrossSell AS CS "
                               + "JOIN SkiChair_Product AS P ON CS.CrossSellProductUID = P.ProductUID "
                               + "WHERE CS.ProductUID = " + productUID;
            DbCommand   cmd = db.GetSqlStringCommand(selectSQL);
            IDataReader rdr = database.ExecuteReader(cmd);

            while (rdr.Read())
            {
                productList.Add(skiChairFactory.CreateProduct(rdr));
            }
            return(productList);
        }