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