public void ShouldRetrieveSchoolCount() { var elementarySchoolCategoryDescriptorId = GetNewSchoolCategoryDescriptorId("Elementary School"); var highSchoolCategoryDescriptorId = GetNewSchoolCategoryDescriptorId("High School"); var middleSchoolCategoryDescriptorId = GetNewSchoolCategoryDescriptorId("Middle School"); var localEducationAgencyId = GetNewLocalEducationAgencyId(); var newHighSchoolId = GetNewSchool(localEducationAgencyId); SetSchoolCategoryDescriptor(newHighSchoolId, highSchoolCategoryDescriptorId); var newMiddleSchoolId1 = GetNewSchool(localEducationAgencyId); var newMiddleSchoolId2 = GetNewSchool(localEducationAgencyId); SetSchoolCategoryDescriptor(newMiddleSchoolId1, middleSchoolCategoryDescriptorId); SetSchoolCategoryDescriptor(newMiddleSchoolId2, middleSchoolCategoryDescriptorId); var newElementarySchoolId1 = GetNewSchool(localEducationAgencyId); var newElementarySchoolId2 = GetNewSchool(localEducationAgencyId); var newElementarySchoolId3 = GetNewSchool(localEducationAgencyId); SetSchoolCategoryDescriptor(newElementarySchoolId1, elementarySchoolCategoryDescriptorId); SetSchoolCategoryDescriptor(newElementarySchoolId2, elementarySchoolCategoryDescriptorId); SetSchoolCategoryDescriptor(newElementarySchoolId3, elementarySchoolCategoryDescriptorId); var otherLocalAgencyId = GetNewLocalEducationAgencyId(); var otherHighSchoolId = GetNewSchool(otherLocalAgencyId); var otherMiddleSchoolId = GetNewSchool(otherLocalAgencyId); var otherElementarySchoolId = GetNewSchool(otherLocalAgencyId); SetSchoolCategoryDescriptor(otherHighSchoolId, highSchoolCategoryDescriptorId); SetSchoolCategoryDescriptor(otherMiddleSchoolId, middleSchoolCategoryDescriptorId); SetSchoolCategoryDescriptor(otherElementarySchoolId, elementarySchoolCategoryDescriptorId); var report = new GetSchoolsBySchoolTypeQuery(TestConnectionProvider); var result = report.Execute(CloudOdsDatabaseNames.ProductionOds, ApiMode.Sandbox, localEducationAgencyId); result.SchoolCounts.Count.ShouldBe(3); result.SchoolCounts.Single(c => c.Description == "High School").Count.ShouldBe(1); result.SchoolCounts.Single(c => c.Description == "Middle School").Count.ShouldBe(2); result.SchoolCounts.Single(c => c.Description == "Elementary School").Count.ShouldBe(3); }
public ReportsController(GetAllLocalEducationAgenciesQuery getAllLocalEducationAgenciesQuery , StudentsByProgramQuery studentsByProgramQuery , StudentEconomicSituationReportQuery studentEconomicSituationReportQuery , TotalEnrollmentQuery totalEnrollmentQuery , GetSchoolsBySchoolTypeQuery getSchoolsBySchoolTypeQuery , StudentEnrollmentByGenderQuery studentEnrollmentByGenderQuery , StudentEnrollmentByRaceQuery studentEnrollmentByRaceQuery , StudentEnrollmentByEthnicityQuery studentEnrollmentByEthnicityQuery , InstanceContext instanceContext) { _getAllLocalEducationAgenciesQuery = getAllLocalEducationAgenciesQuery; _studentsByProgramQuery = studentsByProgramQuery; _studentEconomicSituationReportQuery = studentEconomicSituationReportQuery; _totalEnrollmentQuery = totalEnrollmentQuery; _getSchoolsBySchoolTypeQuery = getSchoolsBySchoolTypeQuery; _studentEnrollmentByGenderQuery = studentEnrollmentByGenderQuery; _studentEnrollmentByRaceQuery = studentEnrollmentByRaceQuery; _studentEnrollmentByEthnicityQuery = studentEnrollmentByEthnicityQuery; _instanceContext = instanceContext; }