public async Task <string> Handle(Query request, CancellationToken cancellationToken)
{
var student = _context.Students.Where(x => x.Name.Equals(request.Name));
if (student.Count() <= 0)
{
var err = new DataObjectNotFoundException(nameof(student));
LogMethods.LogError("Student not found", err, request.Logger);
throw err;
}
var report = new StudentReport()
{
StudentName = student.First().Name,
YearGrade = student.First().Grade
};
using (var stream = new MemoryStream())
{
await JsonSerializer.SerializeAsync(stream, report);
stream.Position = 0;
using var reader = new StreamReader(stream);
return(await reader.ReadToEndAsync());
}
}
// Methods
public SchoolYearScoreReportNew()
{
string reportName = "學年成績單(新制)";
string reportPath = "成績相關報表";
this.buttonStudent = new ButtonAdapter();
this.buttonStudent.Text = reportName;
this.buttonStudent.Path = reportPath;
this.buttonStudent.OnClick += new EventHandler(this.buttonStudent_OnClick);
this.buttonClass = new ButtonAdapter();
this.buttonClass.Text = reportName;
this.buttonClass.Path = reportPath;
this.buttonClass.OnClick += new EventHandler(this.buttonClass_OnClick);
StudentReport.AddReport(this.buttonStudent);
ClassReport.AddReport(this.buttonClass);
string Student = "SHEvaluation.SchoolYearScoreReportNew.Student";
string Class = "SHEvaluation.SchoolYearScoreReportNew.Class";
RibbonBarItem item1 = FISCA.Presentation.MotherForm.RibbonBarItems["學生", "資料統計"];
item1["報表"][reportPath][reportName].Enable = FISCA.Permission.UserAcl.Current[Student].Executable;
RibbonBarItem item2 = FISCA.Presentation.MotherForm.RibbonBarItems["班級", "資料統計"];
item2["報表"][reportPath][reportName].Enable = FISCA.Permission.UserAcl.Current[Class].Executable;
//權限設定
Catalog permission1 = RoleAclSource.Instance["學生"]["報表"];
permission1.Add(new RibbonFeature(Student, reportName));
Catalog permission2 = RoleAclSource.Instance["班級"]["報表"];
permission2.Add(new RibbonFeature(Class, reportName));
}
public ActionResult Report(Student student)
{
StudentReport studentReport = new StudentReport();
byte[] abytes = studentReport.PrepareReport(GetStudents());
return(File(abytes, "application/pdf"));
}
private void button1_Click(object sender, EventArgs e)
{
this.connetionString = "Data Source = whitesnow.database.windows.net; Initial Catalog = Mazal; Integrated Security = False; User ID = Grimm; Password = #!7Dwarfs; Connect Timeout = 15; Encrypt = False; TrustServerCertificate = True; ApplicationIntent = ReadWrite; MultiSubnetFailover = False";
this.sqlcon = new SqlConnection(connetionString);
SqlCommand cmd = new SqlCommand("select ID,F_name,L_name,Telephone,Email from person where Permission='Teaching_Assistant' OR Permission='Lecturer' ", sqlcon);
try
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bsource = new BindingSource();
//Paint headers
StudentReport.EnableHeadersVisualStyles = false;
StudentReport.GridColor = Utility.HeaderBackColor;
StudentReport.ColumnHeadersDefaultCellStyle.BackColor = Utility.HeaderBackColor;
StudentReport.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
StudentReport.AutoResizeColumns();
StudentReport.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
StudentReport.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
bsource.DataSource = dbdataset;
StudentReport.DataSource = bsource;
sda.Update(dbdataset);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Report_Load(object sender, EventArgs e)
{
if (str == "Student")
{
StudentReport sr = new StudentReport();
sr.SetDataSource(dss);
crystalReportViewer1.ReportSource = sr;
}
else if (str == "Staff")
{
StaffReport sr2 = new StaffReport();
sr2.SetDataSource(dss);
crystalReportViewer1.ReportSource = sr2;
}
else if (str == "User")
{
UserReport sr2 = new UserReport();
sr2.SetDataSource(dss);
crystalReportViewer1.ReportSource = sr2;
}
else if (str == "Class")
{
ClassReport cr = new ClassReport();
cr.SetDataSource(dss);
crystalReportViewer1.ReportSource = cr;
}
}
// GET: StudentReports/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentReport studentReport = _db.StudentReports.Find(id);
if (studentReport == null)
{
return(HttpNotFound());
}
var viewModel = new AddEditStudentReportViewModel();
List <SelectListItem> studentList = new List <SelectListItem>();
foreach (Student student in _db.Students)
{
if (studentReport.Student.Id == student.Id)
{
studentList.Add(new SelectListItem {
Text = student.FirstName, Value = student.Id.ToString(), Selected = true
});
}
else
{
studentList.Add(new SelectListItem {
Text = student.FirstName, Value = student.Id.ToString(), Selected = false
});
}
}
List <SelectListItem> documentTypeList = new List <SelectListItem>();
foreach (DocumentType documentType in _db.DocumentTypes)
{
if (studentReport.DocumentType.Id == documentType.Id)
{
documentTypeList.Add(new SelectListItem {
Text = documentType.Name, Value = documentType.Id.ToString(), Selected = true
});
}
else
{
documentTypeList.Add(new SelectListItem {
Text = documentType.Name, Value = documentType.Id.ToString(), Selected = false
});
}
}
viewModel.Id = studentReport.Id;
viewModel.Student = studentReport.Student;
viewModel.Comments = studentReport.Comments;
viewModel.DocumentType = studentReport.DocumentType;
viewModel.DocumentDate = studentReport.DocumentDate;
viewModel.DocumentLink = studentReport.DocumentLink;
viewModel.DocumentTypes = documentTypeList;
viewModel.Students = studentList;
return(View(viewModel));
}
public ActionResult ResultReport(string Str)
{
string UsertypeId = Session["UserTypeId"].ToString();
DataTable dtYearList = new DataTable();
DataTable dtStudentList = new DataTable();
DataTable dtSchoolList = new DataTable();
DataTable dtProductList = new DataTable();
dtYearList = StudentCon.ApplicationYearList();
ViewBag.YearList = ToSelectList(dtYearList, "Name");
dtStudentList = StudentCon.StudentList(UsertypeId);
ViewBag.StudentList = ToSelectList(dtStudentList, "Name");
dtSchoolList = StudentCon.SchoolList();
ViewBag.SchoolList = ToSelectList(dtSchoolList, "Name");
dtProductList = StudentCon.ProductList();
ViewBag.ProductList = ToSelectListWithValues(dtProductList, "Id", "Name");
if (Str == null)
{
Str = "And 1=1";
}
DataTable dt = new DataTable();
dt = StudentReport.GetStudentReport(Str, UsertypeId);
return(View(dt));
}
public void DataInsert()
{
var dataSession = new DataSession();
var uowFactory = new UnitOfWorkFactory(dataSession);
var uow = uowFactory.CreateUnitOfWork();
var user = new BursifyUser()
{
};
user.Email = "*****@*****.**";
user.PasswordHash = "password123";
user.PasswordSalt = "passwordSalt";
user.AccountStatus = "Active";
user.UserType = "Student";
user.RegistrationDate = DateTime.Today;
user.Biography = "Bio stuff";
user.CellphoneNumber = "0840924299";
user.TelephoneNumber = "0123456789";
user.ProfilePicturePath = "somewhereSafe";
var report = new StudentReport()
{
StudentId = 1,
Average = 75,
ReportInstitution = "UJ Test",
ReportPeriod = "Semester 1",
ReportLevel = "Second Year",
Subjects = new List <Subject>()
{
new Subject()
{
Name = "Informatics",
MarkAcquired = 75
},
new Subject()
{
Name = "Maths",
MarkAcquired = 75
},
new Subject()
{
Name = "Linear",
MarkAcquired = 75
}
}
};
//uow.Context.Set<BursifyUser>().Add(user);
uow.Context.Set <StudentReport>().Add(report);
//uow.Context.Set<Subject>().Add(subject);
uow.Context.SaveChanges();
uow.Commit();
}
public ActionResult AdminStudentReport()
{
StudentReport studentReport = new StudentReport
{
studentList = db.Students.ToList()
};
return(View(studentReport));
}
public ActionResult StudentReports(string studentID)
{
List <Enrollment> enrollment = db.Enrollments.Where(c => c.StudentID == studentID).ToList();
StudentReport studentReport = new StudentReport
{
selectedstudent = db.Students.Find(studentID),
NumOfCourses = enrollment.Count,
enrollments = enrollment
};
return(View(studentReport));
}
public ActionResult Index(StudentResult studentResult)
{
// ViewBag.departments = db.RegisterStudents.ToList();
//var studentResults = db.StudentResults.Include(s => s.Course).Include(s => s.GradeLetter).Include(s => s.RegisterStudent);
// return View(studentResults.ToList());
//report(studentResult);
StudentReport studentReport = new StudentReport();
var student = studentResult1(studentResult);
byte[] abytes = studentReport.PrePareReport(student, studentResult);
return(File(abytes, "application/pdf"));
// return View();
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var student = new StudentReport
{
Name = txtBoxName.Text,
LastName = txtBoxLastName.Text,
TestDate = datePicker.SelectedDate?.Date ?? DateTime.Now,
TestName = txtBoxTestName.Text,
Raiting = (int)comboBoxRaiting.SelectedValue
};
App.Manager.Add(student);
Close();
}
// GET: StudentReports/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentReport studentReport = _db.StudentReports.Find(id);
if (studentReport == null)
{
return(HttpNotFound());
}
return(View(studentReport));
}
public StudentReportViewModel MapSingleReport(StudentReport report)
{
ID = report.ID;
StudentId = report.StudentId;
Average = report.Average;
ReportYear = report.ReportYear;
ReportLevel = report.ReportLevel;
ReportPeriod = report.ReportPeriod;
ReportInstitution = report.ReportInstitution;
ReportFilePath = report.ReportFilePath;
Subjects = SubjectViewModel.ReverseMapSubjects((List <Subject>)report.Subjects);
return(this);
}
// GET: Attendance/Details/5
public async Task <ActionResult> Details(StudentReport data)
{
if (data == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
List <StudentReport> report = await _reportRepo.StudentReport(data);
if (report == null)
{
return(HttpNotFound());
}
return(View(report));
}
public ActionResult PrintStudent(int param)
{
List <Student> oStudentds = new List <Student>();
for (int i = 1; i <= 10; i++)
{
Student oStudent = new Student();
oStudent.Id = i;
oStudent.Name = "Student" + i;
oStudent.Address = "Address" + i;
oStudentds.Add(oStudent);
}
StudentReport rpt = new StudentReport(_oHostEnvironment);
return(File(rpt.Report(oStudentds), "application/pdf"));
}
public ActionResult Get()
{
List <Student> students = new List <Student>();
for (int i = 0; i < 100; i++)
{
Student student = new Student();
student.Id = i;
student.Name = "Student សិស្សសាលារៀន " + i;
student.Address = "Address អាសយដ្ឋាន " + i;
students.Add(student);
}
StudentReport rpt = new StudentReport(_webHostEnviroment);
return(File(rpt.Report(students), "application/pdf"));
}
public IActionResult PrintStudent(int param)
{
List <Student> students = new List <Student>();
for (int i = 1; i <= 9; i++)
{
students.Add(new Student()
{
StudentId = i,
Name = "Stu" + i,
Roll = "100" + i
});
}
StudentReport rpt = new StudentReport(_oHostEnvironment);
return(File(rpt.Report(students), "application/pdf"));
}
public static void RegistryFeature()
{
SemesterScoreReportNew semsScoreReport = new SemesterScoreReportNew();
string reportName = "學期成績單(新制)";
string path = "成績相關報表";
semsScoreReport.button = new SecureButtonAdapter("Report0055");
semsScoreReport.button.Text = reportName;
semsScoreReport.button.Path = path;
semsScoreReport.button.OnClick += new EventHandler(semsScoreReport.button_OnClick);
StudentReport.AddReport(semsScoreReport.button);
semsScoreReport.button2 = new SecureButtonAdapter("Report0155");
semsScoreReport.button2.Text = reportName;
semsScoreReport.button2.Path = path;
semsScoreReport.button2.OnClick += new EventHandler(semsScoreReport.button2_OnClick);
ClassReport.AddReport(semsScoreReport.button2);
}
public ActionResult Create([Bind(Include = "DocumentDate,Comments,Student,DocumentType,DocumentLink,PostedFile")] AddEditStudentReportViewModel model)
{
if (ModelState.IsValid)
{
StudentReport studentReport = new StudentReport
{
DocumentDate = model.DocumentDate,
Comments = model.Comments,
DocumentLink = Settings.Default.DocumentStoragePath + model.DocumentLink,
DocumentType = (from d in _db.DocumentTypes where d.Id == model.DocumentType.Id select d).Single(),
Student = (from s in _db.Students where s.Id == model.Student.Id select s).Single()
};
_db.StudentReports.Add(studentReport);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
public SemesterScoreReport()
{
string reportName = "學期成績單";
string path = "成績相關報表";
_ErrorMessage = new StringBuilder();
button = new SecureButtonAdapter("Report0050");
button.Text = reportName;
button.Path = path;
button.OnClick += new EventHandler(button_OnClick);
StudentReport.AddReport(button);
button2 = new SecureButtonAdapter("Report0150");
button2.Text = reportName;
button2.Path = path;
button2.OnClick += new EventHandler(button2_OnClick);
ClassReport.AddReport(button2);
}
public async Task <List <StudentReport> > StudentReport(StudentReport param)
{
string qry = @"select s.id as studentId, s.name as StudentName , s.RollNumber, s.AcademicYear, s.EnrollDate
, m.id as moduleId, m.Name as moduleName
, c.Id as courseId, c.Name as courseName
, sem.id as semesterId, sem.Name as semesterName
from student s
inner join StudentModuleMapping SMM ON SMM.StudentId = s.id
inner join module m on m.id = smm.id
inner join course c on c.Id = m.CourseId
inner join semester sem on sem.id = m.SemesterId
where m.courseId = case when @courseId <> -1 then @courseid else m.courseid end
order by EnrollDate asc" ;
List <SqlParam> collection = new List <SqlParam> {
new SqlParam("@courseId", SqlDbType.VarChar, param.CourseId)
};
return(await _dao.FetchListAsync <StudentReport>(qry, collection));
}
public List <StudentReport> GetFilteredStudent(StudentReport objSR)
{
List <SqlParameter> sqlParameterList = new List <SqlParameter>();
sqlParameterList.Add(new SqlParameter("@SessionID", !string.IsNullOrEmpty(objSR.SessionID)? objSR.SessionID:null));
sqlParameterList.Add(new SqlParameter("@StreamID", objSR.StreamID != null ? objSR.StreamID.Length > 0 ? string.Join(",", objSR.StreamID) : string.Empty : string.Empty));
sqlParameterList.Add(new SqlParameter("@CourseID", objSR.CourseID != null ? objSR.CourseID.Length > 0 ? string.Join(",", objSR.CourseID) : string.Empty : string.Empty));
sqlParameterList.Add(new SqlParameter("@BatchID", objSR.BatchID != null & objSR.CourseID != null ? objSR.BatchID.Length > 0 & objSR.CourseID.Length > 0 ? string.Join(",", objSR.BatchID) : string.Empty : string.Empty));
DataTable dt = DGeneric.RunSP_ReturnDataSet("sp_GetFilterStudent", sqlParameterList, null).Tables[0];
if (dt.Rows.Count > 0)
{
return(DGeneric.BindDataList <StudentReport>(dt));
}
else
{
return(new List <StudentReport>());
}
}
private void GetStudentDetailsByClassReport()
{
btnViewReport.Enabled = false;
lblPleaseWait.Visible = true;
try
{
_studentReport = new StudentReport();
short? classID = Convert.ToInt16(ddlClass.SelectedValue);
short? sectionID = Convert.ToInt16(ddlSection.SelectedValue) == 0 ? null : (short?)Convert.ToInt16(ddlSection.SelectedValue);
DataSet dsStudentReport = _studentReport.GetStudentDetailsByClass(classID, sectionID);
if (dsStudentReport != null && dsStudentReport.Tables[1].Rows.Count > 0)
{
dsStudentReport.Tables[0].TableName = "School";
dsStudentReport.Tables[1].TableName = "StudentDetailsByClassDT";
ReportDocument rdoc = new ReportDocument();
rdoc.Load(_appPath + "Reports\\StudentDetailsByClassReport.rpt");
rdoc.SetDataSource(dsStudentReport);
crystalReportViewer.ReportSource = rdoc;
rdoc.Refresh();
crystalReportViewer.Refresh();
crystalReportViewer.Show();
crystalReportViewer.Visible = true;
btnViewReport.Enabled = true;
lblPleaseWait.Visible = false;
}
else
{
crystalReportViewer.Visible = false;
MessageBox.Show("No Result Found.", "No Record Found", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnViewReport.Enabled = true;
lblPleaseWait.Visible = false;
}
}
catch (Exception ex)
{
}
}
public IEnumerable <StudentReport> getStudents()
{
var s = _ctx.StudentSlabs
.Include(a => a.Slab)
.Include(z => z.Student.CreatedBy)
.Include(a => a.Student).ThenInclude(i => i.StudentUser)
.ToList();
var studentList = new List <StudentReport>();
foreach (var student in s)
{
// mpsUser u = student.Student.StudentUser;
var studentVM = new StudentReport
{
isActive = student.Student.isActive,
StudentId = student.Student.StudentId,
Address1 = student.Student.StudentUser.Address1,
Address2 = student.Student.StudentUser.Address2,
FirstName = student.Student.StudentUser.FirstName,
MiddleName = student.Student.StudentUser.MiddleName,
LastName = student.Student.StudentUser.LastName,
DOB = student.Student.StudentUser.DOB,
Email = student.Student.StudentUser.Email,
UserName = student.Student.StudentUser.UserName,
TotalFees = student.Slab.TotalFee,
AdmissionDate = student.Student.AdmissionDate,
// TotalPaidFees = student.TotalPaidFees,
// PaidDate = student.PaidDate.Value.ToShortDateString(),
// FeesStartDate = student.FeesStartDate.ToShortDateString(),
// FeesEndDate = student.FeesEndDate.ToShortDateString(),
AcademicYear = student.AcademicYear,
SlabName = student.Slab.SlabName,
Grade = student.Slab.Grade,
Phone = student.Student.StudentUser.PhoneNumber,
StudentCreatedBy = student.CreatedBy.UserName
};
studentList.Add(studentVM);
}
return(studentList);
}
public ActionResult DeleteConfirmed(int id)
{
StudentReport studentReport = _db.StudentReports.Find(id);
if (studentReport != null)
{
_db.StudentReports.Remove(studentReport);
_db.SaveChanges();
CloudStorageAccount storageAccount =
CloudStorageAccount.Parse(Settings.Default.StorageConnectionString);
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();
CloudBlobContainer container = blobClient.GetContainerReference("studentreports");
CloudBlockBlob blob = container.GetBlockBlobReference(studentReport.DocumentLink);
if (blob.Exists())
{
blob.Delete();
}
}
return(RedirectToAction("Index"));
}
private void button2_Click(object sender, EventArgs e)
{
this.connetionString = "Data Source = whitesnow.database.windows.net; Initial Catalog = Mazal; Integrated Security = False; User ID = Grimm; Password = #!7Dwarfs; Connect Timeout = 15; Encrypt = False; TrustServerCertificate = True; ApplicationIntent = ReadWrite; MultiSubnetFailover = False";
this.sqlcon = new SqlConnection(connetionString);
try
{
SqlCommand cmd = new SqlCommand("select stud_Id, final_grade from Student_Courses where final_grade <= 56 and course_id='" + CourseID.Text + "'", sqlcon);
StudentReport.Visible = true;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bsource = new BindingSource();
//Paint headers
StudentReport.EnableHeadersVisualStyles = false;
StudentReport.GridColor = Utility.HeaderBackColor;
StudentReport.ColumnHeadersDefaultCellStyle.BackColor = Utility.HeaderBackColor;
StudentReport.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
StudentReport.AutoResizeColumns();
StudentReport.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
StudentReport.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
bsource.DataSource = dbdataset;
StudentReport.DataSource = bsource;
sda.Update(dbdataset);
}
catch (SqlException ex)
{
CourseID.Text = "";
MessageBox.Show("Error selecting course id, try again!!\n" + ex.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Response <List <StudentReport> > GetFilteredStudent(StudentReport objSR)
{
var studentData = _iDStudent.GetFilteredStudent(objSR);
if (studentData != null)
{
return(new Response <List <StudentReport> >
{
IsSuccessful = true,
Object = studentData,
Message = "Success"
});
}
else
{
return(new Response <List <StudentReport> >
{
IsSuccessful = false,
Message = "error",
Object = null
});
}
}
public async Task <List <AttendanceReport> > AttendanceReport(StudentReport param)
{
string qry = @"select s.id as StudentId, s.RollNumber as RollNumber, s.Name as StudentName
,sum(case when ad.[Status] = 'P' then 1 else 0 end) as PresentDays
,sum(case when ad.[Status] = 'L' then 1 else 0 end) as LateDays
,sum(case when ad.[Status] = 'A' then 1 else 0 end) as AbsentDays
from attendanceDetl ad
inner join attendanceMast am on ad.MastId = am.Id
inner join student s on ad.StudentId = s.Id
where am.AttendanceDate between @from_date and @to_date
and am.ModuleId = @moduleId
and s.Id = case when @studentId <> -1 then @studentId else s.Id end
group by s.id, s.RollNumber, s.Name" ;
List <SqlParam> collection = new List <SqlParam> {
new SqlParam("@from_date", SqlDbType.VarChar, param.FromDate),
new SqlParam("@to_date", SqlDbType.VarChar, param.ToDate),
new SqlParam("@moduleId", SqlDbType.VarChar, param.ModuleId),
new SqlParam("@studentId", SqlDbType.VarChar, param.StudentId),
};
return(await _dao.FetchListAsync <AttendanceReport>(qry, collection));
}
public MultiSemesterScore()
{
string report_name = "多學期成績單";
string report_path = "成績相關報表";
//_student_button = new ButtonAdapter();
//_student_button.Text = report_name;
//_student_button.Path = report_path;
//_student_button.OnClick += new EventHandler(studentButton_OnClick);
//StudentReport.AddReport(_student_button);
_class_button = new SecureButtonAdapter("Report0170");
_class_button.Text = report_name;
_class_button.Path = report_path;
_class_button.OnClick += new EventHandler(classButton_OnClick);
ClassReport.AddReport(_class_button);
ButtonAdapter _student_button = new SecureButtonAdapter("Report0060");
_student_button.Text = report_name;
_student_button.Path = report_path;
_student_button.OnClick += new EventHandler(_student_button_OnClick);
StudentReport.AddReport(_student_button);
}
internal IEnumerable<StudentReport> StudentReports()
{
var rv = new List<StudentReport>();
var gradesByQuarter = _studentRow.GetGradeRows().GroupBy(g => g.CourseRow.Quarter);
foreach (var kvp in gradesByQuarter)
{
var i = new StudentReport();
var mp = MarkingPeriods.Singleton.Find(MarkingPeriodKey.Parse(kvp.Key));
i.Quarter = mp.ToString();
i.NumberOfClasses = kvp.Count();
i.Gpa = Gpa(mp);
i.Stage = (ApprovalStage) kvp.Max(g => (int) Enum.Parse(typeof(ApprovalStage), g.ApprovalStage));
i.HonorRoll = HonorRoll(mp);
i.DaysAbsent = DaysAttendance(mp, AttendanceStatus.Absent);
i.DaysTardy = DaysAttendance(mp, AttendanceStatus.Tardy);
i.DaysPresent = mp.DaysIn - i.DaysAbsent - i.DaysTardy;
rv.Add(i);
}
return rv;
}
