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