public async static Task Update(FinancialManagementSystem.Models.Transaction obj) { using (var db = DbAccess.ConnectionFactory()) { await db.ExecuteAsync(DbAccess.Update <FinancialManagementSystem.Models.Transaction>(), obj); } }
public async static Task <FinancialManagementSystem.Models.Transaction> Get(Guid id) { using (var db = DbAccess.ConnectionFactory()) { FinancialManagementSystem.Models.Transaction transaction = await db.QueryFirstOrDefaultAsync <FinancialManagementSystem.Models.Transaction>(DbAccess.Select <FinancialManagementSystem.Models.Transaction>(), new { TransactionId = id }); transaction.Category = await Category.Get(transaction.CategoryId); transaction.Account = await Account.Get(transaction.AccountId); return(transaction); } }