private Purchases buildPurchases(MySqlDataReader data)
{
Purchases item = new Purchases(
data.GetInt16("id"),
data.GetInt16("id_compra"),
data.GetDouble("cantidad"),
data.GetInt16("id_producto"),
data.GetDouble("p_u"),
data.GetDouble("total")
);
return(item);
}
public List <Purchases> getPurchases(int id)
{
string query = "select id, id_compra, cantidad, id_producto, p_u,total from tbadetcompras where id_compra='" + id.ToString() + "'";
MySqlDataReader data = runQuery(query);
List <Purchases> result = new List <Purchases>();
if (data.HasRows)
{
while (data.Read())
{
Purchases item = buildPurchases(data);
result.Add(item);
}
}
return(result);
}
