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