} //--------------------------- //this function returns a searched semester information public DataTable GetSearchedSemesterInformation(CommonExchange.SysAccess userInfo, String queryString, Boolean isNewQuery) { if (isNewQuery) { using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) { _semesterTable = remClient.SelectYearSemesterDescriptionSemesterInformationTable(userInfo, queryString, _serverDateTime); } } DataTable newTable = new DataTable("SemesterInformationSearchedTable"); newTable.Columns.Add("sysid_semester", System.Type.GetType("System.String")); newTable.Columns.Add("year_description", System.Type.GetType("System.String")); newTable.Columns.Add("semester_description", System.Type.GetType("System.String")); if (_semesterTable != null) { foreach (DataRow semRow in _semesterTable.Rows) { DataRow newRow = newTable.NewRow(); newRow["sysid_semester"] = semRow["sysid_semester"]; newRow["year_description"] = semRow["year_description"]; newRow["semester_description"] = semRow["semester_description"]; newTable.Rows.Add(newRow); } } newTable.AcceptChanges(); return(newTable); } //----------------------------
} //----------------------------------- //this function returns a searched school year public DataTable GetSearchedSchoolYearInformation(CommonExchange.SysAccess userInfo, String queryString, Boolean isNewQuery) { if (isNewQuery) { using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) { _schoolYearTable = remClient.SelectByYearDescriptionSchoolYearTable(userInfo, queryString, _serverDateTime); } } DataTable newTable = new DataTable("SchoolYearInformationSearchTable"); newTable.Columns.Add("year_id", System.Type.GetType("System.String")); newTable.Columns.Add("year_description", System.Type.GetType("System.String")); if (_schoolYearTable != null) { DataRow[] selectRow = _schoolYearTable.Select("", "year_id DESC"); foreach (DataRow yearRow in selectRow) { DataRow newRow = newTable.NewRow(); newRow["year_id"] = yearRow["year_id"].ToString(); newRow["year_description"] = yearRow["year_description"].ToString(); newTable.Rows.Add(newRow); } } newTable.AcceptChanges(); return(newTable); } //---------------------------
} //---------------------------- ////this function returns a school semester id //private Byte GetSchoolSemesterId(String yearId) //{ // if (_semesterTable != null) // { // String strFilter = "year_id = '" + yearId + "'"; // DataRow[] selectRow = _semesterTable.Select(strFilter, "sysid_semester DESC"); // return (Byte)(selectRow.Length + 1); // } // else // { // return 0; // } //} //----------------------------- ////this function determines if the school semester has errors //private Boolean HasErrorSemester(CommonExchange.SysAccess userInfo, String yearId) //{ // Boolean hasError = true; // using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) // { // _semesterTable = remClient.SelectYearSemesterDescriptionSemesterInformationTable(userInfo, "*", _serverDateTime); // } // String strFilter = "year_id = '" + yearId + "'"; // DataRow[] selectRow = _semesterTable.Select(strFilter, "sysid_semester DESC"); // if (selectRow.Length < (Int32)CommonExchange.SchoolSemester.SecondSemester) // { // hasError = false; // } // return hasError; //} //--------------------------- //this function gets the semester information start date private DateTime GetSemesterInformationDateStart(CommonExchange.SysAccess userInfo) { DateTime maxDate; using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) { if (!DateTime.TryParse(remClient.GetMaxDateEndSemesterInformation(userInfo), out maxDate)) { maxDate = DateTime.Parse(_stdRegistrar.SchoolYearStart.ToString() + "/01/" + DateTime.Parse(_serverDateTime).Year.ToString() + " 12:00:00 AM"); } } return(DateTime.Parse(maxDate.AddMonths(1).Month.ToString() + "/01/" + maxDate.AddMonths(1).Year.ToString() + " 12:00:00 AM")); } //-------------------------------
} //-------------------------------- //this procedure initializes the class private void InitializeClass(CommonExchange.SysAccess userInfo) { //gets the server date and time using (RemoteClient.RemCntBaseManager remClient = new RemoteClient.RemCntBaseManager()) { _serverDateTime = remClient.GetServerDateTime(userInfo); } //---------------------- //gets the dataset for the school year information using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) { _classDataSet = remClient.GetDataSetForSchoolYearSemeter(userInfo); } //----------------------- //gets the registrar standard using (RemoteClient.RemCntBaseManager remClient = new RemoteClient.RemCntBaseManager()) { _stdRegistrar = remClient.SelectRegistrarStandard(userInfo); } //------------------ } //-----------------------
} //------------------------------------ //this procedure inserts a school year public void InsertSchoolYearSummer(CommonExchange.SysAccess userInfo, CommonExchange.SchoolYear baseYearInfo, ref CommonExchange.SchoolYear yearInfo) { using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) { remClient.InsertSchoolYearSummer(userInfo, baseYearInfo, ref yearInfo); } if (_schoolYearTable != null) { DataRow newRow = _schoolYearTable.NewRow(); newRow["year_id"] = yearInfo.YearId; newRow["year_description"] = yearInfo.Description; newRow["date_start"] = yearInfo.DateStart; newRow["date_end"] = yearInfo.DateEnd; newRow["is_summer"] = yearInfo.IsSummer; _schoolYearTable.Rows.Add(newRow); _schoolYearTable.AcceptChanges(); } } //------------------------------------
} //---------------------------- //this function gets the school year start date private DateTime GetSchoolYearDateStart(CommonExchange.SysAccess userInfo, Boolean isSummer) { DateTime dateStart; using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) { DateTime dateEnd; if (!isSummer) { if (DateTime.TryParse(remClient.GetMaxDateEndSchoolYear(userInfo), out dateEnd)) { dateStart = DateTime.Parse(_stdRegistrar.SchoolYearStart.ToString() + "/01/" + dateEnd.Year.ToString() + " 12:00:00 AM"); } else { dateStart = DateTime.Parse(_stdRegistrar.SchoolYearStart.ToString() + "/01/" + DateTime.Parse(_serverDateTime).Year.ToString() + " 12:00:00 AM"); } } else { if (DateTime.TryParse(remClient.GetMaxDateEndSchoolYear(userInfo), out dateEnd)) { dateStart = DateTime.Parse(dateEnd.AddMonths(1).Month.ToString() + "/01/" + dateEnd.AddMonths(1).Year.ToString() + " 12:00:00 AM"); } else { dateStart = DateTime.Parse(DateTime.Parse(_serverDateTime).AddMonths(1).Month.ToString() + "/01/" + DateTime.Parse(_serverDateTime).AddMonths(1).Year.ToString() + " 12:00:00 AM"); } } } return(dateStart); } //-------------------------
//this procedure insterst a school semester information public void InsertSemesterInformation(CommonExchange.SysAccess userInfo, CommonExchange.SemesterInformation semInfo) { using (RemoteClient.RemCntSchoolYearSemesterManager remClient = new RemoteClient.RemCntSchoolYearSemesterManager()) { remClient.InsertSemesterInformation(userInfo, ref semInfo); } if (_semesterTable != null) { DataRow newRow = _semesterTable.NewRow(); newRow["sysid_semester"] = semInfo.SemesterSysId; newRow["year_id"] = semInfo.SchoolYearInfo.YearId; newRow["semester_id"] = semInfo.SemesterId; newRow["date_start"] = semInfo.DateStart; newRow["date_end"] = semInfo.DateEnd; newRow["year_description"] = semInfo.SchoolYearDescription; newRow["semester_description"] = semInfo.SchoolSemesterDescription; _semesterTable.Rows.Add(newRow); _semesterTable.AcceptChanges(); } } //---------------------------------