public static DataSet GetBankStatements(
     int journalId, DateTime transactionDateFrom, DateTime transactionDateTo, string journalEntryNumber, JournalEntryStati statuses)
 {
     //@"Key, JournalEntryNumber, Status, DisplayStatus, Journal.JournalNumber, TransactionDate, Debit, Credit, OpenAmount,
     //  DisplayOpenAmount, ClosingBalance, HasClosingBalance"
     using (IDalSession session = NHSessionFactory.CreateSession())
     {
         IJournal journal = JournalMapper.GetJournal(session, journalId);
         return JournalEntryMapper.GetJournalEntries<IBankStatement>(session, JournalTypes.BankStatement, journal,
             transactionDateFrom, transactionDateTo, journalEntryNumber, statuses, true)
             .Select(c => new
             {
                 c.Key,
                 c.JournalEntryNumber,
                 c.Status,
                 c.DisplayStatus,
                 Journal_JournalNumber =
                     c.Journal.JournalNumber,
                 c.TransactionDate,
                 c.Debit,
                 c.Credit,
                 c.OpenAmount,
                 c.DisplayOpenAmount,
                 c.ClosingBalance,
                 c.HasClosingBalance
             })
             .ToDataSet();
     }
 }
 public static DataSet GetTradingBookings(    int journalId, DateTime transactionDateFrom, DateTime transactionDateTo, string journalEntryNumber, JournalEntryStati statuses)
 {
     //@"Key, JournalEntryNumber, Status, DisplayStatus, Journal.JournalNumber, TransactionDate"
     using (IDalSession session = NHSessionFactory.CreateSession())
     {
         IJournal journal = JournalMapper.GetJournal(session, journalId);
         return JournalEntryMapper.GetJournalEntries<ITradingJournalEntry>(session, JournalTypes.ClientTransaction, journal,
             transactionDateFrom, transactionDateTo, journalEntryNumber, statuses, true)
             .Select(c => new
             {
                 c.Key,
                 c.JournalEntryNumber,
                 c.Status,
                 c.DisplayStatus,
                 Journal_JournalNumber =
                     c.Journal.JournalNumber,
                 c.TransactionDate
             })
             .ToDataSet();
     }
 }