public void runRestaurantReviews() { bool running = true; string RestaurantProfiles = @"Select * from `RestaurantProfiles`;"; string menustring = " Hello user, How would you like to sort the data:\r\n" + "1. List Restaurants Alphabetically(Show Rating Next To Name)\r\n" + "2. List Restaurants in Reverse Alphabetical(Show Rating Next To Name)\r\n" + "3. Sort Restaurants From Best to Worst(Show Rating Next To Name)\r\n" + "4. Sort Restaurants From Worst to Best(Show Rating Next To Name)\r\n" + "5. Show Only X stars and Up\r\n" + "6. Exit \r\n"; string menuSub = "" + "1. Show the Best(5 Stars)\r\n" + "2. Show 4 Stars and Up\r\n" + "3. Show 3 Stars and Up\r\n" + "4. Show the Worst(1 Stars)\r\n" + "5. Show Unrated\r\n" + "6. Back\r\n" + "7. Exit \r\n"; do { Console.ForegroundColor = ConsoleColor.Blue; Console.Clear(); int selection = Validations.GetInt(menustring + "Make A Selection 1 through 5 : "); Console.ForegroundColor = ConsoleColor.Gray; switch (selection) { case 1: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles order by RestaurantName ASC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); }; break; case 2: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles order by RestaurantName DESC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 3: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles order by OverallRating DESC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 4: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles order by OverallRating ASC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 5: { int selectionSub = Validations.GetInt(menuSub + "Make A Selection 1 through 7 : "); switch (selectionSub) { case 1: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles where OverallRating >= 4.50 order by OverallRating DESC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 2: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles where OverallRating >= 3.50 order by OverallRating DESC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 3: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles where OverallRating >= 2.50 order by OverallRating DESC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 4: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles where OverallRating <= 1.49 and OverallRating >=.50 order by OverallRating DESC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 5: { RestaurantProfiles = @"Select RestaurantName, OverallRating from RestaurantProfiles where OverallRating <=> 0.00 or OverallRating <=> NULL order by OverallRating DESC ;"; List <RestaurantsReviews> reviews = ReviewsQuery(RestaurantProfiles); RestaurantsReviews.ColorStarPrinter(reviews); } break; case 6: { } break; case 7: { running = false; } break; default: { Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("YOU BROKE ME"); } break; } } break; case 6: { running = false; } break; default: { } break; } Utility.Pause("PRESS R TO CONTINUE"); } while (running); }
public void runRestaurantReveiws() { //Database Location //string cs = @"server= 127.0.0.1;userid=root;password=root;database=SampleRestaurantDatabase;port=8889"; //Output Location //string _directory = @"../../output/"; bool running = true; string RestaurantProfiles = @"Select * from `RestaurantProfiles`;"; string RestaurantReviewers = @"Select * from RestaurantReviewers;"; string RestaurantReviews = @"Select * from RestaurantReviews;"; string collection = "Reataurant Profiles"; MySqlConnection conn = _conn(); string capture; string message = $"Welcome to the restaurant reviews \r\nPlease select which file you want to convert \r\n \r\n" + $"Enter 1. Restaurant Profiles\r\n" + $"Enter 2. Restaurant Reviewers\r\n" + $"Enter 3. Restaurant Reviews \r\n" + $"Enter 4. Exit Program\r\n" + $"Your Entry :"; do { Console.Clear(); string selection = Validations.Words(message, 3, 1, false); switch (selection.ToLower()) { case "1": case "restaurant profiles": { capture = GetRestaurantInfo(conn, RestaurantProfiles, collection); Writer(capture, "restaurantProfiles.json"); Console.WriteLine("Restaurant Profiles has been converted to Json"); Utility.Pause(); }; break; case "2": case "restaurant reviewers": { capture = GetRestaurantInfo(conn, RestaurantReviewers, "Restaurant Reviewers"); Writer(capture, "restaurantReviewers.json"); Console.WriteLine("Restaurant Reviewers has been converted to Json"); Utility.Pause(); }; break; case "3": case "restaurant reviews": { capture = GetRestaurantInfo(conn, RestaurantReviews, "Restaurant Reviews"); Writer(capture, "restaurantReviews.json"); Console.WriteLine("Restaurant Reviews has been converted to Json"); Utility.Pause(); }; break; case "4": case "exit program": { running = false; } break; default: { Console.WriteLine("Invalid Entry "); Utility.Pause(); } break; } } while (running); }
static void Main(string[] args) { int score; int selection; bool running = true; do { Utility.Pause(); string memu = "Hello Admin, What Would You Like To Do Today?\r\n" + "1. Convert The Restaurant Profile Table From SQL To JSON\r\n" + "2.Showcase Our 5 Star Rating System\r\n" + "3.Showcase Our Animated Bar Graph Review System\r\n" + "4.Play A Card Game\r\n" + "5.Exit\r\n"; selection = Validations.GetInt(1, 100, memu + "Enter Your Numbered Selection : "); switch (selection) { case 1: { restaurantReviewsData Restaurant = new restaurantReviewsData(); Restaurant.runRestaurantReveiws(); } break; case 2: { Console.ForegroundColor = ConsoleColor.DarkYellow; RestaurantReviewsDisplay restaurant = new RestaurantReviewsDisplay(); restaurant.runRestaurantReviews(); } break; case 3: { AnimatedBarGraph animation = new AnimatedBarGraph(); string mess = "What would you like to do? \r\n1. Show Average of Reviews for Restaurants\r\n2. Dinner Spinner\r\n3. Top 10 Restaurants"; int i = 1; int d = Validations.GetInt(mess + "\r\nPlease enter your selection. : "); RestaurantReviewGraphs[] Graphs = restaurantReviewsData.ReviewGraphs(); List <RestaurantReviewGraphs> _graphs = new List <RestaurantReviewGraphs>(); switch (d) { case 1: { Graphs = restaurantReviewsData.ReviewGraphs(); foreach (RestaurantReviewGraphs reviewAvg in Graphs) { Console.WriteLine(i + "\r\n"); reviewAvg.ToString(); if (i % 10 == 0) { Utility.Pause("Press Space Bar to See the Next 10 : "); } i++; } Utility.Pause(); } break; case 2: { _graphs = restaurantReviewsData.ReviewedGraphs(); foreach (RestaurantReviewGraphs reviewAvg in _graphs) { Console.WriteLine(i + "\r\n"); reviewAvg.ToString(); if (i % 10 == 0) { Utility.Pause("Press Space Bar to End : "); } i++; } } break; case 3: { _graphs = restaurantReviewsData.ReviewedGraphsTopTen(); foreach (RestaurantReviewGraphs reviewAvg in _graphs) { Console.WriteLine(i + "\r\n"); reviewAvg.ToString(); if (i % 10 == 0) { Utility.Pause("Press Space Bar to End : "); } i++; } } break; } Dictionary <int, RestaurantReviewGraphs[]> review = restaurantReviewsData.AllReviews(); } break; case 4: { bool runs = true; do { List <Players> currentPlayers = new List <Players>(); int playnum = 0; CardGame1 currentGame = new CardGame1(); int i = 1; List <Cards>[] allhands = currentGame.Deal(13, 4); foreach (List <Cards> hands in allhands) { score = currentGame.Score(hands); Players player = new Players(score, hands, i); currentPlayers.Add(player); i++; } foreach (Players player in currentPlayers) { Console.BackgroundColor = ConsoleColor.Black; Console.ForegroundColor = ConsoleColor.White; Console.WriteLine(player.ToString()); foreach (Cards card in player.Hand) { Console.Write(card.ToString()); Console.BackgroundColor = ConsoleColor.Black; Console.Write(" "); } Console.BackgroundColor = ConsoleColor.Black; Console.ForegroundColor = ConsoleColor.White; } currentGame.Results(currentPlayers); Utility.Pause("Hit Space Bar to Continue"); runs = Validations.GetBool("Do you want to play again? : "); } while (runs); } break; case 5: { running = false; } break; default: { Console.WriteLine("Program Unavailable or invalid selection"); Utility.Pause(); } break; } } while (running); }