public void Patrons_Find_FindsPatronsInDB() { Patrons controlPatrons = new Patrons("Jenny"); controlPatrons.Save(); Patrons testPatrons = Patrons.Find(controlPatrons.GetId()); Assert.Equal(controlPatrons, 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(); } }