public static Timer GetTimer(int timer_id) { Timer timer = new Timer(-1, "", -1, -1, -1); _semaphore.Enqueue(); _connection.Open(); try { MySqlCommand cmd = new MySqlCommand("SELECT ID, Name, Hours, Minutes, Seconds FROM timers WHERE ID=" + timer_id + "", _connection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32("ID"); string name = reader.GetString("Name"); int hours = reader.GetInt32("Hours"); int minutes = reader.GetInt32("Minutes"); int seconds = reader.GetInt32("Seconds"); timer = new Timer(id, name, hours, minutes, seconds); } reader.Close(); reader.Dispose(); } catch(Exception e) { Debug.Log(_debugChannel, "Could not fetch timer: " + e.Message); timer = new Timer(-1, "", -1, -1, -1); } _connection.Close(); _semaphore.Dequeue(); return timer; }
public TimeFragment() { timer = new Timer(1000); timer.Elapsed += OnElapsed; timer.Start(); }
public AlarmFragment() { timer = new Timer(1000); timer.Elapsed += OnElapsed; }