public StudentScheduleOfCourses GetStudentScheduleOfCourses(int studentNo, string termDate)
{
var query = new StringBuilder();
query.AppendFormat("SELECT StudentNo, Student, TermBeginDate, Course, CourseDescription, Room, Instructor, Units, FirstClassDate, LastClassDate")
.AppendFormat(" FROM vWebScheduleOfCourses")
.AppendFormat(" WHERE StudentNo = {0} AND TermBeginDate = '{1}'", studentNo, termDate);
var classSchedules = new List <ScheduleOfCourse>();
using (var reader = this.ExecuteReader(CommandType.Text, query.ToString()))
{
while (reader.Read())
{
int colIndex = -1;
var classSchedule = new ScheduleOfCourse
{
StudentNo = reader[++colIndex] as int?,
Student = reader[++colIndex] as string,
TermBeginDate = reader[++colIndex] as DateTime?,
Course = reader[++colIndex] as string,
CourseDescription = reader[++colIndex] as string,
Room = reader[++colIndex] as string,
Instructor = reader[++colIndex] as string,
Units = reader[++colIndex] as double?,
FirstClassDate = reader[++colIndex] as DateTime?,
LastClassDate = reader[++colIndex] as DateTime?
};
classSchedules.Add(classSchedule);
}
}
return(new StudentScheduleOfCourses(classSchedules));
}
private void init()
{
#region Insert Test Data of Schedule of Courses
scheduleOfCourses = new Dictionary <int, StudentScheduleOfCourses>();
var classSchedules = new List <ScheduleOfCourse>();
// Enter Test Data
var classSchedule1 = new ScheduleOfCourse
{
StudentNo = 1,
Student = "Alex",
TermBeginDate = new DateTime(10, 01, 12, 00, 00, 00, 000),
Course = "PRP001 (Test-1)",
CourseDescription = "Test",
Room = "5",
Instructor = "john",
Units = 1600.00,
FirstClassDate = new DateTime(10, 01, 12, 00, 00, 00, 000),
LastClassDate = new DateTime(10, 02, 12, 00, 00, 00, 000),
};
classSchedules.Add(classSchedule1);
// Enter Test Data
var classSchedule2 = new ScheduleOfCourse
{
StudentNo = 1,
Student = "Alex",
TermBeginDate = new DateTime(10, 03, 12, 00, 00, 00, 000),
Course = "PRP001 (Test-2)",
CourseDescription = "Test",
Room = "5",
Instructor = "john",
Units = 1600.00,
FirstClassDate = new DateTime(10, 03, 12, 00, 00, 00, 000),
LastClassDate = new DateTime(10, 04, 12, 00, 00, 00, 000),
};
classSchedules.Add(classSchedule2);
// Enter Test Data
var classSchedule3 = new ScheduleOfCourse
{
StudentNo = 1,
Student = "Alex",
TermBeginDate = new DateTime(10, 05, 12, 00, 00, 00, 000),
Course = "PRP001 (Test-3)",
CourseDescription = "Test",
Room = "5",
Instructor = "john",
Units = 1600.00,
FirstClassDate = new DateTime(10, 05, 12, 00, 00, 00, 000),
LastClassDate = new DateTime(10, 06, 12, 00, 00, 00, 000),
};
classSchedules.Add(classSchedule3);
var studentAttendance = new StudentScheduleOfCourses(classSchedules);
scheduleOfCourses.Add(1, studentAttendance);
classSchedules = new List <ScheduleOfCourse>();
// Enter Test Data
classSchedule1 = new ScheduleOfCourse
{
StudentNo = 2,
Student = "Ben",
TermBeginDate = new DateTime(10, 01, 12, 00, 00, 00, 000),
Course = "PRP001 (Test-1)",
CourseDescription = "Test",
Room = "5",
Instructor = "john",
Units = 1600.00,
FirstClassDate = new DateTime(10, 01, 12, 00, 00, 00, 000),
LastClassDate = new DateTime(10, 02, 12, 00, 00, 00, 000),
};
classSchedules.Add(classSchedule1);
// Enter Test Data
classSchedule2 = new ScheduleOfCourse
{
StudentNo = 2,
Student = "Ben",
TermBeginDate = new DateTime(10, 03, 12, 00, 00, 00, 000),
Course = "PRP001 (Test-2)",
CourseDescription = "Test",
Room = "5",
Instructor = "john",
Units = 1600.00,
FirstClassDate = new DateTime(10, 03, 12, 00, 00, 00, 000),
LastClassDate = new DateTime(10, 04, 12, 00, 00, 00, 000),
};
classSchedules.Add(classSchedule2);
// Enter Test Data
classSchedule3 = new ScheduleOfCourse
{
StudentNo = 2,
Student = "Ben",
TermBeginDate = new DateTime(10, 05, 12, 00, 00, 00, 000),
Course = "PRP001 (Test-3)",
CourseDescription = "Test",
Room = "5",
Instructor = "john",
Units = 1600.00,
FirstClassDate = new DateTime(10, 05, 12, 00, 00, 00, 000),
LastClassDate = new DateTime(10, 06, 12, 00, 00, 00, 000),
};
classSchedules.Add(classSchedule3);
studentAttendance = new StudentScheduleOfCourses(classSchedules);
scheduleOfCourses.Add(2, studentAttendance);
#endregion
}
