public async Task <List <Bill> > GetBills()
{
var bills = new List <Bill>();
await Task.Run(() =>
{
try
{
using (var conn = new ShortConnection(connectionString))
{
bills = conn.Query <Bill>(@"SELECT * FROM Bill");
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
});
return(bills);
}
public async Task <List <BankAccount> > GetBankAccounts()
{
var accts = new List <BankAccount>();
await Task.Run(() =>
{
try
{
using (var conn = new ShortConnection(connectionString))
{
accts = conn.Query <BankAccount>(@"SELECT * FROM BankAccount");
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
});
return(accts);
}
public async Task <List <string> > GetBillPayees()
{
var distinctPayees = new List <string>();
var distinctBills = new List <Bill>();
await Task.Run(() =>
{
try
{
using (var conn = new ShortConnection(connectionString))
{
distinctBills = conn.Query <Bill>(@"SELECT DISTINCT Payee FROM Bill ORDER BY Payee");
}
var tmp = distinctBills.Select(x => x.Payee);
distinctPayees = tmp.ToList();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
});
return(distinctPayees);
}
