Пример #1
0
        // 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();
        }
        // button Event.
        private void button_ok_Click(object sender, EventArgs e)
        {
            int    length;
            string sql;

            length = Encoding.Default.GetBytes(textBox_calendarText.Text).Length;


            if (length <= 20 && length > 0)
            {
                try {
                    sql = QueryList.overlapCheckSQL(dateStr);

                    // add schedule mode.
                    if (!modifyMode)
                    {
                        // overlap alarm check.
                        if (!overlapCheck(sql, false))
                        {
                            return;
                        }

                        // insert data. (normal)
                        if (!checkBox_multiMode.Checked)
                        {
                            sql = QueryList.insertSQL(dateStr, numericUpDown_setHour.Value, numericUpDown_setMinute.Value, textBox_calendarText.Text, checkBox_checkAlarm.Checked);
                            queryActive(sql);
                        }

                        // insert data. (multi)
                        else
                        {
                            DateTime temp_nextday = new DateTime(startDateTemp.Ticks);
                            TimeSpan temp         = DateTime.Parse(dateTimePicker_end.Value.ToString("yyyy-MM-dd")) - DateTime.Parse(startDateTemp.ToString("yyyy-MM-dd"));
                            int      dayTemp      = temp.Days;
                            bool     oncemessage  = true;

                            if (dayTemp > 0)
                            {
                                for (int count = 0; count <= dayTemp; count++, temp_nextday = temp_nextday.AddDays(1))
                                {
                                    // DB Check
                                    string[] curDateStr = temp_nextday.ToString("yyyy-MM-dd").Split('-');
                                    sql = QueryList.overlapMultiCheckSQL(curDateStr, numericUpDown_setHour.Value, numericUpDown_setMinute.Value);

                                    dbConnect.Open();
                                    SQLiteCommand    command = new SQLiteCommand(sql, dbConnect);
                                    SQLiteDataReader reader  = command.ExecuteReader();

                                    // data is already exist.
                                    if (reader.Read())
                                    {
                                        reader.Close();
                                        dbConnect.Close();
                                        if (oncemessage)
                                        {
                                            MessageBox.Show("Existing data was maintained due to overlapping schedules.");
                                        }
                                        oncemessage = false;
                                    }

                                    // data is not already exist.
                                    else
                                    {
                                        reader.Close();
                                        dbConnect.Close();

                                        sql = QueryList.insertSQL(curDateStr, numericUpDown_setHour.Value, numericUpDown_setMinute.Value, textBox_calendarText.Text, checkBox_checkAlarm.Checked);

                                        dbConnect.Open();
                                        command = new SQLiteCommand(sql, dbConnect);
                                        command.ExecuteNonQuery();
                                        dbConnect.Close();
                                    }
                                }
                                calendar.changeCalendar();
                                calendar.calendarListRefresh();
                                calendar.refreshAlarm();
                                Close();
                                return;
                            }

                            else
                            {
                                MessageBox.Show("Invalid input.\nPlease select the correct date."); return;
                            }
                        }
                    }


                    // modify schedule mode. (normal)
                    else
                    {
                        // overlap alarm check.
                        if (!overlapCheck(sql, true))
                        {
                            return;
                        }

                        // update data. (normal)
                        if (!checkBox_multiMode.Checked)
                        {
                            sql = QueryList.updateSQL(dateStr, numericUpDown_setHour.Value, numericUpDown_setMinute.Value, textBox_calendarText.Text, checkBox_checkAlarm.Checked, original_hour, original_minute);
                            queryActive(sql);
                        }

                        // update data. (multi)
                        else
                        {
                            DateTime temp_nextday = new DateTime(startDateTemp.Ticks);
                            TimeSpan temp         = DateTime.Parse(dateTimePicker_end.Value.ToString("yyyy-MM-dd")) - DateTime.Parse(startDateTemp.ToString("yyyy-MM-dd"));
                            int      dayTemp      = temp.Days;

                            if (dayTemp > 0)
                            {
                                for (int count = 0; count <= dayTemp; count++, temp_nextday = temp_nextday.AddDays(1))
                                {
                                    // DB Check
                                    string[] curDateStr = temp_nextday.ToString("yyyy-MM-dd").Split('-');
                                    sql = QueryList.overlapMultiCheckSQL(curDateStr, numericUpDown_setHour.Value, numericUpDown_setMinute.Value);

                                    dbConnect.Open();
                                    SQLiteCommand    command = new SQLiteCommand(sql, dbConnect);
                                    SQLiteDataReader reader  = command.ExecuteReader();

                                    // data is already exist.
                                    if (reader.Read())
                                    {
                                        reader.Close();
                                        dbConnect.Close();

                                        sql = QueryList.updateMultiSQL(curDateStr, numericUpDown_setHour.Value, numericUpDown_setMinute.Value, textBox_calendarText.Text, checkBox_checkAlarm.Checked);

                                        dbConnect.Open();
                                        command = new SQLiteCommand(sql, dbConnect);
                                        command.ExecuteNonQuery();
                                        dbConnect.Close();
                                    }


                                    // data is not already exist.
                                    else
                                    {
                                        reader.Close(); dbConnect.Close();
                                    }
                                }
                            }
                            calendar.changeCalendar();
                            calendar.calendarListRefresh();
                            calendar.refreshAlarm();
                            Close();
                            return;
                        }
                    }
                }
                catch (Exception exc) {
                    MessageBox.Show("Error : " + exc.Message);
                    if (dbConnect.State.ToString() == "Open")
                    {
                        dbConnect.Close();
                    }
                }
            }

            else if (length <= 0)
            {
                MessageBox.Show("You didn't enter anything!");
            }
            else
            {
                MessageBox.Show("Character size must be no larger than 20.");
            }
        }
