protected static void GetRandomMovieAndRate() { var random = new Random(); using var conn = new MySqlConnection(ConnStr); conn.Open(); const string sql = "SELECT COUNT(*) FROM movies_tbl"; using var cmd = new MySqlCommand(sql, conn); var count = cmd.ExecuteScalar(); var rand = random.Next(1, int.Parse(count.ToString() !)); var l = 0; while (CheckIfRated(rand.ToString())) { rand = random.Next(1, int.Parse(count.ToString() !)); if (l + 1 == int.Parse(count.ToString() !)) { Console.WriteLine("you have rate every movie"); break; } l++; } Movie randomMovie = GetShowFromIndex(rand.ToString()); Console.WriteLine("Show Selected '{0}'", randomMovie.MovieName); Console.WriteLine($"what would you rate the selected show?(max. 10) "); var rating = Console.ReadLine(); while (int.Parse(rating !) > 10) { Console.WriteLine("what would you rate the selected show?(max. 10)"); rating = Console.ReadLine(); } RateShow.Rate(rand.ToString(), rating); Console.WriteLine($"You rerate '{randomMovie.MovieName}' {rating}/10"); Console.ReadKey(); }
protected static void GetSearchResAndRate(string term) { var titles = new List <string>(); var ratings = new List <string>(); var ids = new List <string>(); var sql = "SELECT * FROM movies_tbl WHERE movie_name LIKE" + "'%" + term + "%'" + ""; using var conn = new MySqlConnection(ConnStr); conn.Open(); using var cmd = new MySqlCommand(sql, conn); using var rdr = cmd.ExecuteReader(); while (rdr.Read()) { titles.Add(rdr.GetString(1)); ratings.Add(rdr.GetString(3)); ids.Add(rdr.GetString(0)); } for (var i = 0; i < titles.Count; i++) { Console.WriteLine(CheckIfRated(ids[i]) ? $"{i + 1}) {titles[i]} | Rating : {ratings[i]}/10 | your Rating ?/10" : $"{i + 1}) {titles[i]} | Rating : {ratings[i]}/10"); } Console.WriteLine("-------------------------------"); Console.WriteLine("Would you like to rate/add to your list one of the shows?(y/n)"); if (Console.ReadLine()?.ToLower() == "y") { try { Console.WriteLine("input the index"); var z = int.Parse(Console.ReadLine() ?? string.Empty); if (CheckIfRated((ids[z - 1]))) { Console.WriteLine( "what would you rate '{0}'? (max Rating = 10) Note : you've already review this show this actions will simply update your score", titles[z - 1]); var rating = Console.ReadLine(); RateShow.RateUpdate(ids[z - 1], rating); Console.WriteLine($"You rated '{titles[z - 1]}' {rating}/10"); Console.ReadKey(); } else { Console.WriteLine("what would you rate '{0}'? (max Rating = 10)", titles[z - 1]); var rating = Console.ReadLine(); RateShow.Rate(ids[z - 1], rating); Console.WriteLine($"You rated '{titles[z - 1]}' {rating}/10"); Console.ReadKey(); } } catch (ArgumentOutOfRangeException) { Console.WriteLine("bro.."); } } conn.Close(); }