public static List <Venues> GetAllVenuess() { List <Venues> allVenues = new List <Venues> { }; MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM Venues;"; var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int venuesId = rdr.GetInt32(0); string venuesName = rdr.GetString(1); string venuesLocation = rdr.GetString(2); Venues newVenues = new Venues(venuesName, venuesLocation, VenuesId); allVenues.Add(newVenues); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allVenues); }
public List <Venues> GetVenues() { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT venues.* FROM bands JOIN venuess_bands ON (venues.id=venuess_bands.Venues_id) JOIN bands ON (venues_bands.venues_id=bands.id) WHERE venues.id=@VenuesId;"; cmd.Parameters.Add(new MySqlParameter("@VenuesId", _id)); var rdr = cmd.ExecuteReader() as MySqlDataReader; List <Venues> venues = new List <Venues> { }; while (rdr.Read()) { int venuesId = rdr.GetInt32(0); string venuesName = rdr.GetString(1); Venues newVenues = new Venues(venuesName, venuesId); venues.Add(newVenues); } conn.Close(); if (conn != null) { conn.Dispose(); } return(venues); }
public static Venues Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM Venuess WHERE id = (@searchId);"; MySqlParameter searchId = new MySqlParameter(); searchId.ParameterVenuesName = "@searchId"; searchId.Value = id; cmd.Parameters.Add(searchId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int venuesId = 0; string venuesName = ""; string venueslocation = ""; while (rdr.Read()) { venuesId = rdr.GetInt32(0); venuesVenuesName = rdr.GetString(1); venueslocation = rdr.GetString(2); } Venues newVenues = new Venues(venuesName, venueslocation, venuesId); conn.Close(); if (conn != null) { conn.Dispose(); } return(newVenues); }
public override bool Equals(System.Object otherVenues) { if (!(otherVenues is Venues)) { return(false); } else { Venues newVenues = (Venues)otherVenues; bool idEquality = this.GetId() == newVenues.GetId(); bool venuesNameEquality = this.GetVenuesName() == newVenues.GetVenuesName(); bool locationEquality = this.GetLocation() == newVenues.GetLocation(); return(idEquality && venuesNameEquality && locationEquality); } }
public void AddVenues(Venues newVenues) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO venuess_bands (venues_id, band_id) VALUES (@venuesId, @bandId);"; cmd.Parameters.Add(new MySqlParameter("@venuesId", _id)); cmd.Parameters.Add(new MySqlParameter("@bandId", newBand.GetId())); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }