public static void DeleteAll()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM venues;", conn);
DB.CloseNonQuery(cmd, conn);
}
public void Delete()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM venues WHERE id = @VenueId; DELETE FROM venues_bands WHERE venue_id = @VenueId;", conn);
cmd.Parameters.Add(new SqlParameter("@VenueId", this.GetId()));
DB.CloseNonQuery(cmd, conn);
}
public void AddVenue(Venue newVenue)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO venues_bands (band_id, venue_id) VALUES (@BandId, @VenueId);", conn);
cmd.Parameters.Add(new SqlParameter("@BandId", this.GetId()));
cmd.Parameters.Add(new SqlParameter("@VenueId", newVenue.GetId()));
DB.CloseNonQuery(cmd, conn);
}