static public void SQLiteOutputTransactionsInCSV(List <MSTransaction> trList) { //MSTransaction to CSV file System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.AppendLine("MSTransactionId, MSIO, MSValue, MSCurrencyCode, MSAccountId, MSCategoryId, MSNote, MSDateTime, MSMulticurrency"); foreach (var tr in trList) { sb.AppendLine($"{tr.MSTransactionId}," + $"{tr.MSIO}," + $"{tr.MSValue}," + $"{tr.MSCurrencyCode}," + $"{MSAccount.GetName(tr.MSAccountId)}," + $"{MSCategory.GetName(tr.MSCategoryId)}," + $"{tr.MSNote}," + $"{tr.MSDateTime}," + $"{tr.MSMulticurrency}"); } //Console.WriteLine(sb.ToString()); System.IO.File.WriteAllText( System.IO.Path.Combine( AppDomain.CurrentDomain.BaseDirectory, "Transaction.csv"), sb.ToString()); }
static public void ShowAllTransaction(List <MSTransaction> trList) { int maxWidth = 80; Console.SetWindowSize(maxWidth, 25); foreach (var tr in trList) { Console.WriteLine($"{tr.MSTransactionId}," + $"{tr.MSIO}," + $"{tr.MSValue}," + $"{tr.MSCurrencyCode}," + $"{MSAccount.GetName(tr.MSAccountId)}," + $"{MSCategory.GetName(tr.MSCategoryId)}," + $"{tr.MSNote}," + $"{tr.MSDateTime}," + $"{tr.MSMulticurrency}\n"); } }