public async Task <IActionResult> UploadAll([FromBody] UploadForm1Info info) { try { var items = info.Items; foreach (var item in items) { var frm = await _appDbContext.TCL_NEPIs.FirstOrDefaultAsync(p => p.TCL_NEPIId == item.TCL_NEPIId); if (frm == null) { if (item.LastUploaded == null) { item.LastUploaded = DateTime.UtcNow; } _appDbContext.Add(item); } else { frm.Barangay = item.Barangay; frm.Municipality = item.Municipality; frm.Province = item.Province; frm.Region = item.Region; frm.LastUploaded = DateTime.UtcNow; } foreach (var entry in item.Entries) { var foo = await _appDbContext.TCL_NEPI_Entries.FirstOrDefaultAsync(p => p.TCL_NEPI_EntryId == entry.TCL_NEPI_EntryId); if (foo == null) { _appDbContext.Add(entry); } else { foo.Address = entry.Address; foo.BCG = entry.BCG; foo.ChildExclusiveBreastFeed1 = entry.ChildExclusiveBreastFeed1; foo.ChildExclusiveBreastFeed2 = entry.ChildExclusiveBreastFeed2; foo.ChildExclusiveBreastFeed3 = entry.ChildExclusiveBreastFeed3; foo.ChildExclusiveBreastFeed4 = entry.ChildExclusiveBreastFeed4; foo.ChildExclusiveBreastFeed5 = entry.ChildExclusiveBreastFeed5; foo.ChildExclusiveBreastFeed6 = entry.ChildExclusiveBreastFeed6; foo.ComplimentaryFeeding6 = entry.ComplimentaryFeeding6; foo.ComplimentaryFeeding7 = entry.ComplimentaryFeeding7; foo.ComplimentaryFeeding8 = entry.ComplimentaryFeeding8; foo.CPABTTAssessed = entry.CPABTTAssessed; foo.CPABTTStatus = entry.CPABTTStatus; foo.DateFullyImmunizedChild = entry.DateFullyImmunizedChild; foo.DateNewbornScreeningDone = entry.DateNewbornScreeningDone; foo.DateNewbornScreeningReferral = entry.DateNewbornScreeningReferral; foo.DateOfBirth = entry.DateOfBirth; foo.DateOfRegistration = entry.DateOfRegistration; foo.Deworming = entry.Deworming; foo.FamilySerialNumber = entry.FamilySerialNumber; foo.Gender = entry.Gender; foo.Height = entry.Height; foo.HepaB1MoreThan24hrs = entry.HepaB1MoreThan24hrs; foo.HepaB1Within24hrs = entry.HepaB1Within24hrs; foo.IPV = entry.IPV; foo.IronA1 = entry.IronA1; foo.IronA2 = entry.IronA2; foo.MCV1 = entry.MCV1; foo.MCV2 = entry.MCV2; foo.MNP1 = entry.MNP1; foo.MNP2 = entry.MNP2; foo.NameOfChild = entry.NameOfChild; foo.NameOfMother = entry.NameOfMother; foo.NHTS = entry.NHTS; foo.OPV1 = entry.OPV1; foo.OPV2 = entry.OPV2; foo.OPV3 = entry.OPV3; foo.PCV1 = entry.PCV1; foo.PCV2 = entry.PCV2; foo.PCV3 = entry.PCV3; foo.Pentavalent1 = entry.Pentavalent1; foo.Pentavalent2 = entry.Pentavalent2; foo.Pentavalent3 = entry.Pentavalent3; foo.Remarks = entry.Remarks; foo.RotaVirusVaccine1 = entry.RotaVirusVaccine1; foo.RotaVirusVaccine2 = entry.RotaVirusVaccine2; foo.VitaminA1 = entry.VitaminA1; foo.VitaminA2 = entry.VitaminA2; foo.VitaminA3 = entry.VitaminA3; foo.Weight = entry.Weight; } } } await _appDbContext.SaveChangesAsync(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.ToString())); } }
public async Task <IActionResult> UploadAll([FromBody] UploadForm1Info info) { try { var items = info.Items; foreach (var item in items) { var frm = await _appDbContext.TCL_PNCs.FirstOrDefaultAsync(p => p.TCL_PNCId == item.TCL_PNCId); if (frm == null) { if (item.LastUploaded == null) { item.LastUploaded = DateTime.UtcNow; } _appDbContext.Add(item); } else { frm.Barangay = item.Barangay; frm.Municipality = item.Municipality; frm.Province = item.Province; frm.Region = item.Region; frm.LastUploaded = DateTime.UtcNow; } foreach (var entry in item.Entries) { var foo = await _appDbContext.TCL_PNC_Entries.FirstOrDefaultAsync(p => p.TCL_PNC_EntryId == entry.TCL_PNC_EntryId); if (foo == null) { _appDbContext.Add(entry); } else { foo.DateOfRegistration = entry.DateOfRegistration; foo.FamilySerialNumber = entry.FamilySerialNumber; foo.Name = entry.Name; foo.Address = entry.Address; foo.Age = entry.Age; foo.LMPDate = entry.LMPDate; foo.LMPGP = entry.LMPGP; foo.EDC = entry.EDC; foo.PrenatalVisitTrimester1 = entry.PrenatalVisitTrimester1; foo.PrenatalVisitTrimester2 = entry.PrenatalVisitTrimester2; foo.PrenatalVisitTrimester3 = entry.PrenatalVisitTrimester3; foo.TetanusStatus = entry.TetanusStatus; foo.DateTetanusToxiodVaccine1 = entry.DateTetanusToxiodVaccine1; foo.DateTetanusToxiodVaccine2 = entry.DateTetanusToxiodVaccine2; foo.DateTetanusToxiodVaccine3 = entry.DateTetanusToxiodVaccine3; foo.DateTetanusToxiodVaccine4 = entry.DateTetanusToxiodVaccine4; foo.DateTetanusToxiodVaccine5 = entry.DateTetanusToxiodVaccine5; foo.IronWithFolicDateGiven1 = entry.IronWithFolicDateGiven1; foo.IronWithFolicNumberGiven1 = entry.IronWithFolicNumberGiven1; foo.IronWithFolicDateGiven2 = entry.IronWithFolicDateGiven2; foo.IronWithFolicNumberGiven2 = entry.IronWithFolicNumberGiven2; foo.IronWithFolicDateGiven3 = entry.IronWithFolicDateGiven3; foo.IronWithFolicNumberGiven3 = entry.IronWithFolicNumberGiven3; foo.IronWithFolicDateGiven4 = entry.IronWithFolicDateGiven4; foo.IronWithFolicNumberGiven4 = entry.IronWithFolicNumberGiven4; foo.IronWithFolicDateGiven5 = entry.IronWithFolicDateGiven5; foo.IronWithFolicNumberGiven5 = entry.IronWithFolicNumberGiven5; foo.IronWithFolicDateGiven6 = entry.IronWithFolicDateGiven6; foo.IronWithFolicNumberGiven6 = entry.IronWithFolicNumberGiven6; foo.DateSTITested = entry.DateSTITested; foo.DateSTIResult = entry.DateSTIResult; foo.DateSTIPenicillin = entry.DateSTIPenicillin; foo.PregnancyDateTerminated = entry.PregnancyDateTerminated; foo.PregnancyOutcome = entry.PregnancyOutcome; foo.PregnancyGender = entry.PregnancyGender; foo.BirthWeight = entry.BirthWeight; foo.PlaceOfHealthFacility = entry.PlaceOfHealthFacility; foo.PlaceOfNIO = entry.PlaceOfNIO; foo.AttendedBy = entry.AttendedBy; foo.Remarks = entry.Remarks; } } } await _appDbContext.SaveChangesAsync(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.ToString())); } }
public async Task <IActionResult> UploadAll([FromBody] UploadForm1Info info) { try { var items = info.Items; foreach (var item in items) { var frm = await _appDbContext.TCL_FPs.FirstOrDefaultAsync(p => p.TCL_FPId == item.TCL_FPId); if (frm == null) { if (item.LastUploaded == null) { item.LastUploaded = DateTime.UtcNow; } _appDbContext.Add(item); } else { frm.Barangay = item.Barangay; frm.Municipality = item.Municipality; frm.Province = item.Province; frm.Region = item.Region; frm.LastUploaded = DateTime.UtcNow; } foreach (var entry in item.Entries) { var foo = await _appDbContext.TCL_FP_Entries.FirstOrDefaultAsync(p => p.TCL_FP_EntryId == entry.TCL_FP_EntryId); if (foo == null) { _appDbContext.Add(entry); } else { foo.DateOfRegistration = entry.DateOfRegistration; foo.FamilySerialNumber = entry.FamilySerialNumber; foo.Name = entry.Name; foo.Address = entry.Address; foo.BirthDate = entry.BirthDate; foo.TypeOfClient = entry.TypeOfClient; foo.PresentMethod = entry.PresentMethod; foo.PreviousMethod = entry.PreviousMethod; foo.DateNextService1 = entry.DateNextService1; foo.DateAccomplishedService1 = entry.DateAccomplishedService1; foo.DateNextService2 = entry.DateNextService2; foo.DateAccomplishedService2 = entry.DateAccomplishedService2; foo.DateNextService3 = entry.DateNextService3; foo.DateAccomplishedService3 = entry.DateAccomplishedService3; foo.DateNextService4 = entry.DateNextService4; foo.DateAccomplishedService4 = entry.DateAccomplishedService4; foo.DateNextService5 = entry.DateNextService5; foo.DateAccomplishedService5 = entry.DateAccomplishedService5; foo.DateNextService6 = entry.DateNextService6; foo.DateAccomplishedService6 = entry.DateAccomplishedService6; foo.DateNextService7 = entry.DateNextService7; foo.DateAccomplishedService7 = entry.DateAccomplishedService7; foo.DateNextService8 = entry.DateNextService8; foo.DateAccomplishedService8 = entry.DateAccomplishedService8; foo.DateNextService9 = entry.DateNextService9; foo.DateAccomplishedService9 = entry.DateAccomplishedService9; foo.DateNextService10 = entry.DateNextService10; foo.DateAccomplishedService10 = entry.DateAccomplishedService10; foo.DateNextService11 = entry.DateNextService11; foo.DateAccomplishedService11 = entry.DateAccomplishedService11; foo.DateNextService12 = entry.DateNextService12; foo.DateAccomplishedService12 = entry.DateAccomplishedService12; foo.DropoutDate = entry.DropoutDate; foo.DropoutReason = entry.DropoutReason; foo.Remarks = entry.Remarks; } } } await _appDbContext.SaveChangesAsync(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.ToString())); } }