public void ViewResults()
{
spacing = 0;
HelpOverlay.SetActive(false);
TableOverlay.SetActive(false);
ResultOverlay.SetActive(true);
if (queryField.transform.GetChild(0).childCount > 0 || queryField.transform.GetChild(1).childCount > 0)
{
for (int i = 0; i < queryField.transform.childCount; i++)
{
for (int j = 0; j < queryField.transform.GetChild(i).childCount; j++)
{
KeywordMetaData key = new KeywordMetaData(queryField.transform.GetChild(i).GetChild(j).tag.Split('-')[0], queryField.transform.GetChild(i).GetChild(j).tag.Split('-')[1]);
if (key.isAttribute)
{
query.Add(key);
}
wholequery.Add(key);
}
}
}
if (!ValidateQuery(wholequery))
{
if (goCoroutine)
{
StartCoroutine(HalfValid());
}
else
{
ClearResults();
AlternativeQuery.SetActive(true);
CorrectQuery.SetActive(false);
}
}
else
{
AlternativeQuery.SetActive(false);
CorrectQuery.SetActive(true);
int c = Score();
Debug.Log("finalScore: " + UI.finalScore);
PlayerPrefs.SetInt("LevelColor2" + user, c);
PlayerPrefs.Save();
}
if (canBeAnswered)
{
for (int u = 0; u < query.Count; u++)
{
Table.transform.GetChild(0).GetChild(u).GetComponent <TextMeshProUGUI>().SetText(query[u].keywordName);
}
for (int i = 0; i < query[0].result.Count; i++)
{
var row = Instantiate(Row, Table.transform);
row.GetComponent <RectTransform>().position = new Vector2(Table.transform.GetChild(2).GetComponent <RectTransform>().position.x, Table.transform.GetChild(2).GetComponent <RectTransform>().position.y - spacing);
spacing += 41;
row.transform.GetChild(0).GetComponent <TextMeshProUGUI>().SetText(query[0].result[i]);
row.transform.GetChild(1).GetComponent <TextMeshProUGUI>().SetText(query[1].result[i]);
row.transform.GetChild(2).GetComponent <TextMeshProUGUI>().SetText(query[2].result[i]);
row.transform.GetChild(3).GetComponent <TextMeshProUGUI>().SetText(query[3].result[i]);
row.transform.GetChild(4).GetComponent <TextMeshProUGUI>().SetText(query[4].result[i]);
}
}
query = new List <KeywordMetaData>();
wholequery = new List <KeywordMetaData>();
}
public void ViewResults()
{
ClearResults();
spacing = 0;
//level One query is select id,firstname,lastname,email,age from students
HelpOverlay.SetActive(false);
TableOverlay.SetActive(false);
ResultOverlay.SetActive(true);
for (int i = 0; i < queryField.transform.childCount; i++)
{
for (int j = 0; j < queryField.transform.GetChild(i).childCount; j++)
{
KeywordMetaData k = new KeywordMetaData(queryField.transform.GetChild(i).GetChild(j).tag.Split('-')[0], queryField.transform.GetChild(i).GetChild(j).tag.Split('-')[1]);
wholequery.Add(k);
}
}
KeywordMetaData key = new KeywordMetaData("id", "Sel");
KeywordMetaData key1 = new KeywordMetaData("firstname", "Sel");
KeywordMetaData key2 = new KeywordMetaData("lastname", "Sel");
KeywordMetaData key3 = new KeywordMetaData("email", "Sel");
KeywordMetaData key4 = new KeywordMetaData("age", "Sel");
query.Add(key);
query.Add(key1);
query.Add(key2);
query.Add(key3);
query.Add(key4);
if (!ValidateQuery(wholequery))
{
ClearResults();
AlternativeQuery.SetActive(true);
CorrectQuery.SetActive(false);
}
else
{
AlternativeQuery.SetActive(false);
CorrectQuery.SetActive(true);
int c = Score();
Debug.Log("Level One " + user);
PlayerPrefs.SetInt("LevelColor1" + user, c);
PlayerPrefs.Save();
}
if (canBeAnswered)
{
for (int u = 0; u < query.Count; u++)
{
Table.transform.GetChild(0).GetChild(u).GetComponent <TextMeshProUGUI>().SetText(query[u].keywordName);
}
for (int i = 0; i < query[0].result.Count; i++)
{
var row = Instantiate(Row, Table.transform);
row.GetComponent <RectTransform>().position = new Vector2(Table.transform.GetChild(2).GetComponent <RectTransform>().position.x, Table.transform.GetChild(2).GetComponent <RectTransform>().position.y - spacing);
spacing += 41;
row.transform.GetChild(0).GetComponent <TextMeshProUGUI>().SetText(query[0].result[i]);
row.transform.GetChild(1).GetComponent <TextMeshProUGUI>().SetText(query[1].result[i]);
row.transform.GetChild(2).GetComponent <TextMeshProUGUI>().SetText(query[2].result[i]);
row.transform.GetChild(3).GetComponent <TextMeshProUGUI>().SetText(query[3].result[i]);
row.transform.GetChild(4).GetComponent <TextMeshProUGUI>().SetText(query[4].result[i]);
}
}
query = new List <KeywordMetaData>();
wholequery = new List <KeywordMetaData>();
}
