// Function for the reverse alphabetical display
public void RestaurantReverseAlphabeticalStart()
{
string cs = @"server=127.0.0.1;userid=dbremoteuser;password=password;database=SampleRestaurantDatabase;port=8889";
MySqlConnection conn = null;
try
{
//create new lists to store the values
List <string> restaurantNames = new List <string>();
List <decimal> overallRating = new List <decimal>();
conn = new MySqlConnection(cs);
conn.Open();
//append the returned list from the private methods into these lists
restaurantNames.AddRange(GetRestaurantNameDESC(conn));
overallRating.AddRange(GetOverallRatingDESC(conn));
//reverse the values of the lists to accomodate reverse alphabetical
restaurantNames.Reverse();
overallRating.Reverse();
for (int i = 0; i < 100; i++)
{
decimal rating = overallRating[i];
string restNumber = (100 - i) + ". ";
Console.WriteLine("=============================================" +
"=========================");
Console.Write("{0, 5}", restNumber);
Console.Write("{0, 5}", restaurantNames[i]);
Console.Write("{0, 10}", "Rating: ");
Console.WriteLine(DrawStars.DrawStarsStart(rating));
if (i == 99)
{
Console.WriteLine("=============================================" +
"=========================");
}
}
Console.WriteLine("Please enter return key to go back to menu...");
}
catch (MySqlException error)
{
Console.WriteLine("Error: {0}", error.ToString());
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
public static void ShowUnratedStart()
{
string cs = @"server=127.0.0.1;userid=dbremoteuser;password=password;database=SampleRestaurantDatabase;port=8889";
MySqlConnection conn = null;
try
{
conn = new MySqlConnection(cs);
conn.Open();
decimal overallRating = 0.00m;
//create a new list that stores the overall rating
List <decimal> overallRatingList = new List <decimal>();
//loops and adds the overall rating to the list
for (int i = 0; i < 3; i++)
{
string stm = "SELECT OverallRating " +
"FROM RestaurantProfiles " +
"WHERE OverallRating IS NULL OR " +
"OverallRating BETWEEN 0 AND 0.49 " +
"ORDER BY OverallRating ASC";
MySqlCommand cmd = new MySqlCommand(stm, conn);
MySqlDataReader rdr1 = cmd.ExecuteReader();
while (rdr1.Read())
{
decimal.TryParse(rdr1["OverallRating"].ToString(),
out overallRating);
decimal roundedRating = Math.Round(overallRating, 0,
MidpointRounding.AwayFromZero);
overallRatingList.Add(roundedRating);
}
rdr1.Close(); //close the reader
}
//create a new list that stores the names of each restaurant
List <string> restaurantNameList = new List <string>();
for (int j = 0; j < 3; j++)
{
//select the restaurant name based on overall rating ASC
string stm2 = "SELECT RestaurantName " +
"FROM RestaurantProfiles " +
"WHERE OverallRating IS NULL OR " +
"OverallRating BETWEEN 0 AND 0.49 " +
"ORDER BY OverallRating ASC";
MySqlCommand cmd2 = new MySqlCommand(stm2, conn);
MySqlDataReader rdr2 = cmd2.ExecuteReader();
while (rdr2.Read())
{
restaurantNameList.Add(rdr2["RestaurantName"].ToString());
}
rdr2.Close(); //close the reader
}
for (int i = 0; i < 3; i++)
{
decimal rating = overallRatingList[i];
string restNumber = (i + 1) + ". ";
Console.WriteLine("=============================================" +
"=========================");
Console.Write("{0, 5}", restNumber);
Console.Write("{0, 5}", restaurantNameList[i]);
Console.Write("{0, 10}", "Rating: ");
Console.WriteLine(DrawStars.DrawStarsStart(rating));
if (i == 2)
{
Console.WriteLine("=============================================" +
"=========================");
}
}
Console.WriteLine("Please enter return key to go back to menu...");
}
catch (MySqlException error)
{
Console.WriteLine("Error: {0}", error.ToString());
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}