public string GetEnablingConditionsInformationBySchoolID(int schoolID) { string results = string.Empty; JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository _repo = new SurveyRepository(); EnablingConditionModel enablingConditionsInformation = _repo.GetEnablingConditionsBySchoolID(schoolID); SchoolBuildingConditionModel buildingConditions = _repo.GetSchoolBuildingConditionBySchoolID(schoolID); IEnumerable <LTSMModel> noOfTextbooksList = _repo.GetLTSMBySchoolID(schoolID); var data = new { EnablingConditions = enablingConditionsInformation, BuildingConditions = buildingConditions, LTSM = noOfTextbooksList }; results = js.Serialize(new { Message = "Success", Data = data }); } catch (Exception ex) { results = js.Serialize(new { Message = string.Format("Error - {0}", ex.Message) }); } return(results); }
public static EnablingConditionModel Map(this EnablingCondition original) { if (original == null) { return(null); } var row = new EnablingConditionModel() { ID = original.ID, DoesTheSchoolHaveElectricity = original.DoesTheSchoolHaveElectricity, HasTheSchoolBeenProvidedWithElectricity = original.HasTheSchoolBeenProvidedWithElectricity, DoesTheSchoolHaveRunningWater = original.DoesTheSchoolHaveRunningWater, HasTheSchoolBeenProvidedWithWater = original.HasTheSchoolBeenProvidedWithWater, DoesTheSchoolExperienceWaterPressureIssuesRegularly = original.DoesTheSchoolExperienceWaterPressureIssuesRegularly, DoesTheSchoolHaveAdequateSanitationFacilities = original.DoesTheSchoolHaveAdequateSanitationFacilities, DoesTheSchoolHaveSecureFencing = original.DoesTheSchoolHaveSecureFencing, DidTheSchoolHaveSufficientClassrooms = original.DidTheSchoolHaveSufficientClassrooms, DidTheSchoolRequestAdditionalFurnitureFromTheGDE = original.DidTheSchoolRequestAdditionalFurnitureFromTheGDE, WasTheFurnitureDelivered = original.WasTheFurnitureDelivered, DidTheSchoolRequestAdditionalClassroomsFromTheGDE = original.DidTheSchoolRequestAdditionalClassroomsFromTheGDE, WereTheClassroomsDelivered = original.WereTheClassroomsDelivered, WasTheSchoolAffectedByIncidentsOfVandalism = original.WasTheSchoolAffectedByIncidentsOfVandalism, HowManyOccasionsWasTheSchoolAffectedByIncidentsOfVandalism = original.HowManyOccasionsWasTheSchoolAffectedByIncidentsOfVandalism, DoesTheSchoolHaveLearnersBenefittingFromTheGDELearnerTransportProgramme = original.DoesTheSchoolHaveLearnersBenefittingFromTheGDELearnerTransportProgramme, NoOfLearnersBenefittingFromTheGDELearnerTransportProgramme = original.NoOfLearnersBenefittingFromTheGDELearnerTransportProgramme, WereThereAnyChallengesExperiencedInTermsOfTheLearnerTransportProgrammeDuringTheLockdown = original.WereThereAnyChallengesExperiencedInTermsOfTheLearnerTransportProgrammeDuringTheLockdown, AreAllTheLearnersBeingTransportedAsExpected = original.AreAllTheLearnersBeingTransportedAsExpected, AreAllTheLearnersArrivingOnTime = original.AreAllTheLearnersArrivingOnTime, AreTheLearnersUsingHandSanitisersBeforeEnteringTheBuses = original.AreTheLearnersUsingHandSanitisersBeforeEnteringTheBuses, AreTheLearnersWearingMasksWhileOnTheBuses = original.AreTheLearnersWearingMasksWhileOnTheBuses, IsThePhysicalDistancingRequirementsBeingObservedOnTheBuses = original.IsThePhysicalDistancingRequirementsBeingObservedOnTheBuses, WereTheCovid19BrigadesAvailableToAssistOnTheLearnerTransportRoutes = original.WereTheCovid19BrigadesAvailableToAssistOnTheLearnerTransportRoutes, DoesTheSchoolHaveLearnersBenefittingFromNationalSchoolNutritionProgramme = original.DoesTheSchoolHaveLearnersBenefittingFromNationalSchoolNutritionProgramme, NoOfLearnersBenefittingFromNationalSchoolNutritionProgramme = original.NoOfLearnersBenefittingFromNationalSchoolNutritionProgramme, IsPhysicalDistancingBeingAppliedInTheFoodPreparationArea = original.IsPhysicalDistancingBeingAppliedInTheFoodPreparationArea, IsPhysicalDistancingBeingAppliedWhereLearnersAreBeingFed = original.IsPhysicalDistancingBeingAppliedWhereLearnersAreBeingFed, IsTheFoodPreparationAreaBeingCleanedRegularly = original.IsTheFoodPreparationAreaBeingCleanedRegularly, AreFeedingTimesAreBeingStaggered = original.AreFeedingTimesAreBeingStaggered, HaveTheFoodHandlersBeenTrainedOnCovid19Protocols = original.HaveTheFoodHandlersBeenTrainedOnCovid19Protocols, DoTheFoodHandlersHaveTheNecessaryPPEs = original.DoTheFoodHandlersHaveTheNecessaryPPEs, IsThereProperCleaningOfTheUtensilsTakingPlace = original.IsThereProperCleaningOfTheUtensilsTakingPlace, IsTheSchoolUsingDisposableUtensils = original.IsTheSchoolUsingDisposableUtensils, AreTheSchoolLearnersSharingUtensils = original.AreTheSchoolLearnersSharingUtensils, WereThereAnyChallengesExperiencedInTermsOfTheSchoolNutritionProgrammeDuringLockdown = original.WereThereAnyChallengesExperiencedInTermsOfTheSchoolNutritionProgrammeDuringLockdown, HowAreThoseLearnersThatAreOnRotatioBeingFed = original.HowAreThoseLearnersThatAreOnRotatioBeingFed, HowAreLearnersLearningFromHomeBeingFed = original.HowAreLearnersLearningFromHomeBeingFed, WereLearnersAllowedToTakeHomeTheirTextbooksDuringLockdown = original.WereLearnersAllowedToTakeHomeTheirTextbooksDuringLockdown, DoesTheSchoolHaveSufficientTextbooksForAllLearners = original.DoesTheSchoolHaveSufficientTextbooksForAllLearners, HasTheSchoolBeenAffectedByDisruptions = original.HasTheSchoolBeenAffectedByDisruptions, HasTheSchoolBeenForcedToClose = original.HasTheSchoolBeenForcedToClose, HowManyOccassionsWasTheSchoolForcedToClose = original.HowManyOccassionsWasTheSchoolForcedToClose, TotalNoOfSchoolDaysLostDueToClosure = original.TotalNoOfSchoolDaysLostDueToClosure, SchoolID = original.SchoolID, DateLogged = original.DateLogged, CausesOfDisruptionsOther = original.CausesOfDisruptionsOther }; return(row); }
public string SaveEnablingConditionsInformation(EnablingConditionModel enablingConditionsInformation, SchoolBuildingConditionModel buildingConditions, List <LTSMModel> noOfTextbooksList) { string results = string.Empty; List <string> resultList = new List <string>(); JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository repo = new SurveyRepository(); bool data = repo.SaveEnablingConditionsInformation(enablingConditionsInformation, buildingConditions, noOfTextbooksList); if (data) { resultList.Add("Success"); } else { resultList.Add("Error when saving Enabling Conditions Information"); } } catch (Exception ex) { resultList.Add(string.Format("Error - {0}", ex.Message)); } results = js.Serialize(resultList); return(results); }