public void arrayExecute(GameObject[] spawnArray, string type)
{
reader=command.ExecuteReader();
int sentinal=0;
while(reader.Read())
{
Debug.Log(reader[0]);
spawnArray[sentinal] = new GameObject(reader[0].ToString());
spawnArray[sentinal].AddComponent<FoodStats>();
Debug.Log(spawnArray[sentinal].name.ToString() + " spawned");
spawnArray[sentinal].GetComponent<FoodStats>().calories = int.Parse(reader[1].ToString()); //int.Parse(reader[4].ToString());
if (spawnArray[sentinal].GetComponent<FoodStats>().calories != null)
{
Debug.Log(spawnArray[sentinal].name.ToString() + " calories calculated" + " " + spawnArray[sentinal].GetComponent<FoodStats>().calories.ToString());
}
else
{
Debug.Log("Skipped");
}
spawnArray[sentinal].GetComponent<FoodStats>().setFoodType(type);
Debug.Log(spawnArray[sentinal].name.ToString() + " type set");
sentinal++;
}
reader.Close();
}
public void Execute()
{
reader=command.ExecuteReader();
while(reader.Read())
{
Debug.Log(reader[0]);
//mystring = reader[0].ToString();
mynum= int.Parse(reader[0].ToString());
Debug.Log(mynum + "edit");
/*
for(int counter=0; counter<4; counter++)
{
Debug.Log(reader[counter]);
}
*/
}
reader.Close();
}
