public JsonResult GroupByNumberOfStudentsReceivedGradesInSubjectAndyearBtwn(int yearStart, int yearEnd, int subjectId, string studentRole)
{
ReportingGroupSubmission[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.GroupByNumberOfStudentsReceivedGradesInSubjectAndyearBtwn(yearStart, yearEnd, subjectId, studentRole);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public JsonResult ReportingGroupSubmission()
{
ReportingGroupSubmission[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.GroupSubmissionsBySubjectRoleAndYear();
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public JsonResult NumberOfStudentsGradedInSubjectAndyearBtwnYearsAcrossSubjectContains(int yearStart, int yearEnd, string subject)
{
if (string.IsNullOrEmpty(subject))
{
return(null);
}
ReportingGroupSubmission[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.NumberOfStudentsGradedInSubjectAndyearBtwnYearsAcrossSubjectContains(yearStart, yearEnd, subject);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public JsonResult NumberOfStudentsGradedInSubjectAndyearBtwnYears(int yearStart, int yearEnd, int subjectId)
{
ReportingGroupSubmission[] reportSubmissions = null;
if (subjectId < 1)
{
return(null);
}
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.NumberOfStudentsGradedInSubjectAndyearBtwnYears(yearStart, yearEnd, subjectId);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public JsonResult AverageAndMedianGradeAttainedBySubjectAcrossAllRolesAndyearBtwnYearsAcrossSubjectContains(int yearStart, int yearEnd, string subject, string studentRole = "")
{
if (string.IsNullOrEmpty(subject))
{
return(null);
}
AverageMedianAttainedGrade[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.AverageAndMedianGradeAttainedBySubjectAcrossAllRolesAndyearBtwnYearsAcrossSubjectContains(yearStart, yearEnd, subject, studentRole);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public JsonResult MedianGradeAttainedGroupedByGradeAndSubjectAcrossAllRolesAndyearBtwnYears(int yearStart, int yearEnd, int subjectId)
{
if (subjectId < 1)
{
return(null);
}
MedianGradeAttainedGrade[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.MedianGradeAttainedGroupedByGradeAndSubjectAcrossAllRolesAndyearBtwnYears(yearStart, yearEnd, subjectId);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public JsonResult MedianGradeAttainedGradeBySubjectRoleAndYearForParticualarSubjectBtwnYearsAcrossSubjectContains(int yearStart, int yearEnd, string subject, string studentRole)
{
if (string.IsNullOrEmpty(studentRole) || string.IsNullOrEmpty(subject))
{
return(null);
}
MedianGradeAttainedGrade[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.MedianGradeAttainedGradeBySubjectRoleAndYearForParticualarSubjectBtwnYearsAcrossSubject(yearStart, yearEnd, subject, studentRole);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public JsonResult AverageGradeBySubjectRoleAndYearForParticualarSubjectBtwnYears(int yearStart, int yearEnd, int subjectId, string studentRole)
{
if (string.IsNullOrEmpty(studentRole) || subjectId < 1)
{
return(null);
}
AverageGradeSubjectYear[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.AverageGradeBySubjectRoleAndYearForParticualarSubjectBtwnYears(yearStart, yearEnd, subjectId, studentRole);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public FileResult ReportAverageAndMedianGradeAttainedBySubjectAcrossAllRolesAndyearBtwnYearsAcrossSubjectContains(int yearStart, int yearEnd, string subject, string studentRole = "")
{
if (string.IsNullOrEmpty(subject))
{
return(null);
}
AverageMedianAttainedGrade[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.AverageAndMedianGradeAttainedBySubjectAcrossAllRolesAndyearBtwnYearsAcrossSubject(yearStart, yearEnd, subject, studentRole);
}
var fileName = string.Format("MedaianGrades_{0}_{1}_{2}.xlsx", yearStart, yearEnd, DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
return(File(ReportingFacilities.ReportAverageAndMedianGradeAttainedBySubjectAcrossAllRolesAndyearBtwnYears(fileName, reportSubmissions), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public FileResult ReportMedianGradeAttainedGradeBySubjectAcrossAllRolesAndYearForParticualarSubjectBtwnYears(int yearStart, int yearEnd, int subjectId)
{
if (subjectId < 1)
{
return(null);
}
MedianGradeAttainedGrade[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.MedianGradeAttainedGroupedByGradeAndSubjectAcrossAllRolesAndyearBtwnYears(yearStart, yearEnd, subjectId);
}
var fileName = string.Format("MedaianGrades_{0}_{1}_{2}.xlsx", yearStart, yearEnd, DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
return(File(ReportingFacilities.ReportMedianGradeAttainedGradeBySubjectRoleAndYearAcrossAllRoles(fileName, reportSubmissions), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public JsonResult GroupSubmissionsBySubjectRoleAndYearBtwnYears(int yearStart, int yearEnd, string studentRole)
{
if (string.IsNullOrEmpty(studentRole))
{
return(null);
}
ReportingGroupSubmission[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.GroupSubmissionsBySubjectRoleAndYearBtwnYears(yearStart, yearEnd, studentRole);
}
return(Json(reportSubmissions, JsonRequestBehavior.AllowGet));
}
public FileResult ReportsAverageGradeBySubjectRoleAndYearForParticualarSubjectBtwnYears(int yearStart, int yearEnd, int subjectId, string studentRole)
{
if (string.IsNullOrEmpty(studentRole) || subjectId < 1)
{
return(null);
}
AverageGradeSubjectYear[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.AverageGradeBySubjectRoleAndYearForParticualarSubjectBtwnYears(yearStart, yearEnd, subjectId, studentRole);
}
var fileName = string.Format("AverageGrades_{0}_{1}_{2}.xlsx", yearStart, yearEnd, DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
return(File(ReportingFacilities.ReportAverageGradeAttainedGradeBySubjectRoleAndYear(fileName, reportSubmissions), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public FileResult ReportGroupByNumberOfStudentsReceivedGradesInSubjectAndyearBtwnAcrossSubjectContains(int yearStart, int yearEnd, string subject, string studentRole)
{
if (string.IsNullOrEmpty(studentRole) || string.IsNullOrEmpty(subject))
{
return(null);
}
ReportingGroupSubmission[] reportSubmissions = null;
using (var dbContext = new TeachersAssistantDbContext())
{
adhocPatchAndReportingRepository.DbContextTeachersAssistant = dbContext;
reportSubmissions = adhocPatchAndReportingRepository.GroupByNumberOfStudentsReceivedGradesInSubjectAndyearBtwnAcrossSubject(yearStart, yearEnd, subject, studentRole);
}
var fileName = string.Format("NumberOfStudentsGroupReceivedGrades_{0}_{1}_{2}.xlsx", yearStart, yearEnd, DateTime.Now.ToString("dd-MM-yyyy HH:mm"));
return(File(ReportingFacilities.ReportNumberOfStudentsReceivedGradeBySubjectRoleAndYear(fileName, reportSubmissions), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
