public bool CreateEvent(int userID, int bookID, DateTime when, bool is_Returning)
{
using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext())
{
if (dataContext.GetBook(bookID) != null && dataContext.GetReader(userID) != null)
{
dataContext.AddEvent(userID, bookID, when, is_Returning);
return(true);
}
return(false);
}
}
public bool BorrowBook(int user, int book)
{
using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext())
{
if (dataContext.GetReader(user) == null || dataContext.GetBook(book) == null)
{
return(false);
}
dataContext.AddEvent(user, book, DateTime.Now, false);
return(true);
}
}
public bool ReturnBook(int user, int book)
{
using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext())
{
foreach (EventDTO e in GetEventsByBook(book))
{
if (e.reader == user)
{
dataContext.AddEvent(user, book, DateTime.Now, true);
return(true);
}
}
return(false);
}
}
public void AddEvent()
{
using (LinqLibraryDataContext db = new LinqLibraryDataContext(m_ConnectionString))
{
Event newEvent = new Event();
newEvent.book = db.GetBook("The Warded Man").book_ID;
newEvent.reader = db.GetReader("Eliza", "Lech").reader_ID;
newEvent.Event_date = DateTime.Now;
newEvent.is_returning = false;
db.AddEvent(newEvent);
Event gotEvent = db.GetEvent(newEvent.event_ID);
Assert.AreEqual(newEvent.book, gotEvent.book);
Assert.AreEqual(newEvent.reader, gotEvent.reader);
Assert.AreEqual(newEvent.Event_date, gotEvent.Event_date);
}
}
