public List <StudentDTO> ShowStudents()
{
List <StudentDTO> list = new List <StudentDTO>();
using (SqlCommand cmd = new SqlCommand())
{
try
{
Connection.Open();
cmd.Connection = Connection;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "Select * From Student";
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
StudentDTO dto = new StudentDTO()
{
ID = dr.GetInt32(dr.GetOrdinal("ID")),
LastName = dr["LastName"].ToString(),
FirstName = dr["FirstName"].ToString(),
CNE = dr["CNE"].ToString(),
};
list.Add(dto);
}
}
}
catch (Exception)
{
Console.WriteLine("Erreur");
}
finally
{
Connection.Close();
}
}
return(list);
}
static void Main(string[] args)
{
string search = string.Empty;
StudentBL bl = new StudentBL();
while (search != "x")
{
Console.WriteLine("Vous cherchez quel étudiant ? (ou x pour sortir)");
search = Console.ReadLine();
if (int.TryParse(search, out int id))
{
// Un seul étudiant avec son ID
StudentDTO dto = bl.GetStudentByID(id);
if (dto != null)
{
Console.WriteLine(dto);
}
else
{
Console.WriteLine("Aucun étudiant correspond à cet ID : " + id);
}
}
else
{
//Une liste d'étudiants
List <StudentDTO> list = bl.SearchStudents(search);
if (list.Count > 0)
{
list.ForEach(s => Console.WriteLine(s));
}
else
{
Console.WriteLine("Aucun étudiant correspond à : " + search);
}
}
}
}
