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