public List <CourseDTO> listAllCourses()
{
string query = "Select * from tb_Curso";
SchoolDatabase d = new SchoolDatabase();
MySqlDataReader r = d.ExecuteSelect(query);
List <CourseDTO> itens = new List <CourseDTO>();
while (r.Read())
{
CourseDTO t = new CourseDTO();
t.ID = r.GetInt32("id_trab");
t.Name = r.GetString("nm_nome");
t.Phone = r.GetString("nr_telefone");
t.Address = r.GetString("nm_endereco");
t.CellPhone = r.GetString("nm_celular");
t.Renewal = r.GetInt32("nr_data");
itens.Add(t);
}
return(itens);
}
