public async Task <List <ColorModel> > GetDadosDb()
{
List <ColorModel> lista = new List <ColorModel>();
ConnectionCommand connection = new ConnectionCommand();
var query = @"
SELECT cor.id,
cor.cor,
COUNT(idcor) as quantidade,
cor.hexa
FROM registro
INNER JOIN cor ON registro.idcor = cor.id
GROUP BY cor.cor, cor.id
ORDER BY cor, quantidade, cor.id";
NpgsqlCommand cmd = new NpgsqlCommand(query, connection.GetConnection());
var dataReader = await cmd.ExecuteReaderAsync();
while (dataReader.Read())
{
ColorModel data = new ColorModel
{
IdCor = dataReader.GetInt16(0),
Cor = dataReader.GetString(1),
Quantidade = dataReader.GetInt32(2),
Hexadecimal = dataReader.GetString(3)
};
lista.Add(data);
}
return(lista);
}
public async Task Insert(int idCor)
{
ConnectionCommand connection = new ConnectionCommand();
var query = $@"
INSERT INTO public.registro(idcor)
VALUES(" + idCor + ")";
var cmd = new NpgsqlCommand(query, connection.GetConnection());
await cmd.ExecuteNonQueryAsync();
}