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();
}
private void comboBoxTraningPrograms_SelectedIndexChanged(object sender, EventArgs e)
{
dataGridViewTraningPrograms.Rows.Clear();
selectedTrp = listTrainingPrograms.Find(g => (g.getWorkoutID().ToString().Equals(comboBoxTraningPrograms.Text)));
foreach (Exercise ex in selectedTrp.getExerciseList())
{
dataGridViewTraningPrograms.Rows.Add(
ex.getExerciseName(), ex.getExerciseRepeats(), ex.getExerciseSets());
}
}
/// <summary>
/// add training progrem to a customer
/// </summary>
/// <param name="edit"></param>
/// <param name="tp"></param>
public void AddCustomerTrainingProgrem(Customer edit, TrainingProgram tp) {
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 = "INSERT INTO training_program (exersie_list) VALUES('" + tpList + "');";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
cmd.ExecuteNonQuery();
long tpLastId = cmd.LastInsertedId;
string query2 = "INSERT INTO client_program (program_id, client_id) VALUES ('"+ tpLastId +"', '" + edit.getDBid() + "');";
MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
cmd2.ExecuteNonQuery();
}
