private void CreateExerciseButton_Click(object sender, EventArgs e)
{
if (queryAdapter.CheckExerciseExists(ExerciseNameTextBox.Text) == 0)
{
newGymPlannerDataSet.Exercises.AddExercisesRow(ExerciseNameTextBox.Text, ExerciseInfoRichTextBox.Text);
NewGymPlannerDataSet.Exercise_MuscleGroupRow egRow = newGymPlannerDataSet.Exercise_MuscleGroup.NewExercise_MuscleGroupRow();
egRow.Name_Exercise = ExerciseNameTextBox.Text;
egRow.Name_MuscleGroup = ChooseMuscleGroupComboBox.GetItemText(ChooseMuscleGroupComboBox.SelectedItem);
newGymPlannerDataSet.Exercise_MuscleGroup.Rows.Add(egRow);
exercisesTableAdapter.Update(newGymPlannerDataSet);
exerciseGroupAdapter.Update(newGymPlannerDataSet);
this.Close();
}
else
{
MessageBox.Show("Дана вправа вже існує");
}
}
private void CreateExerciseButton_Click(object sender, EventArgs e)
{
if (!ctx.Exercises.Any(x => x.Name == ExerciseNameTextBox.Text))
{
Exercises exercise = new Exercises
{
Name = ExerciseNameTextBox.Text,
Information = ExerciseInfoRichTextBox.Text
};
string group = ChooseMuscleGroupComboBox.GetItemText(ChooseMuscleGroupComboBox.SelectedItem);
exercise.MuscleGroups.Add(ctx.MuscleGroups.FirstOrDefault(g => g.Name == group));
ctx.Exercises.Add(exercise);
ctx.SaveChanges();
this.Close();
}
else
{
MessageBox.Show("Дана вправа вже існує");
}
}
private void ChooseMuscleGroupComboBox_SelectedValueChanged(object sender, EventArgs e)
{
this.ExercisesListBox.ClearSelected();
string group = ChooseMuscleGroupComboBox.GetItemText(ChooseMuscleGroupComboBox.SelectedItem);
if (group == "")
{
return;
}
if (group == "Всі")
{
this.ExercisesListBox.DataSource = exercisesList.Where(ex => ex.ToLower()
.Contains(ExerciseNameTextBox.Text.ToLower())).ToList();
}
else
{
var muscleGroup = ctx.MuscleGroups.FirstOrDefault(g => g.Name == group);
this.ExercisesListBox.DataSource = ctx.MuscleGroups.FirstOrDefault(g => g.Name == group)
.Exercises.Select(ex => ex.Name).Where(ex => ex.ToLower()
.Contains(ExerciseNameTextBox.Text.ToLower())).ToList();
}
}
