public void AddVenue(Venue newVenue)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO bands_venues (band_id, venue_id) VALUES (@BandId, @VenueId);", conn);
SqlParameter bandId = new SqlParameter();
bandId.ParameterName = "@BandId";
bandId.Value = this.GetId();
cmd.Parameters.Add(bandId);
SqlParameter venueId = new SqlParameter();
venueId.ParameterName = "@VenueId";
venueId.Value = newVenue.GetId();
cmd.Parameters.Add(venueId);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void Test_FindVenueIdInDatabase_band()
{
// Arrange
Venue newVenue = new Venue("Madison Square Garden");
newVenue.Save();
// Act
Venue result = Venue.Find(newVenue.GetId());
// Assert
Assert.Equal(newVenue, result);
}
// stops doubles between database and object
public override bool Equals(System.Object otherVenue)
{
if (!(otherVenue is Venue))
{
return(false);
}
else
{
Venue newVenue = (Venue)otherVenue;
bool idEquality = this.GetId() == newVenue.GetId();
bool nameEquality = this.GetName() == newVenue.GetName();
return(idEquality && nameEquality);
}
}