public void updateTrainingProgrem(TrainingProgram tp) {
if (tp.getWorkoutID() == 1) {
System.Windows.Forms.MessageBox.Show("Cannot Change Default Training Program");
return;
}
Dictionary<String, int> excersisses = this.getExcerssiesBackwords();
String tpList = "";
foreach (Exercise ex in tp.getExerciseList())
{
tpList = tpList + excersisses[ex.getExerciseName()] + "_" + ex.getExerciseRepeats() + "_" + ex.getExerciseSets() + ",";
}
tpList = tpList.Substring(0, tpList.Length - 1);
string query = "UPDATE training_program SET exersie_list='" + tpList + "' WHERE workoutId='" + tp.getWorkoutID() + "';";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
}
