// delete select database.
private void DeleteDBdata_(int index, bool isCalendarMode)
{
ListView listview = isCalendarMode == true ? listView_Schedule : listView_todayList;
SQLiteConnection tempConnect = isCalendarMode == true ? connect[0] : connect[1];
decimal[] tempDateYMD = isCalendarMode == true ? selectCalendarDay : null;
int mode = isCalendarMode == true ? ListSqlQuery.CALENDAR_MODE : ListSqlQuery.ALARM_MODE;
string[] splitstr = listview.Items[index].Text.Split(':');
DataManage dManage = new DataManage(decimal.Parse(splitstr[0]), decimal.Parse(splitstr[1]));
tempConnect.Open();
SQLiteCommand command = new SQLiteCommand(new ListSqlQuery().sqlDeleteData(mode, tempDateYMD, dManage.HourMinute), tempConnect);
command.ExecuteNonQuery();
tempConnect.Close();
}
private void DeleteButtonClickProcess(bool isCalendar)
{
if (isCalendar)
{
if (MessageBox.Show($"Are you sure you want to delete the data?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int count = listView_Schedule.Items.Count - 1; count >= 0; count = count - 1)
{
if (listView_Schedule.Items[count].Selected == true)
{
DeleteDBdata_(count, true);
}
}
DataManage dManage = new DataManage(selectCalendarDay[0], selectCalendarDay[1], selectCalendarDay[2]);
ChangeCalendar();
CalendarListRefresh();
RefreshAlarm();
}
}
else
{
if (MessageBox.Show($"Are you sure you want to delete the data?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int count = listView_todayList.Items.Count - 1; count >= 0; count = count - 1)
{
if (listView_todayList.Items[count].Selected == true)
{
DeleteDBdata_(count, false);
}
}
TodayAlarmListRefresh();
RefreshAlarm();
}
}
}
// calendar diary set Method.
private void SettingCalendar()
{
int maxDays = int.Parse(DateTime.DaysInMonth((int)selectCalendarDay[0], (int)selectCalendarDay[1]).ToString());
int blankCount, tempCt;
DateTime dOfMonth = new DateTime();
dOfMonth = dOfMonth.AddYears((int)selectCalendarDay[0] - 1).AddMonths((int)selectCalendarDay[1] - 1);
switch (dOfMonth.DayOfWeek.ToString())
{
case "Sunday": blankCount = 7; break;
case "Monday": blankCount = 1; break;
case "Tuesday": blankCount = 2; break;
case "Wednesday": blankCount = 3; break;
case "Thursday": blankCount = 4; break;
case "Friday": blankCount = 5; break;
default: blankCount = 6; break;
}
tempCt = blankCount - 1;
connect[0].Open();
for (int row = 1, boxCount = 0, dayCount = 1; row <= 6; row = row + 1)
{
for (int col = 0; col < 7; col = col + 1)
{
if (blankCount > 0 || dayCount > maxDays)
{
gbox[boxCount].BackColor = System.Drawing.SystemColors.InactiveCaptionText;
gbox[boxCount].Enabled = false;
blankCount = blankCount - 1;
}
else
{
// Calender Panel color setting.
if (DateTime.Now.ToString("yyyy-MM") == (selectCalendarDay[0].ToString() + "-" + selectCalendarDay[1].ToString("00")) && dayCount == int.Parse(DateTime.Now.ToString("dd")))
{
gbox[dayCount + tempCt].BackColor = System.Drawing.Color.FromArgb(192, 255, 255);
}
else if (dOfMonth.DayOfWeek.ToString() == "Sunday")
{
gbox[boxCount].BackColor = System.Drawing.Color.FromArgb(255, 192, 192);
}
else if (dOfMonth.DayOfWeek.ToString() == "Saturday")
{
gbox[boxCount].BackColor = System.Drawing.Color.FromArgb(192, 192, 255);
}
else
{
gbox[boxCount].BackColor = System.Drawing.SystemColors.Window;
}
//gbox[boxCount].MouseDown += new MouseEventHandler(CalendarMouseDown);
// database setting.
string[] dateStr = dOfMonth.ToString("yyyy-MM-dd").Split('-');
DataManage dManage = new DataManage(decimal.Parse(dateStr[0]), decimal.Parse(dateStr[1]), decimal.Parse(dateStr[2]));
command = new SQLiteCommand(new ListSqlQuery().sqlListboxRefresh(dManage.YearMonthDay), connect[0]);
SQLiteDataReader reader = command.ExecuteReader();
gbox[boxCount].Items.Insert(0, dayCount);
int moreCount = 0;
for (int count = 1; reader.Read(); count = count + 1)
{
if (count >= 4)
{
moreCount = moreCount + 1;
}
else
{
gbox[boxCount].Items.Insert(count, reader["text"].ToString());
}
}
if (moreCount > 0)
{
gbox[boxCount].Items.Insert(4, "(...more " + moreCount + ")");
}
reader.Close();
gbox[boxCount].Enabled = true;
dayCount = dayCount + 1;
dOfMonth = dOfMonth.AddDays(1);
}
boxCount = boxCount + 1;
}
}
connect[0].Close();
gbox_index = (int)selectCalendarDay[2] + tempCt;
gbox[gbox_index].BackColor = System.Drawing.Color.FromArgb(255, 255, 192);
if (dataview != null && !dataview.IsDisposed)
{
dataview.RefreshData();
}
}
// Impliment Method.
public void AddMode(bool multiMod)
{
string[] tempDate = (dateTimePicker_start.Value.ToString("yyyy-M-d")).Split('-');
DataManage setData = new DataManage(dateYMD[0], dateYMD[1], dateYMD[2], numericUpDown_setHour.Value, numericUpDown_setMinute.Value, textBox_calendarText.Text, checkBox_checkAlarm.Checked);
// overlap alarm check.
string sql_str = new ListSqlQuery().sqlOverlapCheck(ListSqlQuery.CALENDAR_MODE, setData.YearMonthDay, setData.HourMinute);
if (!OverlapCheck(sql_str, false))
{
return;
}
// insert data. (normal)
if (!multiMod)
{
sql_str = new ListSqlQuery().sqlInsertValues(ListSqlQuery.CALENDAR_MODE, setData.YearMonthDay, setData.HourMinute, setData.Text, setData.Active);
QueryActive(sql_str, false);
}
// insert data. (multi)
else
{
DateTime temp_nextday = new DateTime(dateTimePicker_start.Value.Ticks);
TimeSpan temp = DateTime.Parse(dateTimePicker_end.Value.ToString("yyyy-M-d")) - DateTime.Parse(dateTimePicker_start.Value.ToString("yyyy-M-d"));
int dayTemp = temp.Days;
bool oncemessage = true;
for (int count = 0; count <= dayTemp; count++, temp_nextday = temp_nextday.AddDays(1))
{
tempDate = temp_nextday.ToString("yyyy-M-d").Split('-');
setData.YearMonthDay = new decimal[] { decimal.Parse(tempDate[0]), decimal.Parse(tempDate[1]), decimal.Parse(tempDate[2]) };
sql_str = new ListSqlQuery().sqlOverlapCheck(ListSqlQuery.CALENDAR_MODE, setData.YearMonthDay, setData.HourMinute);
tempConnect.Open();
command = new SQLiteCommand(sql_str, tempConnect);
SQLiteDataReader reader = command.ExecuteReader();
// data is already exist.
if (reader.Read())
{
reader.Close(); tempConnect.Close();
if (oncemessage)
{
MessageBox.Show("Existing data was maintained due to overlapping schedules.");
}
oncemessage = false;
}
// data is not already exist.
else
{
reader.Close(); tempConnect.Close();
sql_str = new ListSqlQuery().sqlInsertValues(ListSqlQuery.CALENDAR_MODE, setData.YearMonthDay, setData.HourMinute, textBox_calendarText.Text, checkBox_checkAlarm.Checked);
tempConnect.Open();
command = new SQLiteCommand(sql_str, tempConnect);
command.ExecuteNonQuery();
tempConnect.Close();
}
}
calendar.ChangeCalendar();
calendar.CalendarListRefresh();
calendar.RefreshAlarm();
Close();
}
}