private void deleteMessage()
{
if (MessageBox.Show($"Are you sure you want to delete the data?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int count = listView_allDatalist.Items.Count - 1; count >= 0; count = count - 1)
{
if (listView_allDatalist.Items[count].Selected == true)
{
string[] date_temp = listView_allDatalist.Items[count].Text.ToString().Split('-');
string[] alarm_temp = listView_allDatalist.Items[count].SubItems[1].Text.ToString().Split(':');
int[] date = new int[3]; date[0] = int.Parse(date_temp[0]);
date[1] = int.Parse(date_temp[1]);
date[2] = int.Parse(date_temp[2]);
int[] alarm = new int[2]; alarm[0] = int.Parse(alarm_temp[0]);
alarm[1] = int.Parse(alarm_temp[1]);
connect.Open();
SQLiteCommand command = new SQLiteCommand(QueryList.deleteDateSQL(date[0], date[1], date[2], alarm), connect);
command.ExecuteNonQuery();
connect.Close();
}
}
refreshData();
cmain.changeCalendar();
cmain.calendarListRefresh();
cmain.refreshAlarm();
}
}
// delete select database.
private void deleteDBdata(int index)
{
string[] splitstr = new string[2];
int[] datetemp = new int[2];
splitstr = listView_Schedule.Items[index].Text.Split(':');
datetemp[0] = int.Parse(splitstr[0]);
datetemp[1] = int.Parse(splitstr[1]);
// MessageBox.Show(listView_Schedule.SelectedItems[0].SubItems[1].ToString());
dbConnect.Open();
dbCommand = new SQLiteCommand(QueryList.deleteDateSQL(selectYear, selectMonth, selectDay, datetemp), dbConnect);
dbCommand.ExecuteNonQuery();
dbConnect.Close();
}