public static void ConnectToSQL(string query) { // MySQL Database Connection String string cs = @"server=10.0.0.126;userid=root;password=root;database=RolandLupi_MDV229_Database_201910;port=8889"; // Declare a MySQL Connection MySqlConnection conn = null; try { // Open a connection to MySQL conn = new MySqlConnection(cs); conn.Open(); // Form SQL Statement string stm = query; // Prepare SQL Statement MySqlCommand cmd = new MySqlCommand(stm, conn); // Execute SQL Statement and Convert Results to a String string response = Convert.ToString(cmd); // Output Results MySqlDataReader reader = cmd.ExecuteReader(); int number = 1; while (reader.Read()) { if (query.Contains("activity_categories")) { Console.WriteLine($"[{number}]" + " " + reader["category_description"].ToString()); number++; } else if (query.Contains("activity_description")) { Console.WriteLine($"[{number}]" + " " + reader["activity_description"].ToString()); number++; } else if (query.Contains("tracked_calendar_dates")) { Console.WriteLine($"[{number}]" + " " + reader["tracked_calendar_dates"].ToString()); number++; } } Console.Write($"[{number}] Back To Previous Menu"); Console.Write("\n\n\nChoice: "); int mainMenuChoice = Validation.GetInt(1, number); } catch (MySqlException ex) //if error occurs, print error { Console.WriteLine("Error: {0}", ex.ToString()); Console.ReadLine(); } finally //close connection after action is complete { if (conn != null) { conn.Close(); } } }
static void Main(string[] args) { bool mainMenuRunning = true; while (mainMenuRunning) //main menu { Console.Write("" + "\n" + "What Would You Like To Do?" + "\n" + "\n" + "[1] Enter Activity" + "\n" + "[2] View Tracked Data" + "\n" + "[3] Run Calculations" + "\n" + "[4] Exit" + "\n" + "\n" + "\n" + "Choice: "); int userMenuChoice = Validation.GetInt(1, 4); bool activityMenu = true; while (userMenuChoice == 1) //activy option menu { Console.WriteLine("" + "\nPick A Category Of Activity:" + "\n"); ConnectToSQL("SELECT * FROM activity_categories;"); bool activitySub1 = true; while (activitySub1) //first sub menu in activity { Console.WriteLine("" + "\nPick An Activity Description:" + "\n"); ConnectToSQL("SELECT * FROM activity_descriptions;"); bool activitySub2 = true; while (activitySub2) //second sub menu in activity { Console.WriteLine("" + "\nWhat Date Did You Perform This Activity:" + "\n"); ConnectToSQL("SELECT * FROM tracked_calendar_dates;"); bool activitySub3 = true; while (activitySub3) //third sub menu in activity { bool activitySub4 = true; while (activitySub4) //fourth sub menu in activity { bool activitySub5 = true; while (activitySub5) { Console.Clear(); } Console.Clear(); } Console.Clear(); } Console.Clear(); } Console.Clear(); } Console.Clear(); } //------------------------------------------------------------------------------------------------------------------------------ bool trackedDataMenu = true; while (trackedDataMenu) //tracked data menu { bool trackedSub1 = true; while (trackedSub1) //tracked data sub menu 1 { bool trackedSub2 = true; while (trackedSub2) //tracked data 1 sub menu 1 { Console.Clear(); } Console.Clear(); } //----------------------------------------------------------------------- bool trackedSub3 = true; while (trackedSub3) //tracked data sub menu 1.0 { bool trackedSub4 = true; while (trackedSub4) //tracked data 1.0 sub menu 1 { Console.Clear(); } Console.Clear(); } //----------------------------------------------------------------------- bool trackedSub5 = true; while (trackedSub5) //tracked data sub menu 2.0 { bool trackedSub6 = true; //tracked data 2.0 sub 1 while (trackedSub6) { Console.Clear(); } Console.Clear(); } //---------------------------------------------------------------------- bool trackedExit = true; while (trackedExit) { Console.Clear(); } Console.Clear(); } //---------------------------------------------------------------------------------------------------------------------------------- bool runCalcMenu = true; while (runCalcMenu) //run calculations menu { Console.Clear(); } //---------------------------------------------------------------------------------------------------------------------------------- bool mainMenuExit = true; while (mainMenuExit) { Console.Clear(); } Console.Clear(); } }