SqliteRunIntervalType.SelectRunIntervalTypes C# (CSharp) Method

SelectRunIntervalTypes() public static method

public static SelectRunIntervalTypes ( string allRunsName, bool onlyName ) : string[]
allRunsName string
onlyName bool
return string[]
    public static string[] SelectRunIntervalTypes(string allRunsName, bool onlyName)
    {
        Sqlite.Open();
        dbcmd.CommandText = "SELECT * " +
            " FROM " + Constants.RunIntervalTypeTable +
            " ORDER BY 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()) {
            if(onlyName) {
                myArray.Add (reader[1].ToString());
            } else {
                myArray.Add (reader[0].ToString() + ":" +	//uniqueID
                        reader[1].ToString() + ":" +	//name
                        reader[2].ToString() + ":" + 	//distance
                        reader[3].ToString() + ":" + 	//tracksLimited
                        reader[4].ToString() + ":" + 	//fixedValue
                        reader[5].ToString() + ":" + 	//unlimited
                        reader[6].ToString() + ":" +	//description
                        Util.ChangeDecimalSeparator(reader[7].ToString())	//distancesString
                        );
            }
            count ++;
        }

        reader.Close();
        Sqlite.Close();

        int numRows;
        if(allRunsName != "") {
            numRows = count +1;
        } else {
            numRows = count;
        }
        string [] myTypes = new string[numRows];
        count =0;
        if(allRunsName != "") {
            myTypes [count++] = allRunsName;
        }
        foreach (string line in myArray) {
            myTypes [count++] = line;
        }

        return myTypes;
    }