public static JumpType SelectAndReturnJumpType(string typeName, bool dbconOpened)
{
if (!dbconOpened)
{
Sqlite.Open();
}
dbcmd.CommandText = "SELECT * " +
" FROM " + Constants.JumpTypeTable + " " +
" WHERE name = \"" + typeName +
"\" ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader;
reader = dbcmd.ExecuteReader();
JumpType myJumpType = new JumpType();
while (reader.Read())
{
myJumpType.Name = reader[1].ToString();
myJumpType.StartIn = Util.IntToBool(Convert.ToInt32(reader[2].ToString()));
myJumpType.HasWeight = Util.IntToBool(Convert.ToInt32(reader[3].ToString()));
myJumpType.Description = reader[4].ToString();
}
myJumpType.IsPredefined = myJumpType.FindIfIsPredefined();
reader.Close();
if (!dbconOpened)
{
Sqlite.Close();
}
return(myJumpType);
}
public static JumpType SelectAndReturnJumpType(string typeName, bool dbconOpened)
{
if(!dbconOpened)
Sqlite.Open();
dbcmd.CommandText = "SELECT * " +
" FROM " + Constants.JumpTypeTable + " " +
" WHERE name = \"" + typeName +
"\" ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader;
reader = dbcmd.ExecuteReader();
JumpType myJumpType = new JumpType();
while(reader.Read()) {
myJumpType.Name = reader[1].ToString();
myJumpType.StartIn = Util.IntToBool(Convert.ToInt32(reader[2].ToString()));
myJumpType.HasWeight = Util.IntToBool(Convert.ToInt32(reader[3].ToString()));
myJumpType.Description = reader[4].ToString();
}
myJumpType.IsPredefined = myJumpType.FindIfIsPredefined();
reader.Close();
if(!dbconOpened)
Sqlite.Close();
return myJumpType;
}
public static JumpType SelectAndReturnJumpRjType(string typeName, bool dbconOpened)
{
if(!dbconOpened)
Sqlite.Open();
dbcmd.CommandText = "SELECT * " +
" FROM " + Constants.JumpRjTypeTable + " " +
" WHERE name = \"" + typeName +
"\" ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader;
reader = dbcmd.ExecuteReader();
JumpType myJumpType = new JumpType();
while(reader.Read()) {
myJumpType.Name = reader[1].ToString();
if(reader[2].ToString() == "1") { myJumpType.StartIn = true; }
else { myJumpType.StartIn = false; }
if(reader[3].ToString() == "1") { myJumpType.HasWeight = true; }
else { myJumpType.HasWeight = false; }
myJumpType.IsRepetitive = true;
if(reader[4].ToString() == "1") { myJumpType.JumpsLimited = true; }
else { myJumpType.JumpsLimited = false; }
myJumpType.FixedValue = Convert.ToInt32( reader[5].ToString() );
}
myJumpType.IsPredefined = myJumpType.FindIfIsPredefined();
reader.Close();
if(!dbconOpened)
Sqlite.Close();
return myJumpType;
}
public static JumpType SelectAndReturnJumpRjType(string typeName, bool dbconOpened)
{
if (!dbconOpened)
{
Sqlite.Open();
}
dbcmd.CommandText = "SELECT * " +
" FROM " + Constants.JumpRjTypeTable + " " +
" WHERE name = \"" + typeName +
"\" ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader;
reader = dbcmd.ExecuteReader();
JumpType myJumpType = new JumpType();
while (reader.Read())
{
myJumpType.Name = reader[1].ToString();
if (reader[2].ToString() == "1")
{
myJumpType.StartIn = true;
}
else
{
myJumpType.StartIn = false;
}
if (reader[3].ToString() == "1")
{
myJumpType.HasWeight = true;
}
else
{
myJumpType.HasWeight = false;
}
myJumpType.IsRepetitive = true;
if (reader[4].ToString() == "1")
{
myJumpType.JumpsLimited = true;
}
else
{
myJumpType.JumpsLimited = false;
}
myJumpType.FixedValue = Convert.ToInt32(reader[5].ToString());
}
myJumpType.IsPredefined = myJumpType.FindIfIsPredefined();
reader.Close();
if (!dbconOpened)
{
Sqlite.Close();
}
return(myJumpType);
}
