X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fui%2Ftransaction_list%2FTransactionListViewModel.java;h=480c0de271b9d4d71d0f2215c84102a04e482c07;hp=10aa2e9bc62630949cf9df03607463bc12d306de;hb=a5971dd3588704cc5c8dd9077d4d74860c5a06a9;hpb=ce34e7c2b46cc78021d9b93f6b82b73bb1bc432a

diff --git a/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java b/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java
index 10aa2e9b..480c0de2 100644
--- a/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java
+++ b/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java
@@ -18,7 +18,42 @@
 package net.ktnx.mobileledger.ui.transaction_list;
 
 import android.arch.lifecycle.ViewModel;
+import android.content.Context;
+import android.database.Cursor;
+import android.database.sqlite.SQLiteDatabase;
+import android.util.Log;
+
+import net.ktnx.mobileledger.model.LedgerTransaction;
+import net.ktnx.mobileledger.utils.MLDB;
+
+import java.util.ArrayList;
 
 public class TransactionListViewModel extends ViewModel {
-    // TODO: Implement the ViewModel
+
+    private ArrayList<LedgerTransaction> transactions;
+
+    public void reloadTransactions(Context context) {
+        ArrayList<LedgerTransaction> newList = new ArrayList<>();
+
+        String sql = "SELECT id FROM transactions ORDER BY date desc, id desc";
+
+        try (SQLiteDatabase db = MLDB.getReadableDatabase(context)) {
+            try (Cursor cursor = db.rawQuery(sql, null)) {
+                while (cursor.moveToNext()) {
+                    newList.add(new LedgerTransaction(cursor.getInt(0)));
+                }
+                transactions = newList;
+                Log.d("transactions", "transaction list updated");
+            }
+        }
+
+    }
+    public LedgerTransaction getTransaction(int position) {
+        if (position >= transactions.size()) return null;
+        return transactions.get(position);
+    }
+    public int getTransactionCount() {
+        if (transactions == null) return 0;
+        return transactions.size();
+    }
 }