private void UpdateSubjec_Click(object sender, RoutedEventArgs e)
{
if (tbSubjectId.Text != "" && ValidationPages.CheckValue(tbSubject, txtError, "Введите название предмета"))
{
Subjects subjects = new Subjects();
subjects.Id = Convert.ToInt16(tbSubjectId.Text);
subjects.SubjectName = tbSubject.Text;
SubjectsManager subjectsManager = new SubjectsManager();
int newArticleID = subjectsManager.UpdateSubjects(subjects);
Console.WriteLine(newArticleID);
//обновить
lstSubjects.ItemsSource = subjectsManager.GetSubjects();
}
}
private void AddSubjec_Click(object sender, RoutedEventArgs e)
{
if (ValidationPages.CheckValue(tbSubject, txtError, "Введите название предмета"))
{
Subjects subjects = new Subjects();
subjects.SubjectName = tbSubject.Text;
tbSubjectId.Text = "";
SubjectsManager subjectsManager = new SubjectsManager();
int newSubjectId = subjectsManager.InsertSubjects(subjects);
Console.WriteLine(newSubjectId);
//обновить
lstSubjects.ItemsSource = subjectsManager.GetSubjects();
}
}
private void UpdateClass_Click(object sender, RoutedEventArgs e)
{
if (tbNumbersId.Text != "" && ValidationPages.CheckValue(cbTeacher_Id, tbNumbers, txtError, "Выберите преподавателя", "введите номер класса") && cbTeacher_Id.SelectedValue != null)
{
Classe newClasse = new Classe();
newClasse.Id = Convert.ToInt16(tbNumbersId.Text);
newClasse.Numbers = tbNumbers.Text.ToUpper();
newClasse.Teacher_Id = Convert.ToInt16(cbTeacher_Id.SelectedValue);
ClassManager classeManager = new ClassManager();
int newClasseID = classeManager.UpdateClasse(newClasse);
Console.WriteLine(newClasseID);
//обновить
lstClass.ItemsSource = classeManager.GetClasse();
}
}
private void UpdateExam_Click(object sender, RoutedEventArgs e)
{
if (tbExaId.Text != "" && ValidationPages.CheckValue(cbStudents, cbSubject, tbAssessment, txtError, "Выберите студента", "Выберите предмет", "Введите оценку студента"))
{
Exam exam = new Exam();
exam.Id = Convert.ToInt32(tbExaId.Text);
exam.Students_id = Convert.ToInt32(cbStudents.SelectedValue);
exam.Subjects_id = Convert.ToInt32(cbSubject.SelectedValue);
exam.Assessment = Convert.ToInt32(tbAssessment.Text);
ExamManager examManager = new ExamManager();
int newArticleID = examManager.UpdateExam(exam);
Console.WriteLine(newArticleID);
//обновить
lstExam.ItemsSource = examManager.GetExamModel();
}
}
private void AddTeachers(object sender, RoutedEventArgs e)
{
if (ValidationPages.CheckValue(txtDateOfBirth, txtFIO, txtPhone, txtAddress, cbSubject, txtError,
"Введите дату", "Введите Фамилию Имя Отчество",
"Напишите свой номер телефона", "Напишите адрес", "Выберите предмет"))
{
Teachers teachers = new Teachers();
teachers.FIO = txtFIO.Text;
teachers.DateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text);
teachers.Address = txtAddress.Text;
teachers.Phone = txtPhone.Text;
teachers.Subjects_id = Convert.ToInt32(cbSubject.SelectedValue);
TeachersManager teachersManagercs = new TeachersManager();
int newClasseID = teachersManagercs.InsertSubjects(teachers);
Console.WriteLine(newClasseID);
//обновить
lstTeachers.ItemsSource = teachersManagercs.GetTeachers();
}
}
private void AddStudent_Click(object sender, RoutedEventArgs e)
{
if (ValidationPages.CheckValue(txtDateOfBirth, txtFIO, txtPhone, txtAddress, cbClass, txtError,
"Введите дату", "Введите Фамилию Имя Отчество",
"Напишите свой номер телефона", "Напишите адрес", "Выберите класс"))
{
Students students = new Students();
students.FIO = txtFIO.Text;
students.YearOfStudy = Convert.ToDateTime(txtDateOfBirth.SelectedDate.Value);
students.Address = txtAddress.Text;
students.Phone = txtPhone.Text;
students.Class_id = Convert.ToInt32(cbClass.SelectedValue);
StudentManager studentManager = new StudentManager();
int newClasseID = studentManager.InsertSubjects(students);
Console.WriteLine(newClasseID);
//обновить
lstStudent.ItemsSource = studentManager.GetStudents();
}
}
