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