/// <summary> /// Метод, который получает всех студентов по заданным параметрам /// </summary> /// <param name="student"></param> /// <returns></returns> public List <Student> GetStudent(StudentSearchObject student) { var students = new List <Student>(); conn.Open(); try { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = StudentsDbRequest(student); var reader = cmd.ExecuteReader(); while (reader.Read()) { students.Add(new Student((int)reader["idstudent"], (string)reader["firstname"], (string)reader["lastname"], (string)reader["pastname"], (bool)reader["male"], student.Group)); } } catch (NullReferenceException) { throw; } finally { conn.Close(); conn.Dispose(); } return(students); }
/// <summary> /// Метод для автотестов /// </summary> /// <param name="studentSearch">Студент</param> /// <param name="date">Дата занятия</param> /// <param name="classroom">Аудитория</param> /// <param name="subject">Предмет</param> /// <returns></returns> public MainWindow FillPage(StudentSearchObject studentSearch, DateTime date, string classroom, string subject) { PickStudentClickEvent(null, null); studentInfoPage.FillPage(studentSearch).PickFirstStudent(); dpDate.SelectedDate = date; cmbClassroom.SelectedIndex = cmbClassroom.Items.IndexOf(classroom); cmbSubject.SelectedIndex = cmbSubject.Items.IndexOf(subject); return(this); }
/// <summary> /// Метод для автотестов /// </summary> /// <param name="studentSearch">Параметры студента</param> /// <returns></returns> public StudentInfoPage FillPage(StudentSearchObject studentSearch) { tbFirstName.Text = studentSearch.FirstName; tbLastName.Text = studentSearch.LastName; tbPastName.Text = studentSearch.PastName; if (studentSearch.Male) { rbMan.IsChecked = true; } else { rbWoman.IsChecked = true; } cmbGroupName.SelectedIndex = cmbGroupName.Items.IndexOf(studentSearch.Group); SearchClickEvent(this, null); return(this); }
private String StudentsDbRequest(StudentSearchObject student) { string request; var male = student.Male ? 1 : 0; request = "SELECT * FROM vcsdb.students " + $"WHERE firstname = '{student.FirstName}' " + $"AND lastname = '{student.LastName}' " + $"AND male = '{male}' "; if (student.PastName != null) { request += $"AND pastname = '{student.PastName}' "; } if (student.Group != null) { request += $"AND idstudentgroup = (select idstudentgroup from vcsdb.studentgroups where studentgroup = '{student.Group}');"; } request += ";"; return(request); }