//false entspricht alles geschafft
//true entspricht Zwischenschritt
public void feedbackForSucces(bool zwischenschritt)
{
if (zwischenschritt)
{
mat.color = Color.white;
StartCoroutine(resetColor());
//Debug.Log("Zwischenschritt!");
}
else
{
mat.color = Color.blue;
StartCoroutine(resetColor());
//Debug.Log("Done!");
// Disable Light Alarm
LightAlarm light1 = (LightAlarm)GameObject.Find("AlarmLight1").GetComponent(typeof(LightAlarm));
light1.StopAlarm();
LightAlarm light2 = (LightAlarm)GameObject.Find("AlarmLight3").GetComponent(typeof(LightAlarm));
light2.StopAlarm();
LightAlarm light3 = (LightAlarm)GameObject.Find("AlarmLight2").GetComponent(typeof(LightAlarm));
light3.StopAlarm();
// Disable Audio Alarm
GameObject.Find("LeftSpeaker").GetComponent <AudioSource>().Stop();
GameObject.Find("RightSpeaker").GetComponent <AudioSource>().Stop();
}
}
// Query of alarm in the alarm table
public List<Alarm> GetAlarms(int id, int parentId)
{
List<Alarm> alarmList = new List<Alarm>();
MySqlConnection sqlConnection = new MySqlConnection(connectionString);
MySqlCommand sqlCmd = sqlConnection.CreateCommand();
try
{
sqlConnection.Open();
sqlCmd.CommandText = "SELECT * FROM ALARMS";
if (id != -1)
{
sqlCmd.CommandText += " WHERE ID=" + id;
}
else if (parentId != -1)
{
sqlCmd.CommandText += " WHERE PARENTID=" + parentId;
}
MySqlDataReader rdr = sqlCmd.ExecuteReader();
while (rdr.Read())
{
Alarm alarm = null;
switch (rdr.GetString(4))
{
case "SIREN":
alarm = new SirenAlarm();
break;
case "LIGHT":
alarm = new LightAlarm();
break;
}
alarm.Id = rdr.GetInt32(0);
alarm.IsEnabled = rdr.GetBoolean(1);
alarm.Sensitivity = rdr.GetInt32(2);
alarm.Location = rdr.GetString(3);
alarm.Type = rdr.GetString(4);
alarm.ParentId = rdr.GetInt16(5);
alarmList.Add(alarm);
}
rdr.Close();
}
catch (Exception e)
{
Console.WriteLine("Could not connect to database!");
Console.WriteLine("{0} Exception caught.", e);
}
finally
{
sqlConnection.Close();
}
return alarmList;
}
