public void LoadData() { if(_mode=="Edit") { DataTable dtbl=null; this.Text = "Editing Event..."; objEvent=new Scheduler.BusinessLayer.Events(); objEvent.EventID = _eventid; if(_calendareventid>0) objEvent.CalendarEventID=_calendareventid; dtbl = objEvent.LoadData(); string strClient="", strDept="", strClass="", strProgram=""; foreach(DataRow dr in dtbl.Rows) { if(dr["Client"]!=System.DBNull.Value) strClient = dr["Client"].ToString(); if(dr["Department"]!=System.DBNull.Value) strDept = dr["Department"].ToString(); if(dr["Program"]!=System.DBNull.Value) strProgram = dr["Program"].ToString(); if(dr["Class"]!=System.DBNull.Value) strClass = dr["Class"].ToString(); if(dr["ProgramID"]!=System.DBNull.Value) intProgramID = Convert.ToInt32(dr["ProgramID"].ToString()); if(dr["CourseID"]!=System.DBNull.Value) intClassID = Convert.ToInt32(dr["CourseID"].ToString()); cmbClient.Text = strClient; if(strClient.Trim()!="") { intClientID = Common.GetCompanyID( "Select ContactID From Contact " + "Where (CompanyName =@CompanyName OR NickName=@CompanyName)", cmbClient.Text ); if(intClientID!=0) { cmbDept.Text = strDept; intDepartmentID = Common.GetCompanyID( "Select D.DepartmentID from Department D, Contact C " + "Where D.ContactID=C.ContactID and (C.CompanyName= @CompanyName OR NickName=@CompanyName)", cmbDept.Text ); } if(intDepartmentID!=0) { cmbProgram.Text = strProgram; intProgramID = Common.GetCompanyID( "Select ProgramID From Program " + "Where ([Name]= @CompanyName OR NickName=@CompanyName)", cmbProgram.Text ); } if(intProgramID!=0) { cmbClass.Text = strClass; intClassID = Common.GetCompanyID( "Select CourseID From Course " + "Where ([Name]= @CompanyName OR NickName=@CompanyName) and ProgramID=" + intProgramID.ToString(), cmbClass.Text ); } if(dr["TestEvent"]!=System.DBNull.Value) { cmbEvent.Text = dr["TestEvent"].ToString(); cmbEvent.Tag = cmbEvent.SelectedIndex.ToString(); } } RepeatRule= dr["RepeatRule"].ToString(); NegativeException = dr["NegetiveException"].ToString(); txtName.Text = dr["Name"].ToString(); txtPhonetic.Text = dr["NamePhonetic"].ToString(); txtRomaji.Text = dr["NameRomaji"].ToString(); if (dr["EventType"] != System.DBNull.Value) { cmbEventType.SelectedIndex = cmbEventType.Items.IndexOf(dr["EventType"].ToString()); switch (dr["EventType"].ToString()) { case "Extra Class": _eventtype = EventType.Extra; break; case "Test Initial": _eventtype = EventType.Initial; break; case "Test Midterm": _eventtype = EventType.MidTerm; break; case "Test Final": _eventtype = EventType.Final; break; } } else SetDefaultEventType(); //cmbEventType.SelectedIndex = -1; txtLocation.Text = dr["Location"].ToString(); cmbBlock.Text = dr["BlockCode"].ToString(); txtRoomNo.Text = dr["RoomNumber"].ToString(); txtDescription.Text = dr["Description"].ToString(); txtNote.Text = dr["Note"].ToString(); if(dr["ExceptionReason"]!=System.DBNull.Value) cmbExceptionReason.Text = dr["ExceptionReason"].ToString(); cmbEventStatus.SelectedIndex = Convert.ToInt16(dr["EventStatus"].ToString()); cmbTeacher1.Text = dr["ScheduledTeacher"].ToString(); cmbTeacher2.Text = dr["RealTeacher"].ToString(); txtChangeReason.Text = dr["ChangeReason"].ToString(); if(dr["IsHoliday"]==System.DBNull.Value) chkIsHoliday.Checked=false; else chkIsHoliday.Checked = (Convert.ToInt16(dr["IsHoliday"])>0); XMLData = dr["RepeatRule"].ToString(); if(dr["RecurrenceText"]!=System.DBNull.Value) if(dr["RecurrenceText"].ToString()!="") IsRecurrenceFlag = 1; dtStart.Value = Convert.ToDateTime(dr["StartDateTime"].ToString()); dtEnd.Value = Convert.ToDateTime(dr["EndDateTime"].ToString()); StartTime = dtStart.Value.ToString("HH:mm"); EndTime = dtEnd.Value.ToString("HH:mm"); try { SetTime(cmbStartTime, Convert.ToDateTime(StartTime).ToString("HH:mm")); SetTime(cmbEndTime, Convert.ToDateTime(EndTime).ToString("HH:mm")); } catch{} dtDateComplete.Value = Convert.ToDateTime(dr["DateCompleted"].ToString()); StartDate = dtStart.Value.ToShortDateString() + " " + cmbStartTime.Text; EndDate = dtEnd.Value.ToShortDateString() + " " + cmbEndTime.Text; break; } if (dtbl.Rows.Count <= 0) { _mode = "Add"; _eventid = 0; dtDateComplete.Value = DateTime.Now; dtStart.Value = DateTime.Now; dtEnd.Value = DateTime.Now; if (File.Exists(strAppPath)) File.Delete(strAppPath); this.Text = "Adding Event..."; //GenerateTimeCombo(); cmbEventStatus.SelectedIndex = 0; SetDefaultEventType(); //cmbEventType.SelectedIndex = -1; } } }
/* private void LoadEvent() { llblEvent.Text = "None"; llblInitialEvt.Text = "None"; llblMidEvt.Text = "None"; llblFinalEvt.Text = "None"; Scheduler.BusinessLayer.Course objCourse=new Scheduler.BusinessLayer.Course(); objCourse.CourseId = _courseid; objCourse.LoadData(); foreach(DataRow dr in objCourse.CourseDataTable.Rows) { txtEvent.Text = dr["EventID"].ToString(); txtInitialEvent.Text = dr["TestInitialEventId"].ToString(); txtMidtermEvent.Text = dr["TestMidTermEventId"].ToString(); txtFinalEvent.Text = dr["TestFinalEventId"].ToString(); break; } string strHint=""; llblEvent.Text = objCourse.getEventText(txtEvent.Text, "Event", ref strHint); if(strHint!="") llblEvent.Text = strHint; strHint=""; llblInitialEvt.Text = objCourse.getEventText(txtInitialEvent.Text, "Initial", ref strHint); strHint=""; llblMidEvt.Text = objCourse.getEventText(txtMidtermEvent.Text, "Midterm", ref strHint); strHint=""; llblFinalEvt.Text = objCourse.getEventText(txtEvent.Text, "Event", ref strHint); strHint=""; } */ private bool LoadEvent(int _eventid, ref ArrayList arrEvent) { //SaveEventData(ref _eventid); if (_eventid == 0) return false; DataTable dtbl = null; DateTime dt1 = Convert.ToDateTime(null); DateTime dt2 = Convert.ToDateTime(null); string sReccText = string.Empty; objEvent = new Scheduler.BusinessLayer.Events(); objEvent.EventID = _eventid; dtbl = objEvent.LoadData(); if (dtbl.Rows.Count <= 0) { return false; } arrEvent.Add(""); foreach (DataRow dr in dtbl.Rows) { bool IsRecc = false; #region oldCode /*if(dr["RecurrenceText"]!=System.DBNull.Value) { if(dr["RecurrenceText"].ToString()!="") { IsRecc=true; FileInfo fi = new FileInfo(strAppPath); StreamWriter Tex =fi.CreateText(); Tex.Write(XMLData_Initial); Tex.Close(); Tex=null; if(AP==null) AP = new Serialize(); AP = AP.Load(strAppPath); if(AP==null) { dt1 = Convert.ToDateTime(dr["StartDateTime"].ToString()); dt2 = Convert.ToDateTime(dr["EndDateTime"].ToString()); } else { try { setToConfig(); dt1 = Convert.ToDateTime(_startdate_Initial); dt2 = Convert.ToDateTime(_enddate_Initial); sReccText = SeforRecurrence(); } catch{} } } }*/ #endregion if (IsRecc == false) { dt1 = Convert.ToDateTime(dr["StartDateTime"].ToString()); dt2 = Convert.ToDateTime(dr["EndDateTime"].ToString()); } arrEvent.Add(dr["Name"].ToString()); arrEvent.Add(dr["NamePhonetic"].ToString()); arrEvent.Add(dr["NameRomaji"].ToString()); arrEvent.Add(dt1.ToString()); arrEvent.Add(dt2.ToString()); //arrEvent.Add(sReccText.Trim()); arrEvent.Add(dr["Location"].ToString()); arrEvent.Add(dr["BlockCode"].ToString()); arrEvent.Add(dr["RoomNumber"].ToString()); if (dr["IsHoliday"] == System.DBNull.Value) { arrEvent.Add("No"); } else { if (Convert.ToInt16(dr["IsHoliday"]) > 0) arrEvent.Add("Yes"); else arrEvent.Add("No"); } if (dr["DateCompleted"] != System.DBNull.Value) { arrEvent.Add(dr["DateCompleted"].ToString()); } else { arrEvent.Add(""); } if (Convert.ToInt16(dr["EventStatus"].ToString()) == 0) { arrEvent.Add("Active"); } else { arrEvent.Add("Inactive"); } arrEvent.Add(dr["ScheduledTeacher"].ToString()); arrEvent.Add(dr["RealTeacher"].ToString()); if (dr["ChangeReason"] != System.DBNull.Value) { arrEvent.Add(dr["ChangeReason"].ToString()); } else { arrEvent.Add(""); } if (dr["ExceptionReason"] != System.DBNull.Value) { arrEvent.Add(dr["ExceptionReason"].ToString()); } else { arrEvent.Add(""); } if (dr["Description"] != System.DBNull.Value) { arrEvent.Add(dr["Description"].ToString()); } else { arrEvent.Add(""); } if (dr["Note"] != System.DBNull.Value) { arrEvent.Add(dr["Note"].ToString()); } else { arrEvent.Add(""); } break; } return true; }
private void LoadEvent(int _eventid, int CalendarID) { if (saved) { saved = false; return; } if (_eventid == 0) return; _curreventid = _eventid; DataTable dtbl = null; objEvent = new Scheduler.BusinessLayer.Events(); objEvent.EventID = _eventid; //pnlTop_I.Visible=false; //btn_ClearRecc.Visible=true; if (CalendarID > 0) objEvent.CalendarEventID = CalendarID; dtbl = objEvent.LoadData(); if (dtbl.Rows.Count <= 0) { _eventid = 0; CalendarID = 0; _calendareventid_Initial = 0; _eventid_Initial = 0; } if (CalendarID != 0) { //means opening a single occurrence pnlTop_I.Visible = true; pnlBottom.Visible = false; objEvent.CalendarEventID = CalendarID; boolSaveSeries_initial = false; } else { pnlTop_I.Visible = false; pnlBottom.Visible = true; //Commented our because the 'Clear Recurrence' button should not be visible for non-repeating class events //btn_ClearRecc.Visible = true; //boolSaveSeries_initial = true; } //Adjust Textbox height if (pnlBottom.Visible) txtNote_I.Height = 130; else txtNote_I.Height = 150; if (dtbl.Rows.Count <= 0) { InitializeEventForm(); return; } foreach (DataRow dr in dtbl.Rows) { RepeatRule = dr["RepeatRule"].ToString(); NegativeException = dr["NegetiveException"].ToString(); txtName_I.Text = dr["Name"].ToString(); txtPhonetic_I.Text = dr["NamePhonetic"].ToString(); txtRomaji_I.Text = dr["NameRomaji"].ToString(); if (dr["EventType"] != System.DBNull.Value) { cmbEventType_I.SelectedIndex = cmbEventType_I.Items.IndexOf(dr["EventType"].ToString()); //cmbEventType_I.SelectedIndex = Convert.ToInt16(dr["EventType"].ToString()); } else cmbEventType_I.SelectedIndex = -1; txtLocation_I.Text = dr["Location"].ToString(); cmbBlock_I.Text = dr["BlockCode"].ToString(); txtRoomNo_I.Text = dr["RoomNumber"].ToString(); txtDescription_I.Text = dr["Description"].ToString(); txtNote_I.Text = dr["Note"].ToString(); if (dr["ExceptionReason"] != System.DBNull.Value) cmbExceptionReason_I.Text = dr["ExceptionReason"].ToString(); //cmbEventStatus_I.SelectedIndex = Convert.ToInt16(dr["EventStatus"].ToString()); if (Convert.ToInt16(dr["EventStatus"].ToString()) == 1) chkEventStatus_I.Checked = true; else chkEventStatus_I.Checked = false; cmbTeacher1_I.Text = dr["ScheduledTeacher"].ToString(); cmbTeacher2_I.Text = dr["RealTeacher"].ToString(); txtChangeReason_I.Text = dr["ChangeReason"].ToString(); if (dr["IsHoliday"] == System.DBNull.Value) chkIsHoliday.Checked = false; else chkIsHoliday.Checked = (Convert.ToInt16(dr["IsHoliday"]) > 0); XMLData_Initial = dr["RepeatRule"].ToString(); IsRecurrenceFlag_Initial = 0; if (dr["RecurrenceText"] != System.DBNull.Value) if (dr["RecurrenceText"].ToString() != "") IsRecurrenceFlag_Initial = 1; if (IsRecurrenceFlag_Initial == 1) { //For loading series or one occurrence in a series if (dtblDates == null) { dtblDates = new DataTable(); dtblDates.Columns.Add("StartDate", Type.GetType("System.DateTime")); dtblDates.Columns.Add("EndDate", Type.GetType("System.DateTime")); } else { dtblDates.Rows.Clear(); } FileInfo fi = new FileInfo(strAppPath); StreamWriter Tex = fi.CreateText(); Tex.Write(XMLData_Initial); Tex.Close(); Tex = null; if (AP == null) AP = new Serialize(); AP = AP.Load(strAppPath); if (AP == null) { dtStart.Value = Convert.ToDateTime(dr["StartDateTime"].ToString()); dtEnd.Value = Convert.ToDateTime(dr["EndDateTime"].ToString()); cmbStartTime.Text = Convert.ToDateTime(dr["StartDateTime"]).ToString("HH:mm"); SetTime(cmbEndTime, Convert.ToDateTime(dr["EndDateTime"]).ToString("HH:mm")); StartTime = cmbStartTime.Text; EndTime = cmbEndTime.Text; } else { try { setToConfig(); dtStart.Value = Convert.ToDateTime(_startdate_Initial); dtEnd.Value = Convert.ToDateTime(_enddate_Initial); SetTime(cmbStartTime, Convert.ToDateTime(_startdate_Initial).ToString("HH:mm")); SetTime(cmbEndTime, Convert.ToDateTime(_enddate_Initial).ToString("HH:mm")); StartTime = cmbStartTime.Text; EndTime = cmbEndTime.Text; SeforRecurrence(true); } catch { } } } else { //For single class events that do not repeat. dtStart.Value = Convert.ToDateTime(dr["StartDateTime"].ToString()); dtEnd.Value = Convert.ToDateTime(dr["EndDateTime"].ToString()); StartTime = dtStart.Value.ToString("HH:mm"); EndTime = dtEnd.Value.ToString("HH:mm"); try { SetTime(cmbStartTime, Convert.ToDateTime(StartTime).ToString("HH:mm")); SetTime(cmbEndTime, Convert.ToDateTime(EndTime).ToString("HH:mm")); } catch { } } if ((_eventid > 0) && (boolSaveSeries_initial == false)) { dtStart.Value = Convert.ToDateTime(dr["StartDateTime"].ToString()); dtEnd.Value = Convert.ToDateTime(dr["EndDateTime"].ToString()); string StartTime = ""; string EndTime = ""; StartTime = dtStart.Value.ToString("HH:mm"); EndTime = dtEnd.Value.ToString("HH:mm"); try { //StartTime StartTime = Convert.ToDateTime(StartTime).ToString("HH:mm"); if (StartTime.Substring(0, 1) == "0") { StartTime = StartTime.Substring(1, StartTime.Length - 1); } cmbStartTime.Text = StartTime; SetTime(cmbEndTime, Convert.ToDateTime(EndTime).ToString("HH:mm")); } catch { } } dtDateComplete_I.Value = Convert.ToDateTime(dr["DateCompleted"].ToString()); StartDate = dtStart.Value.ToShortDateString() + " " + cmbStartTime.Text; EndDate = dtEnd.Value.ToShortDateString() + " " + cmbEndTime.Text; break; } if (!chkEventStatus_I.Checked && cmbTeacher2_I.SelectedIndex <= 0 && cmbExceptionReason_I.SelectedIndex <= 0 && cmbExceptionReason_I.Text == "") SetEventModificationControls(false); else SetEventModificationControls(true); }
public void LoadEvent() { isProcess=false; int year=0, month=0; DateTime dtStart = SqlDateTime.MinValue.Value; DateTime dtEnd = SqlDateTime.MaxValue.Value; if(IsLoad) { PopulateDropDowns(); LoadFilterSettings(); } if (datePickerStart.Checked) dtStart = datePickerStart.Value; if (datePickerEnd.Checked) dtEnd = datePickerEnd.Value; IsLoad=false; objEvent = new Events(); //dtbl = objEvent.LoadData(dtStart, dtEnd, cmbClient.Text, cmbInstructor.Text, cmbProgram.Text, cmbClass.Text); dtbl = objEvent.LoadData(dtStart, dtEnd, ((ValuePair)cmbClient.SelectedItem).Value, ((ValuePair)cmbInstructor.SelectedItem).Value, ((ValuePair)cmbProgram.SelectedItem).Value, ((ValuePair)cmbClass.SelectedItem).Value); grdEvent.DataSource = dtbl; isProcess = true; }