public void init( Alert alert, string defaultColor )
{
if (!Registration.isValid())
{
label7.Visible = false;
soundField.Visible = false;
browseButton.Visible = false;
messageBox.ShowStamp = false;
}
backgroundChanged = false;
currentAlert = alert;
soundField.Text = alert.getSound();
try
{
string background = alert.getBackground();
if (background.ToUpper().Equals("DEFAULT"))
{
background = defaultColor;
}
else
{
backgroundChanged = true;
}
messageBox.RichTextBox.BackColor = Color.FromArgb(System.Convert.ToInt32(background));
}
catch
{
messageBox.RichTextBox.BackColor = Color.FromName("Window");
}
titleField.Text = alert.getTitle();
messageBox.RichTextBox.Rtf = alert.getMessage();
advancedField1.Text = alert.getSchedule();
oneTimeField3.SelectedIndex = 0;
timeDelayField2.SelectedIndex = 0;
dayOfMonthField1.SelectedIndex = 0;
dayOfMonthField3.SelectedIndex = 0;
dayOfMonthField4.SelectedIndex = 0;
dayOfWeekField1.SelectedIndex = 0;
dayOfWeekField3.SelectedIndex = 0;
positionalDayOfWeekField1.SelectedIndex = 0;
positionalDayOfWeekField2.SelectedIndex = 0;
positionalDayOfWeekField4.SelectedIndex = 0;
positionalDayOfWeekField6.SelectedIndex = 0;
this.setRadioButton();
if (alert.getSnoozed())
{
MsgBox.Show("If you save, this alert will no longer be on snooze.",
"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public Alert createNewAlert( Alert alert )
{
SQLiteCommand cmd;
//Create a new Entry
cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO Alerts (Title, Message, Year, DayOfMonth, Month, DayOfWeek, Hour, " +
"Minute, Snoozed, Valid, WakeUpTime, Background, Sound, Command) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters[0].Value = alert.getTitle();
cmd.Parameters[1].Value = alert.getMessage();
cmd.Parameters[2].Value = alert.getYear();
cmd.Parameters[3].Value = alert.getDayOfMonth();
cmd.Parameters[4].Value = alert.getMonth();
cmd.Parameters[5].Value = alert.getDayOfWeek();
cmd.Parameters[6].Value = alert.getHour();
cmd.Parameters[7].Value = alert.getMinute();
cmd.Parameters[8].Value = alert.getSnoozed();
cmd.Parameters[9].Value = alert.getValid();
cmd.Parameters[10].Value = alert.getWakeUpTime();
cmd.Parameters[11].Value = alert.getBackground();
cmd.Parameters[12].Value = alert.getSound();
cmd.Parameters[13].Value = alert.getCommand();
cmd.ExecuteNonQuery();
cmd.Dispose();
//Get the newly created AlertId. Rely on sqlite, hope for no multiple access of the table.
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT last_insert_rowid()";
int newAlertId = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
alert.setAlertId(newAlertId);
return alert;
}
public void alertDialog(Alert alert)
{
while (true)
{
//Make sure it's time to show the dialog
DateTime wakeup = alert.getWakeUpTime();
DateTime now = DateTime.Now;
if( !alert.getValid() && !alert.getSnoozed() )
{
if (alertsListView.IsHandleCreated == true)
{
alertsListView.Invoke(new UpdateListBoxCallback(UpdateManagerAlert), new object[] { alert });
}
return;
}
else if (wakeup > now)
{
double msDifference = wakeup.Subtract(now).TotalMilliseconds;
while (msDifference >= int.MaxValue)
{
Thread.Sleep(int.MaxValue);
msDifference = wakeup.Subtract(now).TotalMilliseconds;
}
Thread.Sleep((int)msDifference);
}
//Take care of color, positioning, command execution, and sound
AlertDialog alertDialog = new AlertDialog(alert, getBackground(alert), getSound(alert));
string positionType = controller.getSetting("WindowsPositioning");
if (positionType.Equals("center"))
{
alertDialog.center();
}
else if (positionType.Equals("custom"))
{
Dictionary<string, int> settings = controller.getAlertSettings();
alertDialog.Location = new Point(settings["xpos"], settings["ypos"]);
alertDialog.Size = new Size(settings["width"], settings["height"]);
}
//Show Dialog
if (alertDialog.ShowDialog() == DialogResult.OK)
{
positionType = controller.getSetting("WindowsPositioning");
if (positionType.Equals("custom"))
{
controller.updateAlertSettings(alertDialog.Location.X, alertDialog.Location.Y,
alertDialog.Size.Width, alertDialog.Size.Height);
}
alert = alertDialog.getCurrentAlert();
if (alertsListView.IsHandleCreated == true)
{
alertsListView.Invoke(new UpdateListBoxCallback(UpdateManagerAlert), new object[] { alert });
}
if (alert.getRemoved())
{
controller.deleteAlert(alert);
return;
}
else if (!alert.getValid() && !alert.getSnoozed())
{
controller.updateAlert(alert);
return;
}
else
{
controller.updateAlert(alert);
continue;
}
}
}
}
public void updateAlert( Alert alert )
{
if (alert.getAlertId() < 0)
{
throw new Exception("Invalid Alert Id");
}
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE Alerts SET Title = ?, Message = ?, Year = ?, DayOfMonth = ?, Month = ?, " +
"DayOfWeek = ?, Hour = ?, Minute = ?, Snoozed = ?, Valid = ?, WakeUpTime = ?, Background = ?, " +
"Sound = ?, Command = ? WHERE AlertId = ?";
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter()); cmd.Parameters.Add(cmd.CreateParameter());
cmd.Parameters[0].Value = alert.getTitle();
cmd.Parameters[1].Value = alert.getMessage();
cmd.Parameters[2].Value = alert.getYear();
cmd.Parameters[3].Value = alert.getDayOfMonth();
cmd.Parameters[4].Value = alert.getMonth();
cmd.Parameters[5].Value = alert.getDayOfWeek();
cmd.Parameters[6].Value = alert.getHour();
cmd.Parameters[7].Value = alert.getMinute();
cmd.Parameters[8].Value = alert.getSnoozed();
cmd.Parameters[9].Value = alert.getValid();
cmd.Parameters[10].Value = alert.getWakeUpTime();
cmd.Parameters[11].Value = alert.getBackground();
cmd.Parameters[12].Value = alert.getSound();
cmd.Parameters[13].Value = alert.getCommand();
cmd.Parameters[14].Value = alert.getAlertId();
cmd.ExecuteNonQuery();
cmd.Dispose();
}