internal static IEnumerable <HDTransactionData> GetAllTransactions(DBConnection conn, int walletId, int?accountIndex, int?addressType, int?addressIndex, int limit = int.MaxValue, HDTransactionData prev = null, bool descending = true) { return(conn.Query <HDTransactionData>($@" SELECT * FROM HDTransactionData WHERE WalletId = {walletId} {((accountIndex == null) ? $@" AND AccountIndex IN (SELECT AccountIndex FROM HDAccount WHERE WalletId = {walletId})" : $@" AND AccountIndex = {accountIndex}")} {((addressType == null) ? $@"
internal static IEnumerable <HDTransactionData> GetAllTransactions(DBConnection conn, int walletId, int?accountIndex, int?addressType, int?addressIndex, int limit = int.MaxValue, HDTransactionData prev = null, bool descending = true) { string strWalletId = DBParameter.Create(walletId); string strAccountIndex = DBParameter.Create(accountIndex); string strAddressType = DBParameter.Create(addressType); string strAddressIndex = DBParameter.Create(addressIndex); string strLimit = DBParameter.Create(limit); string strPrevTime = DBParameter.Create(prev?.OutputTxTime); string strPrevIndex = DBParameter.Create(prev?.OutputIndex); return(conn.Query <HDTransactionData>($@" SELECT * FROM HDTransactionData WHERE WalletId = {strWalletId} {((accountIndex == null) ? $@" AND AccountIndex IN (SELECT AccountIndex FROM HDAccount WHERE WalletId = {strWalletId})" : $@" AND AccountIndex = {strAccountIndex}")} {((addressType == null) ? $@"