//Date selected method
private void dateSelected(DateTime selectedDate)
{
BackgroundImage = null;
bool containsBDay = false;
lastSelectedDate = selectedDate;
sqlCmd = new SqlCommand("select event_id, event_subject as 'Event Subject', event_begin as 'Event Begin',event_end as 'Event End', event_cat as 'Event Category' from event where event_begin>='" +
selectedDate.ToString("M/dd/yyyy 00:00:00") +
"' AND event_begin<='" +
selectedDate.ToString("M/dd/yyyy 23:59:59") +
"'", sc);
sqlAdapter = new SqlDataAdapter();
sqlAdapter.SelectCommand = sqlCmd;
DataTable dt = new DataTable();
sqlAdapter.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int lpCtr = 0; lpCtr < dt.Rows.Count; lpCtr++)
{
if (dt.Rows[0].ItemArray.GetValue(dt.Columns.IndexOf("Event Category")).Equals("Birthday"))
{
containsBDay = true;
}
}
if (containsBDay)
{
if (hb.IsDisposed)
{
hb = new HappyBirthday();
}
hb.Show();
containsBDay = false;
}
}
bs = new BindingSource();
bs.DataSource = dt;
eventGrid.DataSource = bs;
eventGrid.Columns[0].Visible = false;
sqlAdapter.Dispose();
}
public txtCalendarBox()
{
InitializeComponent();
// Initialize HappyBirthday screen
hb = new HappyBirthday();
string dbPath = Application.StartupPath + "\\event_db.mdf";
sc = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=" + dbPath + ";Integrated Security=True;User Instance=True");
sc.Close();
sc.Open();
// Add event handlers for the DateSelected and DateChanged events
monthCalendar.DateSelected += new DateRangeEventHandler(monthCalendar_DateSelected);
monthCalendar.SetDate(System.DateTime.Now);
boldEventDays();
dateSelected(System.DateTime.Now);
timer1.Start();
}
public txtCalendarBox()
{
InitializeComponent();
// Initialize HappyBirthday screen
hb = new HappyBirthday();
string dbPath = Application.StartupPath + "\\event_db.mdf";
sc = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=" + dbPath + ";Integrated Security=True;User Instance=True");
sc.Close();
sc.Open();
// Add event handlers for the DateSelected and DateChanged events
monthCalendar.DateSelected += new DateRangeEventHandler(monthCalendar_DateSelected);
monthCalendar.SetDate(System.DateTime.Now);
boldEventDays();
dateSelected(System.DateTime.Now);
timer1.Start();
}
//Date selected method
private void dateSelected(DateTime selectedDate)
{
BackgroundImage = null;
bool containsBDay = false;
lastSelectedDate = selectedDate;
sqlCmd = new SqlCommand("select event_id, event_subject as 'Event Subject', event_begin as 'Event Begin',event_end as 'Event End', event_cat as 'Event Category' from event where event_begin>='" +
selectedDate.ToString("M/dd/yyyy 00:00:00") +
"' AND event_begin<='" +
selectedDate.ToString("M/dd/yyyy 23:59:59") +
"'", sc);
sqlAdapter = new SqlDataAdapter();
sqlAdapter.SelectCommand = sqlCmd;
DataTable dt = new DataTable();
sqlAdapter.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int lpCtr = 0; lpCtr < dt.Rows.Count; lpCtr++)
{
if (dt.Rows[0].ItemArray.GetValue(dt.Columns.IndexOf("Event Category")).Equals("Birthday"))
containsBDay = true;
}
if (containsBDay)
{
if (hb.IsDisposed) hb = new HappyBirthday();
hb.Show();
containsBDay = false;
}
}
bs = new BindingSource();
bs.DataSource = dt;
eventGrid.DataSource = bs;
eventGrid.Columns[0].Visible = false;
sqlAdapter.Dispose();
}
