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