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