private void buttonadd_Click(object sender, EventArgs e)
{
con.Open();
ExercisePlan ex = new ExercisePlan();
string eqName = comboBoxLsteq.SelectedItem.ToString();
string duration = textBoxPlayDuration.Text.ToString();
string steps = textBoxPlaySteps.Text.ToString();
string exerID = textBoxexerplanID.Text.ToString();
string exercisename = textBoxexrPlanName.Text.ToString();
int exerciseDuration = Convert.ToInt32(textBoxexcerPlanDuration.Text);
EquipmentExer eqex = new EquipmentExer();
eqex.AddExerciseEq(eqName, duration, steps);
ex.setListEq(eqex);
List <EquipmentExer> lst = ex.getListeq();
//dataGridViewExerciseEq.DataSource = lst;
//this.Refresh();
//dataGridViewExerciseEq.Refresh();
SqlCommand cmd2 = new SqlCommand("select Equipment_ID from Equipments where Equipment_Name='" + eqName + "' ", con);
int id = (int)cmd2.ExecuteScalar();
SqlCommand cmd3 = new SqlCommand("insert into Exersice_Equipment (ExersiceID , EquipmentID , ExerciseDuration , Steps) values (@id , @eqID , @exerduration , @steps)", con);
cmd3.Parameters.AddWithValue("@id", exerID);
cmd3.Parameters.AddWithValue("@eqID", id);
cmd3.Parameters.AddWithValue("@exerduration", duration);
cmd3.Parameters.AddWithValue("steps", steps);
cmd3.ExecuteNonQuery();
con.Close();
}
//public static ExercisePlan operator +(ExercisePlan a, ExercisePlan b)
// {
// List<EquipmentExer> newEqLst = new List<EquipmentExer>(a.eqLst);
// newEqLst.AddRange(b.eqLst);
// return new ExercisePlan() { ExerID = a.ExerID + b.ExerID, ExerName = a.ExerName + " & " + b.ExerName, ExerTime = a.ExerTime + b.ExerTime, eqLst = newEqLst };
// }
public static ExercisePlan operator +(ExercisePlan a, ExercisePlan b)
{
List <EquipmentExer> newEqLst = new List <EquipmentExer>(a.eqLst);
newEqLst.AddRange(b.eqLst);
ExercisePlan result = new ExercisePlan();
result.ExerID = a.ExerID + b.ExerID;
result.ExerName = a.ExerName + " & " + b.ExerName;
result.ExerTime = a.ExerTime + b.ExerTime;
result.eqLst = newEqLst;
return(result);
}
private void buttonDone_Click(object sender, EventArgs e)
{
string trainID = textBoxTrainerid.Text.ToString();
string exercisename = textBoxexrPlanName.Text.ToString();
int exerciseDuration = Convert.ToInt32(textBoxexcerPlanDuration.Text);
string exerID = textBoxexerplanID.Text.ToString();
ExercisePlan ex = new ExercisePlan();
List <EquipmentExer> lst = ex.getListeq();
ex.AddExerPlan(exerID, exercisename, exerciseDuration, lst);
con.Open();
SqlCommand cmd = new SqlCommand("insert into ExersicePlans (Exersice_ID , ExerciseName , ExerciseTime) values (@exerid , @exername , @exertime)", con);
cmd.Parameters.AddWithValue("exerid", exerID);
cmd.Parameters.AddWithValue("exername", exercisename);
cmd.Parameters.AddWithValue("exertime", exerciseDuration);
cmd.ExecuteNonQuery();
con.Close();
}
