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