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