public List <Clinica> Lista(int id)
{
conexao.Open();
string sql = "SELECT * FROM Clinica " + (id > 0 ? "WHERE id = @id" : "") + "ORDER BY nome";
MySqlCommand comandoQuery = new MySqlCommand(sql, conexao);
if (id > 0)
{
comandoQuery.Parameters.AddWithValue("@id", id);
}
MySqlDataReader reader = comandoQuery.ExecuteReader();
List <Clinica> lista = new List <Clinica>();
while (reader.Read())
{
Clinica clinica = new Clinica();
clinica.Id = reader.GetInt32("Id");
if (!reader.IsDBNull(reader.GetOrdinal("Nome")))
{
clinica.Nome = reader.GetString("Nome");
}
if (!reader.IsDBNull(reader.GetOrdinal("Detalhes")))
{
clinica.Detalhes = reader.GetString("Detalhes");
}
lista.Add(clinica);
}
conexao.Close();
return(lista);
}