public Task <IEnumerable <MfAggrTransaction> > GetLastOneAsync(MfAggrTransactionSearch option, CancellationToken token = default(CancellationToken)) { var query = @" SELECT TOP 1 tr.* FROM [dbo].[MfAggrTransaction] tr WHERE tr.[CompanyId] = @CompanyId"; if (option.CurrencyId.HasValue) { query += @" AND tr.[CurrencyId] = @CurrencyId"; } query += @" ORDER BY tr.[CreateAt] DESC "; return(dbHelper.GetItemsAsync <MfAggrTransaction>(query, option, token)); }
public Task <IEnumerable <MfAggrTransaction> > GetLastOneAsync(MfAggrTransactionSearch option, CancellationToken token = default(CancellationToken)) => mfAggrTransactionQueryProcessor.GetLastOneAsync(option, token);
public async Task <MfAggrTransaction> GetLastOne(MfAggrTransactionSearch option, CancellationToken token) => (await mfAggrTransactionProcessor.GetLastOneAsync(option, token)).FirstOrDefault();
public async Task <MfAggrTransaction[]> Get(MfAggrTransactionSearch option, CancellationToken token) => (await mfAggrTransactionProcessor.GetAsync(option, token)).ToArray();
public Task <IEnumerable <MfAggrTransaction> > GetAsync(MfAggrTransactionSearch option, CancellationToken token = default(CancellationToken)) { var query = @" SELECT tr.* , ac.[DisplayName] [AccountName] , sb.[Name] [SubAccountName] , sb.[AccountTypeName] , sb.[AccountNumber] FROM [dbo].[MfAggrTransaction] tr INNER JOIN [dbo].[MfAggrAccount] ac ON ac.[Id] = tr.[AccountId] INNER JOIN [dbo].[MfAggrSubAccount] sb ON sb.[Id] = tr.[SubAccountId] LEFT JOIN [dbo].[BankAccountType] at ON at.[Id] = sb.[AccountTypeId] WHERE tr.[CompanyId] = @CompanyId"; if (option.CurrencyId.HasValue) { query += @" AND tr.[CurrencyId] = @CurrencyId"; } if (option.RecordedAtFrom.HasValue) { query += @" AND tr.[RecordedAt] >= @RecordedAtFrom"; } if (option.RecordedAtTo.HasValue) { query += @" AND tr.[RecordedAt] <= @RecordedAtTo"; } if (!string.IsNullOrEmpty(option.AccountName)) { option.AccountName = Sql.GetWrappedValue(option.AccountName); query += @" AND ac.[DisplayName] LIKE @AccountName"; } if (!string.IsNullOrEmpty(option.SubAccountName)) { option.SubAccountName = Sql.GetWrappedValue(option.SubAccountName); query += @" AND sb.[Name] LIKE @SubAccountName"; } if (!string.IsNullOrEmpty(option.BankCode)) { query += @" AND ac.[BankCode] = @BankCode"; } if (!string.IsNullOrEmpty(option.BranchCode)) { query += @" AND sb.[BranchCode] = @BranchCode"; } if (!string.IsNullOrEmpty(option.AccountTypeName)) { option.AccountTypeName = Sql.GetWrappedValue(option.AccountTypeName); query += @" AND sb.[AccountTypeName] LIKE @AccountTypeName"; } if (option.AccountTypeId.HasValue) { query += @" AND sb.[AccountTypeId] = @AccountTypeId"; } if (!string.IsNullOrEmpty(option.AccountNumber)) { query += @" AND sb.[AccountNumber] = @AccountNumber"; } query += @" ORDER BY tr.[Id] ASC "; return(dbHelper.GetItemsAsync <MfAggrTransaction>(query, option, token)); }