private void insert_btn_Click(object sender, EventArgs e) { Finalize_btn.Enabled = true; int num; if ((exercises_cb.Text == "") || (muscles_cb.Text == "")) { MessageBox.Show("Muscle and Exercise fields cannot be empty!"); } else { if ((int.TryParse(Sets_tb.Text, out num) != true) || (Int32.Parse(Sets_tb.Text) < 1)) { MessageBox.Show("Invalid format for the field: Number of sets!"); } else { var db = new Model1(); var obj = new add_into_database(); Exercises_trainings inserted_extrain = new Exercises_trainings(); if (training_started == false) { training_started = true; inserted_training = obj.add_training(usern, date_dtp.Value); } inserted_extrain = obj.add_exercise_training(exercises_cb.Text, inserted_training.id); obj.add_sets(inserted_extrain, Int32.Parse(Sets_tb.Text)); Sets_tb.Text = ""; } } }
private void Save2_btn_Click(object sender, EventArgs e) { if (exercises_out.SelectedRows.Count == 0) { MessageBox.Show("No set was selected for update!"); } else { if (exercise_cb.SelectedIndex == 0) { MessageBox.Show("No exercise name was selected for update!"); } else { var db = new Model1(); var exercise_train = new Exercises_trainings(); int exercise_id = Convert.ToInt32(exercises_out.SelectedRows[0].Cells[0].Value); int training_id = Convert.ToInt32(trainings_out.SelectedRows[0].Cells[0].Value); exercise_train = (from x in db.Exercises_trainings where x.id_exercise == exercise_id where x.id_training == training_id select x).First(); exercise_train.id_exercise = (from x in db.Exercises where x.exercise_name == exercise_cb.Text select x).First().id; db.SaveChanges(); exercises_out.SelectedRows[0].Cells[0].Value = exercise_train.id_exercise; exercises_out.SelectedRows[0].Cells[1].Value = exercise_cb.Text; MessageBox.Show("Item successfully updated."); } } }
public Exercises_trainings add_exercise_training(string ex_name, int training_id) { var db = new Model1(); var exer_train = new Exercises_trainings(); exer_train.id_training = training_id; exer_train.id_exercise = (from x in db.Exercises where x.exercise_name == ex_name select x).First().id; db.Exercises_trainings.Add(exer_train); db.SaveChanges(); return(exer_train); }
public void add_sets(Exercises_trainings exer_train, int setnumber) { var db = new Model1(); int i; for (i = 1; i <= setnumber; i++) { AddSet f = new AddSet(i, exer_train); f.ShowDialog(); if (f.cancel_pressed == true) { break; } if (i == setnumber) { MessageBox.Show("Exercise succesfully added!"); } } }
public AddSet(int set_number, Exercises_trainings exercise_tr) { InitializeComponent(); set_nb = set_number; obj = exercise_tr; }