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 }