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 GetMyProductsWithNRecentReviewsTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext(insertProductsFromBase());
List <MyProduct> list = myProductDataContext.GetMyProductsWithNRecentReviews(1);
Assert.AreEqual(list.Count, 2);
Assert.AreEqual(list[0].ProductID, 709);
Assert.AreEqual(list[1].ProductID, 798);
}
public void GetMyProductsByNameTest()
{
MyProductDataContext dataContext = new MyProductDataContext(insertProductsFromBase());
List <MyProduct> products = dataContext.GetMyProductsByName("lov");
List <MyProduct> products3 = dataContext.GetMyProductsByName("test");
Assert.AreEqual(6, products.Count);
Assert.AreEqual(0, products3.Count);
}
public void GetProductsWithNRecentReviews()
{
using (DataClasses1DataContext context = new DataClasses1DataContext())
{
MyProductDataContext myContext = new MyProductDataContext(context);
List <MyProduct> list = MyProductTools.GetProductsWithNRecentReviews(2);
Assert.AreEqual(1, list.Count);
}
}
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 NProductsFromCategory()
{
using (DataClasses1DataContext context = new DataClasses1DataContext())
{
MyProductDataContext myContext = new MyProductDataContext(context);
List <MyProduct> list = MyProductTools.GetNProductsFromCategory("Bikes", 3);
Assert.AreEqual(3, list.Count);
}
}
public void ProductsWithNReviews2()
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext())
{
MyProductDataContext dataContext = new MyProductDataContext(dbContext);
List <MyProduct> products = dataContext.GetProductsWithNRecentReviews(2);
Assert.AreEqual(products.Count, 1);
Assert.IsNotNull(products.Find(product => product.ProductID == 937));
}
}
public void GetNMyProductFromCategoryTest()
{
MyProductDataContext myProductDataContext = new MyProductDataContext(insertProductsFromBase());
List <MyProduct> list = myProductDataContext.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 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 NameContainsGet()
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext())
{
MyProductDataContext dataContext = new MyProductDataContext(dbContext);
List <MyProduct> products = dataContext.GetProductsByName("ball");
Assert.AreEqual(products.Count, 3);
products = dataContext.GetProductsByName("Ball");
Assert.AreEqual(products.Count, 3);
}
}
public void NProductsFromCategory()
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext())
{
MyProductDataContext dataContext = new MyProductDataContext(dbContext);
List <MyProduct> products = dataContext.GetNProductsFromCategory("Bikes", 5);
Assert.AreEqual(products.Count, 5);
foreach (Product product in products)
{
Assert.AreEqual(product.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 GetProductsByName()
{
using (DataClasses1DataContext context = new DataClasses1DataContext())
{
MyProductDataContext myContext = new MyProductDataContext(context);
List <MyProduct> list = MyProductTools.GetProductsByName("Hex Nut");
Assert.AreEqual(39, list.Count);
foreach (MyProduct product in list)
{
Assert.IsTrue(product.Name.Contains("Hex Nut"));
}
}
}
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");
}
}
