public IList <AreaEstudo> ObterAreaEstudoGeral() { var listagem = new List <AreaEstudo>(); var sql = @"SELECT id_area_geral, area_geral_descricao FROM area_estudo_geral"; using (SqlConnection connection = _connection) { connection.Open(); using (var command = new SqlCommand(sql, connection)) { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var area = new AreaEstudo() { Id = Convert.ToInt32(reader["id_area_geral"]), Descricao = reader["area_geral_descricao"].ToString() }; listagem.Add(area); } } } } return(listagem); }
public IList <AreaEstudo> ObterAreaEstudoEspecifica(int idAreaEstudoGeral) { var listagem = new List <AreaEstudo>(); var sql = @"SELECT id_area_estudo_especifico, area_especifica_descricao FROM area_estudo_especifico WHERE area_geral_vinculada = @areageral"; using (SqlConnection connection = _connection) { connection.Open(); using (var command = new SqlCommand(sql, connection)) { command.Parameters.AddWithValue("@areageral", idAreaEstudoGeral); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var area = new AreaEstudo() { Id = Convert.ToInt32(reader["id_area_estudo_especifico"]), Descricao = reader["area_especifica_descricao"].ToString() }; listagem.Add(area); } } } } return(listagem); }