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;
}