public static void Init(IQueryAdapter dbClient) { dbClient.setQuery("SELECT * FROM pets_racesoncatalogue"); var Table = dbClient.getTable(); Races = new List <PetRace>(); foreach (DataRow Race in Table.Rows) { var R = new PetRace { RaceId = (int)Race["raceid"], Color1 = (int)Race["color1"], Color2 = (int)Race["color2"], Has1Color = ((string)Race["has1color"] == "1"), Has2Color = ((string)Race["has2color"] == "1") }; Races.Add(R); } }
internal static void Initialize(IQueryAdapter dbClient) { dbClient.setQuery("SELECT * FROM pet_races"); DataTable dTable = dbClient.getTable(); int raceID; int colorPrimary; int colorSecondary; bool hasPrimaryColor; bool hasSecondaryColor; raceRegister = new Hashtable(); foreach (DataRow Race in dTable.Rows) { raceID = (int)Race["raceid"]; colorPrimary = (int)Race["color1"]; colorSecondary = (int)Race["color2"]; hasPrimaryColor = ((string)Race["has1color"] == "1"); hasSecondaryColor = ((string)Race["has2color"] == "1"); PetRace race = new PetRace(raceID, colorPrimary, colorSecondary, hasPrimaryColor, hasSecondaryColor); if (raceRegister.ContainsKey(raceID)) { List<PetRace> races = (List<PetRace>)raceRegister[raceID]; races.Add(race); } else { List<PetRace> races = new List<PetRace>(); races.Add(race); raceRegister.Add(raceID, races); } } }