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