public void GetTotalStandardCostByCategoryTest()
        {
            ProductCategory pc = new ProductCategory
            {
                Name = "Bikes"
            };

            Assert.AreEqual(92092.8230m, QuerySyntaxMethods.GetTotalStandardCostByCategory(pc));
        }
        public void GetProductByNameTest()
        {
            List <Product> result = QuerySyntaxMethods.GetProductsByName("Chain");

            Assert.AreEqual(5, result.Count);
            foreach (Product res in result)
            {
                Assert.IsTrue(res.Name.Contains("Chain"));
            }
        }
        public void GetNProductsFromCategoryTest()
        {
            List <Product> result = QuerySyntaxMethods.GetNProductsFromCategory("Bikes", 5);

            Assert.AreEqual(5, result.Count);
        }
        public void GetNRecentlyReviewdProductdTest()
        {
            List <Product> result = QuerySyntaxMethods.GetNRecentlyReviewedProductd(3);

            Assert.AreEqual(3, result.Count);
        }
        public void GetProductsWithRecentReviewsTest()
        {
            List <Product> result = QuerySyntaxMethods.GetProductsWithRecentReviews(3);

            Assert.AreEqual(3, result.Count);
        }
        public void GetProduvtVendorByProductNameTest()
        {
            string result = QuerySyntaxMethods.GetProductVendorByProductName("Chain");

            Assert.AreEqual("Varsity Sport Co.", result);
        }
        public void GetProductNameByVendorNameTest()
        {
            List <string> result = QuerySyntaxMethods.GetProtuctNamesByVendorName("International");

            Assert.AreEqual(1, result.Count);
        }