private static void TopTenRestaurants()
{
//Initiates a MySQL connection and executes a MySQL command to search for two columns in a table, where a join is included to obtain reference data from another table
DataTable dt = new DataTable();
_ = new Database(Program.cs);
using (MySqlCommand cmd = new MySqlCommand("select rp.restaurantname,avg(rr.reviewscore) as average from restaurantprofiles rp join restaurantreviews rr on rp.id = rr.restaurantid where rr.reviewscore >= 70 group by rp.restaurantname desc limit 10", Database.con))
{
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (!string.IsNullOrWhiteSpace(reader["average"].ToString()))
{
Console.Write(reader["restaurantname"].ToString() + " ");
BarGraphs.DrawGraph(reader["average"].ToString());
Console.Write(" Average: " + reader["average"].ToString() + "%");
Console.WriteLine();
}
else
{
Console.Write(reader["restaurantname"].ToString() + " ");
BarGraphs.DrawGraph(reader["average"].ToString());
Console.Write("Average: N/A");
Console.WriteLine();
}
}
Database.con.Close();
}
}
private static void DinnerSpinner()
{
//Initiates a MySQL connection and executes a MySQL command to search for two columns in a table, where a specific row is equal to the given value
DataTable dt = new DataTable();
_ = new Database(Program.cs);
using (MySqlCommand cmd = new MySqlCommand("select rp.restaurantname,avg(rr.reviewscore) as average from restaurantprofiles rp join restaurantreviews rr on rp.id = rr.restaurantid group by rp.restaurantname order by rand() limit 1", Database.con))
{
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (!string.IsNullOrWhiteSpace(reader["average"].ToString()))
{
Console.Write(reader["restaurantname"].ToString() + " ");
BarGraphs.DrawGraph(reader["average"].ToString());
Console.Write(" Average: " + reader["average"].ToString() + "%");
Console.WriteLine();
}
else
{
Console.Write(reader["restaurantname"].ToString() + " ");
BarGraphs.DrawGraph(reader["average"].ToString());
Console.Write("Average: N/A");
Console.WriteLine();
}
}
Database.con.Close();
}
}