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