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