Пример #3
0
        /*** Method List. ***/

        // select "Add mode"
        public void addMode()
        {
            string sql;

            string[]      date;
            SQLiteCommand command;

            date = new string[3];
            date = (this.dateTimePicker_start.Value.ToString("yyyy-M-d")).Split('-');

            // duplicate check.
            sql = QueryList.overlapMultiCheckSQL(date, numericUpDown_hour.Value, numericUpDown_minute.Value);
            connect.Open();
            command = new SQLiteCommand(sql, connect);
            SQLiteDataReader reader = command.ExecuteReader();

            if (reader.Read())
            {
                MessageBox.Show("Duplicate alarm time.");
                reader.Close(); connect.Close(); return;
            }

            reader.Close();
            connect.Close();


            /* normal mode */
            if (this.checkBox_isMulti.Checked == false)
            {
                // input data.
                sql = QueryList.insertSQL(date, numericUpDown_hour.Value, numericUpDown_minute.Value, textBox_text.Text, checkBox_alarm.Checked);
                connect.Open();
                command = new SQLiteCommand(sql, connect);
                command.ExecuteNonQuery();
                connect.Close();
            }


            /* multi mode */
            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;

                // input data (multi).
                for (int count = 0; count <= dayTemp; count++, temp_nextday = temp_nextday.AddDays(1))
                {
                    date = new string[3];
                    date = temp_nextday.ToString("yyyy-M-d").Split('-');
                    sql  = QueryList.overlapMultiCheckSQL(date, numericUpDown_hour.Value, numericUpDown_minute.Value);

                    connect.Open();
                    command = new SQLiteCommand(sql, connect);
                    reader  = command.ExecuteReader();


                    // data is already exist.
                    if (reader.Read())
                    {
                        reader.Close(); connect.Close();
                        if (oncemessage)
                        {
                            MessageBox.Show("Existing data was maintained due to overlapping schedules."); oncemessage = false;
                        }
                    }

                    // data is not already exist.
                    else
                    {
                        reader.Close(); connect.Close();

                        sql = QueryList.insertSQL(date, numericUpDown_hour.Value, numericUpDown_minute.Value, textBox_text.Text, checkBox_alarm.Checked);
                        connect.Open(); command = new SQLiteCommand(sql, connect);
                        command.ExecuteNonQuery();
                        connect.Close();
                    }
                }
            }

            // refresh data
            refreshData();
            cmain.changeCalendar();
            cmain.calendarListRefresh();
            cmain.refreshAlarm();
        }