public StudentPreviewDataView DataBaseShowStudentPreview(int indexNumber)
{
command = new MySqlCommand($"CALL wyswietl_dane_studenta_podglad('{indexNumber}')", this.conection);
reader = command.ExecuteReader();
StudentPreviewDataView studentPreviewData = new StudentPreviewDataView();
if (reader.HasRows)
{
while (reader.Read())
{
studentPreviewData.IndexNumber = int.Parse(reader.GetValue(0).ToString());
studentPreviewData.Pesel = reader.GetValue(1).ToString();
studentPreviewData.Name = reader.GetValue(2).ToString();
studentPreviewData.Surname = reader.GetValue(3).ToString();
studentPreviewData.DateOfBirth = DateTime.Parse(reader.GetValue(4).ToString());
studentPreviewData.Sex = char.Parse(reader.GetValue(5).ToString());
studentPreviewData.ContactNumber = reader.GetValue(6).ToString();
studentPreviewData.Country = reader.GetValue(7).ToString();
studentPreviewData.City = reader.GetValue(8).ToString();
studentPreviewData.Street = reader.GetValue(9).ToString();
studentPreviewData.HouseNumber = reader.GetValue(10).ToString();
studentPreviewData.ApartmentNumber = reader.GetValue(11).ToString();
studentPreviewData.PostalCode = reader.GetValue(12).ToString();
studentPreviewData.StudyFiled = reader.GetValue(13).ToString();
studentPreviewData.Degree = int.Parse(reader.GetValue(14).ToString());
studentPreviewData.Semestr = int.Parse(reader.GetValue(15).ToString());
}
}
reader.Close();
return(studentPreviewData);
}
private void ShowChoosenStudentData()
{
studentPreviewData = DbService.DataBaseShowStudentPreview(choosenIndexNumber);
tableRowContentList[0].Text = studentPreviewData.IndexNumber.ToString();
tableRowContentList[1].Text = studentPreviewData.Pesel;
tableRowContentList[2].Text = studentPreviewData.Name;
tableRowContentList[3].Text = studentPreviewData.Surname;
tableRowContentList[4].Text = studentPreviewData.DateOfBirth.ToString();
tableRowContentList[5].Text = studentPreviewData.Sex.ToString();
tableRowContentList[6].Text = studentPreviewData.ContactNumber;
tableRowContentList[7].Text = studentPreviewData.Country;
tableRowContentList[8].Text = studentPreviewData.City;
tableRowContentList[9].Text = studentPreviewData.Street;
tableRowContentList[10].Text = studentPreviewData.HouseNumber;
tableRowContentList[11].Text = studentPreviewData.ApartmentNumber;
tableRowContentList[12].Text = studentPreviewData.PostalCode;
tableRowContentList[13].Text = studentPreviewData.StudyFiled;
tableRowContentList[14].Text = studentPreviewData.Degree.ToString();
tableRowContentList[15].Text = studentPreviewData.Semestr.ToString();
}
