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