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