//use SelectRunITypes object. Since 1.6.3
public static List <object> SelectRunIntervalTypesNew(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();
List <object> types = new List <object>();
SelectRunITypes type;
if (allRunsName != "")
{
type = new SelectRunITypes(allRunsName);
types.Add(type);
}
while (reader.Read())
{
if (onlyName)
{
type = new SelectRunITypes(reader[1].ToString());
}
else
{
type = new SelectRunITypes(
Convert.ToInt32(reader[0]), //uniqueID
reader[1].ToString(), //nameEnglish
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[2].ToString())), //distance
Util.IntToBool(Convert.ToInt32(reader[3].ToString())), //tracksLimited
Convert.ToInt32(reader[4].ToString()), //fixedValue
Util.IntToBool(Convert.ToInt32(reader[5].ToString())), //unlimited
reader[6].ToString(), //description
Util.ChangeDecimalSeparator(reader[7].ToString()) //distancesString
);
}
types.Add(type);
}
reader.Close();
Sqlite.Close();
return(types);
}
//use SelectRunITypes object. Since 1.6.3
public static List<object> SelectRunIntervalTypesNew(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();
List<object> types = new List<object>();
SelectRunITypes type;
if(allRunsName != "") {
type = new SelectRunITypes(allRunsName);
types.Add(type);
}
while(reader.Read()) {
if(onlyName) {
type = new SelectRunITypes(reader[1].ToString());
} else {
type = new SelectRunITypes(
Convert.ToInt32(reader[0]), //uniqueID
reader[1].ToString(), //nameEnglish
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[2].ToString())), //distance
Util.IntToBool(Convert.ToInt32(reader[3].ToString())), //tracksLimited
Convert.ToInt32(reader[4].ToString()), //fixedValue
Util.IntToBool(Convert.ToInt32(reader[5].ToString())), //unlimited
reader[6].ToString(), //description
Util.ChangeDecimalSeparator(reader[7].ToString()) //distancesString
);
}
types.Add(type);
}
reader.Close();
Sqlite.Close();
return types;
}
