// Methods private void Activity() { Console.Clear(); Console.WriteLine("Select an activity category using the number"); Console.WriteLine(); // Show the data _data = new DataCon("Select category_description From activity_categories", 1); Console.WriteLine("31. Back"); temp = Console.ReadLine(); cat = Validation.IntVal(temp); if (cat == 31) { Console.Clear(); // Go back to main menu Selection(); } else { Console.Clear(); // Show What was selected to the user Console.Write("You selected "); _data = new DataCon($"Select category_description From activity_categories Where activity_category_id = {cat}", 1); Console.WriteLine("Press enter to chose your activity description"); Console.ReadKey(); // Go to the next method ActDescription(); } }
private void ActDescription() { Console.Clear(); Console.WriteLine("Select an activity description using the number"); Console.WriteLine(); // Show the data _data = new DataCon("Select activity_description From activity_descriptions", 1); Console.WriteLine("40. Back"); // Save the data to a variable temp = Console.ReadLine(); des = Validation.IntVal(temp); if (des == 40) { Console.Clear(); // Go back to the last method Activity(); } else { Console.Clear(); // Show what the user selected Console.Write("You selected "); _data = new DataCon($"Select activity_description From activity_descriptions Where activity_description_id = {des}", 1); Console.WriteLine("Press enter to continue "); Console.ReadKey(); // Go to the next method DayName(); } }
private void ActTime() { Console.Clear(); Console.WriteLine("Select a time using the number"); Console.WriteLine(); // Show the data _data = new DataCon("Select time_spent_on_activity From activity_times", 1); Console.WriteLine("97. Back"); // Save the data into a variable temp = Console.ReadLine(); time = Validation.IntVal(temp); if (time == 97) { Console.Clear(); // Go back to the last method DateChoice(); } else { Console.Clear(); // Show the user what they selected Console.Write("You selected "); _data = new DataCon($"Select time_spent_on_activity From activity_times Where activity_time_id = {time}", 1); Console.WriteLine("Press enter to continue "); Console.ReadKey(); } Console.Clear(); // Save all the collected data into the database _data = new DataCon("Insert Into activity_log(user_id, calendar_day, calendar_date, day_name, category_description, activity_description, time_spent_on_activity)" + $"Values(1, {dayNum}, {date}, {dayName}, {cat}, {des}, {time})", 3); //_data = new DataCon("Insert Into activity_log1(user_id, calendar_day, calendar_date, day_name, category_description, activity_description, time_spent_on_activity)" + // $"Values(1, 1, 1, 1, 1, 1, 1)", 3); Console.WriteLine("Press enter to continue"); Console.ReadKey(); Console.Clear(); Console.WriteLine("1. Enter Another Activity\n2. Back to Main Menu"); temp = Console.ReadLine(); int choice = Validation.IntVal(temp); if (choice == 1) { Activity(); } }
private void DateChoice() { Console.Clear(); Console.WriteLine("Select a date using the number"); Console.WriteLine(); // Show the data _data = new DataCon("Select calendar_date From tracked_calendar_dates", 2); Console.WriteLine("27. Back"); // Save the data in a variable temp = Console.ReadLine(); dayNum = Validation.IntVal(temp); date = Validation.IntVal(temp); if (date == 27) { Console.Clear(); // Go back to the last method DayName(); } else { Console.Clear(); // Show the user what they selected Console.Write("You selected "); _data = new DataCon($"Select calendar_date From tracked_calendar_dates Where calendar_date_id = {date}", 2); Console.WriteLine("Press enter to continue "); Console.ReadKey(); // Go to the next method ActTime(); } }
private void DayName() { Console.Clear(); Console.WriteLine("Select the day using the number"); Console.WriteLine(); // Show the data _data = new DataCon("Select day_name From days_of_the_week", 1); Console.WriteLine("8. Back"); // Save the data into a variable temp = Console.ReadLine(); dayName = Validation.IntVal(temp); if (dayName == 8) { Console.Clear(); // Go back to the last method ActDescription(); } else { Console.Clear(); // Show the user what they selected Console.Write("You selected "); _data = new DataCon($"Select day_name From days_of_the_week Where day_id = {dayName}", 1); Console.WriteLine("Press enter to continue "); Console.ReadKey(); // Go to the next method DateChoice(); } }
// 2nd set of Methods private void TrackedData() { // Create the method for TrackedData _myMenu = new Menu("Select By Date", "Select By Category", "Select By Description", "To Main Menu"); _myMenu.Title = "Search Menu"; while (running) { _myMenu.Display(); int selection = Validation.IntVal("Enter Selection"); switch (selection) { case 1: { Console.Clear(); // Show the data _data = new DataCon("Select calendar_date From tracked_calendar_dates", 2); // Save the data into a variable temp = Console.ReadLine(); date = Validation.IntVal(temp); Console.Clear(); //_data = new DataCon($"Select * From activity_log Where calendar_date = {date}", 1); // Show the data _data.MultipleReturn($"Select activity_log.category_description From activity_log Join activity_categories ON activity_log.category_description = activity_categories.activity_category_id Where calendar_date = {date}", 1); //_data.MultipleReturn($"Select activity_description From activity_log Join activity_descriptions ON activity_log.activity_description = activity_descriptions.activity_description_id Where calendar_date = {date}", 1); Console.ReadKey(); } break; case 2: { Console.Clear(); Console.ReadKey(); } break; case 3: { Console.Clear(); Console.ReadKey(); } break; case 4: { Selection(); //Application app = new Application(); } break; } } }