// GET: Products
 public ActionResult Index()
 {
     //Get products
     _productList.productList = _productDataSerice.GetProducts();
     //Get product primary image
     PrimaryProductImage(_productList);
     return(View(_productList));
 }
        public void GetProducts()
        {
            //Arrange
            var service = new ProductDataService(repository);

            //Act
            List <Product> products = service.GetProducts();

            //Assert
            Assert.IsNotNull(products);
        }
        public IList <Product> GetProducts()
        {
            IList <Product> products = new List <Product>();
            DataTable       ds;

            using (ProductDataService data = new ProductDataService())
            {
                string sql = "SELECT *  FROM [Production].[Product]";

                ds = data.GetProducts(sql);
            }
            products = ConvertToProducts(ds);

            return(products);
        }