public async Task <GridResponse> GetGridData(GridRequest request, IPrincipal currentUser) { // Gets a list of all the last versions of the student extra hours. var query = _db.StudentExtraHourGrid; var securedQuery = _auth.ApplySecurity(query, query, currentUser); var gridMetadata = request.ProcessMetadata(new StudentExtraHourGrid()); return(await securedQuery.ExecuteGridQuery(gridMetadata, request.AllData)); }
public async Task <GridResponse> GetGridData(GridRequest request, IPrincipal currentUser) { var query = _db.StudentAttendanceDetail; var securedQuery = _auth.ApplySecurity(query, query, currentUser); var gridMetadata = request.ProcessMetadata(new StudentAttendanceDetail()); return(await securedQuery.ExecuteGridQuery(gridMetadata, true)); }
public async Task <GridResponse> GetGridData(GridRequest request, IPrincipal currentUser) { var query = _db.StudentCourseTranscript; var securedQuery = _auth.ApplySecurity(query, query, currentUser); var gridMetadata = request.ProcessMetadata(new StudentCourseTranscript()); return(await securedQuery.ExecuteGridQuery(gridMetadata, request.AllData)); }
public async Task <GridResponse> GetGridData(GridRequest request, IPrincipal currentUser) { var query = _db.StudentAbsencesByCourse; var securedQuery = _auth.ApplySecurity(query, query, currentUser); var gridMetadata = request.ProcessMetadata(new StudentAbsencesByCourse()); return(await securedQuery.OrderBy(x => x.ClassPeriodName).ExecuteGridQuery(gridMetadata, request.AllData)); }
public async Task <IEnumerable <object> > GetGridFilter(IPrincipal currentUser) { var query = _db.Schools; return(_auth.ApplySecurity(query, query, currentUser).ToList().GroupBy(x => new { x.SchoolId, x.LocalEducationAgencyId, x.NameOfInstitution }).Select(x => new { x.Key.SchoolId, x.Key.LocalEducationAgencyId, x.Key.NameOfInstitution, ChildOptions = x.Select(g => new { Id = g.GradeLevel, Value = g.GradeLevel }) // For GradeLevel Filter })); }