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);"; MySqlParameter BandId = new MySqlParameter(); BandId.ParameterName = "@BandId"; BandId.Value = _id; cmd.Parameters.Add(BandId); MySqlParameter VenueId = new MySqlParameter(); VenueId.ParameterName = "@VenueId"; VenueId.Value = newVenue.GetId(); cmd.Parameters.Add(VenueId); cmd.ExecuteNonQuery(); conn.Close(); }
public void AddVenue(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); var 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.GetId(); 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 void DeleteVenueFromBand(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"DELETE FROM bands_venues WHERE band_id = @BandId AND venue_id = @VenueId;"; MySqlParameter bandId = new MySqlParameter(); bandId.ParameterName = "@BandId"; bandId.Value = _id; cmd.Parameters.Add(bandId); MySqlParameter venueId = new MySqlParameter(); venueId.ParameterName = "@VenueId"; venueId.Value = newVenue.GetId(); cmd.Parameters.Add(venueId); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddToPerformance(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO performances(band_id, venue_id, date) VALUES (@bandId, @venueId,@date);"; MySqlParameter bandIdParameter = new MySqlParameter(); bandIdParameter.ParameterName = "@bandId"; bandIdParameter.Value = this._id; cmd.Parameters.Add(bandIdParameter); MySqlParameter venueIdParameter = new MySqlParameter(); venueIdParameter.ParameterName = "@venueId"; venueIdParameter.Value = newVenue.GetId(); cmd.Parameters.Add(venueIdParameter); MySqlParameter dateParameter = new MySqlParameter(); dateParameter.ParameterName = "@date"; dateParameter.Value = DateTime.Now; cmd.Parameters.Add(dateParameter); 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; return(this.GetId().Equals(newVenue.GetId())); } }
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 venueNameEquality = (this.GetVenueName() == newVenue.GetVenueName()); return(idEquality && venueNameEquality); } }
public override bool Equals(Object otherVenue) { if (!(otherVenue is Venue)) { return(false); } else { Venue band = (Venue)otherVenue; bool idEquality = _id == band.GetId(); bool nameEquality = _name == band.GetName(); return(idEquality && nameEquality); } }
public override bool Equals(Object otherVenue) { if (!(otherVenue is Venue)) { return(false); } else { Venue newVenue = (Venue)otherVenue; bool idEquality = this._id == newVenue.GetId(); bool nameEquality = this._name == newVenue.GetName(); return(idEquality && nameEquality); } }
public override bool Equals(Object otherVenue) { if (!(otherVenue is Venue)) { return(false); } else { Venue newVenue = (Venue)otherVenue; bool idEquality = newVenue.GetId() == this._id; bool nameEquality = newVenue.GetName() == this._name; bool addressEquality = newVenue.GetAddress() == this._address; return(idEquality && nameEquality && addressEquality); } }
public override bool Equals(System.Object otherVenue) { if (!(otherVenue is Venue)) { return(false); } else { Venue newVenue = (Venue)otherVenue; bool idEquality = (this.GetId() == newVenue.GetId()); //when we change an object from one type to another, its called "TYPE CASTING" bool nameEquality = (this.GetName() == newVenue.GetName()); return(idEquality && nameEquality); } }
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(); bool addressEquality = this.GetAddress() == newVenue.GetAddress(); bool capacityEquality = this.GetCapacity() == newVenue.GetCapacity(); return(idEquality && nameEquality && addressEquality && capacityEquality); } }
public void AddVenue(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = "INSERT INTO gigs (band_id, venue_id) VALUES (@BandId, @VenueId);"; cmd.Parameters.Add(new MySqlParameter("@BandId", this.GetId())); cmd.Parameters.Add(new MySqlParameter("@VenueId", newVenue.GetId())); 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.GetId() == newVenue.GetId(); bool nameEquality = this.GetName() == newVenue.GetName(); bool descriptionEquality = this.GetDescription() == newVenue.GetDescription(); bool locationEquality = this.GetLocation() == newVenue.GetLocation(); bool capacityEquality = this.GetCapacity() == newVenue.GetCapacity(); return(idEquality && nameEquality && descriptionEquality && locationEquality && capacityEquality); } }
public void AddVenue(Venue newVenue) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO venues_bands (venue_id, band_id) VALUES (@venueId, @bandId);"; cmd.Parameters.Add(new MySqlParameter("@bandId", _id)); cmd.Parameters.Add(new MySqlParameter("@venueId", newVenue.GetId())); cmd.ExecuteNonQuery(); _id = (int)cmd.LastInsertedId; conn.Close(); if (conn != null) { conn.Dispose(); } }