public void MyProductGetProductsByVendorNameTest() { using (DataBaseDataContext db = new DataBaseDataContext()) { ToolsMyProduct toolsMyProduct = new ToolsMyProduct(); List <MyProduct> queryFromMethod = toolsMyProduct.MyProductGetProductsByVendorName("Greenwood Athletic Company"); List <MyProduct> queryFromDB = new List <MyProduct>(); MyProduct myProduct = (from p in db.MyProduct where p.ProductID == 935 select p).First(); queryFromDB.Add(myProduct); myProduct = (from p in db.MyProduct where p.ProductID == 936 select p).First(); queryFromDB.Add(myProduct); 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 MyProductGetNRecentlyReviewedProductsTest() { using (DataBaseDataContext db = new DataBaseDataContext()) { ToolsMyProduct toolsMyProduct = new ToolsMyProduct(); List <MyProduct> queryFromMethod = toolsMyProduct.MyProductGetNRecentlyReviewedProducts(5); List <MyProduct> queryFromDB = new List <MyProduct>(); MyProduct myProduct = (from p in db.MyProduct where p.ProductID == 709 select p).First(); queryFromDB.Add(myProduct); myProduct = (from p in db.MyProduct where p.ProductID == 937 select p).First(); queryFromDB.Add(myProduct); queryFromDB.Add(myProduct); myProduct = (from p in db.MyProduct where p.ProductID == 798 select p).First(); queryFromDB.Add(myProduct); 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 MyProductGetProductsByNameTest() { using (DataBaseDataContext db = new DataBaseDataContext()) { ToolsMyProduct toolsMyProduct = new ToolsMyProduct(); List <MyProduct> queryFromMethod = toolsMyProduct.MyProductGetProductsByName("Crankarm"); queryFromMethod.Sort((x, y) => x.ProductID.CompareTo(y.ProductID)); List <MyProduct> queryFromDB = new List <MyProduct>(); MyProduct myProduct = (from p in db.MyProduct where p.ProductID == 317 select p).First(); queryFromDB.Add(myProduct); myProduct = (from p in db.MyProduct where p.ProductID == 318 select p).First(); queryFromDB.Add(myProduct); myProduct = (from p in db.MyProduct where p.ProductID == 319 select p).First(); queryFromDB.Add(myProduct); 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()); } }