public void GetReaderID() { using (LinqLibraryDataContext rep = new LinqLibraryDataContext(m_ConnectionString)) { rep.AddUser("oh", "no"); Reader oh = rep.GetReader("oh", "no"); Reader no = rep.GetReader(oh.reader_ID); Assert.AreEqual(no.reader_ID, oh.reader_ID); Assert.AreEqual(no.reader_firstName, oh.reader_firstName); rep.DeleteUser(oh.reader_ID); } }
public void TestUpdateUser() { using (LinqLibraryDataContext rep = new LinqLibraryDataContext(m_ConnectionString)) { rep.AddUser("airzile", "pods"); Reader airZile = rep.GetReader("airzile", "pods"); rep.UpdateUserName(airZile.reader_ID, "Stu"); rep.UpdateUserSurname(airZile.reader_ID, "GizzardLizardWizard"); airZile = rep.GetReader(airZile.reader_ID); Assert.AreEqual("Stu", airZile.reader_firstName); Assert.AreEqual(airZile.reader_surname, rep.GetReader(airZile.reader_ID).reader_surname); rep.DeleteUser(airZile.reader_ID); } }
public void AddAndDeleteUser() { using (LinqLibraryDataContext rep = new LinqLibraryDataContext(m_ConnectionString)) { rep.AddUser("unexpected", "name"); Reader r = rep.GetReader("unexpected", "name"); Assert.IsNotNull(r); rep.DeleteUser(r.reader_ID); } }
public void RemoveReader() { using (LinqLibraryDataContext db = new LinqLibraryDataContext(m_ConnectionString)) { db.AddUser("VeryUnusualName", "VeryUnusualName"); int count = db.CountReaders(); Reader whoIsHe = db.GetReader("VeryUnusualName", "VeryUnusualName"); db.DeleteUser(whoIsHe.reader_ID); Assert.AreEqual(count - 1, db.CountReaders()); } }
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 CreateReader(Reader reader) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { if (reader != null && dataContext.GetReader(reader.reader_ID) == null) { dataContext.AddUser(reader.reader_firstName, reader.reader_surname); return(true); } return(false); } }
public bool DeleteReader(int ID) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { Reader reader = dataContext.GetReader(ID); if (reader != null) { dataContext.DeleteUser(ID); return(true); } return(false); } }
public bool UpdateReader(int ID, string name, string surname) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { if (dataContext.GetReader(ID) != null) { dataContext.UpdateUserName(ID, name); dataContext.UpdateUserSurname(ID, surname); return(true); } return(false); } }
public bool UpdateSurname(int id, string s) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { if (dataContext.GetReader(id) == null) { return(false); } else { dataContext.UpdateUserSurname(id, s); return(true); } } }
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); } }
public IEnumerable <Event> GetEventByUserData(string name, string surname) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { List <Event> toBeReturned = new List <Event>(); Reader r = dataContext.GetReader(name, surname); if (r != null) { foreach (Event e in dataContext.GetAllEvents()) { if (e.reader == r.reader_ID) { toBeReturned.Add(e); } } } return(toBeReturned); } }
public IEnumerable <EventDTO> GetEventByUser(string name, string surname) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { Reader h = dataContext.GetReader(name, surname); List <Event> evvv = new List <Event>(); foreach (Event e in evvv) { if (e.reader == h.reader_ID) { evvv.Add(e); } } List <EventDTO> toReturn = new List <EventDTO>(); foreach (Event e in evvv) { toReturn.Add(ToDTO(e)); } return(toReturn); } }