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