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); }