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