public void GetProductsWithNRecentReviewsTest()
{
using (DataBaseDataContext db = new DataBaseDataContext())
{
ToolsProduct toolsProduct = new ToolsProduct();
List <Product> queryFromMethod = toolsProduct.GetProductsWithNRecentReviews(5);
List <Product> queryFromDB = new List <Product>();
Product product = (from p in db.Products where p.ProductID == 709 select p).First();
queryFromDB.Add(product);
product = (from p in db.Products where p.ProductID == 937 select p).First();
queryFromDB.Add(product);
queryFromDB.Add(product);
product = (from p in db.Products where p.ProductID == 798 select p).First();
queryFromDB.Add(product);
for (int i = 0; i < queryFromMethod.Count(); i++)
{
Assert.AreEqual(queryFromDB[i].ProductID, queryFromMethod[i].ProductID);
Assert.AreEqual(queryFromDB[i].Name, queryFromMethod[i].Name);
}
Assert.AreEqual(queryFromDB.Count(), queryFromMethod.Count());
}
}
public void GetProductVendorByProductNameTest()
{
ToolsProduct toolsProduct = new ToolsProduct();
string query = toolsProduct.GetProductVendorByProductName("Racing Socks, M");
string temp = "Jeff's Sporting Goods";
Assert.AreEqual(query, temp);
}
public void GetTotalStandardCostByCategoryTest()
{
using (DataBaseDataContext db = new DataBaseDataContext())
{
ToolsProduct toolsProduct = new ToolsProduct();
ProductCategory productCategory = (from p in db.ProductCategory where p.ProductCategoryID == 2 select p).First();
double queryFromMethod = Math.Round(toolsProduct.GetTotalStandardCostByCategory(productCategory), 2);
double temp = 62961.28;
Assert.AreEqual(queryFromMethod, temp);
}
}
public void GetProductAndNameTests()
{
using (DataBaseDataContext db = new DataBaseDataContext())
{
ToolsProduct toolsProduct = new ToolsProduct();
List <Product> all = (from p in db.Products select p).ToList();
List <Product> query = toolsProduct.GetProductsByName("Thin-Jam Hex Nut");
query.Sort((x, y) => x.ProductID.CompareTo(y.ProductID));
List <String> productsAndNames = query.GetProductAndName().Split('\n').ToList();
for (int i = 0; i < query.Count; i++)
{
Assert.AreEqual(all.Find(x => x.ProductID == 359 + i).Name + " - " + "Advanced Bicycles", productsAndNames[i]);
}
}
}
public void GetProductNamesByVendorNameTest()
{
using (DataBaseDataContext db = new DataBaseDataContext())
{
ToolsProduct toolsProduct = new ToolsProduct();
List <string> queryFromMethod = toolsProduct.GetProductNamesByVendorName("Greenwood Athletic Company");
List <Product> queryFromDB = new List <Product>();
Product product = (from p in db.Products where p.ProductID == 935 select p).First();
queryFromDB.Add(product);
product = (from p in db.Products where p.ProductID == 936 select p).First();
queryFromDB.Add(product);
for (int i = 0; i < queryFromMethod.Count(); i++)
{
Assert.AreEqual(queryFromDB[i].Name, queryFromMethod[i]);
}
Assert.AreEqual(queryFromDB.Count(), queryFromMethod.Count());
}
}
public void GetNProductsFromCategoryTest()
{
using (DataBaseDataContext db = new DataBaseDataContext())
{
ToolsProduct toolsProduct = new ToolsProduct();
List <Product> queryFromMethod = toolsProduct.GetNProductsFromCategory("Components", 2);
List <Product> queryFromDB = new List <Product>();
Product product = (from p in db.Products where p.ProductID == 808 select p).First();
queryFromDB.Add(product);
product = (from p in db.Products where p.ProductID == 809 select p).First();
queryFromDB.Add(product);
for (int i = 0; i < queryFromMethod.Count(); i++)
{
Assert.AreEqual(queryFromDB[i].ProductID, queryFromMethod[i].ProductID);
Assert.AreEqual(queryFromDB[i].Name, queryFromMethod[i].Name);
}
Assert.AreEqual(queryFromDB.Count(), queryFromMethod.Count());
}
}
public void GetProductsByNameTest()
{
using (DataBaseDataContext db = new DataBaseDataContext())
{
ToolsProduct toolsProduct = new ToolsProduct();
List <Product> queryFromMethod = toolsProduct.GetProductsByName("Crankarm");
queryFromMethod.Sort((x, y) => x.ProductID.CompareTo(y.ProductID));
List <Product> queryFromDB = new List <Product>();
Product product = (from p in db.Products where p.ProductID == 317 select p).First();
queryFromDB.Add(product);
product = (from p in db.Products where p.ProductID == 318 select p).First();
queryFromDB.Add(product);
product = (from p in db.Products where p.ProductID == 319 select p).First();
queryFromDB.Add(product);
for (int i = 0; i < queryFromMethod.Count(); i++)
{
Assert.AreEqual(queryFromDB[i].ProductID, queryFromMethod[i].ProductID);
Assert.AreEqual(queryFromDB[i].Name, queryFromMethod[i].Name);
}
Assert.AreEqual(queryFromDB.Count(), queryFromMethod.Count());
}
}
