public void GetArticleNumberFromEan_ShouldReturn1()
{
var data = new List<ean>{
new ean { article_id = 1, ean1 = "0000000000"},
}.AsQueryable();
var mockSet = new Mock<DbSet<ean>>();
mockSet.As<IQueryable<ean>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<ean>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<ean>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<ean>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.ean).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var aid = service.GetArticleNumber("ean", "ean", "0000000000");
var wrongEan = service.GetArticleNumber("ean", "ean", "1111111111");
var wrongTable = service.GetArticleNumber("NonExistingTable", "NonExistingColumn", "SomeValue");
Assert.AreEqual(1, aid);
Assert.AreEqual(-1, wrongEan);
Assert.AreEqual(-1, wrongTable);
}
public void GetArticleNumberFromSku_ShouldReturn1()
{
var data = new List<sku>{
new sku { article_id = 1, sku1 = "0000000000"},
}.AsQueryable();
var mockSet = new Mock<DbSet<sku>>();
mockSet.As<IQueryable<sku>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<sku>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<sku>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<sku>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.sku).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var aid = service.GetArticleNumber("sku", "sku", "0000000000");
var wrongSku = service.GetArticleNumber("sku", "sku", "1111111111");
Assert.AreEqual(1, aid);
Assert.AreEqual(-1, wrongSku);
}
public void GetArticleNumberFromTitle_ShouldReturn1()
{
var data = new List<title>{
new title { article_id = 1, title1 = "Hello"},
}.AsQueryable();
var mockSet = new Mock<DbSet<title>>();
mockSet.As<IQueryable<title>>().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As<IQueryable<title>>().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As<IQueryable<title>>().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As<IQueryable<title>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock<BetsyEntities>();
mockContext.Setup(c => c.title).Returns(mockSet.Object);
var service = new BetsyService(mockContext.Object);
var aid = service.GetArticleNumber("title", "title", "Hello");
var wrongTitle = service.GetArticleNumber("title", "title", "Bye");
Assert.AreEqual(1, aid);
Assert.AreEqual(-1, wrongTitle);
}
