//New Event Constructor
public eventForm(SqlConnection sc, DateTime selectedDate, Calendar.txtCalendarBox myParent)
{
InitializeComponent();
this.myParent = myParent;
btnEdit.Visible = false;
btnCreate.Visible = true;
beginDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
beginDatePicker.Format = DateTimePickerFormat.Custom;
endDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
endDatePicker.Format = DateTimePickerFormat.Custom;
selectedDate = selectedDate.AddSeconds(1);
beginDatePicker.Text = selectedDate.ToString();
endDatePicker.Text = selectedDate.ToString();
this.sc = sc;
this.Visible = true;
}
public eventForm(SqlConnection sc, DateTime selectedDate, Calendar.txtCalendarBox myParent)//New Event Constructor
{
InitializeComponent();
this.myParent = myParent;
btnEdit.Visible = false;
btnCreate.Visible = true;
beginDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
beginDatePicker.Format = DateTimePickerFormat.Custom;
endDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
endDatePicker.Format = DateTimePickerFormat.Custom;
selectedDate = selectedDate.AddSeconds(1);
beginDatePicker.Text = selectedDate.ToString();
endDatePicker.Text = selectedDate.ToString();
this.sc = sc;
this.Visible = true;
}
//Edit Constructor
public eventForm(SqlConnection sc, Int32 eventID, Calendar.txtCalendarBox myParent)
{
InitializeComponent();
this.myParent = myParent;
btnCreate.Visible = false;
btnEdit.Visible = true;
this.eventID = eventID;
beginDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
beginDatePicker.Format = DateTimePickerFormat.Custom;
endDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
endDatePicker.Format = DateTimePickerFormat.Custom;
this.Text = "Edit Event";
sqlCmd = new SqlCommand("SELECT event_subject as 'Event Subject', event_begin as 'Event Begin', event_end as 'Event End', event_description as 'Event Description', event_cat as 'Event Category' FROM event WHERE event_id='" + eventID.ToString() + "'", sc);
sqlRdr = sqlCmd.ExecuteReader();
sqlRdr.Read();
try
{
txtSubject.Text = sqlRdr.GetValue(0).ToString();
beginDatePicker.Text = sqlRdr.GetValue(1).ToString();
endDatePicker.Text = sqlRdr.GetValue(2).ToString();
txtDescription.Text = sqlRdr.GetValue(3).ToString();
catCombo.Text = sqlRdr.GetValue(4).ToString();
}
catch (InvalidOperationException) { }
sqlRdr.Close();
this.sc = sc;
this.Visible = true;
}
public eventForm(SqlConnection sc, Int32 eventID, Calendar.txtCalendarBox myParent)//Edit Constructor
{
InitializeComponent();
this.myParent = myParent;
btnCreate.Visible = false;
btnEdit.Visible = true;
this.eventID = eventID;
beginDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
beginDatePicker.Format = DateTimePickerFormat.Custom;
endDatePicker.CustomFormat = "dddd,MMMM d, yyyy 'at' h:mm:ss tt";
endDatePicker.Format = DateTimePickerFormat.Custom;
this.Text = "Edit Event";
sqlCmd = new SqlCommand("SELECT event_subject as 'Event Subject', event_begin as 'Event Begin', event_end as 'Event End', event_description as 'Event Description', event_cat as 'Event Category' FROM event WHERE event_id='" + eventID.ToString() + "'", sc);
sqlRdr = sqlCmd.ExecuteReader();
sqlRdr.Read();
try
{
txtSubject.Text = sqlRdr.GetValue(0).ToString();
beginDatePicker.Text = sqlRdr.GetValue(1).ToString();
endDatePicker.Text = sqlRdr.GetValue(2).ToString();
txtDescription.Text = sqlRdr.GetValue(3).ToString();
catCombo.Text = sqlRdr.GetValue(4).ToString();
}
catch (InvalidOperationException) { }
sqlRdr.Close();
this.sc = sc;
this.Visible = true;
}
