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