// //Create method for 'join' table public void AddVenuesToBand(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO venues_bands (venue_id, band_id) VALUES (@VenueId, @BandId);"; MySqlParameter venue_id = new MySqlParameter(); venue_id.ParameterName = "@VenueId"; venue_id.Value = newVenue.GetVenueId(); cmd.Parameters.Add(venue_id); MySqlParameter band_id = new MySqlParameter(); band_id.ParameterName = "@BandId"; band_id.Value = _id; cmd.Parameters.Add(band_id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherVenue) { if (!(otherVenue is Venue)) { return(false); } else { Venue newVenue = (Venue)otherVenue; bool idEquality = (this.GetVenueId() == newVenue.GetVenueId()); bool venueNameEquality = (this.GetVenueName() == newVenue.GetVenueName()); return(idEquality && venueNameEquality); } }
public void AddVenue(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO bands_venues (band_id, venue_id) VALUES (@bandId, @venueId);"; cmd.Parameters.Add(new MySqlParameter("@venueId", newVenue.GetVenueId())); cmd.Parameters.Add(new MySqlParameter("@bandId", _id)); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }