public ActionResult Generate() { try { DistributedInformationSystems.Business.SchoolYear pSchYr = new Business.SchoolYear(); List <Models.SchoolYear> AvailableSchoolYears = pSchYr.GetSchoolYears(); foreach (Models.SchoolYear pSchoolYr in AvailableSchoolYears) { DistributedInformationSystems.Business.StudentComposition vStudentComposition = new Business.StudentComposition(); DistributedInformationSystems.Models.results pResults = vStudentComposition.GetStudentCompostionByYearFromApi(pSchoolYr); var studentComposition = new StudetnCompositionByYear { Asian = 100 * Convert.ToDecimal(pResults.asian), AfricanAmerican = 100 * Convert.ToDecimal(pResults.black), Hispanic = 100 * Convert.ToDecimal(pResults.hispanic), NonHispanic = 100 * Convert.ToDecimal(pResults.nhpi), White = 100 * Convert.ToDecimal(pResults.white), Unknown = 100 * Convert.ToDecimal(pResults.unknown), MultiRacial = 100 * Convert.ToDecimal(pResults.two_or_more), Hawaiian = 100 * 0, SchoolYearId = pSchoolYr.Id, SchoolName = "University of South Florida (Main Campus)" }; Business.StudentComposition pStuComposition = new Business.StudentComposition(); pStuComposition.AddStudentCompositionToDb(studentComposition); } return(RedirectToAction("History")); } catch (Exception ex) { throw ex; } }
public void AddStudentCompositionToDb(StudetnCompositionByYear pStudentCompostion) { _enrollmentsdb.StudetnCompositionByYears.Add(pStudentCompostion); _enrollmentsdb.SaveChanges(); }