private void AddDisciplineBTN_Click(object sender, RoutedEventArgs e)
{
bool isValid = true;
if (DisciplineNameTB.Text.Trim() == "")
{
DisciplineNameLB.Foreground = Brushes.Red;
isValid = false;
}
else
{
DisciplineNameLB.Foreground = Brushes.White;
}
if (TeacherTB.Text.Trim() == "")
{
TeacherLB.Foreground = Brushes.Red;
isValid = false;
}
else
{
TeacherLB.Foreground = Brushes.White;
}
if (isValid)
{
var Discipline = new Discipline()
{
Name = DisciplineNameTB.Text.Trim(),
Teacher = TeacherTB.Text.Trim()
};
DBInterface.DisciplineADD(Discipline);
}
}
private void AddAdminConfirmButton_Click(object sender, RoutedEventArgs e)
{
if (DBInterface.AdminInput(AdminLogin, Pass.Password.Trim()))
{
OnConfirm?.Invoke();
}
else
{
MessageBox.Show("Неверный пароль!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void FillStudentInfo(string StudentNumber)
{
Stud = DBInterface.GetStudent(StudentNumber);
StudNumPole.Text = Stud.StudentNumber;
StudNamePole.Text = Stud.Name;
StudSpecialtyPole.Text = Stud.Specialty;
StudFacultyPole.Text = Stud.Faculty;
StudGenderPole.Text = Stud.Gender;
StudGroupPole.Text = Stud.Group;
StudBirthdayPole.Text = Stud.DateOfBirth.ToString("d");
}
private void ResultsDG_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (ResultsDG.SelectedItem != null)
{
try
{
var Did = ((SessionResult)ResultsDG.SelectedItem).DisciplineID;
var Discipline = DBInterface.GetDiscipline(Did);
DisciplineNameLB.Text = Discipline.Name;
TeacherNameLB.Text = Discipline.Teacher;
}
catch (System.InvalidCastException)
{
return;
}
}
}
private void AdminLoginButton_Click(object sender, RoutedEventArgs e)
{
if (DBInterface.AdminInput(AdminLoginTB.Text.Trim(), AdminPassTB.Password.Trim()))
{
var AdminWindow = new AdminWindow(AdminLoginTB.Text.Trim(), AdminPassTB.Password.Trim());
AdminWindow.Show();
}
else
{
MessageBox.Show(
"Неверный логин или пароль!",
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error
);
}
}
//Login buttons logic
private void StudentLoginButton_Click(object sender, RoutedEventArgs e)
{
if (DBInterface.StudentInput(StudentNumberTB.Text.Trim()))
{
var StudWindow = new StudentWindow(StudentNumberTB.Text.Trim());
StudWindow.Show();
}
else
{
MessageBox.Show(this,
$"Cтудента с номером зачетной книги \"{StudentNumberTB.Text}\" не существует!",
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error
);
}
}
public AdminWindow(string AdminLogin, string AdminPass)
{
InitializeComponent();
StudentEditor.Init();
AdminEditor.Init();
DisciplineEditor.Init();
LoggedAdminLogin = AdminLogin;
AddAdminTab = new AddAdminTab(this);
if (!DBInterface.GetAdminPermission(AdminLogin, AdminPass))
{
AddAdminTabItem.IsEnabled = false;
}
SAddMaleRB.IsChecked = true;
SAddFemaleRB.IsChecked = false;
DataLoad();
}
private void LoadData()
{
Sessions = DBInterface.GetSessions(Stud.StudentNumber);
ResultsDG.ItemsSource = Sessions;
}
private void AddSessionResultBTN_Click(object sender, RoutedEventArgs e)
{
bool isValid = true;
if (AddResultStudentNumberTB.Text.Trim() == "")
{
AddResultStudentNumberLB.Foreground = Brushes.Red;
isValid = false;
}
else
{
AddResultStudentNumberLB.Foreground = Brushes.White;
}
if (ExamDateDP.SelectedDate == null)
{
ExamDateLB.Foreground = Brushes.Red;
isValid = false;
}
else
{
ExamDateLB.Foreground = Brushes.White;
}
if (DisciplinesDG.SelectedItem == null)
{
MessageBox.Show(this,
$"Выберите дисциплину в таблице!",
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error
);
return;
}
if (isValid)
{
var result = new SessionResult()
{
DisciplineID = ((Discipline)DisciplinesDG.SelectedItem).ID,
ExamDate = (DateTime)ExamDateDP.SelectedDate,
ExamMark = Convert.ToInt16(LRC_Label.Text)
};
if (DBInterface.SessionResultADD(AddResultStudentNumberTB.Text.Trim(), result))
{
MessageBox.Show(this,
"Результат добавлен!",
"Успех!",
MessageBoxButton.OK,
MessageBoxImage.Information
);
}
else
{
MessageBox.Show(this,
$"Студента с таким номером зачетной книги не найдено!",
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error
);
}
}
else
{
MessageBox.Show(this,
$"Не все обязательные поля заполнены!",
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error
);
}
}
private void SAddBTN_Click(object sender, RoutedEventArgs e)
{
if (SAddSNameTB.Text.Trim() != "" && SAddSNumberTB.Text.Trim() != "" && SAddSpecialtyTB.Text.Trim() != "" && SAddFacultyTB.Text.Trim() != "" && SAddGroupTB.Text.Trim() != "" && SAddMaleRB.IsChecked != null && SAddFemaleRB != null && SAddBirthdayDP.SelectedDate != null)
{
Student stud;
if (DBInterface.IsStudentNumberNotUsed(SAddSNumberTB.Text.Trim()))
{
stud = new Student()
{
Name = SAddSNameTB.Text.Trim(),
StudentNumber = SAddSNumberTB.Text.Trim(),
Specialty = SAddSpecialtyTB.Text.Trim(),
Faculty = SAddFacultyTB.Text.Trim(),
DateOfBirth = (DateTime)SAddBirthdayDP.SelectedDate,
Gender = SAddMaleRB.IsChecked == true ? "Мужской" : "Женский",
Group = SAddGroupTB.Text.Trim()
};
DBInterface.StudentADD(stud);
DataLoad();
MessageBox.Show(this,
$"Студент добавлен!",
"Успех!",
MessageBoxButton.OK,
MessageBoxImage.Information
);
}
else
{
MessageBox.Show(this,
$"Студент с таким номером зачетной книги уже существует!",
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error
);
}
}
else
{
MessageBox.Show(this,
$"Не все обязательные поля заполнены!",
"Ошибка",
MessageBoxButton.OK,
MessageBoxImage.Error
);
if (SAddSNameTB.Text == "")
{
NameLB.Foreground = Brushes.Red;
}
else
{
NameLB.Foreground = Brushes.White;
}
if (SAddSNumberTB.Text == "")
{
SNumberLB.Foreground = Brushes.Red;
}
else
{
SNumberLB.Foreground = Brushes.White;
}
if (SAddSpecialtyTB.Text == "")
{
SpecialtyLB.Foreground = Brushes.Red;
}
else
{
SpecialtyLB.Foreground = Brushes.White;
}
if (SAddFacultyTB.Text == "")
{
FacultyLB.Foreground = Brushes.Red;
}
else
{
FacultyLB.Foreground = Brushes.White;
}
if (SAddBirthdayDP.SelectedDate == null)
{
BirthdayLB.Foreground = Brushes.Red;
}
else
{
BirthdayLB.Foreground = Brushes.White;
}
if (SAddGroupTB.Text == "")
{
GroupLB.Foreground = Brushes.Red;
}
else
{
GroupLB.Foreground = Brushes.White;
}
}
}
