// database(today) current day calendar import.
public void todayAlarmListRefresh()
{
dbConnect2.Open();
listView_todayList.Items.Clear();
dbCommand2 = new SQLiteCommand(QueryList.listviewTodayRefreshSQL(), dbConnect2);
SQLiteDataReader reader = dbCommand2.ExecuteReader();
while (reader.Read())
{
listView_todayList.Items.Add(new ListViewItem(new string[] {
((int)reader["sethour"]).ToString("00") + " : " + ((int)reader["setminute"]).ToString("00"),
reader["text"].ToString()
}));
}
reader.Close();
dbConnect2.Close();
button_today_modify.Enabled = false;
button_today_delete.Enabled = false;
}
// today alarm check.
public void todayAlarmChecked()
{
DateTime today = new DateTime();
DateTime current = DateTime.Now;
bool findToday = false;
try {
sql = QueryList.listviewTodayRefreshSQL();
dbconnect2.Open();
dbcommand = new SQLiteCommand(sql, dbconnect2);
reader = dbcommand.ExecuteReader();
// Today alarm confirm.
while (reader.Read())
{
today = new DateTime();
today = today.AddYears(current.Year - 1).AddMonths(current.Month - 1).AddDays(current.Day - 1).
AddHours((int)reader["sethour"]).AddMinutes((int)reader["setminute"]);
if (today <= current)
{
continue;
}
else if (today > current)
{
findToday = true;
if (today >= alarm)
{
break;
}
else if (today < alarm)
{
alarm = today;
alarm_text = reader["text"].ToString();
break;
}
}
}
reader.Close();
// Next day confirm.
if (!findToday)
{
reader = dbcommand.ExecuteReader();
if (reader.Read())
{
today = new DateTime();
today = today.AddYears(current.Year - 1).AddMonths(current.Month - 1).AddDays(current.Day).
AddHours((int)reader["sethour"]).AddMinutes((int)reader["setminute"]);
if (today <= current)
{
}
else if (today > current)
{
if (today >= alarm)
{
}
else if (today < alarm)
{
alarm = today;
alarm_text = reader["text"].ToString();
}
}
}
reader.Close();
}
dbconnect2.Close();
MessageBox.Show("alarm : " + alarm.Year + "." + alarm.Month + "." + alarm.Day + " " + alarm.Hour + ":" + alarm.Minute);
} catch (Exception exc) { MessageBox.Show(exc.Message); }
}