public List <Compra> ListaCompra()
{
List <Compra> Lista = new List <Compra>();
this.Conect();
sql = "SELECT id, data, vlrtotal, desconto, qtditens, idfornecedor FROM tbcompra order by id;";
cmd = new NpgsqlCommand(sql, con);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Compra c = new Compra();
CItemCompra i = new CItemCompra();
List <ItemCompra> itensCompra = new List <ItemCompra>();
c.setID(rdr.GetInt32(0));
c.setData(rdr.GetString(1));
c.setVlrTotal(rdr.GetDouble(2));
c.setDesconto(rdr.GetDouble(3));
c.setQtdItens(rdr.GetInt32(4));
c.setIdFornecedor(rdr.GetInt32(5));
itensCompra = i.ListarItemCompra(c.getId());
c.setItensCompra(itensCompra);
Lista.Add(c);
}
this.Desconect();
return(Lista);
}
