private void ButtonEnter_Click(object sender, RoutedEventArgs e)
{
string password;
if (PasswordBoxPas.Password.Length > 0)
{
password = PasswordBoxPas.Password;
}
else
{
password = TextBoxPassword.Text;
}
using (var db = new CollegeDB())
{
Employee employee = db.Employees.FirstOrDefault(c => c.Login == TextBoxLogin.Text && c.Password == password);
Student student = db.Students.FirstOrDefault(c => c.Login == TextBoxLogin.Text && c.Password == password);
if (employee != null)
{
MenuWindow window = new MenuWindow(employee.Id, employee.RoleId);
window.Show();
Close();
MessageBox.Show("Здравствуйте, " + employee.FirstName + "!", "Авторизация прошла успешно!", MessageBoxButton.OK, MessageBoxImage.Information);
}
if (student != null)
{
MenuWindow window = new MenuWindow(student.Id);
window.Show();
Close();
MessageBox.Show("Здравствуйте, " + student.FirstName + "!", "Авторизация прошла успешно!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
private void LoadExams()
{
using (var db = new CollegeDB())
{
ListViewExams.ItemsSource = db.Transcripts.ToList();
}
}
private void LoadEmployees()
{
using (var db = new CollegeDB())
{
DataGridEmployees.ItemsSource = db.Employees.Include("Role").Include("EmployeeCategory").Where(x => x.IsFired != true).ToList();
}
}
private void LoadStudents()
{
using (var db = new CollegeDB())
{
BaseStudents = db.Students.Include("Gender").Include("Group").Where(x => x.IsExpelled != true).ToList();
}
SortStudents();
}
public AddEditStudentWindow()
{
InitializeComponent(); using (var db = new CollegeDB())
{
ComboBoxGender.ItemsSource = db.Genders.ToList();
ComboBoxGroup.ItemsSource = db.Groups.ToList();
}
}
public AddEditEmployeeWindow()
{
InitializeComponent();
using (var db = new CollegeDB())
{
ComboBoxCategory.ItemsSource = db.EmployeeCategories.ToList();
ComboBoxRole.ItemsSource = db.Roles.ToList();
}
}
private void ButtonAccept_Click(object sender, RoutedEventArgs e)
{
if (StudentId > 0)
{
using (var db = new CollegeDB())
{
var student = db.Students.Find(StudentId);
if (imagePath != "")
{
student.Photo = File.ReadAllBytes(imagePath);
}
student.LastName = TextBoxLastName.Text;
student.FirstName = TextBoxFirstName.Text;
student.MiddleName = TextBoxMiddleName.Text;
student.Login = TextBoxLogin.Text;
student.Password = PasseordBoxPas.Password;
student.BirthDate = (DateTime)DatePickerBirthDate.SelectedDate;
student.Adrress = TextBoxAddress.Text;
student.GenderId = ComboBoxGender.SelectedIndex + 1;
student.GroupId = ComboBoxGroup.SelectedIndex + 1;
db.SaveChanges();
Close();
}
}
else
{
using (var db = new CollegeDB())
{
var student = new Student();
if (File.Exists(imagePath))
{
student.Photo = File.ReadAllBytes(imagePath);
}
student.LastName = TextBoxLastName.Text;
student.FirstName = TextBoxFirstName.Text;
student.MiddleName = TextBoxMiddleName.Text;
student.Login = TextBoxLogin.Text;
student.Password = PasseordBoxPas.Password;
student.BirthDate = (DateTime)DatePickerBirthDate.SelectedDate;
student.Adrress = TextBoxAddress.Text;
student.GenderId = ComboBoxGender.SelectedIndex + 1;
student.GroupId = ComboBoxGroup.SelectedIndex + 1;
db.Students.Add(student);
db.SaveChanges();
Close();
}
}
}
private void ButtonFireEmployee_Click(object sender, RoutedEventArgs e)
{
if (DataGridEmployees.SelectedIndex != -1)
{
if (MessageBox.Show("Вы уверены, что хотите уволить сотрудника? Это действие нельзя будет отменить.", "Увольнение сотрудника", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
var employeeId = (DataGridEmployees.SelectedItem as Employee).Id;
using (var db = new CollegeDB())
{
db.Employees.Find(employeeId).IsFired = true;
db.SaveChanges();
}
}
}
LoadEmployees();
}
private void ButtonExpellStudent_Click(object sender, RoutedEventArgs e)
{
if (ListViewStudents.SelectedIndex != -1)
{
if (MessageBox.Show("Вы уверены, что хотите отчислить студента? Это действие нельзя будет отменить.", "Отчисление студента", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
var studentId = (ListViewStudents.SelectedItem as Student).Id;
using (var db = new CollegeDB())
{
db.Students.Find(studentId).IsExpelled = true;
db.SaveChanges();
}
}
}
LoadStudents();
}
public AddEditEmployeeWindow(int employeeId)
{
InitializeComponent();
EmployeeId = employeeId;
using (var db = new CollegeDB())
{
ComboBoxCategory.ItemsSource = db.EmployeeCategories.ToList();
ComboBoxRole.ItemsSource = db.Roles.ToList();
var employee = db.Employees.Find(employeeId);
TextBoxLastName.Text = employee.LastName;
TextBoxFirstName.Text = employee.FirstName;
TextBoxMiddleName.Text = employee.MiddleName;
TextBoxLogin.Text = employee.Login;
PasseordBoxPas.Password = employee.Password;
ComboBoxRole.SelectedIndex = employee.RoleId - 1;
ComboBoxCategory.SelectedIndex = employee.CategoryId - 1;
}
}
public DetailsWindow(int studentId)
{
InitializeComponent();
using (var db = new CollegeDB())
{
var student = db.Students.Include("Marks").First(x => x.Id == studentId);
if (student.Photo != null)
{
ImageStudent.Source = (BitmapSource) new ImageSourceConverter().ConvertFrom(student.Photo);
}
TextBlockName.Text = student.FullName;
TextBlockGroupNumber.Text = student.GroupNumber;
var semesters = db.Marks.Where(c => c.StudentId == studentId).ToList().Select(c => c.Transcript).ToList().Select(c => c.Subject.Semester).ToList();
TabControlSemesters.ItemsSource = semesters;
}
}
private void LoadEmployees(string search)
{
if (!string.IsNullOrEmpty(search))
{
using (var db = new CollegeDB())
{
DataGridEmployees.ItemsSource = db.Employees
.Include("Role")
.Include("EmployeeCategory")
.Where(x => x.IsFired != true)
.Where(c => (c.LastName + c.FirstName + c.MiddleName).ToLower().Contains(search.ToLower()))
.ToList();
}
}
else
{
LoadEmployees();
}
}
private void ButtonAccept_Click(object sender, RoutedEventArgs e)
{
if (EmployeeId > 0)
{
using (var db = new CollegeDB())
{
var employee = db.Employees.Find(EmployeeId);
employee.LastName = TextBoxLastName.Text;
employee.FirstName = TextBoxFirstName.Text;
employee.MiddleName = TextBoxMiddleName.Text;
employee.Login = TextBoxLogin.Text;
employee.Password = PasseordBoxPas.Password;
employee.RoleId = ComboBoxRole.SelectedIndex + 1;
employee.CategoryId = ComboBoxCategory.SelectedIndex + 1;
db.SaveChanges();
Close();
}
}
else
{
using (var db = new CollegeDB())
{
var employee = new Employee();
employee.LastName = TextBoxLastName.Text;
employee.FirstName = TextBoxFirstName.Text;
employee.MiddleName = TextBoxMiddleName.Text;
employee.Login = TextBoxLogin.Text;
employee.Password = PasseordBoxPas.Password;
employee.RoleId = ComboBoxRole.SelectedIndex + 1;
employee.CategoryId = ComboBoxCategory.SelectedIndex + 1;
db.Employees.Add(employee);
db.SaveChanges();
Close();
}
}
}
public AddEditStudentWindow(int studentId)
{
InitializeComponent();
StudentId = studentId;
using (var db = new CollegeDB())
{
ComboBoxGender.ItemsSource = db.Genders.ToList();
ComboBoxGroup.ItemsSource = db.Groups.ToList();
var student = db.Students.Find(studentId);
if (student.Photo != null)
{
ImageStudent.Source = (BitmapSource) new ImageSourceConverter().ConvertFrom(student.Photo);
}
TextBoxLastName.Text = student.LastName;
TextBoxFirstName.Text = student.FirstName;
TextBoxMiddleName.Text = student.MiddleName;
TextBoxLogin.Text = student.Login;
PasseordBoxPas.Password = student.Password;
DatePickerBirthDate.SelectedDate = (DateTime)student.BirthDate;
TextBoxAddress.Text = student.Adrress;
ComboBoxGender.SelectedIndex = student.GenderId - 1;
ComboBoxGroup.SelectedIndex = student.GroupId - 1;
}
}
