public void Dispose()
{
Authors.DeleteAll();
Copies.DeleteAll();
Patrons.DeleteAll();
Books.DeleteAll();
}
public static List <Patrons> GetAll()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM patrons", conn);
SqlDataReader rdr = cmd.ExecuteReader();
List <Patrons> Patrons = new List <Patrons> {
};
while (rdr.Read())
{
int id = rdr.GetInt32(0);
string name = rdr.GetString(1);
Patrons newPatrons = new Patrons(name, id);
Patrons.Add(newPatrons);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(Patrons);
}
public static Patrons Find(int idToFind)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM patrons WHERE id = @PatronsId", conn);
SqlParameter idParam = new SqlParameter("@PatronsId", idToFind);
cmd.Parameters.Add(idParam);
SqlDataReader rdr = cmd.ExecuteReader();
int id = 0;
string name = null;
while (rdr.Read())
{
id = rdr.GetInt32(0);
name = rdr.GetString(1);
}
Patrons foundPatrons = new Patrons(name, id);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(foundPatrons);
}
public void Patrons_AddCopies_AddsCopiesToPatron()
{
Patrons newPatron = new Patrons("Jenny", 1);
newPatron.Save();
Books newBooks = new Books("Of Mice and Men", 1);
newBooks.Save();
Copies newCopies1 = new Copies(1, DateTime.Now, 1);
newCopies1.Save();
Copies newCopies2 = new Copies(1, DateTime.Now, 1);
newCopies2.Save();
newCopies1.AddPatrons(newPatron);
newCopies2.AddPatrons(newPatron);
List <Patrons> testList = newCopies1.GetPatronCopies();
List <Patrons> controlList = new List <Patrons> {
newPatron
};
Assert.Equal(controlList, testList);
}
public List <Patrons> GetPatronCopies()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT patrons.* FROM copies JOIN patrons_copies ON (copies.id = patrons_copies.copies_id) JOIN patrons ON (patrons.id = patrons_copies.patrons_id) WHERE copies.id = @CopiesId;", conn);
SqlParameter BookParameter = new SqlParameter("@CopiesId", this.GetId());
cmd.Parameters.Add(BookParameter);
List <Patrons> AllPatrons = new List <Patrons> {
};
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int id = rdr.GetInt32(0);
string copiesId = rdr.GetString(1);
Patrons newPatrons = new Patrons(copiesId, id);
AllPatrons.Add(newPatrons);
}
if (conn != null)
{
conn.Close();
}
if (rdr != null)
{
rdr.Close();
}
return(AllPatrons);
}
public void Patrons_Equals_PatronsEqualsPatrons()
{
Patrons controlPatrons = new Patrons("Jenny");
Patrons testPatrons = new Patrons("Jenny");
Assert.Equal(controlPatrons, testPatrons);
}
public void Copies_AddBook_AddCopiesToPatrons()
{
Copies newCopies = new Copies(1, DateTime.Now, 1);
newCopies.Save();
Books newBook = new Books("Of mice and men", 1);
newBook.Save();
Patrons newPatrons1 = new Patrons("Jerry");
newPatrons1.Save();
Patrons newPatrons2 = new Patrons("Jerry");
newPatrons2.Save();
newCopies.AddPatrons(newPatrons1);
newCopies.AddPatrons(newPatrons2);
List <Patrons> testList = newCopies.GetPatronCopies();
List <Patrons> controlList = new List <Patrons> {
newPatrons1, newPatrons2
};
Assert.Equal(controlList, testList);
}
public void Copies_AddBook_AddCopiesToPatrons()
{
Copies newCopies = new Copies(1);
newCopies.Save();
Books newBook = new Books("Of mice and men", "John Steinbeck", new DateTime(2017, 05, 06), 1);
newBook.Save();
Patrons newPatrons1 = new Patrons("Jerry", 1);
newPatrons1.Save();
Patrons newPatrons2 = new Patrons("Jerry", 2);
newPatrons2.Save();
// Console.WriteLine(newCopies.GetId());
// Console.WriteLine(testCopies.GetId());
newCopies.AddPatrons(newPatrons1);
newCopies.AddPatrons(newPatrons2);
List <Patrons> testList = newCopies.GetPatronCopies();
List <Patrons> controlList = new List <Patrons> {
newPatrons1, newPatrons2
};
Assert.Equal(controlList, testList);
}
public void Patrons_GetAll_DatabaseEmptyOnload()
{
List <Patrons> testList = Patrons.GetAll();
List <Patrons> controlList = new List <Patrons> {
};
Assert.Equal(controlList, testList);
}
public void Patrons_Find_FindsPatronsInDB()
{
Patrons controlPatrons = new Patrons("Jenny");
controlPatrons.Save();
Patrons testPatrons = Patrons.Find(controlPatrons.GetId());
Assert.Equal(controlPatrons, testPatrons);
}
public void Patrons_Save_SaveToDatabase()
{
Patrons newPatrons = new Patrons("Jenny");
newPatrons.Save();
Patrons testPatrons = Patrons.GetAll()[0];
Assert.Equal(newPatrons, testPatrons);
}
public override bool Equals(System.Object otherPatrons)
{
if (!(otherPatrons is Patrons))
{
return(false);
}
else
{
Patrons newPatrons = (Patrons)otherPatrons;
bool nameEquality = this.GetName() == newPatrons.GetName();
bool idEquality = this.GetId() == newPatrons.GetId();
return(nameEquality && idEquality);
}
}
public void AddPatrons(Patrons newPatrons)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO patrons_copies (patrons_id, copies_id) OUTPUT INSERTED.id VALUES (@PatronsId, @CopiesId);", conn);
SqlParameter patronsIdParam = new SqlParameter("@PatronsId", newPatrons.GetId());
SqlParameter copiesIdParam = new SqlParameter("@CopiesId", this.GetId());
cmd.Parameters.Add(patronsIdParam);
cmd.Parameters.Add(copiesIdParam);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public HomeModule()
{
Get["/"] = _ => {
return(View["index.cshtml"]);
};
Post["/"] = _ => {
Patrons newPatron = new Patrons(Request.Form["new-user"]);
newPatron.Save();
return(View["index.cshtml"]);
};
Post["/catalog"] = _ => {
Dictionary <string, object> newDictionary = new Dictionary <string, object>();
List <Books> allBooks = Books.GetAll();
// Patrons test = Patrons.login("Hunter");
Patrons newPatrons = Patrons.login(Request.Form["user-name"]);
newDictionary.Add("allBooks", allBooks);
newDictionary.Add("user", newPatrons);
// Have a user error message on other page if user incorrectly entered a name
return(View["catalog.cshtml", newDictionary]);
};
}
public void Copies_Delete_DeleteSingleCopy()
{
Patrons newPatrons = new Patrons("David", 1);
newPatrons.Save();
Books newBook = new Books("Of mice and men", 1);
newBook.Save();
Copies newCopies = new Copies(1, DateTime.Now, 1);
newCopies.Save();
newCopies.AddPatrons(newPatrons);
newCopies.Delete();
List <Copies> testCopies = Copies.GetAll();
List <Copies> controlCopies = new List <Copies> {
};
Assert.Equal(controlCopies, testCopies);
}
