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