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