public async Task <BarChartModel <double> > ByLunchStatus(EnrollmentFilterModel model) { var groupings = _attendanceFactService.BaseQuery(model) .GroupBy(x => new EnrollmentGroupByModel { Property = x.Demographic.FreeReducedLunchStatus, SortOrder = x.Demographic.FreeReducedLunchStatus }); return(await _attendanceFactService.CreateChart(groupings, "Lunch Status", "Lunch Statuses", "Free/Reduced Price Meals")); }
public async Task <BarChartModel <double> > ByEthnicity(EnrollmentFilterModel model) { var groupings = _attendanceFactService.BaseQuery(model) .GroupBy(x => new EnrollmentGroupByModel { Property = x.Demographic.Ethnicity, SortOrder = x.Demographic.Ethnicity }); return(await _attendanceFactService.CreateChart(groupings, "Ethnicity", "Ethncities", "Ethnicity")); }
public async Task <BarChartModel <double> > BySpecialEducationStatus(EnrollmentFilterModel model) { var groupings = _attendanceFactService.BaseQuery(model) .GroupBy(x => new EnrollmentGroupByModel { Property = x.Demographic.SpecialEducationStatus, SortOrder = x.Demographic.SpecialEducationStatus, }); return(await _attendanceFactService.CreateChart(groupings, "Special Education Status", "Special Education Statuses", "Special Education")); }
public async Task <BarChartModel <double> > ByEnglishLanguageLearnerStatus(EnrollmentFilterModel model) { var groupings = _attendanceFactService.BaseQuery(model) .GroupBy(x => new EnrollmentGroupByModel { Property = x.Demographic.EnglishLanguageLearnerStatus, SortOrder = x.Demographic.EnglishLanguageLearnerStatus }); return(await _attendanceFactService.CreateChart(groupings, "English Language Learner Status", "English Language Leaner Statuses", "English Language Learner")); }
public IQueryable <AttendanceFact> BaseQuery(EnrollmentFilterModel model) { var query = _attendanceRepository .GetAll() .AsQueryable(); if (model.SchoolYear > 0) { query = query.Where(x => x.SchoolYearKey == model.SchoolYear); } if (model.SchoolYears != null && model.SchoolYears.Any()) { query = query.Where(x => model.SchoolYears.Contains(x.SchoolYearKey)); } if (model.Schools != null && model.Schools.Any()) { query = query.Where(x => model.Schools.Contains(x.SchoolKey)); } if (model.Districts != null && model.Districts.Any()) { query = query.Where(x => model.Districts.Contains(x.School.LocalEducationAgencyKey)); } if (model.EnglishLanguageLearnerStatuses != null && model.EnglishLanguageLearnerStatuses.Any()) { query = query.Where(x => model.EnglishLanguageLearnerStatuses.Contains(x.Demographic.EnglishLanguageLearnerStatus)); } if (model.Ethnicities != null && model.Ethnicities.Any()) { query = query.Where(x => model.Ethnicities.Contains(x.Demographic.Ethnicity)); } if (model.Grades != null && model.Grades.Any()) { query = query.Where(x => model.Grades.Contains(x.Demographic.GradeLevel)); } if (model.LunchStatuses != null && model.LunchStatuses.Any()) { query = query.Where(x => model.LunchStatuses.Contains(x.Demographic.FreeReducedLunchStatus)); } if (model.SpecialEducationStatuses != null && model.SpecialEducationStatuses.Any()) { query = query.Where(x => model.SpecialEducationStatuses.Contains(x.Demographic.SpecialEducationStatus)); } return(query); }
public async Task <LineChartModel <double> > ByLunchStatus(EnrollmentFilterModel model) { var groupings = _attendanceFactService.BaseQuery(model) .GroupBy(x => new EnrollmentTrendGroupByModel { SchoolYear = x.SchoolYearKey, SchoolYearDescription = x.SchoolYearDimension.SchoolYearDescription, Property = x.Demographic.FreeReducedLunchStatus, SortOrder = x.Demographic.FreeReducedLunchStatus }); return(await _attendanceFactService.CreateTrendChart(groupings, "Lunch Statuses", "Free/Reduced Price Meals")); }
public async Task <BarChartModel <int> > ByEthnicity(EnrollmentFilterModel model) { var groupings = _enrollmentFactService.BaseQuery(model) .GroupBy(x => new EnrollmentTrendGroupByModel { SchoolYear = x.SchoolYearKey, SchoolYearDescription = x.SchoolYearDimension.SchoolYearDescription, Property = x.Demographic.Ethnicity, SortOrder = x.Demographic.Ethnicity }); return(await _enrollmentFactService.CreateTrendChart(groupings, "Ethncities", "Ethnicity")); }
public async Task <BarChartModel <int> > BySpecialEducationStatus(EnrollmentFilterModel model) { var groupings = _enrollmentFactService.BaseQuery(model) .GroupBy(x => new EnrollmentTrendGroupByModel { SchoolYear = x.SchoolYearKey, SchoolYearDescription = x.SchoolYearDimension.SchoolYearDescription, Property = x.Demographic.SpecialEducationStatus, SortOrder = x.Demographic.SpecialEducationStatus }); return(await _enrollmentFactService.CreateTrendChart(groupings, "Special Education Statuses", "Special Education")); }
public async Task <LineChartModel <double> > ByEnglishLanguageLearnerStatus(EnrollmentFilterModel model) { var groupings = _attendanceFactService.BaseQuery(model) .GroupBy(x => new EnrollmentTrendGroupByModel { SchoolYear = x.SchoolYearKey, SchoolYearDescription = x.SchoolYearDimension.SchoolYearDescription, Property = x.Demographic.EnglishLanguageLearnerStatus, SortOrder = x.Demographic.EnglishLanguageLearnerStatus }); return(await _attendanceFactService.CreateTrendChart(groupings, "English Language Learner Statuses", "English Language Learner")); }
public async Task <PieChartModel <int> > ByGrade(EnrollmentFilterModel model) { var groupings = _enrollmentFactService.BaseQuery(model) .GroupBy(x => new EnrollmentGroupByModel { Property = x.Demographic.GradeLevel, SortOrder = x.Demographic.GradeLevelSort }); var chart = await _enrollmentFactService.CreateChart(groupings, "Grade", "Grade"); chart.ShowChart = false; // Show Table First return(chart); }
public async Task <BarChartModel <double> > ByGrade(EnrollmentFilterModel model) { var groupings = _attendanceFactService.BaseQuery(model) .GroupBy(x => new EnrollmentGroupByModel { Property = x.Demographic.GradeLevel, SortOrder = x.Demographic.GradeLevelSort }); var chart = await _attendanceFactService.CreateChart(groupings, "Grade", "Grades", "Grade"); chart.ShowChart = false; return(chart); }
public async Task <BarChartModel <int> > ByGrade(EnrollmentFilterModel model) { var groupings = _enrollmentFactService.BaseQuery(model) .GroupBy(x => new EnrollmentTrendGroupByModel { SchoolYear = x.SchoolYearKey, SchoolYearDescription = x.SchoolYearDimension.SchoolYearDescription, Property = x.Demographic.GradeLevel, SortOrder = x.Demographic.GradeLevelSort }); var chart = await _enrollmentFactService.CreateTrendChart(groupings, "Grades", "Grade"); chart.ShowChart = false; // Show Table First return(chart); }
public async Task <IHttpActionResult> BySpecialEducationStatus(EnrollmentFilterModel model) { var chart = await _enrollmentService.BySpecialEducationStatus(model); return(Ok(chart)); }
public async Task <IHttpActionResult> ByGrade(EnrollmentFilterModel model) { var chart = await _enrollmentService.ByGrade(model); return(Ok(chart)); }
public async Task <IHttpActionResult> ByEnglishLanguageLearnerStatus(EnrollmentFilterModel model) { var chart = await _enrollmentService.ByEnglishLanguageLearnerStatus(model); return(Ok(chart)); }
public async Task <IHttpActionResult> ByEthnicity(EnrollmentFilterModel model) { var chart = await _attendanceService.ByEthnicity(model); return(Ok(chart)); }
public async Task <IHttpActionResult> ByLunchStatus(EnrollmentFilterModel model) { var chart = await _attendanceTrendsService.ByLunchStatus(model); return(Ok(chart)); }