public SpeciesData(SpeciesData species) { species_id = species.species_id; name = species.name; organism_type = species.organism_type; description = species.description; biomass = species.biomass; diet_type = species.diet_type; trophic_level = species.trophic_level; level = species.level; predatorList = new Dictionary <int, string>(); foreach (KeyValuePair <int, string> predator in species.predatorList) { predatorList.Add(predator.Key, predator.Value); } preyList = new Dictionary <int, string>(); foreach (KeyValuePair <int, string> prey in species.preyList) { preyList.Add(prey.Key, prey.Value); } categoryList = new string[0]; image = species.image; }
public SpeciesData(SpeciesData species) { species_id = species.species_id; name = species.name; organism_type = species.organism_type; description = species.description; biomass = species.biomass; diet_type = species.diet_type; trophic_level = species.trophic_level; level = species.level; predatorList = new Dictionary<int, string>(); foreach (KeyValuePair<int, string> predator in species.predatorList) { predatorList.Add(predator.Key, predator.Value); } preyList = new Dictionary<int, string>(); foreach (KeyValuePair<int, string> prey in species.preyList) { preyList.Add(prey.Key, prey.Value); } categoryList = new string[0]; image = species.image; }
public static NetworkResponse Parse(MemoryStream dataStream) { ResponseSpeciesList response = new ResponseSpeciesList(); Dictionary <int, SpeciesData> speciesList = new Dictionary <int, SpeciesData>(); int size = DataReader.ReadShort(dataStream); //Debug.Log ("species list size is: " + size); for (int i = 0; i < size; i++) { SpeciesData species = new SpeciesData(DataReader.ReadInt(dataStream)); species.level = DataReader.ReadShort(dataStream); //Debug.Log ("species list level is: " + species.level); species.name = DataReader.ReadString(dataStream); species.description = DataReader.ReadString(dataStream); short numArgs = DataReader.ReadShort(dataStream); string[] extraArgs = new string[numArgs]; for (int j = 0; j < numArgs; j++) { string arg = DataReader.ReadString(dataStream); extraArgs[j] = arg; } species.biomass = int.Parse(extraArgs[0]); species.diet_type = short.Parse(extraArgs[1]); species.trophic_level = float.Parse(extraArgs[2]); Dictionary <int, string> predatorList = species.predatorList; foreach (string predator_id in extraArgs[3].Split(new string[] { "," }, StringSplitOptions.None)) { if (predator_id != "") { predatorList.Add(int.Parse(predator_id), ""); } } Dictionary <int, string> preyList = species.preyList; foreach (string prey_id in extraArgs[4].Split(new string[] { "," }, StringSplitOptions.None)) { if (prey_id != "") { preyList.Add(int.Parse(prey_id), ""); } } species.categoryList = DataReader.ReadString(dataStream).Split(new string[] { ", " }, StringSplitOptions.None); speciesList.Add(species.species_id, species); //Constants.speciesList = speciesList; } //Debug.Log("Reached here!!----------" + Constants.speciesList.Count); response.speciesList = speciesList; return(response); }
public static NetworkResponse Parse(MemoryStream dataStream) { ResponseSpeciesList response = new ResponseSpeciesList(); Dictionary<int, SpeciesData> speciesList = new Dictionary<int, SpeciesData>(); int size = DataReader.ReadShort(dataStream); //Debug.Log ("species list size is: " + size); for (int i = 0; i < size; i++) { SpeciesData species = new SpeciesData(DataReader.ReadInt(dataStream)); species.level = DataReader.ReadShort(dataStream); //Debug.Log ("species list level is: " + species.level); species.name = DataReader.ReadString(dataStream); species.description = DataReader.ReadString(dataStream); short numArgs = DataReader.ReadShort(dataStream); string[] extraArgs = new string[numArgs]; for (int j = 0; j < numArgs; j++) { string arg = DataReader.ReadString(dataStream); extraArgs[j] = arg; } species.biomass = int.Parse(extraArgs[0]); species.diet_type = short.Parse(extraArgs[1]); species.trophic_level = float.Parse(extraArgs[2]); Dictionary<int, string> predatorList = species.predatorList; foreach (string predator_id in extraArgs[3].Split(new string[]{","}, StringSplitOptions.None)) { if (predator_id != "") { predatorList.Add(int.Parse(predator_id), ""); } } Dictionary<int, string> preyList = species.preyList; foreach (string prey_id in extraArgs[4].Split(new string[]{","}, StringSplitOptions.None)) { if (prey_id != "") { preyList.Add(int.Parse(prey_id), ""); } } species.categoryList = DataReader.ReadString(dataStream).Split(new string[]{", "}, StringSplitOptions.None); speciesList.Add(species.species_id, species); //Constants.speciesList = speciesList; } //Debug.Log("Reached here!!----------" + Constants.speciesList.Count); response.speciesList = speciesList; return response; }
public Card(string name, Texture2D image, SpeciesData species, Rect rect, Color color) { this.name = name; this.image = image; this.species = species; this.rect = rect; this.color = color; cardTexture = Resources.Load<Texture2D>("card_bg"); statTexture = Resources.Load<Texture2D>("chart_dot"); font = Resources.Load<Font>("Fonts/" + "Chalkboard"); frameTexture = Resources.Load<Texture2D>("card_highlight"); float imageWidth = rect.width * 0.8f, imageHeight = rect.width * 0.5f; imageRect = new Rect((rect.width - imageWidth) / 2, 35, imageWidth, imageHeight); imgTexture = Functions.CreateTexture2D(Color.white); startPos.x = currentPos.x = rect.x; startPos.y = currentPos.y = rect.y; }
public Card(string name, Texture2D image, SpeciesData species, Rect rect, Color color) { this.name = name; this.image = image; this.species = species; this.rect = rect; this.color = color; cardTexture = Resources.Load <Texture2D>("card_bg"); statTexture = Resources.Load <Texture2D>("chart_dot"); font = Resources.Load <Font>("Fonts/" + "Chalkboard"); frameTexture = Resources.Load <Texture2D>("card_highlight"); float imageWidth = rect.width * 0.8f, imageHeight = rect.width * 0.5f; imageRect = new Rect((rect.width - imageWidth) / 2, 35, imageWidth, imageHeight); imgTexture = Functions.CreateTexture2D(Color.white); startPos.x = currentPos.x = rect.x; startPos.y = currentPos.y = rect.y; }
//public static Dictionary<string, SpeciesData> spNameUpperList = new Dictionary<string, SpeciesData>(); public static void Initialize() { SqliteConnection con = new SqliteConnection("URI=file:" + Application.dataPath + "/Database/WoB_DB.db"); con.Open(); SqliteCommand cmd = new SqliteCommand(con); cmd.CommandText = "" + "SELECT *" + " FROM `species`"; cmd.Prepare(); cmd.ExecuteNonQuery(); SqliteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int species_id = reader.GetInt32(0); SpeciesData species = new SpeciesData(species_id); species.name = reader.GetString(1); species.description = reader.GetString(2); species.biomass = reader.GetInt32(3); species.diet_type = reader.GetInt16(4); species.trophic_level = reader.GetFloat(5); species.level = reader.GetInt16(6); SqliteCommand subcmd = new SqliteCommand(con); subcmd.CommandText = "" + "SELECT `predator_id`" + " FROM `pp_relations`" + " WHERE `prey_id` = @species_id"; subcmd.Parameters.Add(new SqliteParameter("@species_id", species.species_id)); subcmd.Prepare(); subcmd.ExecuteNonQuery(); SqliteDataReader subreader = subcmd.ExecuteReader(); while (subreader.Read()) { int predator_id = subreader.GetInt32(0); if (!species.predatorList.ContainsKey(predator_id)) { species.predatorList.Add(predator_id, ""); } } subcmd = new SqliteCommand(con); subcmd.CommandText = "" + "SELECT `prey_id`" + " FROM `pp_relations`" + " WHERE `predator_id` = @species_id"; subcmd.Parameters.Add(new SqliteParameter("@species_id", species.species_id)); subcmd.Prepare(); subcmd.ExecuteNonQuery(); subreader = subcmd.ExecuteReader(); while (subreader.Read()) { int prey_id = subreader.GetInt32(0); if (!species.preyList.ContainsKey(prey_id)) { species.preyList.Add(subreader.GetInt32(0), ""); } } species.name = Functions.NormalizeSpeciesName (species.name); speciesList.Add(species.species_id, species); spNameList.Add(species.name, species); //spNameUpperList.Add(species.name.ToUpper (), species); } foreach (SpeciesData species in speciesList.Values) { foreach (int predator_id in new List<int>(species.predatorList.Keys)) { if (SpeciesTable.speciesList.ContainsKey(predator_id)) { species.predatorList[predator_id] = SpeciesTable.speciesList[predator_id].name; } else { species.predatorList.Remove(predator_id); } } foreach (int prey_id in new List<int>(species.preyList.Keys)) { if (SpeciesTable.speciesList.ContainsKey(prey_id)) { species.preyList[prey_id] = SpeciesTable.speciesList[prey_id].name; } else { species.preyList.Remove(prey_id); } } } reader.Close(); con.Close(); }
public static void Update(Dictionary <int, SpeciesData> updateList) { SqliteConnection con = new SqliteConnection("URI=file:" + Application.dataPath + "/Database/WoB_DB.db"); con.Open(); SqliteCommand cmd = new SqliteCommand(con); cmd.CommandText = "" + "DELETE FROM `pp_relations`" + " WHERE `predator_id` > 0 OR `prey_id` > 0"; cmd.Prepare(); cmd.ExecuteNonQuery(); foreach (KeyValuePair <int, SpeciesData> entry in updateList) { int species_id = entry.Key; SpeciesData species = entry.Value; if (speciesList.ContainsKey(species_id)) // If Exists, Delete Record { cmd.CommandText = "" + "DELETE FROM `species`" + " WHERE `species_id` = @species_id"; cmd.Parameters.Add(new SqliteParameter("@species_id", species.species_id)); cmd.Prepare(); cmd.ExecuteNonQuery(); } cmd.CommandText = "" + "INSERT INTO `species` (`species_id`, `name`, `description`, `biomass`, `diet_type`, `trophic_level`, 'level')" + " VALUES (@species_id, @name, @description, @biomass, @diet_type, @trophic_level, @level)"; cmd.Parameters.Add(new SqliteParameter("@species_id", species.species_id)); cmd.Parameters.Add(new SqliteParameter("@name", species.name)); cmd.Parameters.Add(new SqliteParameter("@description", species.description)); cmd.Parameters.Add(new SqliteParameter("@biomass", species.biomass)); cmd.Parameters.Add(new SqliteParameter("@diet_type", species.diet_type)); cmd.Parameters.Add(new SqliteParameter("@trophic_level", species.trophic_level)); cmd.Parameters.Add(new SqliteParameter("@level", species.level)); cmd.Prepare(); cmd.ExecuteNonQuery(); foreach (int predator_id in species.predatorList.Keys) { cmd.CommandText = "" + "INSERT INTO `pp_relations` (`predator_id`, `prey_id`)" + " VALUES (@predator_id, @prey_id)"; cmd.Parameters.Add(new SqliteParameter("@predator_id", predator_id)); cmd.Parameters.Add(new SqliteParameter("@prey_id", species.species_id)); cmd.Prepare(); cmd.ExecuteNonQuery(); } foreach (int prey_id in species.preyList.Keys) { cmd.CommandText = "" + "INSERT INTO `pp_relations` (`predator_id`, `prey_id`)" + " VALUES (@predator_id, @prey_id)"; cmd.Parameters.Add(new SqliteParameter("@predator_id", species.species_id)); cmd.Parameters.Add(new SqliteParameter("@prey_id", prey_id)); cmd.Prepare(); cmd.ExecuteNonQuery(); } } con.Close(); }
//public static Dictionary<string, SpeciesData> spNameUpperList = new Dictionary<string, SpeciesData>(); public static void Initialize() { SqliteConnection con = new SqliteConnection("URI=file:" + Application.dataPath + "/Database/WoB_DB.db"); con.Open(); SqliteCommand cmd = new SqliteCommand(con); cmd.CommandText = "" + "SELECT *" + " FROM `species`"; cmd.Prepare(); cmd.ExecuteNonQuery(); SqliteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int species_id = reader.GetInt32(0); SpeciesData species = new SpeciesData(species_id); species.name = reader.GetString(1); species.description = reader.GetString(2); species.biomass = reader.GetInt32(3); species.diet_type = reader.GetInt16(4); species.trophic_level = reader.GetFloat(5); species.level = reader.GetInt16(6); SqliteCommand subcmd = new SqliteCommand(con); subcmd.CommandText = "" + "SELECT `predator_id`" + " FROM `pp_relations`" + " WHERE `prey_id` = @species_id"; subcmd.Parameters.Add(new SqliteParameter("@species_id", species.species_id)); subcmd.Prepare(); subcmd.ExecuteNonQuery(); SqliteDataReader subreader = subcmd.ExecuteReader(); while (subreader.Read()) { int predator_id = subreader.GetInt32(0); if (!species.predatorList.ContainsKey(predator_id)) { species.predatorList.Add(predator_id, ""); } } subcmd = new SqliteCommand(con); subcmd.CommandText = "" + "SELECT `prey_id`" + " FROM `pp_relations`" + " WHERE `predator_id` = @species_id"; subcmd.Parameters.Add(new SqliteParameter("@species_id", species.species_id)); subcmd.Prepare(); subcmd.ExecuteNonQuery(); subreader = subcmd.ExecuteReader(); while (subreader.Read()) { int prey_id = subreader.GetInt32(0); if (!species.preyList.ContainsKey(prey_id)) { species.preyList.Add(subreader.GetInt32(0), ""); } } species.name = Functions.NormalizeSpeciesName(species.name); speciesList.Add(species.species_id, species); spNameList.Add(species.name, species); //spNameUpperList.Add(species.name.ToUpper (), species); } foreach (SpeciesData species in speciesList.Values) { foreach (int predator_id in new List <int>(species.predatorList.Keys)) { if (SpeciesTable.speciesList.ContainsKey(predator_id)) { species.predatorList[predator_id] = SpeciesTable.speciesList[predator_id].name; } else { species.predatorList.Remove(predator_id); } } foreach (int prey_id in new List <int>(species.preyList.Keys)) { if (SpeciesTable.speciesList.ContainsKey(prey_id)) { species.preyList[prey_id] = SpeciesTable.speciesList[prey_id].name; } else { species.preyList.Remove(prey_id); } } } reader.Close(); con.Close(); }
public void SetCard(Card card) { if (cardList.Count > 0 && card != cardList[0]) { predatorList.Clear(); preyList.Clear(); } if (cardList.Contains(card)) { int index = cardList.IndexOf(card); cardList.RemoveRange(0, index); } else { if (cardList.Count > 5) { cardList.RemoveAt(cardList.Count - 2); } cardList.Insert(0, card); } card.x = (width - card.width) / 2; card.y = (height - card.height) / 2; for (int i = cardList.Count - 1; i >= 0; i--) { float y = (height - card.height) / 2 - i * card.height * 0.15f; if (cardList.Count > 1 && i == cardList.Count - 1) { y -= card.height * 0.15f; } cardList[i].Translate(cardList[i].x, y, 1.2f); } List <Card> tempList = new List <Card>(); GameState gs = GameObject.Find("Global Object").GetComponent <GameState> (); foreach (int species_id in card.species.predatorList.Keys) { SpeciesData species = SpeciesTable.speciesList[species_id]; //for converge game, ignore predators not currently in ecosystem if (mode == Constants.MODE_CONVERGE_GAME && !gs.speciesList.ContainsKey(species_id)) { continue; } string name = manager.MatchSeriesLabel(species.name); Texture2D image = Resources.Load <Texture2D>(Constants.IMAGE_RESOURCES_PATH + species.name); Card temp = new Card( species.name, image, species, new Rect(card.x, card.y, 160, 200), name == null ? Color.red : manager.seriesColors [name] ); tempList.Add(temp); } tempList.Sort(SortByName); CreateLayout(tempList, predatorList, -1); tempList = new List <Card>(); foreach (int species_id in card.species.preyList.Keys) { SpeciesData species = SpeciesTable.speciesList[species_id]; //for converge game, ignore prey not currently in ecosystem if (mode == Constants.MODE_CONVERGE_GAME && !gs.speciesList.ContainsKey(species_id)) { continue; } string name = manager.MatchSeriesLabel(species.name); Texture2D image = Resources.Load <Texture2D>(Constants.IMAGE_RESOURCES_PATH + species.name); Card temp = new Card( species.name, image, species, new Rect(card.x, card.y, 160, 200), name == null ? Color.green : manager.seriesColors [name] ); tempList.Add(temp); } tempList.Sort(SortByName); CreateLayout(tempList, preyList, 1); Expand(); }
public Card(string name, Texture2D image, SpeciesData species, Rect rect) : this(name, image, species, rect, Color.black) { }
public Card(string name, Texture2D image, SpeciesData species, Rect rect) : this(name, image, species, rect, Color.black) { }