public TransactionVOut GetUnspeTransactionVOut(string id, out bool spent)
{
var sql = "SELECT * FROM unspent WHERE id=$id";
var cmd = _unspentConnection.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("id", id);
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
spent = true;
return(null);
}
reader.Read();
spent = reader["spent"].ToString().Equals("1");
return(TransactionVOut.GetVoutFromSqlReader(reader));
}
public List <TransactionVOut> GetAllTransactionVOutsForAddress(string addr)
{
var cmd = _unspentConnection.CreateCommand();
cmd.CommandText = "SELECT * FROM unspent WHERE toaddr=$to AND spent='0';";
cmd.Parameters.AddWithValue("to", addr);
var reader = cmd.ExecuteReader();
var ts = new List <TransactionVOut>();
while (reader.Read())
{
var trans = TransactionVOut.GetVoutFromSqlReader(reader);
if (_blockChainService.IsBlockInLongestChain(trans.FromBlock))
{
ts.Add(trans);
}
}
return(ts);
}
