public JsonResult AssignFinalResult_Total( int?SPinstitutionId, int?PRecordId, int?PYear, int PCountry ) { //IEnumerable<FluCase> flucases; IQueryable <FluCase> flucases = null; var InstitutionDB = SPinstitutionId; var RecordDB = PRecordId; var YearDB = PYear; var CountryDB = PCountry; var user = UserManager.FindById(User.Identity.GetUserId()); var UsrCtry = user.Institution.CountryID; var UsrAccessLevel = user.Institution.AccessLevel; var UsrRegion = user.Institution.cod_region_institucional; var UsrArea = user.Institution.AreaID; var UsrInstitution = user.Institution.ID; string language = user.Institution.Country.Language.ToString(); flucases = db.FluCases.Where(f => f.CountryID == CountryDB); if (RecordDB != null && RecordDB > 0) { flucases = flucases.Where(x => x.ID == RecordDB); } if (YearDB != null && YearDB > 0) { flucases = flucases.Where(y => y.HospitalDate.Year == YearDB); } if (InstitutionDB != null && InstitutionDB > 0) { flucases = flucases.Where(x => x.HospitalID == InstitutionDB); } // prueba //flucases = flucases.Where(z => z.ID == 96097); var toArrayClone = flucases.ToArray(); foreach (FluCase Record_ in toArrayClone) { var List_Test = Record_.CaseLabTests.OfType <CaseLabTest>() .Where(z => z.TestResultID_VirusSubType == Convert.ToString('P') || z.TestResultID_VirusSubType == null || z.TestResultID_VirusSubType_2 == Convert.ToString('P') || z.TestResultID_VirusSubType_2 == null) .OrderBy(z => z.Institution.OrdenPrioritybyLab == null ? 99 : z.Institution.OrdenPrioritybyLab) .ThenBy(z => z.CatTestResult == null ? 99 : z.CatTestResult.orden) .ThenBy(x => x.CatTestType == null ? 99 : x.CatTestType.orden) .ThenBy(y => y.CatVirusType == null ? 99 : y.CatVirusType.orden) .ThenBy(z => z.CatVirusSubType == null ? 99 : z.CatVirusSubType.orden) .ThenBy(x => x.CatVirusSubType_2 == null ? 99 : x.CatVirusSubType_2.orden) .ThenBy(y => y.CatVirusLinaje == null ? 99 : y.CatVirusLinaje.orden) .ToList(); //var List_Save = Record_.CaseLabTests.OfType<CaseLabTest>().ToArray(); //foreach (CaseLabTest Test_ in List_Save.Where(z => z.inst_conf_end_flow_by_virus == 0) // .OrderBy(x => x.SampleNumber ) // .ThenBy(z => z.TestDate) // .ThenBy(y => y.LabID)) //{ // var Institution_Conf_Original = db.InstitutionsConfiguration.Where(i => i.InstitutionToID == Test_.LabID && i.InstitutionParentID == Record_.HospitalID).Any() ? db.InstitutionsConfiguration.Where(i => i.InstitutionToID == Test_.LabID && i.InstitutionParentID == Record_.HospitalID).FirstOrDefault().ID : 0; // var Inst_Conf_End_Flow_By_Virus = Test_.TestResultID == "P" ? db.InstitutionConfEndFlowByVirus.Where(j => j.id_Lab == Test_.LabID && j.id_Cat_TestType == Test_.TestType && j.value_Cat_TestResult == Test_.TestResultID && j.id_Cat_VirusType == Test_.VirusTypeID).Any() ? db.InstitutionConfEndFlowByVirus.Where(j => j.id_Lab == Test_.LabID && j.id_Cat_TestType == Test_.TestType && j.value_Cat_TestResult == Test_.TestResultID && j.id_Cat_VirusType == Test_.VirusTypeID).FirstOrDefault().ID : 0 : db.InstitutionConfEndFlowByVirus.Where(j => j.id_Lab == Test_.LabID && j.id_Cat_TestType == Test_.TestType && j.value_Cat_TestResult == Test_.TestResultID).Any() ? db.InstitutionConfEndFlowByVirus.Where(j => j.id_Lab == Test_.LabID && j.id_Cat_TestType == Test_.TestType && j.value_Cat_TestResult == Test_.TestResultID).FirstOrDefault().ID : db.InstitutionConfEndFlowByVirus.Where(j => j.id_Lab == Test_.LabID && j.id_Cat_TestType == Test_.TestType && j.value_Cat_TestResult == Test_.TestResultID).Any() ? db.InstitutionConfEndFlowByVirus.Where(j => j.id_Lab == Test_.LabID && j.id_Cat_TestType == Test_.TestType && j.value_Cat_TestResult == Test_.TestResultID).FirstOrDefault().ID : 0; // Test_.inst_cnf_orig = Institution_Conf_Original; // Test_.inst_conf_end_flow_by_virus = Inst_Conf_End_Flow_By_Virus; //} //if (List_Save.Count() > 0) // db.SaveChanges(); if (List_Test.Count > 0) { if (List_Test[0].TestResultID == Convert.ToString('N')) { FluCase c = (from x in db.FluCases where x.ID == Record_.ID select x).First(); c.FinalResult = Convert.ToString('N'); c.FinalResultVirusTypeID = null; c.FinalResultVirusSubTypeID = null; c.FinalResultVirusLineageID = null; c.FinalResult_2 = null; c.FinalResultVirusTypeID_2 = null; c.FinalResultVirusSubTypeID_2 = null; c.FinalResultVirusLineageID_2 = null; c.FinalResult_3 = null; c.FinalResultVirusTypeID_3 = null; c.FinalResultVirusSubTypeID_3 = null; c.FinalResultVirusLineageID_3 = null; db.SaveChanges(); //break; } else if (List_Test[0].TestResultID == Convert.ToString('P')) { FluCase c = (from x in db.FluCases where x.ID == Record_.ID select x).First(); c.FinalResult = List_Test[0].TestResultID; c.FinalResultVirusTypeID = List_Test[0].VirusTypeID; if (List_Test[0].TestResultID_VirusSubType == Convert.ToString('P')) { c.FinalResultVirusSubTypeID = List_Test[0].VirusSubTypeID; } else if (List_Test[0].TestResultID_VirusSubType_2 == Convert.ToString('P')) { c.FinalResultVirusSubTypeID = List_Test[0].VirusSubTypeID_2; } c.FinalResultVirusLineageID = List_Test[0].VirusLineageID; var List_result_2 = List_Test.Where(z => z.VirusTypeID != List_Test[0].VirusTypeID) .OrderBy(z => z.Institution.OrdenPrioritybyLab == null ? 99 : z.Institution.OrdenPrioritybyLab) .ThenBy(z => z.CatTestResult == null ? 99 : z.CatTestResult.orden) .ThenBy(x => x.CatTestType == null ? 99 : x.CatTestType.orden) .ThenBy(y => y.CatVirusType == null ? 99 : y.CatVirusType.orden) .ThenBy(z => z.CatVirusSubType == null ? 99 : z.CatVirusSubType.orden) .ThenBy(x => x.CatVirusSubType_2 == null ? 99 : x.CatVirusSubType_2.orden) .ThenBy(y => y.CatVirusLinaje == null ? 99 : y.CatVirusLinaje.orden) .ToList(); if (List_result_2.Count > 0) { var List_result_2_1 = List_result_2 .OrderBy(z => z.Institution.OrdenPrioritybyLab == null ? 99 : z.Institution.OrdenPrioritybyLab) .ThenBy(z => z.CatTestResult == null ? 99 : z.CatTestResult.orden) .ThenBy(x => x.CatTestType == null ? 99 : x.CatTestType.orden) .ThenBy(y => y.CatVirusType == null ? 99 : y.CatVirusType.orden) .ThenBy(z => z.CatVirusSubType == null ? 99 : z.CatVirusSubType.orden) .ThenBy(x => x.CatVirusSubType_2 == null ? 99 : x.CatVirusSubType_2.orden) .ThenBy(y => y.CatVirusLinaje == null ? 99 : y.CatVirusLinaje.orden) .ToList(); var List_result_2_1_1 = List_result_2_1; var List_result_3 = List_result_2_1; if (List_result_2[0].TestResultID == Convert.ToString('N')) { if (List_result_2.Where(z => z.TestResultID == Convert.ToString('N')).Count() != List_result_2.Count()) { List_result_2_1 = List_result_2.Where(z => z.VirusTypeID != List_result_2[0].VirusTypeID) .OrderBy(z => z.Institution.OrdenPrioritybyLab == null ? 99 : z.Institution.OrdenPrioritybyLab) .ThenBy(z => z.CatTestResult == null ? 99 : z.CatTestResult.orden) .ThenBy(x => x.CatTestType == null ? 99 : x.CatTestType.orden) .ThenBy(y => y.CatVirusType == null ? 99 : y.CatVirusType.orden) .ThenBy(z => z.CatVirusSubType == null ? 99 : z.CatVirusSubType.orden) .ThenBy(x => x.CatVirusSubType_2 == null ? 99 : x.CatVirusSubType_2.orden) .ThenBy(y => y.CatVirusLinaje == null ? 99 : y.CatVirusLinaje.orden) .ToList(); if (List_result_2_1.Count > 0) { if (List_result_2_1[0].TestResultID == Convert.ToString('N')) { List_result_2_1_1 = List_result_2_1.Where(z => z.VirusTypeID != List_result_2_1[0].VirusTypeID) .OrderBy(z => z.Institution.OrdenPrioritybyLab == null ? 99 : z.Institution.OrdenPrioritybyLab) .ThenBy(z => z.CatTestResult == null ? 99 : z.CatTestResult.orden) .ThenBy(x => x.CatTestType == null ? 99 : x.CatTestType.orden) .ThenBy(y => y.CatVirusType == null ? 99 : y.CatVirusType.orden) .ThenBy(z => z.CatVirusSubType == null ? 99 : z.CatVirusSubType.orden) .ThenBy(x => x.CatVirusSubType_2 == null ? 99 : x.CatVirusSubType_2.orden) .ThenBy(y => y.CatVirusLinaje == null ? 99 : y.CatVirusLinaje.orden) .ToList(); } else { c.FinalResult_2 = List_result_2_1[0].TestResultID; c.FinalResultVirusTypeID_2 = List_result_2_1[0].VirusTypeID; if (List_result_2_1[0].TestResultID_VirusSubType == Convert.ToString('P')) { c.FinalResultVirusSubTypeID_2 = List_result_2_1[0].VirusSubTypeID; } else if (List_result_2_1[0].TestResultID_VirusSubType_2 == Convert.ToString('P')) { c.FinalResultVirusSubTypeID_2 = List_result_2_1[0].VirusSubTypeID_2; } c.FinalResultVirusLineageID_2 = List_result_2_1[0].VirusLineageID; // Aquí empieza el resultado 3 List_result_3 = List_result_2_1.Where(z => z.VirusTypeID != List_result_2_1[0].VirusTypeID) .OrderBy(z => z.Institution.OrdenPrioritybyLab == null ? 99 : z.Institution.OrdenPrioritybyLab) .ThenBy(z => z.CatTestResult == null ? 99 : z.CatTestResult.orden) .ThenBy(x => x.CatTestType == null ? 99 : x.CatTestType.orden) .ThenBy(y => y.CatVirusType == null ? 99 : y.CatVirusType.orden) .ThenBy(z => z.CatVirusSubType == null ? 99 : z.CatVirusSubType.orden) .ThenBy(x => x.CatVirusSubType_2 == null ? 99 : x.CatVirusSubType_2.orden) .ThenBy(y => y.CatVirusLinaje == null ? 99 : y.CatVirusLinaje.orden) .ToList(); if (List_result_3 != null) { if (List_result_3[0].TestResultID == Convert.ToString('P')) { c.FinalResult_3 = List_result_3[0].TestResultID; c.FinalResultVirusTypeID_3 = List_result_3[0].VirusTypeID; if (List_result_3[0].TestResultID_VirusSubType == Convert.ToString('P')) { c.FinalResultVirusSubTypeID_3 = List_result_3[0].VirusSubTypeID; } else if (List_result_3[0].TestResultID_VirusSubType_2 == Convert.ToString('P')) { c.FinalResultVirusSubTypeID_3 = List_result_3[0].VirusSubTypeID_2; } c.FinalResultVirusLineageID_3 = List_result_3[0].VirusLineageID; } } } } } else { c.FinalResult_2 = null; c.FinalResultVirusTypeID_2 = null; c.FinalResultVirusSubTypeID_2 = null; c.FinalResultVirusLineageID_2 = null; c.FinalResult_3 = null; c.FinalResultVirusTypeID_3 = null; c.FinalResultVirusSubTypeID_3 = null; c.FinalResultVirusLineageID_3 = null; } } else { c.FinalResult = List_result_2[0].TestResultID; c.FinalResultVirusTypeID = List_result_2[0].VirusTypeID; c.FinalResultVirusSubTypeID = List_result_2[0].VirusSubTypeID; c.FinalResultVirusLineageID = List_result_2[0].VirusLineageID; } } db.SaveChanges(); } } } return(Json("Success")); }
public JsonResult SaveContact( int? id, int? Surv, bool? SInusual, bool? Brote, string LName1, string LName2, string FName1, string FName2, int DocumentType, string NoExpediente, string NationalId, DateTime? DOB, int? Age, AMeasure? AMeasure, Gender Gender, DateTime HospitalDate, DateTime RegDate, int HospitalId, int? nativepeople, int? nationality, DateTime DateFeverDummy ) { FluCase flucase; var DateDummyRange1 = DateFeverDummy.Date.AddDays(1); var DateDummyRange2 = DateFeverDummy.Date.AddDays(-10); if (!id.HasValue) { var flucases = db.FluCases.Where(f => f.NoExpediente == NoExpediente.ToUpper() && (f.FeverDate < DateDummyRange1 && f.FeverDate >= DateDummyRange2)).ToList(); if (flucases.Any()) { //id = flucases.First().ID; //flucase = db.FluCases.Find(id); //db.Entry(flucase).State = EntityState.Modified; flucase = db.FluCases.Find(id); return Json("El registro ya existe por favor verifique. Último registro: " + flucases.First().ID.ToString() ); } else { flucase = new FluCase(); flucase.HospitalID = HospitalId; db.Entry(flucase).State = EntityState.Added; } } else { flucase = db.FluCases.Find(id); db.Entry(flucase).State = EntityState.Modified; } flucase.Surv = Surv; flucase.SurvInusual = SInusual; flucase.Brote = Brote; flucase.LName1 = LName1 ?? ""; flucase.LName2 = LName2 ?? ""; flucase.FName1 = FName1 ?? ""; flucase.FName2 = FName2 ?? ""; flucase.DocumentType = DocumentType; flucase.NoExpediente = NoExpediente ?? ""; flucase.NationalId = NationalId ?? ""; flucase.DOB = DOB; flucase.Age = Age; flucase.AMeasure = AMeasure; flucase.Gender = Gender; flucase.HospitalDate = HospitalDate; flucase.RegDate = RegDate; flucase.nativepeople = nativepeople; flucase.nationality = nationality; flucase.InsertDate = DateTime.Now; //flucase.UserID = User.Identity.Name; db.SaveChanges(); // Grabar en la bitacora if (!id.HasValue) { HistoryRecord(flucase.ID, 1); } else { HistoryRecord(id, 2); } return Json(flucase.ID); }
public JsonResult SaveRisk( int Id, Vaccin? Vaccin, bool? HDisease, bool? Diabetes, bool? Neuro, bool? Asthma, bool? Pulmonary, bool? Liver, bool? Renal, bool? Immunsupp, bool? ParaCerebral, bool? Indigena, bool? TrabSalud, bool? Desnutricion, bool? Prematuridad, bool? BajoPesoNacer, bool? AusLacMat, Pregnant? Pregnant, bool? Pperium, Trimester? Trimester, int? PregnantWeek, bool? Smoking, bool? Alcohol, bool? DownSyn, Obesity? Obesity, string OtherRisk, int? VacInfluenza, DateTime? VacInfluenzaDateFirst, DateTime? VacInfluenzaDateSecond, int? VacBcg, DateTime? VacBcgDate, int? VacBcgDosis, int? VacNeumococo, DateTime? VacNeumococoDate, int? VacNeumococoDosis, int? VacTosFerina, DateTime? VacTosFerinaDate, int? VacTosFerinaDosis, int? VacHaemophilus, DateTime? VacHaemophilusDate, int? VaccinFuente, int? AntiViral, DateTime? AntiViralDate, DateTime? AntiViralDateEnd, int? AntiViralType, int? OseltaDose, string AntiViralDose, int? RiskFactors ) { FluCase flucase; flucase = db.FluCases.Find(Id); if (flucase == null) { flucase = new FluCase(); db.Entry(flucase).State = EntityState.Added; } else { db.Entry(flucase).State = EntityState.Modified; } flucase.Vaccin = Vaccin; flucase.HDisease = HDisease; flucase.Diabetes = Diabetes; flucase.Neuro = Neuro; flucase.Asthma = Asthma; flucase.Pulmonary = Pulmonary; flucase.Liver = Liver; flucase.Renal = Renal; flucase.Immunsupp = Immunsupp; flucase.ParaCerebral = ParaCerebral; flucase.Indigena = Indigena; flucase.TrabSalud = TrabSalud; flucase.Desnutricion = Desnutricion; flucase.Prematuridad = Prematuridad; flucase.BajoPesoNacer = BajoPesoNacer; flucase.AusLacMat = AusLacMat; flucase.Pregnant = Pregnant; flucase.Pperium = Pperium; flucase.Trimester = Trimester; flucase.PregnantWeek = PregnantWeek; flucase.Smoking = Smoking; flucase.Alcohol = Alcohol; flucase.DownSyn = DownSyn; flucase.Obesity = Obesity; flucase.OtherRisk = OtherRisk; flucase.InsertDate = DateTime.Now; //flucase.UserID = User.Identity.Name; //flucase.VacInfluenza = (VacInfluenza.ToString() == null) ? VacInfluenza : (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacInfluenza.ToString()); flucase.VacInfluenza = VacInfluenza; flucase.VacInfluenzaDateFirst = VacInfluenzaDateFirst; flucase.VacInfluenzaDateSecond = VacInfluenzaDateSecond; if (VacBcg != null) flucase.VacBcg = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacBcg.ToString()); flucase.VacBcgDate = VacBcgDate; flucase.VacBcgDosis = VacBcgDosis; if (VacNeumococo != null) flucase.VacNeumococo = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacNeumococo.ToString()); flucase.VacNeumococoDate = VacNeumococoDate; flucase.VacNeumococoDosis = VacNeumococoDosis; if (VacTosFerina != null) flucase.VacTosFerina = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacTosFerina.ToString()); flucase.VacTosFerinaDate = VacTosFerinaDate; flucase.VacTosFerinaDosis = VacTosFerinaDosis; if (VacHaemophilus != null) flucase.VacHaemophilus = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacHaemophilus.ToString()); flucase.VacHaemophilusDate = VacHaemophilusDate; flucase.VaccinFuente = VaccinFuente; if (AntiViral != null) flucase.AntiViral = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), AntiViral.ToString()); flucase.AntiViralDate = AntiViralDate; flucase.AntiViralDateEnd = AntiViralDateEnd; flucase.AntiViralType = AntiViralType; flucase.OseltaDose = OseltaDose; flucase.AntiViralDose = AntiViralDose; if (AntiViral != null) flucase.RiskFactors = (RiskFactor)Enum.Parse(typeof(RiskFactor), RiskFactors.ToString()); db.SaveChanges(); return Json("Success"); }
public JsonResult SaveLab( int id, DateTime? RecDate, bool? Processed, DateTime? RecDate2, bool? Processed2, DateTime? RecDate3, bool? Processed3, DateTime? EndLabDate, string FResult, string NoProRen, string NoProRen2, string NoProRen3, string Comments, string FinalResult, int? FinalResultVirusTypeID, int? FinalResultVirusSubTypeID, int? FinalResultVirusLineageID, List<LabTestViewModel> LabTests ) { FluCase flucase; flucase = db.FluCases.Find(id); if (flucase == null) { flucase = new FluCase(); db.Entry(flucase).State = EntityState.Added; } else { db.Entry(flucase).State = EntityState.Modified; } flucase.RecDate = RecDate; flucase.Processed = Processed; flucase.RecDate2 = RecDate2; flucase.Processed2 = Processed2; flucase.RecDate3 = RecDate3; flucase.Processed3 = Processed3; flucase.EndLabDate = EndLabDate; flucase.FResult = FResult; flucase.NoProRen = NoProRen; flucase.Comments = Comments; flucase.FinalResult = FinalResult; flucase.FinalResultVirusTypeID = FinalResultVirusTypeID; flucase.FinalResultVirusSubTypeID = FinalResultVirusSubTypeID; flucase.FinalResultVirusLineageID = FinalResultVirusLineageID; db.CaseLabTests.RemoveRange(flucase.CaseLabTests); flucase.CaseLabTests = new List<CaseLabTest>(); if (LabTests != null) { foreach (LabTestViewModel labTestViewModel in LabTests.OrderBy(x=>x.SampleNumber).ThenBy(y=>y.LabID).ThenBy(z => z.TestDate)) { flucase.CaseLabTests.Add( new CaseLabTest { LabID = labTestViewModel.LabID, Processed = labTestViewModel.Processed, SampleNumber = labTestViewModel.SampleNumber, TestDate = labTestViewModel.TestDate, TestResultID = labTestViewModel.TestResultID, TestEndDate = labTestViewModel.TestEndDate, TestType = (TestType)labTestViewModel.TestType, VirusTypeID = labTestViewModel.VirusTypeID, CTVirusType = labTestViewModel.CTVirusType, OtherVirusTypeID = labTestViewModel.OtherVirusTypeID, CTOtherVirusType = labTestViewModel.CTOtherVirusType, InfA = labTestViewModel.InfA, VirusSubTypeID = labTestViewModel.VirusSubTypeID, CTSubType = labTestViewModel.CTSubType, InfB = labTestViewModel.InfB, VirusLineageID = labTestViewModel.VirusLineageID, CTLineage = labTestViewModel.CTLineage, ParaInfI = labTestViewModel.ParaInfI, ParaInfII = labTestViewModel.ParaInfII, ParaInfIII = labTestViewModel.ParaInfIII, RNP = labTestViewModel.RNP, RSV = labTestViewModel.RSV, Adenovirus = labTestViewModel.Adenovirus, Metapneumovirus = labTestViewModel.Metapneumovirus, FluCaseID = flucase.ID } ); } } flucase.InsertDate = DateTime.Now; //flucase.UserID = User.Identity.Name; var result = SaveChanges(); var tests = flucase.CaseLabTests.ToList(); if (tests.Count <= 0) return result; if (tests.Count >= 1) flucase.MuestraID1 = tests[0].ID; if (tests.Count >= 2) flucase.MuestraID2 = tests[1].ID; if (tests.Count >= 3) flucase.MuestraID3 = tests[2].ID; if (tests.Count >= 4) flucase.MuestraID4 = tests[3].ID; if (tests.Count >= 5) flucase.MuestraID5 = tests[4].ID; if (tests.Count >= 6) flucase.MuestraID6 = tests[5].ID; if (tests.Count >= 7) flucase.MuestraID7 = tests[6].ID; if (tests.Count >= 8) flucase.MuestraID8 = tests[7].ID; if (tests.Count >= 9) flucase.MuestraID9 = tests[8].ID; if (tests.Count >= 10) flucase.MuestraID10 = tests[9].ID; if (tests.Count >= 11) flucase.MuestraID11 = tests[10].ID; if (tests.Count >= 12) flucase.MuestraID12 = tests[11].ID; if (tests.Count >= 13) flucase.MuestraID13 = tests[12].ID; if (tests.Count >= 14) flucase.MuestraID14 = tests[13].ID; if (tests.Count >= 15) flucase.MuestraID15 = tests[14].ID; result = SaveChanges(); //Bitacora HistoryRecord(flucase.ID, 4); return result; }
public JsonResult SaveHospital( int id, string CHNum, DateTime? FeverDate, int? FeverEW, DateTime? DiagDate, int? DiagEW, string Antiviral, DateTime? AStartDate, DateTime? HospAmDate, int? HospEW, DateTime? HospExDate, int? ICU, DateTime? ICUAmDate, int? ICUEW, DateTime? ICUExDate, string Destin, bool? IsSample, DateTime? SampleDate, string SampleType, DateTime? ShipDate, int? LabId, DateTime? SampleDate2, string SampleType2, DateTime? ShipDate2, int? LabId2, DateTime? SampleDate3, string SampleType3, DateTime? ShipDate3, int? LabId3, bool? Adenopatia, bool? AntecedentesFiebre, bool? Rinorrea, bool? Malestar, bool? Nauseas, bool? DolorMuscular, bool? Disnea, bool? DolorCabeza, bool? Estridor, bool? Tos, bool? DifResp, bool? MedSatOxig, int? SatOxigPor, int? SalonVal, int? DiagPrinAdmVal, string DiagOtroAdm, string DestinICU, DateTime? FalleDate, string InstReferName, bool? HallRadio, bool? MecVent, bool? MecVentNoInv, bool? ECMO, bool? VAFO, int? DiagEgVal, bool? Tiraje, bool? Odinofagia, int? CaseStatus, DateTime? CloseDate, string ObservationCase ) { FluCase flucase; flucase = db.FluCases.Find(id); if (flucase == null) { flucase = new FluCase(); db.Entry(flucase).State = EntityState.Added; } else { db.Entry(flucase).State = EntityState.Modified; } flucase.CHNum = CHNum; flucase.FeverDate = FeverDate; flucase.FeverEW = FeverEW; flucase.DiagDate = DiagDate; flucase.DiagEW = DiagEW; flucase.Antiviral = Antiviral; flucase.AStartDate = AStartDate; flucase.HospAmDate = HospAmDate; flucase.HospEW = HospEW; flucase.HospExDate = HospExDate; flucase.ICU = ICU; flucase.ICUAmDate = ICUAmDate; flucase.ICUEW = ICUEW; flucase.ICUExDate = ICUExDate; flucase.Destin = Destin; flucase.FalleDate = FalleDate; flucase.IsSample = IsSample; flucase.SampleDate = SampleDate; flucase.SampleType = SampleType; flucase.ShipDate = ShipDate; flucase.LabID = LabId; flucase.SampleDate2 = SampleDate2; flucase.SampleType2 = SampleType2; flucase.ShipDate2 = ShipDate2; flucase.LabID2 = LabId2; flucase.SampleDate3 = SampleDate3; flucase.SampleType3 = SampleType3; flucase.ShipDate3 = ShipDate3; flucase.LabID3 = LabId3; flucase.InsertDate = DateTime.Now; //flucase.UserID = User.Identity.Name; flucase.Adenopatia = Adenopatia; flucase.AntecedentesFiebre = AntecedentesFiebre; flucase.Rinorrea = Rinorrea; flucase.Malestar = Malestar; flucase.Nauseas = Nauseas; flucase.DolorMuscular = DolorMuscular; flucase.Disnea = Disnea; flucase.DolorCabeza = DolorCabeza; flucase.Estridor = Estridor; flucase.Tos = Tos; flucase.DifResp = DifResp; flucase.MedSatOxig = MedSatOxig; flucase.SatOxigPor = SatOxigPor; flucase.Salon = SalonVal; flucase.DiagAdm = DiagPrinAdmVal; flucase.DiagOtroAdm = DiagOtroAdm; flucase.DestinICU = DestinICU; flucase.HallRadio = HallRadio; flucase.MecVent = MecVent; flucase.MecVentNoInv = MecVentNoInv; flucase.ECMO = ECMO; flucase.VAFO = VAFO; flucase.DiagEg = DiagEgVal; flucase.Tiraje = Tiraje; flucase.Odinofagia = Odinofagia; flucase.CaseStatus = CaseStatus; flucase.CloseDate = CloseDate; flucase.ObservationCase = ObservationCase; db.SaveChanges(); return Json("Success"); }
public JsonResult SaveGEO( int id, int? CountryId, int? AreaId, int? StateId, int? LocalId, int? NeighborhoodId, UrbanRural UrbanRural, string Address, int? CountryOrigin, string PhoneNumber, string Latitude, string Longitude ) { FluCase flucase; flucase = db.FluCases.Find(id); if (flucase == null) { flucase = new FluCase(); db.Entry(flucase).State = EntityState.Added; } else { db.Entry(flucase).State = EntityState.Modified; } flucase.CountryID = CountryId; flucase.AreaID = AreaId; flucase.StateID = StateId; flucase.LocalID = LocalId; flucase.NeighborhoodID = NeighborhoodId; flucase.UrbanRural = UrbanRural; flucase.Address = Address; flucase.PhoneNumber = PhoneNumber; flucase.Latitude = Latitude; flucase.Longitude = Longitude; flucase.CountryOrigin = CountryOrigin; flucase.InsertDate = DateTime.Now; //flucase.UserID = User.Identity.Name; db.SaveChanges(); return Json("Success"); }