public async static Task <m.Transaction> Get(Guid id)
{
using (var db = DbAccess.ConnectionFactory())
{
m.Transaction transaction = await db.QueryFirstOrDefaultAsync <m.Transaction>(DbAccess.Select <m.Transaction>(),
new { TransactionId = id });
transaction.Category = await Category.Get(transaction.CategoryId);
transaction.Account = await Account.Get(transaction.AccountId);
return(transaction);
}
}
public async static Task <IEnumerable <m.Transaction> > Get()
{
IEnumerable <m.Category> categories = await Category.Get();
IEnumerable <m.Account> accounts = await Account.Get();
using (var db = DbAccess.ConnectionFactory())
{
IEnumerable <m.Transaction> transactions = await db.QueryAsync <m.Transaction>(DbAccess.SelectAll <m.Transaction>());
foreach (var t in transactions)
{
t.Category = categories.FirstOrDefault(c => c.CategoryId == t.CategoryId);
t.Account = accounts.FirstOrDefault(a => a.AccountId == t.AccountId);
}
return(transactions);
}
}
public async static Task <IEnumerable <FinancialManagementSystem.Models.Profile> > Get()
{
using (var db = DbAccess.ConnectionFactory())
{
return(await db.QueryAsync <FinancialManagementSystem.Models.Profile>(DbAccess.SelectAll <FinancialManagementSystem.Models.Profile>()));
}
}
public async static Task <FinancialManagementSystem.Models.Profile> Get(Guid id)
{
using (var db = DbAccess.ConnectionFactory())
{
return(await db.QueryFirstOrDefaultAsync <FinancialManagementSystem.Models.Profile>(DbAccess.Select <FinancialManagementSystem.Models.Profile>(),
new { ProfileId = id }));
}
}
public async static Task <IEnumerable <m.DailyTransaction> > GetByProfileId(Guid ProfileId, DateTime _start, DateTime _end)
{
IEnumerable <m.Category> categories = await Category.Get();
IEnumerable <m.Account> accounts = await Account.Get();
using (var db = DbAccess.ConnectionFactory())
{
IEnumerable <m.DailyTransaction> transactions = await db.QueryAsync <m.DailyTransaction>(DbAccess.SelectAll <m.DailyTransaction>() +
" WHERE ([TransactionDate] BETWEEN @s AND @e) AND (AccountId IN (SELECT AccountId FROM Account WHERE ProfileId=@ProfileId)) ORDER BY TransactionDate",
new { s = _start, e = _end, ProfileId = ProfileId });
foreach (var t in transactions)
{
t.Category = categories.FirstOrDefault(c => c.CategoryId == t.CategoryId);
t.Account = accounts.FirstOrDefault(a => a.AccountId == t.AccountId);
}
return(transactions);
}
}
