public static List <ActivityLog> AllActivities(string query) { List <ActivityLog> logOfActivity = new List <ActivityLog>(); DataTable logs = DatabaseConnection.queryDatabase(query); foreach (DataRow log in logs.Rows) { ActivityLog logger = new ActivityLog(); int.TryParse(log["id"].ToString(), out logger._activityID); int.TryParse(log["user_id"].ToString(), out logger._user_ID); int.TryParse(log["calendar_day"].ToString(), out logger._dateTime); int.TryParse(log["day_name"].ToString(), out logger._day_name); int.TryParse(log["category_description"].ToString(), out logger._category_description); int.TryParse(log["activity_description"].ToString(), out logger._activity_description); int.TryParse(log["time_spent_on_activity"].ToString(), out logger.time_spent_on); int.TryParse(log["calendar_date"].ToString(), out logger.calendar_date); logOfActivity.Add(logger); } return(logOfActivity); }
public static void MenuStart(int userName) { int UsersID = userName; string query; bool running = true; do { bool run = true; int selection = Validations.GetInt("1. Enter an Activity \r\n2. View Tracked Data\r\n3. Run Calculations"); int subSelection; string value; ActivityLog Activity = new ActivityLog(); Console.WriteLine(UsersID); switch (selection) { case 1: { do { Activity.User_ID = UsersID; query = @"select * from activity_categories ;"; DataTable table = DatabaseConnection.queryDatabase(query); Dictionary <int, string> keyValues = DatabaseConnection.DataList(table, "activity_category_id", "category_description"); DatabaseConnection.PrintDictionary(keyValues); subSelection = Validations.GetInt(); if (keyValues.TryGetValue(subSelection, out value)) { Activity.CatDescr = subSelection; } query = @"select * from activity_descriptions ;"; table = DatabaseConnection.queryDatabase(query); keyValues = DatabaseConnection.DataList(table, "activity_description_id", "activity_description"); DatabaseConnection.PrintDictionary(keyValues); subSelection = Validations.GetInt(); if (keyValues.TryGetValue(subSelection, out value)) { Activity.ActDescr = subSelection; } query = @"select * from days_of_week ;"; table = DatabaseConnection.queryDatabase(query); keyValues = DatabaseConnection.DataList(table, "day_id", "day_name"); DatabaseConnection.PrintDictionary(keyValues); subSelection = Validations.GetInt(); if (keyValues.TryGetValue(subSelection, out value)) { Activity.DayName = subSelection; } query = @"select * from tracked_calendar_days ;"; table = DatabaseConnection.queryDatabase(query); keyValues = DatabaseConnection.DataList(table, "calendar_day_id", "calendar_numerical_day"); DatabaseConnection.PrintDictionary(keyValues); subSelection = Validations.GetInt(); if (keyValues.TryGetValue(subSelection, out value)) { Activity.DateTime = subSelection; } query = @"select * from activity_times ;"; table = DatabaseConnection.queryDatabase(query); keyValues = DatabaseConnection.DataList(table, "activity_time_id", "time_spent_on_activity"); DatabaseConnection.PrintDictionary(keyValues); subSelection = Validations.GetInt(); if (keyValues.TryGetValue(subSelection, out value)) { Activity.TimeSpent = subSelection; } query = @"select * from tracked_calendar_dates ;"; table = DatabaseConnection.queryDatabase(query); keyValues = DatabaseConnection.DataList(table, "calendar_date_id", "calendar_date"); DatabaseConnection.PrintDictionary(keyValues); subSelection = Validations.GetInt(); if (keyValues.TryGetValue(subSelection, out value)) { Activity.CalendarDate = subSelection; } string queryadd = UsersID + " ," + Activity.ToString(); query = $@"INSERT INTO activity_log (user_id,calendar_day,day_name,category_description,activity_description,time_spent_on_activity,calendar_date) VALUES ({queryadd});"; Console.Write(query); DatabaseConnection.queryDataInsert(query); Utility.Pause(); run = Validations.GetBool("Do you want to add another activity? : "); } while (run); } break; case 2: { List <ActivityLog> activities = null; Activity.User_ID = UsersID; query = @"select * from activity_categories ;"; DataTable table = DatabaseConnection.queryDatabase(query); Dictionary <int, string> keyValues = DatabaseConnection.DataList(table, "activity_category_id", "category_description"); DatabaseConnection.PrintDictionary(keyValues); subSelection = Validations.GetInt(); if (keyValues.TryGetValue(subSelection, out value)) { Activity.DateTime = subSelection; string category = "category_description"; query = $@"Select * from activity_log where user_id = {userName} and {category} = {subSelection};"; activities = ActivityLog.AllActivities(query); } else { Console.WriteLine("Invalid Entry"); } List <Activities> descriptActivities = new List <Activities>(); foreach (ActivityLog log in activities) { int i = log.SetID; Activities activity = new Activities(i); descriptActivities.Add(activity); } foreach (Activities log in descriptActivities) { Console.WriteLine(log.ToString()); } Utility.Pause(); } break; case 3: { } break; case 4: { running = false; } break; default: { } break; } } while (running); }
public Activities(int id) : base() { _id = id; string query = $@"Select * from activity_log where id = {id};"; DataTable logs = DatabaseConnection.queryDatabase(query); foreach (DataRow log in logs.Rows) { ActivityLog logger = new ActivityLog(); int.TryParse(log["user_id"].ToString(), out user_id); int.TryParse(log["calendar_day"].ToString(), out calendar_day); int.TryParse(log["day_name"].ToString(), out day_name); int.TryParse(log["category_description"].ToString(), out category_description); int.TryParse(log["activity_description"].ToString(), out activity_description); int.TryParse(log["time_spent_on_activity"].ToString(), out time_spent_on_activity); int.TryParse(log["calendar_date"].ToString(), out calendar_date); } query = $@"Select * from time_tracker_users where user_id = {user_id};"; logs = DatabaseConnection.queryDatabase(query); foreach (DataRow row in logs.Rows) { _userName = $"{row["user_firstname"].ToString().Trim()} {row["user_lastname"].ToString().Trim()}"; } query = $@"Select * from tracked_calendar_days where calendar_day_id = {calendar_day};"; logs = DatabaseConnection.queryDatabase(query); foreach (DataRow row in logs.Rows) { _calendar_day = $"School Day : {row["calendar_numerical_day"].ToString().Trim()}"; } query = $@"Select * from tracked_calendar_dates where calendar_date_id = {calendar_date};"; logs = DatabaseConnection.queryDatabase(query); foreach (DataRow row in logs.Rows) { _calendar_date = $"{row["calendar_date"].ToString().Trim()}"; } query = $@"Select * from days_of_week where day_id = {day_name};"; logs = DatabaseConnection.queryDatabase(query); foreach (DataRow row in logs.Rows) { _day_of_week = $"{row["day_name"].ToString().Trim()}"; } query = $@"Select * from activity_times where activity_time_id = {time_spent_on_activity};"; logs = DatabaseConnection.queryDatabase(query); foreach (DataRow row in logs.Rows) { _time_spent_on_activity = $"{row["time_spent_on_activity"].ToString().Trim()}"; } query = $@"Select * from activity_categories where activity_category_id = {category_description};"; logs = DatabaseConnection.queryDatabase(query); foreach (DataRow row in logs.Rows) { _activity_category = $"{row["category_description"].ToString().Trim()}"; } query = $@"Select * from activity_descriptions where activity_description_id = {activity_description};"; logs = DatabaseConnection.queryDatabase(query); foreach (DataRow row in logs.Rows) { _activity_description = $"{row["activity_description"].ToString().Trim()}"; } }