public void TestUpdateProduct()
{
Product p2 = new Product();
p2.ProductCode = "zzzz";
p2.Description = "Test Product 2";
p2.UnitPrice = 99.99M;
p2.OnHandQuantity = 2;
Product p3 = new Product();
p3.ProductCode = "zzzz2";
p3.Description = "Updated Test Product 2";
p3.UnitPrice = 99.99M;
p3.OnHandQuantity = 3;
// add Product p2 to ProductDB
ProductDB.AddProduct(p2);
// update pd with p3 properties
ProductDB.UpdateProduct(p2, p3);
// GetProduct p3 from ProductDB and store in variable q
Product q = ProductDB.GetProduct(p3.ProductCode);
// ProductCode of q should still be equal to zzzz2
Assert.AreEqual("zzzz2 ", q.ProductCode);
// OnHandQuantity should reflect update and be equal to 3
Assert.AreEqual(3, q.OnHandQuantity);
// Delete Product p3 from ProductDB (since no test set-up)
ProductDB.DeleteProduct(p3);
}
public void TestDeleteProduct()
{
Product p = ProductDB.GetProduct("EFGH ");
ProductDB.DeleteProduct(p);
Assert.IsNull(ProductDB.GetProduct(p.ProductCode));
}
public void TestDeleteProduct()
{
//Product p = new Product();
//p.ProductCode = "ZZZZ";
//p.Description = "Delete Test Product";
//p.UnitPrice = 11.1M;
//p.OnHandQuantity = 4;
//Already added the Product p
// ProductDB.AddProduct(p);
//Assert.AreEqual(4, p.OnHandQuantity);
Product d = ProductDB.GetProduct("ZZZZ ");
Assert.AreEqual("ZZZZ ", d.ProductCode);
Assert.IsTrue(ProductDB.DeleteProduct(d));
Assert.IsNull(ProductDB.GetProduct("ZZZZ "));
//Assert.AreEqual(null, d1.ProductCode);
//Assert.AreEqual(null, d1.OnHandQuantity);
// Assert.Throws<SqlException>( () => ProductDB.GetProduct("QQQ2 "));
// If it is working would I need to be testing for the exception??
}
public void TestDeleteProduct()
{
Product p = new Product();
p.ProductCode = "XYZ1 ";
p.Description = "test product 1";
p.Price = 20.00m;
p.OnHandQuantity = 5;
bool isDeleted = ProductDB.DeleteProduct(p);
Assert.IsTrue(isDeleted);
}
public void TestDeleteProduct()
{
// note: as written, this test only functions after TestAddProduct is run
Product p = new Product();
p.ProductCode = "2222";
p.Description = "Test Product";
p.UnitPrice = 100.00M;
p.OnHandQuantity = 12;
// delete Product p from ProductDB
ProductDB.DeleteProduct(p);
// GetProduct p in ProductDB should be equal to null (since it is deleted)
Assert.AreEqual(null, ProductDB.GetProduct(p.ProductCode));
}
public void TestInsertProduct()
{
Product p = new Product();
p.ProductCode = "ZZZZ ";
p.Description = "Test Product";
p.UnitPrice = 99.99M;
p.OnHandQuantity = 2;
ProductDB.AddProduct(p);
Assert.AreEqual("ZZZZ ", p.ProductCode);
Assert.AreEqual("Test Product", p.Description);
Assert.AreEqual(99.99M, p.UnitPrice);
Assert.AreEqual(2, p.OnHandQuantity);
ProductDB.DeleteProduct(p);
Assert.IsNull(ProductDB.GetProduct(p.ProductCode));
}
public void Setup()
{
Product p = new Product();
p.ProductCode = "ZZZZ";
p.Description = "Test Product";
p.UnitPrice = 99.9M;
p.OnHandQuantity = 2;
if (ProductDB.GetProduct("ZZZZ ") != null)
{
ProductDB.DeleteProduct(p);
}
else
{
ProductDB.AddProduct(p);
}
}
public void TestDeleteProduct()
{
Assert.True(ProductDB.DeleteProduct(p2));
}
public void DeleteProduct()
{
Assert.True(ProductDB.DeleteProduct(this.testProduct));
}
public void TestUpdateProduct()
{
//need to retrieve product from data base
//either use clone or can use two variables
//update values to change except for the ProductCode
//Because ProductCode is what references the actual product and knows what to update.
Product p = new Product();
p.ProductCode = "ZZZ1";
p.Description = "Test Product";
p.UnitPrice = 99.9M;
p.OnHandQuantity = 2;
ProductDB.DeleteProduct(p);
ProductDB.AddProduct(p);
Product op = ProductDB.GetProduct("ZZZ1 ");
Product np = ProductDB.GetProduct("ZZZ1 ");
Assert.AreEqual(2, op.OnHandQuantity);
Assert.AreEqual(2, np.OnHandQuantity);
np.OnHandQuantity = 3;
ProductDB.UpdateProduct(op, np);
Product pp = ProductDB.GetProduct("ZZZ1 ");
Assert.AreEqual(3, pp.OnHandQuantity);
//np.Description = "Replaced Test Product";
//np.UnitPrice = 00.0M;
//np.OnHandQuantity = 3;
//ProductDB.UpdateProduct(op, np);
//Assert.AreEqual(3, op.OnHandQuantity);
// My previous thoughts when I wasn't getting the product and expecting the
// method to change the values.
//Product op = new Product();
//op.ProductCode = "ZZZZ";
//op.Description = "Test Product";
//op.UnitPrice = 99.9M;
//op.OnHandQuantity = 2;
//Product np = new Product();
//np.ProductCode = "YYYY";
//np.Description = "Replaced Test Product";
//np.UnitPrice = 00.0M;
//np.OnHandQuantity = 3;
//ProductDB.UpdateProduct(op, np);
//Trying to test that the Product op was switched to the np values.
//Does not appear to be working this way.
// Assert.AreEqual("YYYY ", op.ProductCode);
}