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