public void ProductsWithNReviews2() { List <Product> products = LinqTools.GetProductsWithNRecentReviews(2); Assert.AreEqual(products.Count, 1); Assert.IsNotNull(products.Find(product => product.ProductID == 937)); }
public void Update(Product product) { Task.Run(() => { LinqTools.UpdateProduct(product); CollectionChanged?.Invoke(); }); }
public void TotalStandardCostByCategory() { ProductCategory product = new ProductCategory(); product.Name = "Bikes"; int total = LinqTools.GetTotalStandardCostByCategory(product); //Assert.AreEqual(total, 92315); }
public void Insert(Product product) { Task.Run(() => { LinqTools.AddNewProduct(product); CollectionChanged?.Invoke(); }); }
public void NProductsByReviews() { List <Product> products = LinqTools.GetNRecentlyReviewedProducts(3); Assert.AreEqual(products.Count, 3); Assert.AreEqual(products[0].Name, "HL Mountain Pedal"); Assert.AreEqual(products[1].Name, "Road-550-W Yellow, 40"); Assert.AreEqual(products[2].Name, "Mountain Bike Socks, M"); }
public void NameContainsGet() { List <Product> products = LinqTools.GetProductsByName("Ball"); foreach (Product product in products) { Assert.IsTrue(product.Name.Contains("Ball")); } }
public void NProductsFromCategory() { List <Product> products = LinqTools.GetNProductsFromCategory("Bikes", 5); Assert.AreEqual(products.Count, 5); foreach (Product product in products) { Assert.AreEqual(product.ProductSubcategory.ProductCategory.Name, "Bikes"); } }
public void Delete(int productID) { Task.Run(() => { //LinqTools.RemoveProduct(productID); Product product = LinqTools.GetProductById(productID); product.DiscontinuedDate = DateTime.Today; LinqTools.UpdateProduct(product); CollectionChanged?.Invoke(); }); }
public void Upsert(Product product) { Task.Run(() => { if (LinqTools.GetProductById(product.ProductID) != null) { LinqTools.UpdateProduct(product); } else { LinqTools.AddNewProduct(product); } CollectionChanged?.Invoke(); }); }
public List <string> GetProductSubcategories() { return(LinqTools.SelectDistinctSubcategories()); }
public void VendorNameByProduct() { string productsName = LinqTools.GetProductVendorByProductName("Adjustable Race"); Assert.AreEqual(productsName, "Litware, Inc."); }
public void ProductNameByVendor() { List <string> productsName = LinqTools.GetProductNamesByVendorName("Litware, Inc."); Assert.AreEqual(productsName.Count, 1); }
public void ProductByVendor() { List <Product> products = LinqTools.GetProductsByVendorName("Litware, Inc."); Assert.AreEqual(products.Count, 1); }
public List <string> GetProductStyles() { return(LinqTools.SelectDistinctStyles()); }
public List <Product> GetDeletedProducts() { return((List <Product>)LinqTools.GetAllProducts().Where(product => product.DiscontinuedDate.HasValue).ToList()); }
public List <string> GetWeightUnits() { return(LinqTools.SelectDistinctWeightUnits()); }
public List <string> GetSizeUnits() { return(LinqTools.SelectDistinctSizesUnits()); }
public string GetModelNameByID(int id) { return(LinqTools.SelectModelName(id)); }
public string GetSubcategoryNameByID(int id) { return(LinqTools.SelectSubcategoryName(id)); }
public int GetModelIDByName(string name) { return(LinqTools.SelectModelId(name)); }
public int GetSubcategoryIDByName(string name) { return(LinqTools.SelectSubcategoryId(name)); }