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 void setListEq(EquipmentExer eq)
{
eqLst.Add(eq);
}
