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