public List <StrengthExercise> GetStrengthExercises(int workoutId)
{
List <StrengthExercise> se = new List <StrengthExercise>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL_Plans = @"SELECT *
from strength_exercise
JOIN exercises ON strength_exercise.exercise_id = exercises.exercise_id
WHERE workout_id = @workout_id";
conn.Open();
using (SqlCommand cmd = new SqlCommand(SQL_Plans, conn))
{
cmd.Parameters.AddWithValue("@workout_Id", workoutId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StrengthExercise exercise = MapRowToStrength(reader);
se.Add(exercise);
}
}
}
return(se);
}
public bool AddStrengthToWorkout(StrengthExercise exercise)
{
bool check;
string addStrength = @"INSERT INTO strength_exercise (exercise_id, strength_reps, strength_sets, rest_time, workout_id)
VALUES (@exercise_id, @strength_reps, @strength_sets, @rest_time, @workout_id)";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(addStrength, conn);
cmd.Parameters.AddWithValue("@exercise_id", exercise.ExerciseID);
cmd.Parameters.AddWithValue("@strength_reps", exercise.Reps);
cmd.Parameters.AddWithValue("@strength_sets", exercise.Sets);
cmd.Parameters.AddWithValue("@rest_time", exercise.Rest_time);
cmd.Parameters.AddWithValue("@workout_id", exercise.WorkoutID);
check = cmd.ExecuteNonQuery() > 0 ? true : false;
}
return(check);
}
public NewStrengthExercisePage()
{
InitializeComponent();
Exercise = new StrengthExercise
{
Id = Guid.NewGuid().ToString(),
Exercise = "",
Weight = 0,
Sets = 0,
Reps = 0,
Mins = 0,
Hours = 0,
Secs = 0,
IsCardio = false,
Distance = 0,
Note = "",
ExerciseDate = DateTime.Today
};
//call static function to get exercises and bind them to pick list
_exerciseList = App.Database.GetExerciseList().ToList <ExerciseListItem>();
exPicker.ItemsSource = (from e in _exerciseList where e.Id >= 0 select e.Value).ToList();
cardioVals.IsVisible = false;
//add a selected item change event to pick list
exPicker.SelectedIndexChanged += (sender, args) =>
{
if (exPicker.SelectedIndex == -1)
{
Exercise.Exercise = "";
}
else
{
Exercise.Exercise = exPicker.Items[exPicker.SelectedIndex];
int key = _exerciseList.FirstOrDefault(x => x.Value == Exercise.Exercise).Id;
switch (key)
{
case 0:
strengthVals.IsVisible = false;
cardioVals.IsVisible = false;
Exercise.IsCardio = false;
break;
case 90:
strengthVals.IsVisible = false;
cardioVals.IsVisible = true;
Exercise.IsCardio = true;
break;
default:
strengthVals.IsVisible = true;
cardioVals.IsVisible = false;
Exercise.IsCardio = false;
break;
}
}
};
BindingContext = this;
}
