/** ArrayList contains Alert objects */ private ArrayList getAlerts( String query ) { ArrayList alerts = new ArrayList(); SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = query; SQLiteDataReader results = cmd.ExecuteReader(); while (results.Read()) { int alertId = results.GetInt32(0); string title = results.GetString(1); string message = results.GetString(2); string year = results.GetString(3); string dayOfMonth = results.GetString(4); string month = results.GetString(5); string dayOfWeek = results.GetString(6); string hour = results.GetString(7); string minute = results.GetString(8); bool snoozed = results.GetBoolean(9); bool valid = results.GetBoolean(10); DateTime wakeUpTime = results.GetDateTime(11); string background = results.GetString(12); string sound = results.GetString(13); string command = results.GetString(14); //Do not change the order of the following block, //otherwise snoozed and valid values may be set //incorrectly. Alert alert = new Alert(); alert.setAlertId(alertId); alert.setTitle(title); alert.setMessage(message); alert.setSchedule(year, month, dayOfMonth, dayOfWeek, hour, minute, false); alert.setWakeUpTime(wakeUpTime); alert.setSnoozed(snoozed); alert.setValid(valid); alert.setBackground(background); alert.setSound(sound); alert.setCommand(command); alerts.Add(alert); } cmd.Dispose(); return alerts; }
/** ArrayList contains Alert objects */ public Alert getUpdatedAlert( Alert alert ) { SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT AlertId, Title, Message, Year, DayOfMonth, Month, " + "DayOfWeek, Hour, Minute, Snoozed, Valid, WakeUpTime Background, " + "Sound, Command FROM Alerts WHERE AlertID = ?"; cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters[0].Value = alert.getAlertId(); SQLiteDataReader results = cmd.ExecuteReader(); if (results.Read()) { int alertId = results.GetInt32(0); string title = results.GetString(1); string message = results.GetString(2); string year = results.GetString(3); string dayOfMonth = results.GetString(4); string month = results.GetString(5); string dayOfWeek = results.GetString(6); string hour = results.GetString(7); string minute = results.GetString(8); bool snoozed = results.GetBoolean(9); bool valid = results.GetBoolean(10); DateTime wakeUpTime = results.GetDateTime(11); string background = results.GetString(12); string sound = results.GetString(13); string command = results.GetString(14); //Do not change the order of the following block, //otherwise snoozed and valid values may be set //incorrectly. alert.setAlertId(alertId); alert.setTitle(title); alert.setMessage(message); alert.setSchedule(year, month, dayOfMonth, dayOfWeek, hour, minute, false); alert.setWakeUpTime(wakeUpTime); alert.setSnoozed(snoozed); alert.setValid(valid); alert.setBackground(background); alert.setSound(sound); alert.setCommand(command); } cmd.Dispose(); return alert; }