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); }