public void Save() { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO bands (band_name) VALUES (@bandName);"; MySqlParameter bandName = new MySqlParameter(); bandName.ParameterName = "@bandName"; bandName.Value = this._bandName; cmd.Parameters.Add(bandName); cmd.ExecuteNonQuery(); _id = (int)cmd.LastInsertedId; conn.Close(); if (conn != null) { conn.Dispose(); } }
public List <Band> GetBands() { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT bands.* FROM venue JOIN bands_venues ON ( venue.id = bands_venues.venue_id) JOIN bands ON ( bands_venues.band_id = bands.id) where venue.id = @venueId;"; MySqlParameter venueId = new MySqlParameter(); venueId.ParameterName = "@venueId"; venueId.Value = _id; cmd.Parameters.Add(venueId); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; List <Band> Bands = new List <Band> { }; while (rdr.Read()) { int id = rdr.GetInt32(0); string name = rdr.GetString(1); string song = rdr.GetString(2); Band MyBand = new Band(name, song, id); Bands.Add(MyBand); } conn.Close(); if (conn != null) { conn.Dispose(); } return(Bands); }
public static Venue Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM venues WHERE id = (@searchId);"; MySqlParameter searchId = new MySqlParameter(); searchId.ParameterName = "@searchId"; searchId.Value = id; cmd.Parameters.Add(searchId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int venueId = 0; string venueName = ""; while (rdr.Read()) { venueId = rdr.GetInt32(0); venueName = rdr.GetString(1); } // Constructor below no longer includes a itemCategoryId parameter: Venue newVenue = new Venue(venueName, venueId); conn.Close(); if (conn != null) { conn.Dispose(); } return(newVenue); }
public List <Venue> GetVenues() { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT venues.* FROM bands JOIN bands_venues ON (bands.id = bands_venues.band_id) JOIN venues ON (bands_venues.venue_id = venues.id) WHERE bands.id = @BandId;"; MySqlParameter venueIdParameter = new MySqlParameter(); venueIdParameter.ParameterName = "@BandId"; venueIdParameter.Value = _id; cmd.Parameters.Add(venueIdParameter); var rdr = cmd.ExecuteReader() as MySqlDataReader; List <Venue> venues = new List <Venue> { }; while (rdr.Read()) { int venueId = rdr.GetInt32(0); string venueName = rdr.GetString(1); Venue newVenue = new Venue(venueName, venueId); venues.Add(newVenue); } conn.Close(); if (conn != null) { conn.Dispose(); } return(venues); }