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