public void UpdateStudents() { var result = CollegeDBEntities.GetContext().User.Where(p => p.RoleID == 8).ToList(); if (!string.IsNullOrWhiteSpace(TextUserName.Text)) { result = result.Where(p => p.FullName.ToLower().Contains(TextUserName.Text.ToLower())).ToList(); } if (ComboGender.SelectedIndex > 0) { result = result.Where(p => p.Gender == ComboGender.SelectedItem as Gender).ToList(); } if (ComboGruppa.SelectedIndex > 0) { result = result.Where(p => p.Student.Gruppa == ComboGruppa.SelectedItem as Gruppa).ToList(); } if (!string.IsNullOrEmpty(TextZachetka.Text)) { result = result.Where(p => p.Student.Zachetka.ToLower().Contains(TextZachetka.Text.ToLower())).ToList(); } if (DateBirth.SelectedDate != null) { result = result.Where(p => p.BirthDate == DateBirth.SelectedDate).ToList(); } DGridStudent.ItemsSource = result; }
public ScheduleViewPage(User teacher) { InitializeComponent(); if (teacher != null) { currentTeacher = teacher; } if (CollegeDBEntities.currentUser.RoleID == 7 || CollegeDBEntities.currentUser.RoleID == 8) { BtnAdd.Visibility = Visibility.Hidden; BtnBack.Visibility = Visibility.Hidden; } if (CollegeDBEntities.currentUser.RoleID == 8) { TextTeacherName.Text = "Расписание для студента: "; } TextTeacherName.Text += currentTeacher.FullName; DataContext = schedule; DGridSchedule.ItemsSource = CollegeDBEntities.GetContext().Schedule.Where(p => p.LessonPlan.UserID == currentTeacher.UserID).OrderBy(p => p.DayID).ToList(); }
public void UpdateGruppa() { var currentGruppa = CollegeDBEntities.GetContext().Gruppa.ToList(); if (!string.IsNullOrWhiteSpace(GruppaName.Text)) { currentGruppa = currentGruppa.Where(p => p.GruppaName.ToLower().Contains(GruppaName.Text.ToLower())).ToList(); } if (ComboSpecial.SelectedIndex > 0) { currentGruppa = currentGruppa.Where(p => p.Special == ComboSpecial.SelectedItem as Special).ToList(); } if (DateBegin.SelectedDate != null) { currentGruppa = currentGruppa.Where(p => p.BeginDate == DateBegin.SelectedDate).ToList(); } if (DateFinish.SelectedDate != null) { currentGruppa = currentGruppa.Where(p => p.FinishDate == DateFinish.SelectedDate).ToList(); } DGridGruppa.ItemsSource = currentGruppa; }
public void UpdateTeacher() { var result = CollegeDBEntities.GetContext().User.Where(p => p.RoleID == 7).ToList(); if (!string.IsNullOrWhiteSpace(TextUserName.Text)) { result = result.Where(p => p.FullName.ToLower().Contains(TextUserName.Text.ToLower())).ToList(); } if (ComboGender.SelectedIndex > 0) { result = result.Where(p => p.Gender == ComboGender.SelectedItem as Gender).ToList(); } if (ComboOtdel.SelectedIndex > 0) { result = result.Where(p => p.Teacher.Otdel == ComboOtdel.SelectedItem as Otdel).ToList(); } if (DateBirth.SelectedDate != null) { result = result.Where(p => p.BirthDate == DateBirth.SelectedDate).ToList(); } DGridTeacher.ItemsSource = result; }
private void BtnAddGruppa_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (string.IsNullOrWhiteSpace(currentGruppa.GruppaName)) { errors.AppendLine("Укажите название группы"); } if (currentGruppa.Special == null) { errors.AppendLine("Укажите специальность группы"); } if (currentGruppa.BeginDate == null) { errors.AppendLine("Укажите дату поступления студентов группы"); } if (currentGruppa.FinishDate == null) { errors.AppendLine("Укажите дату выпуска студентов группы"); } if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } else { if (currentGruppa.GruppaID == 0) { int count = CollegeDBEntities.GetContext().Gruppa.Where(p => p.GruppaName == currentGruppa.GruppaName).Count(); if (count > 0) { MessageBoxResult result = MessageBox.Show("Такая группа уже существует!", "Внимание!", MessageBoxButton.YesNo); if (result == MessageBoxResult.No) { return; } } CollegeDBEntities.GetContext().Gruppa.Add(currentGruppa); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация успешно сохранена!"); NavigationManager.GruppaFrame.Navigate(new GruppaViewPage()); } catch (Exception) { MessageBox.Show("При попытке сохранения произошла ошибка"); } } }
private void BtnSave_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (schedule.LessonPlan == null) { errors.AppendLine("Укажите пункт в плане"); } if (schedule.Day == null) { errors.AppendLine("Укажите день недели"); } if (schedule.LessonNum == null) { errors.AppendLine("Укажите номер пары"); } if (schedule.Classroom == null) { errors.AppendLine("Укажите аудиторию"); } if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } else { if (CollegeDBEntities.GetContext().Schedule.Where(p => p.LessonPlan.GruppaID == schedule.LessonPlan.GruppaID && p.DayID == schedule.Day.DayID && p.LessonNumId == schedule.LessonNum.LessonNumID).Count() > 0) { MessageBox.Show("Расписание для группы на этот день и пару уже занято!"); return; } if (CollegeDBEntities.GetContext().Schedule.Where(p => p.LessonPlan.UserID == schedule.LessonPlan.UserID && p.DayID == schedule.Day.DayID && p.LessonNumId == schedule.LessonNum.LessonNumID).Count() > 0) { MessageBox.Show("Расписание для преподавателя на этот день и пару уже занято!"); return; } if (schedule.ScheduleID == 0) { CollegeDBEntities.GetContext().Schedule.Add(schedule); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Данные успешно сохранены!"); NavigationManager.PlanFrame.Navigate(new ScheduleViewPage(currentTeacher)); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void TextOtdel_TextChanged(object sender, TextChangedEventArgs e) { var currentOtdel = CollegeDBEntities.GetContext().Otdel.ToList(); if (!string.IsNullOrWhiteSpace(TextOtdel.Text)) { currentOtdel = currentOtdel.Where(p => p.OtdelName.ToLower().Contains(TextOtdel.Text.ToLower())).ToList(); } DGridOtdel.ItemsSource = currentOtdel; }
private void BtnAddSubject_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (string.IsNullOrWhiteSpace(currentSubject.SubjectName)) { errors.AppendLine("Укажите название предмета"); } if (currentSubject.Otdel == null) { errors.AppendLine("Укажите отделение, которому принадлежит предмет"); } if (currentSubject.Hours < 0) { errors.AppendLine("Часы введены некорректно"); } if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } else { if (currentSubject.SubjectID == 0) { int count = CollegeDBEntities.GetContext().Subject.Where(p => p.SubjectName == currentSubject.SubjectName).Count(); if (count > 0) { MessageBoxResult result = MessageBox.Show("Такой предмет уже существует! Продолжить?", "Внимание!", MessageBoxButton.YesNo); if (result == MessageBoxResult.No) { return; } } CollegeDBEntities.GetContext().Subject.Add(currentSubject); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена успешно!"); NavigationManager.SubjectFrame.Navigate(new SubjectViewPage()); } catch (Exception) { MessageBox.Show("При попытке сохранения произошла ошибка!"); } } }
public SubjectAddEditPage(Subject selectedSubject) { InitializeComponent(); if (selectedSubject != null) { currentSubject = selectedSubject; } DataContext = currentSubject; ComboOtdel.ItemsSource = CollegeDBEntities.GetContext().Otdel.ToList(); }
public GruppaAddEditPage(Gruppa selectedGruppa) { InitializeComponent(); if (selectedGruppa != null) { currentGruppa = selectedGruppa; } DataContext = currentGruppa; ComboSpecial.ItemsSource = CollegeDBEntities.GetContext().Special.ToList(); }
public TeacherAddPage(User selectedUser) { InitializeComponent(); if (selectedUser != null) { currentUser = selectedUser; } DataContext = currentUser; ComboGender.ItemsSource = CollegeDBEntities.GetContext().Gender.ToList(); ComboOtdel.ItemsSource = CollegeDBEntities.GetContext().Otdel.ToList(); }
public StudentAddEditPage(User selectedUser) { InitializeComponent(); if (selectedUser != null) { currentUser = selectedUser; } DataContext = currentUser; ComboGender.ItemsSource = CollegeDBEntities.GetContext().Gender.ToList(); ComboGruppa.ItemsSource = CollegeDBEntities.GetContext().Gruppa.ToList(); }
public GruppaViewPage() { InitializeComponent(); DGridGruppa.ItemsSource = CollegeDBEntities.GetContext().Gruppa.ToList(); var special = CollegeDBEntities.GetContext().Special.ToList(); special.Insert(0, new Special { SpecialName = "Все специальности" }); ComboSpecial.ItemsSource = special; ComboSpecial.SelectedIndex = 0; }
public SubjectViewPage() { InitializeComponent(); DGridSubject.ItemsSource = CollegeDBEntities.GetContext().Subject.ToList(); var otdels = CollegeDBEntities.GetContext().Otdel.ToList(); otdels.Insert(0, new Otdel { OtdelName = "Все отделения" }); ComboOtdel.ItemsSource = otdels; ComboOtdel.SelectedIndex = 0; }
public SpecialAddEditPage(Special selectedSpecial) { InitializeComponent(); if (selectedSpecial != null) { currentSpecial = selectedSpecial; textMain.Text = "Редактирование специальности"; } DataContext = currentSpecial; ComboOtdel.ItemsSource = CollegeDBEntities.GetContext().Otdel.ToList(); }
private void BtnAdd_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (lessonPlan.Gruppa == null) { errors.AppendLine("Укажите группу"); } if (lessonPlan.Subject == null) { errors.AppendLine("Укажите предмет"); } if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } else { int count = CollegeDBEntities.GetContext().LessonPlan.Where(p => p.GruppaID == lessonPlan.Gruppa.GruppaID && p.SubjectID == lessonPlan.Subject.SubjectID).Count(); if (count > 0) { MessageBoxResult result = MessageBox.Show("Данной группе уже ведется такой предмет! Продолжить?", "Внимание!", MessageBoxButton.YesNo); if (result == MessageBoxResult.No) { return; } } if (lessonPlan.LessonPlanID == 0) { CollegeDBEntities.GetContext().LessonPlan.Add(lessonPlan); } try { CollegeDBEntities.GetContext().SaveChanges(); //currentTeacher.Teacher.CountOfHours += lessonPlan.Subject.Hours; MessageBox.Show("Добавление пункта плана прошло успешно!"); NavigationManager.PlanFrame.Navigate(new PlanTeacherPage(currentTeacher)); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void BtnAddSpecial_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (string.IsNullOrWhiteSpace(currentSpecial.SpecialName)) { errors.AppendLine("Укажите название специальности"); } if (currentSpecial.Otdel == null) { errors.AppendLine("Укажите отделение"); } if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } else { if (currentSpecial.SpecialID == 0) { int count = CollegeDBEntities.GetContext().Special.Where(p => p.SpecialName == currentSpecial.SpecialName).Count(); if (count > 0) { MessageBoxResult result = MessageBox.Show("Такая специальность уже существует! Продолжить?", "Внимание!", MessageBoxButton.YesNo); if (result == MessageBoxResult.No) { return; } } CollegeDBEntities.GetContext().Special.Add(currentSpecial); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена успешно!"); NavigationManager.SpecialFrame.Navigate(new SpecialViewPage()); } catch (Exception) { MessageBox.Show("При попытке сохранения произошла ошибка"); } } }
public PlanTeacherPage(User teacher) { InitializeComponent(); if (teacher != null) { currentTeacher = teacher; } lessonPlan.User = currentTeacher; DataContext = lessonPlan; DGridTeacherPlan.ItemsSource = CollegeDBEntities.GetContext().LessonPlan.Where(p => p.UserID == currentTeacher.UserID).ToList(); TextTeacherName.Text += currentTeacher.FullName; }
public PlanTeacherAddPage(User teacher) { InitializeComponent(); if (teacher != null) { currentTeacher = teacher; } lessonPlan.User = currentTeacher; DataContext = lessonPlan; TextTeacherName.Text += currentTeacher.FullName; ComboGruppas.ItemsSource = CollegeDBEntities.GetContext().Gruppa.Where(p => p.Active == true).ToList(); ComboSubjects.ItemsSource = CollegeDBEntities.GetContext().Subject.Where(p => p.Active == true).ToList(); }
public void UpdateSubject() { var currentSubject = CollegeDBEntities.GetContext().Subject.ToList(); if (!string.IsNullOrWhiteSpace(TextSubject.Text)) { currentSubject = currentSubject.Where(p => p.SubjectName.ToLower().Contains(TextSubject.Text.ToLower())).ToList(); } if (ComboOtdel.SelectedIndex > 0) { currentSubject = currentSubject.Where(p => p.Otdel == ComboOtdel.SelectedItem as Otdel).ToList(); } DGridSubject.ItemsSource = currentSubject; }
public void UpdateSpecial() { var currentSpecial = CollegeDBEntities.GetContext().Special.ToList(); if (TextSpecial.Text != null) { currentSpecial = currentSpecial.Where(p => p.SpecialName.ToLower().Contains(TextSpecial.Text.ToLower())).ToList(); } if (ComboOtdel.SelectedIndex > 0) { currentSpecial = currentSpecial.Where(p => p.Otdel == ComboOtdel.SelectedItem as Otdel).ToList(); } DGridSpecial.ItemsSource = currentSpecial; }
public ScheduleAddPage(User teacher) { InitializeComponent(); if (teacher != null) { currentTeacher = teacher; } DataContext = schedule; TextTeacherName.Text += currentTeacher.FullName; ComboLessonPlan.ItemsSource = CollegeDBEntities.GetContext().LessonPlan.Where(p => p.UserID == currentTeacher.UserID).ToList(); ComboDay.ItemsSource = CollegeDBEntities.GetContext().Day.ToList(); ComboClassroom.ItemsSource = CollegeDBEntities.GetContext().Classroom.Where(p => p.Active == true).ToList(); ComboLessonNum.ItemsSource = CollegeDBEntities.GetContext().LessonNum.ToList(); }
public ScheduleTeacherPage(User teacher) { InitializeComponent(); if (teacher != null) { currentTeacher = teacher; } DataContext = currentTeacher; TextName.Text += currentTeacher.FullName; ListSchedule.ItemsSource = CollegeDBEntities.GetContext().Schedule.Where(p => p.LessonPlan.UserID == currentTeacher.UserID).OrderBy(p => p.DayID).ThenBy(p => p.LessonNumId).ToList(); CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(ListSchedule.ItemsSource); PropertyGroupDescription groupDescription = new PropertyGroupDescription("Day.DayName"); view.GroupDescriptions.Add(groupDescription); }
public ScheduleStudentPage(User student) { InitializeComponent(); if (student != null) { currentStudent = student; } DataContext = currentStudent; TextName.Text += currentStudent.Student.Gruppa.GruppaName; ListSchedule.ItemsSource = CollegeDBEntities.GetContext().Schedule.Where(p => p.LessonPlan.GruppaID == currentStudent.Student.GruppaID).OrderBy(p => p.DayID).ThenBy(p => p.LessonNumId).ToList(); CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(ListSchedule.ItemsSource); PropertyGroupDescription groupDescription = new PropertyGroupDescription("Day.DayName"); view.GroupDescriptions.Add(groupDescription); }
private void BtnDeletePlan_Click(object sender, RoutedEventArgs e) { var removingPlan = DGridTeacherPlan.SelectedItem as LessonPlan; MessageBoxResult messageBoxResult = MessageBox.Show($"Вы точно хотите удалить пункт плана для группы {removingPlan.Gruppa.GruppaName}?", "Внимание!", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { try { CollegeDBEntities.GetContext().LessonPlan.Remove(removingPlan); CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация удалена успешно!"); DGridTeacherPlan.ItemsSource = CollegeDBEntities.GetContext().LessonPlan.Where(p => p.UserID == currentTeacher.UserID).ToList(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void BtnDelete_Click(object sender, RoutedEventArgs e) { var removingSchedule = DGridSchedule.SelectedItem as Schedule; MessageBoxResult result = MessageBox.Show("Вы точно хотите удалить пункт из расписания?", "Внимание!", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { try { CollegeDBEntities.GetContext().Schedule.Remove(removingSchedule); CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Данные успешно удалены!"); DGridSchedule.ItemsSource = CollegeDBEntities.GetContext().Schedule.Where(p => p.LessonPlan.UserID == currentTeacher.UserID).OrderBy(p => p.DayID).ToList(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void BtnAddOtdel_Click(object sender, System.Windows.RoutedEventArgs e) { if (string.IsNullOrWhiteSpace(currentOtdel.OtdelName)) { MessageBox.Show("Укажите название отделения", "Внимание!"); return; } else { if (currentOtdel.OtdelID == 0) { int count = CollegeDBEntities.GetContext().Otdel.Where(p => p.OtdelName == currentOtdel.OtdelName).Count(); if (count > 0) { MessageBoxResult result = MessageBox.Show("Такое отделение уже существует! Продолжить?", "Внимание!", MessageBoxButton.YesNo); if (result == MessageBoxResult.No) { return; } } CollegeDBEntities.GetContext().Otdel.Add(currentOtdel); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена успешно!"); NavigationManager.OtdelFrame.Navigate(new OtdelViewPage()); } catch (Exception) { MessageBox.Show("При попытке сохранения произошла ошибка"); } } }
private void BtnAddClassroom_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrWhiteSpace(currentClassroom.ClassroomName)) { MessageBox.Show("Введите название/номер аудитории"); return; } else { if (currentClassroom.ClassroomID == 0) { int count = CollegeDBEntities.GetContext().Classroom.Where(p => p.ClassroomName == currentClassroom.ClassroomName).Count(); if (count > 0) { MessageBoxResult result = MessageBox.Show("Такая аудитория уже существует! Продолжить?", "Внимание!", MessageBoxButton.YesNo); if (result == MessageBoxResult.No) { return; } } CollegeDBEntities.GetContext().Classroom.Add(currentClassroom); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена успешно!"); NavigationManager.ClassroomFrame.Navigate(new ClassroomViewPage()); } catch (Exception) { MessageBox.Show("При попытке сохранения произошла ошибка"); } } }
public TeacherViewPage() { InitializeComponent(); DGridTeacher.ItemsSource = CollegeDBEntities.GetContext().User.Where(p => p.RoleID == 7).ToList(); var otdels = CollegeDBEntities.GetContext().Otdel.ToList(); otdels.Insert(0, new Otdel { OtdelName = "Все отделения" }); var genders = CollegeDBEntities.GetContext().Gender.ToList(); genders.Insert(0, new Gender { GenderName = "Не выбрано" }); ComboGender.ItemsSource = genders; ComboGender.SelectedIndex = 0; ComboOtdel.ItemsSource = otdels; ComboOtdel.SelectedIndex = 0; }
public StudentViewPage() { InitializeComponent(); var gruppas = CollegeDBEntities.GetContext().Gruppa.ToList(); gruppas.Insert(0, new Gruppa { GruppaName = "Все группы" }); var genders = CollegeDBEntities.GetContext().Gender.ToList(); genders.Insert(0, new Gender { GenderName = "Не выбрано" }); ComboGruppa.ItemsSource = gruppas; ComboGruppa.SelectedIndex = 0; ComboGender.ItemsSource = genders; ComboGender.SelectedIndex = 0; DGridStudent.ItemsSource = CollegeDBEntities.GetContext().User.Where(p => p.RoleID == 8).ToList(); }