}//--------------------------
//this procedure will update major exam schedule
public void UpdateMajorExamSchedule(CommonExchange.SysAccess userInfo, CommonExchange.MajorExamSchedule majorExamScheduleInfo)
{
using (RemoteClient.RemCntMajorExamScheduleManager remClient = new RemoteClient.RemCntMajorExamScheduleManager())
{
remClient.UpdateMajorExamSchedule(userInfo, majorExamScheduleInfo);
}
Int32 index = 0;
foreach (DataRow examRow in _majorExamScheduleTable.Rows)
{
if (examRow.RowState != DataRowState.Deleted)
{
if (majorExamScheduleInfo.MajorExamId == RemoteServerLib.ProcStatic.DataRowConvert(examRow, "major_exam_id", Int64.Parse("0")))
{
DataRow editRow = _majorExamScheduleTable.Rows[index];
editRow.BeginEdit();
editRow["course_group_id"] = majorExamScheduleInfo.CourseGroupId;
editRow["exam_date"] = majorExamScheduleInfo.ExamDate;
editRow["exam_description"] = majorExamScheduleInfo.ExamDescription;
editRow["exam_information_id"] = majorExamScheduleInfo.ExamInformationId;
editRow["group_description"] = majorExamScheduleInfo.GroupDescription;
editRow["sysid_semester"] = majorExamScheduleInfo.SemesterSysId;
editRow["year_id"] = majorExamScheduleInfo.YearId;
editRow.EndEdit();
}
index++;
}
}
}//----------------------------
}//-------------------------------
//this procedure will insert major exam schedule
public void InsertMajorExamSchedule(CommonExchange.SysAccess userInfo, CommonExchange.MajorExamSchedule majorExamScheduleInfo)
{
using (RemoteClient.RemCntMajorExamScheduleManager remClient = new RemoteClient.RemCntMajorExamScheduleManager())
{
remClient.InsertMajorExamSchedule(userInfo, majorExamScheduleInfo);
}
}//--------------------------
}//-------------------------
//this procedure will get details major exam schedule
public CommonExchange.MajorExamSchedule GetDetailsMajorExamSchedule(String majorExamId)
{
CommonExchange.MajorExamSchedule majorExamScheduleInfo = new CommonExchange.MajorExamSchedule();
String strFilter = "major_exam_id = '" + majorExamId + "'";
DataRow[] selectRow = _majorExamScheduleTable.Select(strFilter);
foreach (DataRow examRow in selectRow)
{
if (examRow.RowState != DataRowState.Deleted)
{
majorExamScheduleInfo.CourseGroupId = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "course_group_id", "");
majorExamScheduleInfo.ExamDate = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "exam_date", "");
majorExamScheduleInfo.ExamDescription = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "exam_description", "");
majorExamScheduleInfo.ExamInformationId = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "exam_information_id", "");
majorExamScheduleInfo.GroupDescription = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "group_description", "");
majorExamScheduleInfo.SemesterSysId = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "sysid_semester", "");
majorExamScheduleInfo.YearId = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "year_id", "");
majorExamScheduleInfo.CourseGroupId = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "course_group_id", "");
majorExamScheduleInfo.MajorExamId = RemoteServerLib.ProcStatic.DataRowConvert(examRow, "major_exam_id", Int64.Parse("0"));
break;
}
}
return(majorExamScheduleInfo);
}//------------------------
}//--------------------
//this fucntion will determine if the major exam schedule already exist
public Boolean IsExistsYearSemesterIDExamDateInformationIDExamSchedule(CommonExchange.SysAccess userInfo,
CommonExchange.MajorExamSchedule majorExamScheduleInfo)
{
Boolean value = false;
using (RemoteClient.RemCntMajorExamScheduleManager remClient = new RemoteClient.RemCntMajorExamScheduleManager())
{
value = remClient.IsExistsYearSemesterIDExamDateInformationIDExamSchedule(userInfo, majorExamScheduleInfo);
}
return(value);
}//-----------------------
public MajorExamScheduleUpdate(CommonExchange.SysAccess userInfo, CommonExchange.MajorExamSchedule majorExamScheduleInfo,
MajorExamScheduleLogic majorExamScheduleManager)
: base(userInfo, majorExamScheduleManager)
{
this.InitializeComponent();
_userInfo = userInfo;
_majorExamScheduleInfo = majorExamScheduleInfo;
_majorExamScheduleInfoTemp = (CommonExchange.MajorExamSchedule)majorExamScheduleInfo.Clone();
_majorExamScheduleManager = majorExamScheduleManager;
this.FormClosing += new FormClosingEventHandler(ClassClosing);
this.btnClose.Click += new EventHandler(btnCloseClick);
this.btnUpdate.Click += new EventHandler(btnUpdateClick);
this.btnDelete.Click += new EventHandler(btnDeleteClick);
}
public MajorExamSchedule(CommonExchange.SysAccess userInfo, MajorExamScheduleLogic majorExamScheduleManager)
{
this.InitializeComponent();
_userInfo = userInfo;
_majorExamScheduleManager = majorExamScheduleManager;
_majorExamScheduleInfo = new CommonExchange.MajorExamSchedule();
_errProvider = new ErrorProvider();
this.Load += new EventHandler(ClassLoad);
this.cboCourseGroup.SelectedIndexChanged += new EventHandler(cboCourseGroupSelectedIndexChanged);
this.cboYear.SelectedIndexChanged += new EventHandler(cboYearSelectedIndexChanged);
this.cboSemester.SelectedIndexChanged += new EventHandler(cboSemesterSelectedIndexChanged);
this.cboExamDescription.SelectedIndexChanged += new EventHandler(cboExamDescriptionSelectedIndexChanged);
this.txtExamDate.Validated += new EventHandler(txtExamDateValidated);
this.lnkChangeDate.LinkClicked += new LinkLabelLinkClickedEventHandler(lnkChangeDateLinkClicked);
}
}//----------------------------
//this procedure will delete major exam schedule
public void DeleteMajorExamSchedule(CommonExchange.SysAccess userInfo, CommonExchange.MajorExamSchedule majorExamScheduleInfo)
{
using (RemoteClient.RemCntMajorExamScheduleManager remClient = new RemoteClient.RemCntMajorExamScheduleManager())
{
remClient.DeleteMajorExamSchedule(userInfo, majorExamScheduleInfo);
}
Int32 index = 0;
foreach (DataRow examRow in _majorExamScheduleTable.Rows)
{
if (examRow.RowState != DataRowState.Deleted)
{
if (majorExamScheduleInfo.MajorExamId == RemoteServerLib.ProcStatic.DataRowConvert(examRow, "major_exam_id", Int64.Parse("0")))
{
DataRow delRow = _majorExamScheduleTable.Rows[index];
delRow.Delete();
}
index++;
}
}
}//--------------------------
//####################################################CLASS MajorExamSchedule EVENTS###############################################
//event is raised when the class is loaded
protected virtual void ClassLoad(object sender, EventArgs e)
{
_majorExamScheduleInfo = new CommonExchange.MajorExamSchedule();
_majorExamScheduleManager.InitializeCourseGroupCombo(this.cboCourseGroup);
}//-------------------------
