public void GetProductsGrouped()
{
var db = _setup.GetDbTest();
var repo = new Linq2dbResearchRepository(db);
var query = repo.GetProductsGrouped();
var expected = new List <CategoryGroup>()
{
new CategoryGroup()
{
Name = "Category 1",
NumberOfProducts = 3,
AveragePrice = 33.333333333333336,
},
new CategoryGroup()
{
Name = "Category 2",
NumberOfProducts = 1,
AveragePrice = 20
},
new CategoryGroup()
{
Name = "Category 3",
NumberOfProducts = 1,
AveragePrice = 30
},
};
Assert.Equal(query[0], expected[0]);
Assert.Equal(query[1], expected[1]);
Assert.Equal(query[2], expected[2]);
}
public void CanLoadProductsWithCategory()
{
var db = _setup.GetDbTest();
var repo = new Linq2dbResearchRepository(db);
var query = repo.LoadProductsWithCategory();
Assert.True(query.Count == 5);
}
public void CanAddProduct()
{
var db = _setup.GetDbTest();
var repo = new Linq2dbResearchRepository(db);
var mockProduct = new Product()
{
Name = "testproductha",
CategoryId = 1,
UnitPrice = 765
};
var query = repo.AddProduct(mockProduct);
Assert.True(query);
}
public void Test1()
{
var testObject = new Product();
var context = new Mock <Context>();
var dbSetMock = new Mock <ITable <Product> >();
context.Setup(x => x.Products).Returns(dbSetMock.Object);
context.Setup(x => x.InsertWithInt32Identity(It.IsAny <Product>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>())).Returns(1);
//dbSetMock.Setup(x => x.InsertWithInt32Identity(It.IsAny<Product>())).Returns(testObject);
// Act
var repository = new Linq2dbResearchRepository();
repository.AddProduct(testObject);
//Assert
context.Verify(x => x.InsertWithInt32Identity(testObject, null, null, null));
Assert.Pass();
}
