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));
}
