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