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