public async Task <dynamic> Execute(GetUserTransactionsByFilterMessage message) { var sql = @"select Id, RecurrentExpenseId as RecurrencyId, Name, Date, UserId, Value, 'Expense' Type from financialControl.Expenses where userId = @userId UNION select Id, RecurrentIncomeId as RecurrencyId, Name, Date, UserId, Value, 'Income' Type from financialControl.Incomes where userId = @userId order by Date asc"; var transactions = await this._dbConnection.QueryAsync <UserTransactions.Transaction>(sql, new { message.UserId }); this._dbConnection.Dispose(); return(new UserTransactions(transactions)); }
public async Task <UserTransactions> GetUserTransactionsByFilter(GetUserTransactionsByFilterMessage message) { return(await new GetUserTransactionsByFilterMessageDispatcher().Dispatch(message, this._configurations)); }