SqlitePulse.SelectPulses C# (CSharp) Method

    public static string[] SelectPulses(bool dbconOpened, int sessionID, int personID)
    {
        if(!dbconOpened)
            Sqlite.Open();

        string tp = Constants.PersonTable;

        string filterPersonString = "";
        if(personID != -1)
            filterPersonString = " AND " + tp + ".uniqueID == " + personID;

        dbcmd.CommandText = "SELECT " + tp + ".name, pulse.* " +
            " FROM " + tp + ", pulse " +
            " WHERE " + tp + ".uniqueID == pulse.personID" +
            " AND pulse.sessionID == " + sessionID +
            filterPersonString +
            " ORDER BY upper(" + tp + ".name), pulse.uniqueID";

        LogB.SQL(dbcmd.CommandText.ToString());
        dbcmd.ExecuteNonQuery();

        SqliteDataReader reader;
        reader = dbcmd.ExecuteReader();

        ArrayList myArray = new ArrayList(2);

        int count = new int();
        count = 0;

        while(reader.Read()) {
            myArray.Add (reader[0].ToString() + ":" +	//person.name
                    reader[1].ToString() + ":" +	//pulse.uniqueID
                    reader[2].ToString() + ":" + 	//pulse.personID
                    reader[3].ToString() + ":" + 	//pulse.sessionID
                    reader[4].ToString() + ":" + 	//pulse.type
                    Util.ChangeDecimalSeparator(reader[5].ToString()) + ":" + //fixedPulse
                    reader[6].ToString() + ":" + //totalPulsesNum
                    Util.ChangeDecimalSeparator(reader[7].ToString()) + ":" + //timesString
                    reader[8].ToString() + ":" +  	//description
                    reader[9].ToString()	  	//simulated
                    );
            count ++;
        }

        reader.Close();

        if(!dbconOpened)
            Sqlite.Close();

        string [] myPulses = new string[count];
        count =0;
        foreach (string line in myArray) {
            myPulses [count++] = line;
        }

        return myPulses;
    }

    protected override void getData()
    {
        //create directory fileName_files/
        string directoryName = Util.GetReportDirectoryName(fileName);

        if (!Directory.Exists(directoryName))
        {
            Directory.CreateDirectory(directoryName);
        }
        else
        {
            //if it exists before, delete all pngs
            string [] pngs = Directory.GetFiles(directoryName, "*.png");
            foreach (string myFile in pngs)
            {
                File.Delete(myFile);
            }
        }

        if (ShowCurrentSessionJumpers)
        {
            myPersonsAndPS = SqlitePersonSession.SelectCurrentSessionPersons(sessionID, true);
        }

        //Leave SQL opened in all this process
        Sqlite.Open();         // ------------------------------

        if (ShowSimpleJumps)
        {
            myJumps = SqliteJump.SelectJumps(true, sessionID, -1, "", "",
                                             Sqlite.Orders_by.DEFAULT, -1);
        }
        if (ShowReactiveJumps)
        {
            myJumpsRj = SqliteJumpRj.SelectJumps(true, sessionID, -1, "", "");
        }
        if (ShowSimpleRuns)
        {
            myRuns = SqliteRun.SelectRuns(true, sessionID, -1, "",
                                          Sqlite.Orders_by.DEFAULT, -1);
        }
        if (ShowIntervalRuns)
        {
            myRunsInterval = SqliteRunInterval.SelectRuns(true, sessionID, -1, "");
        }
        if (ShowReactionTimes)
        {
            myReactionTimes = SqliteReactionTime.SelectReactionTimes(true, sessionID, -1, "",
                                                                     Sqlite.Orders_by.DEFAULT, -1);
        }
        if (ShowPulses)
        {
            myPulses = SqlitePulse.SelectPulses(true, sessionID, -1);
        }

        Sqlite.Close();         // ------------------------------
    }