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;
}
