public StudentCosmetologyGradeBookLab GetStudentCosmetologyGradeBookLabReport(int studentNo) { var query = new StringBuilder(); query.AppendFormat("SELECT StudentNo, Student, [Description], CompletedSessions, RequiredSessions ") .AppendFormat(" FROM vWebCosmetologyGradeBookLab") .AppendFormat(" WHERE StudentNo = {0} ORDER BY Student, [Description] ASC", studentNo); var cosmetologyGradeBookLab = new List <CosmetologyGradeBookLab>(); using (var reader = this.ExecuteReader(CommandType.Text, query.ToString())) { while (reader.Read()) { int colIndex = -1; var gradeBookLab = new CosmetologyGradeBookLab { StudentNo = reader[++colIndex] as int?, Student = reader[++colIndex] as string, Description = reader[++colIndex] as string, CompletedSessions = int.Parse(reader[++colIndex].ToString()) as int?, RequiredSessions = int.Parse(reader[++colIndex].ToString()) as int? }; cosmetologyGradeBookLab.Add(gradeBookLab); } } return(new StudentCosmetologyGradeBookLab(cosmetologyGradeBookLab)); }
private void init() { #region Insert Test Data of Student Cosmetology Grade Book Test studentCosmetologyGradeBookTest = new Dictionary <int, StudentCosmetologyGradeBookTest>(); var cosmetologyGradeBookTest = new List <DiamondD.Data.DataAccess.CosmetologyGradeBook.CosmetologyGradeBookTest>(); // Enter Test Data var gradeBookTest1 = new DiamondD.Data.DataAccess.CosmetologyGradeBook.CosmetologyGradeBookTest { StudentNo = 1, Student = "Alex", Description = "Test 1", CompletedPoints = 95.00 }; cosmetologyGradeBookTest.Add(gradeBookTest1); // Enter Test Data var gradeBookTest2 = new DiamondD.Data.DataAccess.CosmetologyGradeBook.CosmetologyGradeBookTest { StudentNo = 1, Student = "Alex", Description = "Test 2", CompletedPoints = 100 }; cosmetologyGradeBookTest.Add(gradeBookTest2); // Enter Test Data var gradeBookTest3 = new DiamondD.Data.DataAccess.CosmetologyGradeBook.CosmetologyGradeBookTest { StudentNo = 1, Student = "Alex", Description = "Test 3", CompletedPoints = 95.00 }; cosmetologyGradeBookTest.Add(gradeBookTest3); var CosmetologyGradeBookTest = new StudentCosmetologyGradeBookTest(cosmetologyGradeBookTest); studentCosmetologyGradeBookTest.Add(1, CosmetologyGradeBookTest); #endregion #region Insert Test Data of Student Cosmetology Grade Book Summary studentCosmetologyGradeBookSummary = new Dictionary <int, StudentCosmetologyGradeBookSummary>(); var cosmetologyGradeBookSummary = new List <CosmetologyGradeBookSummary>(); // Enter Valid Data var gradeBookSummary1 = new CosmetologyGradeBookSummary { StudentNo = 1, Student = "Alex", GradeBookGPA = 90.00, TotalScheduled = 2000.00, TotalAttended = 1500.00, AttendancePercentage = 75.00, TotalRequiredHours = 1800, TotalTransferHours = 500, TotalHoursRemaining = 300.00 }; cosmetologyGradeBookSummary.Add(gradeBookSummary1); // Enter Valid Data var gradeBookSummary2 = new CosmetologyGradeBookSummary { StudentNo = 1, Student = "Alex", GradeBookGPA = 90.00, TotalScheduled = 2000.00, TotalAttended = 1600.00, AttendancePercentage = 80.00, TotalRequiredHours = 1800, TotalTransferHours = 500, TotalHoursRemaining = 200.00 }; cosmetologyGradeBookSummary.Add(gradeBookSummary2); // Enter Valid Data var gradeBookSummary3 = new CosmetologyGradeBookSummary { StudentNo = 1, Student = "Alex", GradeBookGPA = 90.00, TotalScheduled = 2000.00, TotalAttended = 1700.00, AttendancePercentage = 85.00, TotalRequiredHours = 1800, TotalTransferHours = 500, TotalHoursRemaining = 100.00 }; cosmetologyGradeBookSummary.Add(gradeBookSummary3); var CosmetologyGradeBookSummary = new StudentCosmetologyGradeBookSummary(cosmetologyGradeBookSummary); studentCosmetologyGradeBookSummary.Add(1, CosmetologyGradeBookSummary); #endregion #region Insert Test Data of Student Cosmetology Grade Book Lab studentCosmetologyGradeBookLab = new Dictionary <int, StudentCosmetologyGradeBookLab>(); var cosmetologyGradeBookLab = new List <CosmetologyGradeBookLab>(); //Enter Valid Data var gradeBookLab1 = new CosmetologyGradeBookLab { StudentNo = 1, Student = "Alex", Description = "Test 1", CompletedSessions = 150, RequiredSessions = 160 }; cosmetologyGradeBookLab.Add(gradeBookLab1); //Enter Valid Data var gradeBookLab2 = new CosmetologyGradeBookLab { StudentNo = 1, Student = "Alex", Description = "Test 2", CompletedSessions = 60, RequiredSessions = 100 }; cosmetologyGradeBookLab.Add(gradeBookLab2); //Enter Valid Data var gradeBookLab3 = new CosmetologyGradeBookLab { StudentNo = 1, Student = "Alex", Description = "Test 3", CompletedSessions = 50, RequiredSessions = 50 }; cosmetologyGradeBookLab.Add(gradeBookLab3); var CosmetologyGradeBookLab = new StudentCosmetologyGradeBookLab(cosmetologyGradeBookLab); studentCosmetologyGradeBookLab.Add(1, CosmetologyGradeBookLab); #endregion }