// select "Modift mode"
public void modifyMode()
{
string sql;
string[] date;
date = new string[3];
date = past_day.ToString("yyyy-M-d").Split('-');
sql = QueryList.overlapMultiCheckSQL(date, past_h, past_m);
connect.Open();
SQLiteCommand command = new SQLiteCommand(sql, connect);
SQLiteDataReader reader = command.ExecuteReader();
if (!reader.Read())
{
MessageBox.Show("Can't find past data.");
reader.Close(); connect.Close();
return;
}
reader.Close(); connect.Close();
// single alarm mode.
if (checkBox_isMulti.Checked == false)
{
sql = QueryList.updateSQL(date, numericUpDown_hour.Value, numericUpDown_minute.Value, textBox_text.Text, checkBox_alarm.Checked, (int)past_h, (int)past_m);
connect.Open();
command = new SQLiteCommand(sql, connect);
command.ExecuteNonQuery();
connect.Close();
}
// multi alarm mode.
else
{
DateTime temp_checkDay = new DateTime(dateTimePicker_start.Value.Ticks);
int dayCount = (DateTime.Parse(dateTimePicker_end.Value.ToString("yyyy-M-d")) - DateTime.Parse(dateTimePicker_start.Value.ToString("yyyy-M-d"))).Days;
for (int count = 0; count <= dayCount; count++, temp_checkDay = temp_checkDay.AddDays(1))
{
date = new string[3];
date = temp_checkDay.ToString("yyyy-M-d").Split('-');
sql = QueryList.updateMultiSQL2(date, numericUpDown_hour.Value, numericUpDown_minute.Value, textBox_text.Text, checkBox_alarm.Checked, past_h, past_m);
connect.Open();
command = new SQLiteCommand(sql, connect);
command.ExecuteNonQuery();
connect.Close();
}
}
// refresh data
refreshData();
cmain.changeCalendar();
cmain.calendarListRefresh();
cmain.refreshAlarm();
}
