public void InsertDataBalance(SQLiteConnection AnyConnectionObject, ref int Choice2)
{
string Duration = null;
string ChooseTable = null;
SQLiteCommand SQLQuery;
SQLQuery = AnyConnectionObject.CreateCommand();
if (Choice2 == 1)
{
Console.Write("Enter the leg raised (left/right): ");
string LegRaised = Console.ReadLine();
Console.WriteLine("Enter the duration: ");
Duration = Console.ReadLine();
ChooseTable = "StandingOnOneFoot";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, LegRaisedToFront, Time) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", LegRaised));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Duration));
SQLQuery.ExecuteNonQuery();
}
if (Choice2 == 2)
{
Console.Write("*******GUIDELINES*******: For (Decimal), maximum number that can be entered is 9999.99. Max number of decimal places is 2, values like 9999.999 cannot be entered\n");
Console.Write("*******END OF GUIDELINES**\n\n\n");
Console.Write("Enter duration: ");
Duration = Console.ReadLine();
Console.Write("Enter the number of steps taken (Decimal): ");
double StepsTaken = Convert.ToDouble(Console.ReadLine());
ChooseTable = "HeelToToeWalk";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Time, Steps) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Duration));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", StepsTaken));
SQLQuery.ExecuteNonQuery();
}
}
public void InsertDataCardio(SQLiteConnection AnyConnectionObject, ref int Choice2, ref int Choice3, ref int Choice4)
{
string Resistance = null;
string ChooseTable = null;
string Duration = null;
string Distance = null;
SQLiteCommand SQLQuery;
SQLQuery = AnyConnectionObject.CreateCommand();
SQLQuery.CommandType = System.Data.CommandType.Text;
if (Choice2 == 1)
{
if (Choice4 == 1)
{
Console.Write("*******GUIDELINES*******: For (Decimal), maximum number that can be entered is 999.9. Max number of decimal places is 1, values like 999.99 cannot be entered\n");
Console.Write("*******END OF GUIDELINES**\n\n\n");
Console.Write("Enter Resistance value: ");
Resistance = Console.ReadLine();
Console.Write("Enter Ramp Control : ");
string RampControl = Console.ReadLine();
Console.Write("Enter Steps Per Minute (Decimal): ");
double StepsPerMin = Convert.ToDouble(Console.ReadLine());;
ChooseTable = "EllipticalCustom";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Resistance, RampControl, StepsPerMin) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Resistance));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", RampControl));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", StepsPerMin));
SQLQuery.ExecuteNonQuery();
}
if (Choice4 == 2)
{
Console.Write("Enter Setting value: ");
string Setting = Console.ReadLine();
Console.Write("Enter Duration of setting: ");
Duration = Console.ReadLine();
Console.Write("Enter Distance: ");
double DblDistance = Convert.ToDouble(Console.ReadLine());
ChooseTable = "EllipticalPreset";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Setting, Time, Distance) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Setting));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Duration));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", DblDistance));
SQLQuery.ExecuteNonQuery();
}
if (Choice3 == 2)
{
Console.Write("*******GUIDELINES*******: For (Decimal), maximum number that can be entered is 999.9. Max number of decimal places is 1, values like 999.99 cannot be entered\n");
Console.Write("*******END OF GUIDELINES**\n\n\n");
Console.Write("Enter Resistance: ");
Resistance = Console.ReadLine();
Console.Write("Enter Duration of setting: ");
Duration = Console.ReadLine();
Console.Write("Enter Revolutions Per Minute (RPM) (Decimal): ");
double RevolutionsPerMinute = Convert.ToDouble(Console.ReadLine());
ChooseTable = "IndoorBicycle";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Resistance, LengthOfTime, RevolutionsPerMinute) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Resistance));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Duration));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", RevolutionsPerMinute));
SQLQuery.ExecuteNonQuery();
}
if (Choice3 == 3)
{
Console.Write("Enter Speed: ");
string Speed = Console.ReadLine();
Console.Write("Enter Incline: ");
string Incline = Console.ReadLine();
Console.Write("Enter Duration of setting: ");
Duration = Console.ReadLine();
ChooseTable = "Treadmill";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Speed, Incline, Time) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Speed));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Incline));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", Duration));
SQLQuery.ExecuteNonQuery();
}
}
if (Choice2 == 2)
{
Console.Write("Enter distnace covered for workout: ");
Distance = Console.ReadLine();
Console.Write("Enter Duration of exercise: ");
Duration = Console.ReadLine();
if (Choice3 == 1)
{
ChooseTable = "Walking";
}
if (Choice3 == 2)
{
ChooseTable = "Cycling";
}
if (Choice3 == 3)
{
ChooseTable = "Running";
}
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Distance, Time) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Distance));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Duration));
SQLQuery.ExecuteNonQuery();
}
if (Choice2 == 3)
{
if (Choice3 == 1)
{
double Laps = 0;
Console.Write("*******GUIDELINES*******: For (Decimal), maximum number that can be entered is 999.99. Max number of decimal places is 2, values like 999.999 cannot be entered\n");
Console.Write("*******END OF GUIDELINES**\n\n\n");
Console.Write("Enter the number of laps completed (Decimal): ");
Laps = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter duration of swim: ");
Duration = Console.ReadLine();
ChooseTable = "Swimming";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Laps, Time) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Laps));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Duration));
SQLQuery.ExecuteNonQuery();
}
if (Choice3 == 2)
{
Console.Write("*******GUIDELINES*******: For (Decimal), maximum number that can be entered is 9999.99. Max number of decimal places is 2, values like 9999.999 cannot be entered\n");
Console.Write("*******END OF GUIDELINES**\n\n\n");
Console.Write("Enter the number of successful jumps (Decimal): ");
double Revolutions = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter duration of workout: ");
Duration = Console.ReadLine();
Console.Write("Enter the type of jump: ");
string JumpType = Console.ReadLine();
ChooseTable = "JumpRope";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Revolutions, Time, JumpType) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3)";
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Revolutions));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Duration));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", JumpType));
SQLQuery.ExecuteNonQuery();
}
}
}
public void InsertDataStrength(SQLiteConnection AnyConnectionObject, ref int Choice2, ref int Choice3, ref int Choice4)
{
double Repetitions = 0;
int Sets = 0;
double Weight = 0;
SQLiteCommand SQLQuery;
string ChooseTable = null;
Console.Write("******GUIDELINES*********:\n1) For (Decimal) labels, can only enter maximum of 99.9. Cannot enter decimal values with more than 1 decimal place; eg: 9.99.\n");
Console.Write("2) For (int) labels, can only enter whole numbers. Decimal values eg: 4.3 are not allowed.\n");
Console.Write("******END OF GUIDELINES***\n\n\n");
if (Choice2 == 1)
{
Console.Write("Enter value for Repetitons (Decimal): ");
Repetitions = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Sets (int): ");
Sets = ReadInt32(Console.ReadLine());
SQLQuery = AnyConnectionObject.CreateCommand();
if (Choice3 == 1)
{
ChooseTable = "Pushups";
}
if (Choice3 == 2)
{
ChooseTable = "Pullups";
}
if (Choice3 == 3)
{
ChooseTable = "Situps";
}
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Repetitions, Sets) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2)";
SQLQuery.CommandType = System.Data.CommandType.Text;
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Repetitions));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Sets));
SQLQuery.ExecuteNonQuery();
}
//For Barbell (121 1-5)
if (Choice2 == 2 && Choice3 == 1 && ((5 - Choice4) >= 0 && (5 - Choice4) <= 4))
{
Console.Write("Enter value for Weight (Decimal): ");
Weight = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Repetitions (Decimal): ");
Repetitions = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Sets (int): ");
Sets = ReadInt32(Console.ReadLine());
SQLQuery = AnyConnectionObject.CreateCommand();
if (Choice4 == 1)
{
ChooseTable = "BarbellBenchPress";
}
if (Choice4 == 2)
{
ChooseTable = "BarbellBentOverRow";
}
if (Choice4 == 3)
{
ChooseTable = "BarbellDeadlift";
}
if (Choice4 == 4)
{
ChooseTable = "BarbellBackSquat";
}
if (Choice4 == 5)
{
ChooseTable = "BarbellOverheadPress";
}
//(date('now', 'localtime'),
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Weight, Repetitions, Sets) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3)";
SQLQuery.CommandType = System.Data.CommandType.Text;
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Weight));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Repetitions));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", Sets));
SQLQuery.ExecuteNonQuery();
}
//For DumbBell(122 2-9)
if (Choice2 == 2 && Choice3 == 2 && ((9 - Choice4) >= 0 && (9 - Choice4) <= 7))
{
Console.Write("Enter value for Weight (Decimal): ");
Weight = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Repetitions (Decimal): ");
Repetitions = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Sets (int): ");
Sets = ReadInt32(Console.ReadLine());
SQLQuery = AnyConnectionObject.CreateCommand();
if (Choice4 == 2)
{
ChooseTable = "DumbbellLateralRaise";
}
if (Choice4 == 3)
{
ChooseTable = "DumbbellBicepsCurl";
}
if (Choice4 == 4)
{
ChooseTable = "DumbbellLunge";
}
if (Choice4 == 5)
{
ChooseTable = "DumbbellOverheadPress";
}
if (Choice4 == 6)
{
ChooseTable = "DumbbellChestFlye";
}
if (Choice4 == 7)
{
ChooseTable = "DumbbellBentOverRow";
}
if (Choice4 == 8)
{
ChooseTable = "DumbbellChestPullOver";
}
if (Choice4 == 9)
{
ChooseTable = "DumbbellFrontSquat";
}
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Weight, Repetitions, Sets) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3)";
SQLQuery.CommandType = System.Data.CommandType.Text;
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Weight));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Repetitions));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", Sets));
SQLQuery.ExecuteNonQuery();
}
if (Choice2 == 2 && Choice3 == 1 && Choice4 == 6)
{
Console.Write("Enter value for Weight (Decimal): ");
Weight = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Repetitions (Decimal): ");
Repetitions = Convert.ToDouble(Console.ReadLine());
SQLQuery = AnyConnectionObject.CreateCommand();
ChooseTable = "BarbellPowerClean";
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, Weight, Repetitions) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2)";
SQLQuery.CommandType = System.Data.CommandType.Text;
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", Weight));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Repetitions));
SQLQuery.ExecuteNonQuery();
}
if (Choice2 == 2 && Choice3 == 2 && Choice4 == 1)
{
string FrontLeg = null;
Console.Write("Enter the lunged leg (left/right): ");
FrontLeg = Console.ReadLine();
Console.Write("Enter value for Weight (Decimal): ");
Weight = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Repetitions (Decimal): ");
Repetitions = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter value for Sets (int): ");
Sets = ReadInt32(Console.ReadLine());
ChooseTable = "DumbbellSplitSquat";
SQLQuery = AnyConnectionObject.CreateCommand();
SQLQuery.CommandText = "INSERT INTO " + ChooseTable + " (Date, FrontLeg, Weight, Repetitions, Sets) VALUES(strftime('%d/%m/%Y %H:%M', 'now', 'localtime'), @param1, @param2, @param3, @param4)";
SQLQuery.CommandType = System.Data.CommandType.Text;
SQLQuery.Parameters.Add(new SQLiteParameter("@param1", FrontLeg));
SQLQuery.Parameters.Add(new SQLiteParameter("@param2", Weight));
SQLQuery.Parameters.Add(new SQLiteParameter("@param3", Repetitions));
SQLQuery.Parameters.Add(new SQLiteParameter("@param4", Sets));
SQLQuery.ExecuteNonQuery();
}
}