// Use this for initialization
void Start()
{
Selektor selektor = Selektor.getInstance();
Transform olap_kocka;
Vector3 position = new Vector3();
Vector3 scale = new Vector3();
using (DataTable entiteti = selektor.getEntites()) {
foreach (DataRow e in entiteti.Rows)
{
//postavljanje pozicije
position.x = float.Parse(e ["PositionX"].ToString()); //358.18F;
position.y = float.Parse(e ["PositionY"].ToString()); //0.67F;
position.z = float.Parse(e ["PositionZ"].ToString()); //237.87F;
//postavljanje veličine
scale.x = float.Parse(e ["ScaleX"].ToString());
scale.y = float.Parse(e ["ScaleY"].ToString());
scale.z = float.Parse(e ["ScaleZ"].ToString());
olap_kocka = Instantiate(prefab, position, Quaternion.identity);
olap_kocka.name = e ["Naziv"].ToString();
//postavljanje rotacije
olap_kocka.transform.Rotate(float.Parse(e ["RotationX"].ToString()),
float.Parse(e ["RotationY"].ToString()),
float.Parse(e ["RotationZ"].ToString()));
olap_kocka.transform.localScale += scale;
olap_kocka.GetComponent <Entity> ().EntitetID = e ["EntitetiID"].ToString();
olap_kocka.GetComponent <Entity> ().sifra = e ["Sifra"].ToString();
olap_kocka.GetComponent <Entity> ().opis = e ["Opis"].ToString();
}
}
}
private void setEntiteti()
{
//dohvaćanje trenutnog ID prostora
query = "select *from Entiteti where ProstoriID=" + prostorID + ";";
DatabaseConnection database = DatabaseConnection.getInstance();
DataTable data = database.Query(query);
Selektor selektor = Selektor.getInstance();
selektor.setEntity(data);
}
private void setAtributi()
{
//dohvaćanje trenutnog ID prostora
query = "select EntietiID, Vrijednost, Naziv from Atributi,AtributiEntiteta " +
"where AtributiEntiteta.AtributiID = Atributi.AtributiID and Atributi.ProstoriID = " + prostorID + ";";
DatabaseConnection database = DatabaseConnection.getInstance();
DataTable data = database.Query(query);
Selektor selektor = Selektor.getInstance();
selektor.setAtributi(data);
}
void getEntites()
{
Selektor selektor = Selektor.getInstance();
string query = buildQuery();
Debug.Log(query);
foreach (DataRow e in selektor.getAtributi().Select(query))
{
Debug.Log(e["EntietiID"].ToString());
}
}
public void atributesOfEntityMenuData(string id)
{
List <string> atributi = new List <string> ();
Selektor selektor = Selektor.getInstance();
id = "1";
dropdown.ClearOptions();
foreach (DataRow a in selektor.getAtributi().Select("EntietiID>" + id))
{
atributi.Add(a["Naziv"].ToString() + ": \t" + a ["Vrijednost"].ToString());
}
dropdown.AddOptions(atributi);
}