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