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