Example #1
0
        // main method.
        public CalendarMain()
        {
            InitializeComponent();
            alarm_onCheck = true;
            gbox          = new ListBox[42];
            addForm       = new DataAddForm(label_DateTemp, this, false);
            addForm_today = new TodayDataAddForm(this);


            // Database setting.
            dbConnect  = new SQLiteConnection("Data Source=" + path + dbFileName + ";Version=3;");
            dbConnect2 = new SQLiteConnection("Data Source=" + path + dbFileName2 + ";Version=3;");
            addForm.setDbConnect(dbConnect);
            addForm_today.setDbConnect(dbConnect2);

            if (!File.Exists(path + dbFileName))
            {
                dbCommand = new SQLiteCommand(QueryList.createTableSQL(), dbConnect);
                Directory.CreateDirectory(path);
                SQLiteConnection.CreateFile(path + dbFileName);
                MessageBox.Show("Created new calendar db.");
                dbConnect.Open();
                dbCommand.ExecuteNonQuery();
                dbConnect.Close();
            }

            if (!File.Exists(path + dbFileName2))
            {
                dbCommand2 = new SQLiteCommand(QueryList.createTableSQL_today(), dbConnect2);
                if (!Directory.Exists(path))
                {
                    Directory.CreateDirectory(path);
                }
                SQLiteConnection.CreateFile(path + dbFileName2);
                MessageBox.Show("Created new today alarm db.");
                dbConnect2.Open();
                dbCommand2.ExecuteNonQuery();
                dbConnect2.Close();
            }



            tManager = new ThreadManager(label_Time, dbConnect, dbConnect2);    // Thread setting.
            dataview = new DataView(dbConnect, this);                           // DataView setting.


            // Panel setting.
            for (int count = 0; count < gbox.Length; count++)
            {
                gbox[count] = new ListBox();
            }

            // Current date setting.
            selectDay   = int.Parse(DateTime.Now.ToString("dd"));
            selectYear  = int.Parse(DateTime.Now.ToString("yyyy"));
            selectMonth = int.Parse(DateTime.Now.ToString("MM"));

            for (int row = 1, count = 0; row <= 6; row++)
            {
                for (int col = 0; col < 7; col++)
                {
                    panel_MonthList.Controls.Add(gbox[count], col, row); count++;
                }
            }

            label_DateTemp.Text  = selectYear.ToString() + "." + selectMonth.ToString() + "." + selectDay.ToString();
            label_YearMonth.Text = selectYear.ToString() + "." + selectMonth.ToString("00");
            changeCalendar();
            todayAlarmListRefresh();
        }