public async Task <Wallet[]> GetWallets()
{
return(await SqlExecutor.ExecuteStoreProcedureReader(_configuration.ConnectionString,
"Wallets_GetAll",
dr => new Wallet()
{
Balance = (decimal)dr["Balance"],
Name = (string)dr["Name"]
}));
}
public async Task <InTransaction[]> GetLast()
{
return(await SqlExecutor.ExecuteStoreProcedureReader(_configuration.ConnectionString,
"InTransactions_GetLast",
dr => new InTransaction()
{
TxId = (string)dr["TxId"],
Address = (string)dr["Address"],
TimeReceived = (DateTime)dr["TimeReceived"],
Confirmations = (int)dr["Confirmations"],
Amount = (decimal)dr["Amount"]
}));
}
public async Task <Wallet[]> GetWalletsForTransaction(decimal amount)
{
return(await SqlExecutor.ExecuteStoreProcedureReader(_configuration.ConnectionString,
"Wallets_ForTransaction",
dr => new Wallet()
{
Balance = (decimal)dr["Balance"],
Name = (string)dr["Name"]
},
new[]
{
new SqlParameter("@Amount", amount),
}));
}
