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