public void DataContextGetAllTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(insertProductsFromBase());
Assert.AreEqual(myProductDataContext.GetAll().Count, 504);
}
public void DataContextAddTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(new MyProduct(DataService.GetProductByName("Adjustable Race")));
Assert.AreEqual(myProductDataContext.GetAll().Count, 1);
}
public void DataContextDeleteTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(insertProductsFromBase());
Assert.AreEqual(myProductDataContext.GetAll().Count, 504);
myProductDataContext.Delete((new MyProduct(DataService.GetProductByName("Adjustable Race")).ProductID));
Assert.AreEqual(myProductDataContext.GetAll().Count, 503);
}
public void GetTotalStandardCostByCategoryStringTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(insertProductsFromBase());
MyProductRepository myProductRepository = new MyProductRepository(myProductDataContext);
decimal cost = myProductRepository.GetTotalStandardCostByCategory("Bikes");
Assert.AreEqual(92092.8230m, cost);
}
public void GetNMyProductFromCategoryTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(insertProductsFromBase());
MyProductRepository myProductRepository = new MyProductRepository(myProductDataContext);
List <MyProduct> list = myProductRepository.GetNMyProductFromCategory("Bikes", 3);
Assert.AreEqual(list.Count, 3);
Assert.AreEqual(list[0].ProductSubcategory.ProductCategory.Name, "Bikes");
Assert.AreEqual(list[1].ProductSubcategory.ProductCategory.Name, "Bikes");
Assert.AreEqual(list[2].ProductSubcategory.ProductCategory.Name, "Bikes");
}
public void GetProductsByName()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(insertProductsFromBase());
MyProductRepository myProductRepository = new MyProductRepository(myProductDataContext);
List <MyProduct> products = myProductRepository.GetProductsByName("Women's");
List <MyProduct> products2 = myProductRepository.GetProductsByName("Touring-3000 Yellow, 50");
List <MyProduct> products3 = myProductRepository.GetProductsByName("test");
Assert.AreEqual(6, products.Count);
Assert.AreEqual(1, products2.Count);
Assert.AreEqual(0, products3.Count);
}
public void GetTotalStandardCostByCategoryTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(insertProductsFromBase());
MyProductRepository myProductRepository = new MyProductRepository(myProductDataContext);
List <MyProduct> list = myProductRepository.GetNMyProductFromCategory("Bikes", 1);
ProductCategory productCategory = list[0].ProductSubcategory.ProductCategory;
decimal cost = myProductRepository.GetTotalStandardCostByCategory(productCategory);
Assert.AreEqual(92092.8230m, cost);
}
public void DataContextUpdateTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext();
myProductDataContext.Add(insertProductsFromBase());
MyProduct myProduct = new MyProduct(DataService.GetProductByName("Adjustable Race"));
Assert.AreEqual(myProductDataContext.Get(myProduct.ProductID).Name, "Adjustable Race");
myProduct.Name = "test name";
if (myProductDataContext.Update(myProduct) == true)
{
Assert.AreEqual(myProductDataContext.Get(myProduct.ProductID).Name, "test name");
}
}