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; }
public GruppaAddEditPage(Gruppa selectedGruppa) { InitializeComponent(); if (selectedGruppa != null) { currentGruppa = selectedGruppa; } DataContext = currentGruppa; ComboSpecial.ItemsSource = CollegeDBEntities.GetContext().Special.ToList(); }
public SubjectAddEditPage(Subject selectedSubject) { InitializeComponent(); if (selectedSubject != null) { currentSubject = selectedSubject; } DataContext = currentSubject; ComboOtdel.ItemsSource = CollegeDBEntities.GetContext().Otdel.ToList(); }
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 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 SpecialAddEditPage(Special selectedSpecial) { InitializeComponent(); if (selectedSpecial != null) { currentSpecial = selectedSpecial; textMain.Text = "Редактирование специальности"; } DataContext = currentSpecial; ComboOtdel.ItemsSource = CollegeDBEntities.GetContext().Otdel.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(); }
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 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 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 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 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); }
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); }
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 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 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(); }
private void BtnAddTeacher_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (string.IsNullOrWhiteSpace(currentUser.Surname)) { errors.AppendLine("Введите фамилию"); } if (string.IsNullOrWhiteSpace(currentUser.Name)) { errors.AppendLine("Введите имя"); } if (string.IsNullOrWhiteSpace(currentUser.Login)) { errors.AppendLine("Введите логин"); } if (string.IsNullOrWhiteSpace(currentUser.Password)) { errors.AppendLine("Введите пароль"); } if (currentUser.Gender == null) { errors.AppendLine("Укажите пол"); } if (ComboOtdel.SelectedItem == null) { errors.AppendLine("Укажите отделение"); } if (currentUser.BirthDate == null) { errors.AppendLine("Укажите дату рождения"); } if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } else { currentUser.RoleID = 7; if (currentUser.UserID == 0) { if (CollegeDBEntities.GetContext().User.Where(p => p.Login == currentUser.Login).Count() > 0) { MessageBox.Show("Пользователь с таким логином уже существует!", "Внимание!"); return; } CollegeDBEntities.GetContext().User.Add(currentUser); Teacher currentTeacher = new Teacher(); currentTeacher.UserID = currentUser.UserID; currentTeacher.Otdel = ComboOtdel.SelectedItem as Otdel; currentTeacher.HasHighEducation = (bool)CheckHigh.IsChecked; CollegeDBEntities.GetContext().Teacher.Add(currentTeacher); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация успешно сохранена!"); NavigationManager.TeacherFrame.Navigate(new TeacherViewPage()); } catch (Exception) { MessageBox.Show("Произвошла ошибка при попытке сохранения данных"); } } }
public PlanViewPage() { InitializeComponent(); DGridPlan.ItemsSource = CollegeDBEntities.GetContext().User.Where(p => p.RoleID == 7).ToList(); }
public OtdelViewPage() { InitializeComponent(); DGridOtdel.ItemsSource = CollegeDBEntities.GetContext().Otdel.ToList(); }
public LoginPage() { InitializeComponent(); ComboLogin.ItemsSource = CollegeDBEntities.GetContext().User.Where(p => p.Active == true).OrderBy(p => p.Login).ToList(); }
public ClassroomViewPage() { InitializeComponent(); DGridClassroom.ItemsSource = CollegeDBEntities.GetContext().Classroom.ToList(); }
private void BtnAddStudent_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (string.IsNullOrWhiteSpace(currentUser.Surname)) { errors.AppendLine("Введите фамилию"); } if (string.IsNullOrWhiteSpace(currentUser.Name)) { errors.AppendLine("Введите имя"); } if (currentUser.Gender == null) { errors.AppendLine("Укажите пол"); } if (currentUser.BirthDate == null) { errors.AppendLine("Укажите дату рождения"); } if (string.IsNullOrWhiteSpace(currentUser.Login)) { errors.AppendLine("Введите логин"); } if (string.IsNullOrWhiteSpace(currentUser.Password)) { errors.AppendLine("Введите пароль"); } if (ComboGruppa.SelectedItem == null) { errors.AppendLine("Укажите группу"); } if (string.IsNullOrWhiteSpace(TextZach.Text)) { errors.AppendLine("Введите номер зачетки"); } if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } else { currentUser.RoleID = 8; if (currentUser.UserID == 0) { if (CollegeDBEntities.GetContext().User.Where(p => p.Login == currentUser.Login).Count() > 0) { MessageBox.Show("Пользователь с таким логином уже существует!", "Внимание!"); return; } CollegeDBEntities.GetContext().User.Add(currentUser); Student student = new Student { UserID = currentUser.UserID, Gruppa = ComboGruppa.SelectedItem as Gruppa, Zachetka = TextZach.Text }; CollegeDBEntities.GetContext().Student.Add(student); } try { CollegeDBEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена успешно!", "Внимание!"); NavigationManager.StudentFrame.Navigate(new StudentViewPage()); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void TextClassroom_TextChanged(object sender, TextChangedEventArgs e) { var currentClassroom = CollegeDBEntities.GetContext().Classroom.Where(p => p.ClassroomName.Contains(TextClassroom.Text)).ToList(); DGridClassroom.ItemsSource = currentClassroom; }