public void CanUpdateExistingProduct()
{
if (_products != null)
{
var product = _products[0];
product.Name = "TestProductRename";
product.Description = "TestProductDescriptionChange";
product.Price = 99;
IProductRepository repository = new ProductRepository();
repository.Update(product);
// use session to try to load the product
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Product>(product.ProductId);
Assert.AreEqual(product.Name, fromDb.Name);
Assert.AreEqual(product.Description, fromDb.Description);
Assert.AreEqual(product.Price, fromDb.Price);
}
}
}
public void CanAddNewProduct()
{
var product = new Product
{
ProductCode = "Test106",
Name = "TestProduct106",
Description = "Testing product 6",
Price = 106,
ManafacturerId = 1
};
IProductRepository repository = new ProductRepository();
repository.Add(product);
// use session to try to load the product
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Product>(product.ProductId);
// Test that the product was successfully inserted
Assert.IsNotNull(fromDb);
Assert.AreNotSame(product, fromDb);
Assert.AreEqual(product.Name, fromDb.Name);
Assert.AreEqual(product.Description, fromDb.Description);
Assert.AreEqual(product.Price, fromDb.Price);
}
}
public void CanSearchByName()
{
IProductRepository repository = new ProductRepository();
var fromDb = repository.Search("101", new List<int>());
Assert.AreEqual(1, fromDb.Count);
Assert.IsTrue(IsInProductCollection(_products[0], fromDb));
}
public void CanRemoveExistingProduct()
{
var product = _products[0];
IProductRepository repository = new ProductRepository();
repository.Remove(product);
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Product>(product.ProductId);
Assert.IsNull(fromDb);
}
}
public void CanGetExistingProductsByManafacturer()
{
IProductRepository repository = new ProductRepository();
var fromDb = repository.ManafacturerProductList(2);
Assert.AreEqual(1, fromDb.Count);
Assert.IsTrue(IsInProductCollection(_products[1], fromDb));
}
public void CanGetExistingProductList()
{
IProductRepository repository = new ProductRepository();
var fromDb = repository.List();
Assert.AreEqual(5, fromDb.Count);
Assert.IsTrue(IsInProductCollection(_products[0], fromDb));
Assert.IsTrue(IsInProductCollection(_products[1], fromDb));
Assert.IsTrue(IsInProductCollection(_products[2], fromDb));
Assert.IsTrue(IsInProductCollection(_products[3], fromDb));
Assert.IsTrue(IsInProductCollection(_products[4], fromDb));
}
public void CanGetExistingProductByProductName()
{
IProductRepository repository = new ProductRepository();
var fromDb = repository.GetByProductName(_products[1].Name);
Assert.IsNotNull(fromDb);
Assert.AreNotSame(_products[1], fromDb);
Assert.AreEqual(_products[1].ProductId, fromDb.ProductId);
}
