//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; }