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()}";
}
}
