public void TestBookInsertion() { var book = new Book() { ISBN = "ISBN-ISBN", Author = Guid.NewGuid().ToString(), Name = Guid.NewGuid().ToString(), }; using (var db = new BookStoreService.Models.StoreDbContext()) { db.Books.Add(book); db.SaveChanges(); } Assert.IsTrue(book.BookId != 0); using (var db = new BookStoreService.Models.StoreDbContext()) { var b = db.Books.Find(book.BookId); Assert.IsNotNull(b); Assert.IsTrue(b.Name == book.Name); } }
public void TestIgnoreDeleted() { var ctrl = new reportController(); // Mark all books as deleted using(var db = new BookStoreService.Models.StoreDbContext()) { var toDelete = (from i in db.Books where i.Deleted.HasValue == false select i); foreach(var i in toDelete) { i.Deleted = DateTime.Now; } db.SaveChanges(); } { var result = ctrl.Get().ToArray(); Assert.IsNotNull(result); Assert.IsTrue((from i in result where i.BooksCount > 0 select i).Count() == 0); } // add one book, uncategorized using (var db = new BookStoreService.Models.StoreDbContext()) { db.Books.Add(new Book() { ISBN = "ISBN-ISBN", Author = Guid.NewGuid().ToString(), Name = Guid.NewGuid().ToString(), }); db.SaveChanges(); } // check { var result = ctrl.Get().ToArray(); Assert.IsNotNull(result); Assert.IsTrue((from i in result where i.BooksCount > 0 select i).Count() == 1); // uncategorized always last Assert.IsTrue(result.Last().BooksCount == 1); } }
public void CheckCategories() { using (var db = new BookStoreService.Models.StoreDbContext()) { var test2 = from i in db.Categories.Include("Books") select i; foreach (var i in test2) { Assert.IsNotNull(i.Books); } } }
public void TestCategoryInsertion() { _ctrl.Post(new Category() { Created = DateTime.Now, Name = _categoryName }); using (var db = new BookStoreService.Models.StoreDbContext()) { var items = (from i in db.Categories where i.Name == _categoryName select i); Assert.IsTrue(items.Count() == 1, "Category insertion failed"); } }
public void TestInit() { _ctrl = new CategoriesController(); _db = new BookStoreService.Models.StoreDbContext(); }