public StudentProgramCourseProgress GetStudentProgramCoursePrograssDetail(int?studentNo)
{
var query = new StringBuilder();
query.AppendFormat("SELECT TOP (100) PERCENT StudentNo, Student, ReportGroup, CourseNo, CourseCode, CourseDescription, Units")
.AppendFormat(" FROM vWebProgramCourseProgress")
.AppendFormat(" WHERE StudentNo = {0} ORDER BY Student, ReportGroup, CourseCode", studentNo);
var programCoursePrograssDetail = new List <ProgramCourseProgress>();
using (var reader = this.ExecuteReader(CommandType.Text, query.ToString()))
{
while (reader.Read())
{
int colIndex = -1;
var programCoursePrograss = new ProgramCourseProgress()
{
StudentNo = reader[++colIndex] as int?,
Student = reader[++colIndex] as string,
ReportGroup = reader[++colIndex] as string,
CourseNo = reader[++colIndex] as int?,
CourseCode = reader[++colIndex] as string,
CourseDescription = reader[++colIndex] as string,
Units = reader[++colIndex] as double?
};
programCoursePrograssDetail.Add(programCoursePrograss);
}
}
return(new StudentProgramCourseProgress(programCoursePrograssDetail));
}
private void init()
{
#region Insert Test Data of Program Course Progress
programCourseProgress = new Dictionary <int, StudentProgramCourseProgress>();
// StudentNo 1.
var programCoursePrograssDetail = new List <ProgramCourseProgress>();
// Enter Valid Data
var programCoursePrograss1 = new ProgramCourseProgress()
{
StudentNo = 1,
Student = "Alex",
ReportGroup = "Completed",
CourseNo = 100,
CourseCode = "CLI002 Tast1",
CourseDescription = "Test",
Units = 1600.00
};
programCoursePrograssDetail.Add(programCoursePrograss1);
// Enter Valid Data
var programCoursePrograss2 = new ProgramCourseProgress()
{
StudentNo = 1,
Student = "Alex",
ReportGroup = "Completed",
CourseNo = 102,
CourseCode = "CLI002 Tast2",
CourseDescription = "Test",
Units = 1200.00
};
programCoursePrograssDetail.Add(programCoursePrograss2);
// Enter Valid Data
var programCoursePrograss3 = new ProgramCourseProgress()
{
StudentNo = 1,
Student = "Alex",
ReportGroup = "Completed",
CourseNo = 180,
CourseCode = "CLI002 Tast3",
CourseDescription = "Test",
Units = 1600.00
};
programCoursePrograssDetail.Add(programCoursePrograss3);
// Enter Valid Data
var programCoursePrograss4 = new ProgramCourseProgress()
{
StudentNo = 1,
Student = "Alex",
ReportGroup = "In Progress",
CourseNo = 250,
CourseCode = "CLI002 Tast4",
CourseDescription = "Test",
Units = 1200.00
};
programCoursePrograssDetail.Add(programCoursePrograss4);
// Enter Valid Data
var programCoursePrograss5 = new ProgramCourseProgress()
{
StudentNo = 1,
Student = "Alex",
ReportGroup = "In Progress",
CourseNo = 200,
CourseCode = "CLI002 Tast5",
CourseDescription = "Test",
Units = 800.00
};
programCoursePrograssDetail.Add(programCoursePrograss5);
var programCourseDetail = new StudentProgramCourseProgress(programCoursePrograssDetail);
programCourseProgress.Add(1, programCourseDetail);
// StudentNo 2.
programCoursePrograssDetail = new List <ProgramCourseProgress>();
for (int i = 0; i < 4; i++)
{
// Enter Valid Data
programCoursePrograss1 = new ProgramCourseProgress()
{
StudentNo = 2,
Student = "Ben",
ReportGroup = "In Progress",
CourseNo = 100,
CourseCode = "CLI002 Tast" + i,
CourseDescription = "Test",
Units = 400.00 * i
};
programCoursePrograssDetail.Add(programCoursePrograss1);
}
programCourseDetail = new StudentProgramCourseProgress(programCoursePrograssDetail);
programCourseProgress.Add(2, programCourseDetail);
#endregion
}
