// select box data refresh.
public void selectBoxDataRefresh(ListBox selectBox, string[] dateStr)
{
int dayItem = (int)selectBox.Items[0];
selectBox.Items.Clear();
selectBox.Items.Insert(0, dayItem);
dbConnect.Open();
SQLiteCommand command = new SQLiteCommand(QueryList.listBoxRefreshSQL(dateStr), dbConnect);
SQLiteDataReader reader = command.ExecuteReader();
int moreCount = 0;
for (int count = 1; reader.Read(); count = count + 1)
{
if (count >= 4)
{
moreCount = moreCount + 1;
}
else
{
selectBox.Items.Insert(count, reader["text"].ToString());
}
}
if (moreCount > 0)
{
selectBox.Items.Insert(4, "(...more " + moreCount + ")");
}
reader.Close();
dbConnect.Close();
}
// calendar diary set Method.
private void settingCalendar()
{
int maxDays = int.Parse(DateTime.DaysInMonth(selectYear, selectMonth).ToString());
int blankCount, tempCt;
DateTime dOfMonth = new DateTime();
dOfMonth = dOfMonth.AddYears(selectYear - 1).AddMonths(selectMonth - 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;
dbConnect.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].TabStop = false;
blankCount = blankCount - 1;
}
else
{
string[] dateStr = new string[3];
// Calender Panel color setting.
if (DateTime.Now.ToString("yyyy-MM") == (selectYear.ToString() + "-" + selectMonth.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;
}
// database setting.
dateStr = dOfMonth.ToString("yyyy-MM-dd").Split('-');
dateStr[1] = int.Parse(dateStr[1]).ToString();
dateStr[2] = int.Parse(dateStr[2]).ToString();
dbCommand = new SQLiteCommand(QueryList.listBoxRefreshSQL(dateStr), dbConnect);
SQLiteDataReader reader = dbCommand.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].TabStop = true;
dayCount = dayCount + 1;
dOfMonth = dOfMonth.AddDays(1);
}
gbox[boxCount].Enabled = false;
boxCount = boxCount + 1;
}
}
dbConnect.Close();
gbox_index = selectDay + tempCt;
gbox[gbox_index].BackColor = System.Drawing.Color.FromArgb(255, 255, 192);
//MessageBox.Show("Refresh Database");
dataview.refreshData();
}
