public void TestAddingAndDeleting()
{
using (LinqLibraryDataContext rep = new LinqLibraryDataContext(m_ConnectionString))
{
rep.AddBook("nie", "nie", "nie", 2000);
Book b = rep.GetBook("nie");
Assert.IsNotNull(b);
rep.DeleteBook(b.book_ID);
}
}
public void TestGetBook()
{
using (LinqLibraryDataContext rep = new LinqLibraryDataContext(m_ConnectionString))
{
rep.AddBook("nie", "nie", "nie", 2000);
Book b = rep.GetBook("nie");
Book d = rep.GetBook(b.book_ID);
Assert.AreEqual(b.title, d.title);
rep.DeleteBook(b.book_ID);
}
}
public void AddSameBookTwoTimes()
{
using (LinqLibraryDataContext db = new LinqLibraryDataContext(m_ConnectionString))
{
int count = db.CountBooks();
Book oim = new Book();
oim.title = "Ogniem i mieczem";
oim.author = "Henryk Sienkiewicz";
oim.yearPublished = 1884;
oim.publisher = "KWE";
db.AddBook(oim);
Book oim2 = new Book();
oim2.title = "Ogniem i mieczem";
oim2.author = "Henryk Sienkiewicz";
oim2.yearPublished = 1884;
oim2.publisher = "KWE";
db.AddBook(oim2);
Assert.AreEqual(count + 2, db.CountBooks());
db.DeleteBook(oim2.book_ID);
db.DeleteBook(oim.book_ID);
}
}
public bool RemoveBook(int ID)
{
using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext())
{
Book book = dataContext.GetBook(ID);
if (book != null)
{
dataContext.DeleteBook(ID);
return(true);
}
else
{
return(false);
}
}
}
public bool DeleteBookByTitle(string title)
{
using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext())
{
Book book = dataContext.GetBook(title);
if (book != null)
{
dataContext.DeleteBook(book.book_ID);
return(true);
}
else
{
return(false);
}
}
}
public void RemoveBook()
{
using (LinqLibraryDataContext db = new LinqLibraryDataContext(m_ConnectionString))
{
Book book2 = new Book();
book2.title = "Dziady";
book2.author = "Adam Mickiewicz";
book2.yearPublished = 1834;
book2.publisher = "greg";
db.AddBook(book2);
int count = db.CountBooks();
Book someBook = db.GetBook("Dziady");
Assert.IsNotNull(someBook);
db.DeleteBook(book2.book_ID);
Assert.AreEqual(count - 1, db.CountBooks());
}
}