[chronojump] SqliteJumpRj.SelectJumps return a list<JumpRj>

[Xavier de Blas <xaviblas src gnome org>]

commit 3417fead73f522a65809aef8c2588c983a621af0
Author: Xavier de Blas <xaviblas gmail com>
Date:   Wed Aug 5 18:29:42 2020 +0200

    SqliteJumpRj.SelectJumps return a list<JumpRj>

 src/sqlite/jumpRj.cs | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 56 insertions(+)
---
diff --git a/src/sqlite/jumpRj.cs b/src/sqlite/jumpRj.cs
index e40af6b8..a3e42138 100644
--- a/src/sqlite/jumpRj.cs
+++ b/src/sqlite/jumpRj.cs
@@ -22,6 +22,7 @@ using System;
 using System.Data;
 using System.IO;
 using System.Collections; //ArrayList
+using System.Collections.Generic; //List<T>
 using Mono.Data.Sqlite;
 
 
@@ -94,6 +95,61 @@ class SqliteJumpRj : SqliteJump
                return myLast;
        }
 
+       public static List<JumpRj> SelectJumps (bool dbconOpened, int sessionID, int personID, string 
filterType)
+       {
+               if(!dbconOpened)
+                       Sqlite.Open();
+
+               string sep = " WHERE ";
+
+               string filterSessionString = "";
+               if(sessionID != -1)
+               {
+                       filterSessionString = sep + "jumpRj.sessionID = " + sessionID;
+                       if(sep == " WHERE ")
+                               sep = " AND ";
+               }
+
+               string filterPersonString = "";
+               if(personID != -1)
+               {
+                       filterPersonString = sep + "jumpRj.personID = " + personID;
+                       if(sep == " WHERE ")
+                               sep = " AND ";
+               }
+
+               string filterTypeString = "";
+               if(filterType != "")
+               {
+                       filterTypeString = sep + "jumpRj.type = \"" + filterType + "\"";
+                       if(sep == " WHERE ")
+                               sep = " AND ";
+               }
+
+               dbcmd.CommandText = "SELECT * FROM jumpRj" +
+                       filterSessionString +
+                       filterPersonString +
+                       filterTypeString;
+
+               LogB.SQL(dbcmd.CommandText.ToString());
+               dbcmd.ExecuteNonQuery();
+
+               SqliteDataReader reader;
+               reader = dbcmd.ExecuteReader();
+
+               List<JumpRj> jmpRj_l = new List<JumpRj>();
+
+               while(reader.Read())
+                       jmpRj_l.Add (new JumpRj(DataReaderToStringArray(reader, 19)));
+
+               reader.Close();
+
+               if(!dbconOpened)
+                       Sqlite.Close();
+
+               return jmpRj_l;
+       }
+
        public static string[] SelectJumpsSA(bool dbconOpened, int sessionID, int personID, string 
filterWeight, string filterType) 
        {
                if(!dbconOpened)