//use SelectJumpTypes object. Since 1.6.3
public static List<object> SelectJumpTypesNew(bool dbconOpened, string allJumpsName, string filter, bool onlyName)
{
//allJumpsName: add and "allJumpsName" value
//filter:
// "" all jumps,
// "TC" only with previous fall,
// "nonTC" only not with previous fall
// used in gui/stats.cs
//onlyName: return only type name
string whereString = "";
if(filter == "TC") { whereString = " WHERE startIn == 0 "; }
else if(filter == "nonTC") { whereString = " WHERE startIn == 1 "; }
openIfNeeded(dbconOpened);
dbcmd.CommandText = "SELECT * " +
" FROM " + Constants.JumpTypeTable + " " +
whereString +
" ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader;
reader = dbcmd.ExecuteReader();
List<object> types = new List<object>();
SelectJumpTypes type;
if(allJumpsName != "") {
type = new SelectJumpTypes(allJumpsName);
types.Add(type);
}
while(reader.Read()) {
if(onlyName) {
type = new SelectJumpTypes(reader[1].ToString());
} else {
type = new SelectJumpTypes(
Convert.ToInt32(reader[0]), //uniqueID
reader[1].ToString(), //nameEnglish
Util.IntToBool(Convert.ToInt32(reader[2].ToString())), //startIn
Util.IntToBool(Convert.ToInt32(reader[3].ToString())), //hasWeight
reader[4].ToString()); //description
}
types.Add(type);
}
reader.Close();
closeIfNeeded(dbconOpened);
return types;
}
//use SelectJumpTypes object. Since 1.6.3
public static List <object> SelectJumpTypesNew(bool dbconOpened, string allJumpsName, string filter, bool onlyName)
{
//allJumpsName: add and "allJumpsName" value
//filter:
// "" all jumps,
// "TC" only with previous fall,
// "nonTC" only not with previous fall
// used in gui/stats.cs
//onlyName: return only type name
string whereString = "";
if (filter == "TC")
{
whereString = " WHERE startIn == 0 ";
}
else if (filter == "nonTC")
{
whereString = " WHERE startIn == 1 ";
}
openIfNeeded(dbconOpened);
dbcmd.CommandText = "SELECT * " +
" FROM " + Constants.JumpTypeTable + " " +
whereString +
" ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader;
reader = dbcmd.ExecuteReader();
List <object> types = new List <object>();
SelectJumpTypes type;
if (allJumpsName != "")
{
type = new SelectJumpTypes(allJumpsName);
types.Add(type);
}
while (reader.Read())
{
if (onlyName)
{
type = new SelectJumpTypes(reader[1].ToString());
}
else
{
type = new SelectJumpTypes(
Convert.ToInt32(reader[0]), //uniqueID
reader[1].ToString(), //nameEnglish
Util.IntToBool(Convert.ToInt32(reader[2].ToString())), //startIn
Util.IntToBool(Convert.ToInt32(reader[3].ToString())), //hasWeight
reader[4].ToString()); //description
}
types.Add(type);
}
reader.Close();
closeIfNeeded(dbconOpened);
return(types);
}
