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