public RegisteredAvailableCourseList GetUpdatedRegisteredCoursesList(RegisteredAvailableCourseList RnAList) { SqlConnection connection = SqlHelper.CreateConnection(); List<StudentCourse> availableCourses = new List<StudentCourse>(); List<StudentCourse> RegisteredCourses = RnAList.registeredCourses; List<StudentCourse> AvailableCourses = RnAList.availableCourses; string RegisteredCoursesList = ""; foreach (StudentCourse studentCourse in RegisteredCourses) { RegisteredCoursesList = RegisteredCoursesList + studentCourse.SemesterCourseID + ","; } if (RegisteredCoursesList != "" && RegisteredCoursesList != null) { try { SqlParameter pCourseList = new SqlParameter("@CourseIDs", SqlDbType.NVarChar); SqlParameter pRemovedSemesterCourseID = new SqlParameter("@CheckSemesterCourseID", SqlDbType.Int); SqlParameter pToRemoveCourseList = new SqlParameter("@ToRemove", SqlDbType.NVarChar, 100); pToRemoveCourseList.Direction = ParameterDirection.Output; string spName = "GetAllDependenciesChain"; RegisteredCoursesList = RegisteredCoursesList.Remove(RegisteredCoursesList.Length - 1); pCourseList.Value = RegisteredCoursesList; pRemovedSemesterCourseID.Value = RnAList.removedSemesterCourseID; SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, spName,pRemovedSemesterCourseID, pCourseList, pToRemoveCourseList); string ToRemove = SqlHelper.ToString(pToRemoveCourseList.Value); if(ToRemove!=null && ToRemove!="") { string[] toRemoveCourses = ToRemove.Trim(',').Split(','); foreach (string semestercourseID in toRemoveCourses) { foreach (StudentCourse SC in RegisteredCourses) { if (SC.SemesterCourseID == Convert.ToInt32(semestercourseID)) { RegisteredCourses.Remove(SC); break; } } } } RnAList.registeredCourses = RegisteredCourses; } catch (SqlException sqlEx) { SqlHelper.CloseConnection(connection); throw new Exception("SearchStudent: " + sqlEx.ToString()); } catch (Exception Ex) { SqlHelper.CloseConnection(connection); throw new Exception("SearchStudent: " + Ex.ToString()); } } return RnAList; }
public RegisteredAvailableCourseList GetStudentRegisteredAndAvailableCourses(int studentID, RegisteredAvailableCourseList RnAList) { dlStudent = new DLStudent(); return dlStudent.GetStudentRegisteredAndAvailableCourses(studentID, RnAList); }
public RegisteredAvailableCourseList GetStudentRegisteredAndAvailableCourses(int studentID,RegisteredAvailableCourseList RnAList) { List<StudentCourse> RegisteredCourses = RnAList.registeredCourses; List<StudentCourse> AvailableCourses = RnAList.availableCourses; if (RnAList.availableCourses == null) { RegisteredCourses = GetStudentRegisteredCourses(studentID); AvailableCourses = GetAvailableCourses(RegisteredCourses); RnAList.availableCourses = AvailableCourses; RnAList.registeredCourses = RegisteredCourses; return RnAList; } else { RnAList = GetUpdatedRegisteredCoursesList(RnAList); RnAList.availableCourses = GetAvailableCourses(RnAList.registeredCourses); } return RnAList; }