public ActionResult Edit([Bind(Include = "birthRecordId,certiferName,certiferTitle,certiferDate,filedDate,paternityAck,ssnRequested,facilityId,birthFacility,homebirth,attendantName,attendantNpi,attendantTitle,motherTransferred,transferFacility,firstPrenatal,lastPrenatal,totalPrenatal,motherPreWeight,motherPostWeight,motherDeliveryWeight,hadWic,previousBirthLiving,previousBirthDead,lastLiveBirth,otherBirthOutcomes,lastOtherOutcome,cigThreeBefore,packThreeBefore,cigFirstThree,packFirstThree,cigSecondThree,packSecondThree,cigThirdTri,packThirdTri,paymentSource,dateLastMenses,diabetesPrepregnancy,diabetesGestational,hyperTensionPrepregnancy,hyperTensionGestational,hyperTensionEclampsia,prePreTerm,prePoorOutcome,resultInfertility,fertilityDrug,assistedTech,previousCesarean,previousCesareanAmount,gonorrhea,syphilis,chlamydia,hepB,hepC,cervicalCerclage,tocolysis,externalCephalic,preRuptureMembrane,preLabor,proLabor,inductionLabor,augmentationLabor,nonvertex,steroids,antibotics,chorioamnionitis,meconium,fetalIntolerance,epidural,unsuccessfulForceps,unsuccessfulVacuum,cephalic,breech,otherFetalPresentation,finalSpontaneous,finalForceps,finalVacuum,finalCesarean,finalTrialOfLabor,maternalTransfusion,perinealLaceration,rupturedUterus,hysterectomy,admitICU,unplannedOperating,fiveMinAgpar,tenMinAgpar,plurality,birthOrder,ventImmedite,ventSixHours,nicu,surfactant,neoNatalAntibotics,seizureDysfunction,birthInjury,anencephaly,meningomyelocele,cyanotic,cogenital,omphalocele,gastroschisis,limbReduction,cleftLip,cleftPalate,downConfirmed,downPending,suspectedConfirmed,suspectedPending,hypospadias,infantTransferred,infantLiving,breastFed,dateCreated,dateEdited,editedBy")] zz_birthRecord birthRecord) { user account = newDB.users.Find(UserAccount.GetUserID()); if (ModelState.IsValid) { newDB.Entry(birthRecord).State = EntityState.Modified; newDB.SaveChanges(); logger.Info("User " + account.firstName + " " + account.lastName + " edited birth record: " + birthRecord.birthRecordId); return(RedirectToAction("Index")); } return(View(birthRecord)); }
// GET: birthRecords/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } zz_birthRecord birthRecord = newDB.zz_birthRecord.Find(id); if (birthRecord == null) { return(HttpNotFound()); } return(View(birthRecord)); }
// GET: birthRecords/Edit/5 public ActionResult Edit(int?id) { user account = newDB.users.Find(UserAccount.GetUserID()); if (account.role.title != "Disabled") { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } zz_birthRecord birthRecord = newDB.zz_birthRecord.Find(id); if (birthRecord == null) { return(HttpNotFound()); } return(View(birthRecord)); } else { return(RedirectToAction("tempError", "Home")); } }
public ActionResult Create([Bind(Include = "birthRecordId,certiferName,certiferTitle,certiferDate,filedDate,paternityAck,ssnRequested,facilityId,birthFacility,homebirth,attendantName,attendantNpi,attendantTitle,motherTransferred,transferFacility,firstPrenatal,lastPrenatal,totalPrenatal,motherPreWeight,motherPostWeight,motherDeliveryWeight,hadWic,previousBirthLiving,previousBirthDead,lastLiveBirth,otherBirthOutcomes,lastOtherOutcome,cigThreeBefore,packThreeBefore,cigFirstThree,packFirstThree,cigSecondThree,packSecondThree,cigThirdTri,packThirdTri,paymentSource,dateLastMenses,diabetesPrepregnancy,diabetesGestational,hyperTensionPrepregnancy,hyperTensionGestational,hyperTensionEclampsia,prePreTerm,prePoorOutcome,resultInfertility,fertilityDrug,assistedTech,previousCesarean,previousCesareanAmount,gonorrhea,syphilis,chlamydia,hepB,hepC,cervicalCerclage,tocolysis,externalCephalic,preRuptureMembrane,preLabor,proLabor,inductionLabor,augmentationLabor,nonvertex,steroids,antibotics,chorioamnionitis,meconium,fetalIntolerance,epidural,unsuccessfulForceps,unsuccessfulVacuum,cephalic,breech,otherFetalPresentation,finalSpontaneous,finalForceps,finalVacuum,finalCesarean,finalTrialOfLabor,maternalTransfusion,perinealLaceration,rupturedUterus,hysterectomy,admitICU,unplannedOperating, birthWeight, fiveMinAgpar,tenMinAgpar,plurality,birthOrder,ventImmedite,ventSixHours,nicu,surfactant,neoNatalAntibotics,seizureDysfunction,birthInjury,anencephaly,meningomyelocele,cyanotic,cogenital,omphalocele,gastroschisis,limbReduction,cleftLip,cleftPalate,downConfirmed,downPending,suspectedConfirmed,suspectedPending,hypospadias,infantTransferred,infantLiving,breastFed,dateCreated,dateEdited,editedBy")] zz_birthRecord birthRecord, FormCollection form) { user account = newDB.users.Find(UserAccount.GetUserID()); if (ModelState.IsValid) { //Create Child Info zz_patient child = new zz_patient(); child.firstName = form["childFirstName"]; child.middleName = form["childMiddleName"]; child.lastName = form["childLastName"]; child.suffix = form["childSuffix"]; child.birthTime = TimeSpan.Parse(form["timeOfBirth"]); child.gender = form["genderList"]; child.birthDate = Convert.ToDateTime(form["childBirthDate"]); child.birthFacility = form["facilityName"]; child.birthCity = form["childBirthLocation"]; child.birthCounty = form["childBirthCounty"]; child.birthWeight = Convert.ToInt32(form["birthWeight"]); if (Request.Cookies["userId"] != null) { HttpCookie aCookie = Request.Cookies["userId"]; child.editedBy = Convert.ToInt32(Server.HtmlEncode(aCookie.Value)); } child.dateCreated = DateTime.Now; child.dateUpdated = DateTime.Now; Random random = new Random(); int childMRN = random.Next(100000000, 999999999); using (HITProjectData_Fall17Entities1 newDB = new HITProjectData_Fall17Entities1()) { string randomNumberString = Convert.ToString(childMRN); List <zz_patient> patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList(); while (patients.Count > 0) { childMRN = random.Next(100000000, 999999999); randomNumberString = Convert.ToString(childMRN); patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList(); } } child.medicalRecordNumber = Convert.ToString(childMRN); //Add and save child to Database newDB.zz_patient.Add(child); newDB.SaveChanges(); //Mother info int id = Convert.ToInt32(form["motherId"]); zz_patient mother = newDB.zz_patient.Find(id); mother.firstName = form["motherFirstName"]; mother.middleName = form["motherMiddleName"]; mother.lastName = form["motherLastName"]; mother.suffix = form["motherSuffix"]; mother.birthDate = Convert.ToDateTime(form["motherDOB"]); mother.priorFirstName = form["motherPriorFirstName"]; mother.priorMiddleName = form["motherPriorMiddleName"]; mother.priorLastName = form["motherPriorLastName"]; mother.priorSuffix = form["motherPriorSuffix"]; mother.residenceState = form["state"]; mother.residenceCounty = form["motherCountry"]; mother.residenceCity = form["motherCity"]; mother.residenceStreetAddress = form["motherAddress"]; mother.residenceAptNo = form["motherAptNo"]; mother.residenceZip = form["motherZip"]; mother.inCity = Convert.ToBoolean(form["inCity"].Split(',')[0]); newDB.Entry(mother).State = EntityState.Modified; newDB.SaveChanges(); //Add Mother address to child child.residenceState = form["state"]; child.residenceCounty = form["motherCountry"]; child.residenceCity = form["motherCity"]; child.residenceStreetAddress = form["motherAddress"]; child.residenceAptNo = form["motherAptNo"]; child.residenceAptNo = form["motherZip"]; newDB.Entry(child).State = EntityState.Modified; newDB.SaveChanges(); //Father Information zz_patient father = new zz_patient(); //If father information exists //TODO add logic for father lookup if (form["fatherFirstName"] != "") { father.firstName = form["fatherFirstName"]; father.middleName = form["fatherMiddleName"]; father.lastName = form["fatherLastName"]; father.suffix = form["fatherSuffix"]; father.birthDate = Convert.ToDateTime(form["fatherDOB"]); father.birthState = form["fatherBirthplace"]; int fatherMRN = random.Next(100000000, 999999999); using (HITProjectData_Fall17Entities1 newDB = new HITProjectData_Fall17Entities1()) { string randomNumberString = Convert.ToString(fatherMRN); List <zz_patient> patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList(); while (patients.Count > 0) { fatherMRN = random.Next(100000000, 999999999); randomNumberString = Convert.ToString(fatherMRN); patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == randomNumberString).ToList(); } } father.medicalRecordNumber = Convert.ToString(fatherMRN); //Add and save father to Database newDB.zz_patient.Add(father); newDB.SaveChanges(); } //Certifier information birthRecord.certiferName = form["certifierName"]; birthRecord.certiferTitle = form["certifierTitleList"]; if (birthRecord.certiferTitle == "Other") { birthRecord.certiferTitle = form["certifierTitleOther"]; } birthRecord.certiferDate = Convert.ToDateTime(form["dateCertified"]); birthRecord.filedDate = Convert.ToDateTime(form["datedFiled"]); //Mother2 Info mother.mailingState = form["stateList"]; mother.mailingCity = form["motherMailingCity"]; mother.mailingStreetAddress = form["motherMailingAddress"]; mother.mailingAptNo = form["motherMailingAptNo"]; mother.mailingZip = form["motherMailingZip"]; mother.isMarried = Convert.ToBoolean(form["isMarried"].Split(',')[0]); //TODO null check mother.SSN = form["motherSSN"]; child.motherSSN = form["motherSSN"]; //TODO null check if (form["fatherFirstName"] != "") { father.SSN = form["fatherSSN"]; child.fatherSSN = form["fatherSSN"]; newDB.Entry(father).State = EntityState.Modified; } newDB.Entry(child).State = EntityState.Modified; newDB.Entry(mother).State = EntityState.Modified; newDB.SaveChanges(); //Mother3 Info mother.educationEarned = form["motherEducation"]; mother.hispanic = form["motherHispanic"]; if (mother.hispanic == "Yes, other Spanish/Hispanic/Latina") { mother.hispanic = "motherHispanicOther"; } newDB.Entry(mother).State = EntityState.Modified; newDB.SaveChanges(); zz_patientRace motherRace = new zz_patientRace(); motherRace.patientId = id; motherRace.white = Convert.ToBoolean(form["motherWhite"].Split(',')[0]); motherRace.black = Convert.ToBoolean(form["motherBlack"].Split(',')[0]); motherRace.tribe = form["mothertribe"]; motherRace.asianIndian = Convert.ToBoolean(form["motherAsianIndian"].Split(',')[0]); motherRace.chinese = Convert.ToBoolean(form["motherChinese"].Split(',')[0]); motherRace.flipino = Convert.ToBoolean(form["motherFilipino"].Split(',')[0]); motherRace.japanese = Convert.ToBoolean(form["motherJapanese"].Split(',')[0]); motherRace.korean = Convert.ToBoolean(form["motherKorean"].Split(',')[0]); motherRace.vietnamese = Convert.ToBoolean(form["motherVietnamese"].Split(',')[0]); motherRace.otherAsian = form["motherOtherAsian"]; motherRace.hawaiian = Convert.ToBoolean(form["motherHawaiian"].Split(',')[0]); motherRace.guamanian = Convert.ToBoolean(form["motherGuamanian"].Split(',')[0]); motherRace.samoan = Convert.ToBoolean(form["motherSamoan"].Split(',')[0]); motherRace.pacificIslander = form["motherOtherIslander"]; motherRace.other = form["motherOtherRace"]; newDB.zz_patientRace.Add(motherRace); newDB.SaveChanges(); //Father 2 Information if (form["fatherFirstName"] != "") { father.educationEarned = form["fatherEducation"]; father.hispanic = form["fatherHispanic"]; if (father.hispanic == "Yes, other Spanish/Hispanic/Latina") { father.hispanic = "fatherHispanicOther"; } newDB.Entry(father).State = EntityState.Modified; newDB.SaveChanges(); List <zz_patient> patients = newDB.zz_patient.Where(p => p.medicalRecordNumber == father.medicalRecordNumber).ToList(); zz_patientRace fatherRace = new zz_patientRace(); fatherRace.patientId = patients[0].patientId; fatherRace.white = Convert.ToBoolean(form["fatherWhite"].Split(',')[0]); fatherRace.black = Convert.ToBoolean(form["fatherBlack"].Split(',')[0]); fatherRace.tribe = form["fatherTribe"]; fatherRace.asianIndian = Convert.ToBoolean(form["fatherAsianIndian"].Split(',')[0]); fatherRace.chinese = Convert.ToBoolean(form["fatherChinese"].Split(',')[0]); fatherRace.flipino = Convert.ToBoolean(form["fatherFilipino"].Split(',')[0]); fatherRace.japanese = Convert.ToBoolean(form["fatherJapanese"].Split(',')[0]); fatherRace.korean = Convert.ToBoolean(form["fatherKorean"].Split(',')[0]); fatherRace.vietnamese = Convert.ToBoolean(form["fatherVietnamese"].Split(',')[0]); fatherRace.otherAsian = form["fatherOtherAsian"]; fatherRace.hawaiian = Convert.ToBoolean(form["fatherHawaiian"].Split(',')[0]); fatherRace.guamanian = Convert.ToBoolean(form["fatherGuamanian"].Split(',')[0]); fatherRace.samoan = Convert.ToBoolean(form["fatherSamoan"].Split(',')[0]); fatherRace.pacificIslander = form["fatherOtherIslander"]; fatherRace.other = form["fatherOtherRace"]; newDB.zz_patientRace.Add(fatherRace); newDB.SaveChanges(); } birthRecord.birthFacility = form["birthOccuredPlace"]; if (birthRecord.birthFacility == "Other") { birthRecord.birthFacility = form["birthOccuredPlaceOther"]; } birthRecord.attendantTitle = form["attendantTitleList"]; if (birthRecord.attendantTitle == "Other") { birthRecord.attendantTitle = form["attendantNPIOther"]; } birthRecord.noPrenatal = Convert.ToBoolean(form["noPrenatal"].Split(',')[0]); if (birthRecord.noPrenatal == false) { birthRecord.firstPrenatal = Convert.ToDateTime(form["firstPrenatal"]); birthRecord.lastPrenatal = Convert.ToDateTime(form["lastPrenatal"]); } mother.height = Convert.ToInt32(form["motherHeight"]); birthRecord.lastLiveBirth = Convert.ToDateTime(form["lastLiveBirth"]); birthRecord.lastOtherOutcome = Convert.ToDateTime(form["lastOtherOutcome"]); birthRecord.paymentSource = form["paymentList"]; if (birthRecord.paymentSource == "Other") { birthRecord.paymentSource = form["paymentOther"]; } birthRecord.dateLastMenses = Convert.ToDateTime(form["dateLastMenses"]); birthRecord.infantLiving = form["infantLiving"]; newDB.Entry(mother).State = EntityState.Modified; newDB.zz_birthRecord.Add(birthRecord); newDB.SaveChanges(); //TODO add record to bridging table //Add Mother zz_record motherR = new zz_record(); var userId = Convert.ToInt32(Request.Cookies["userId"].Value); List <user> users = newDB.users.Where(u => u.userId == userId).ToList(); motherR.hospitalId = users[0].hospitalId; motherR.patientId = mother.patientId; motherR.birthRecordId = birthRecord.birthRecordId; newDB.zz_record.Add(motherR); newDB.SaveChanges(); //Add Father if (form["fatherFirstName"] != "") { zz_record fatherR = new zz_record(); fatherR.hospitalId = users[0].hospitalId; fatherR.patientId = father.patientId; fatherR.birthRecordId = birthRecord.birthRecordId; newDB.zz_record.Add(fatherR); newDB.SaveChanges(); } //Add Child zz_record childR = new zz_record(); childR.hospitalId = users[0].hospitalId; childR.patientId = child.patientId; childR.birthRecordId = birthRecord.birthRecordId; newDB.zz_record.Add(childR); newDB.SaveChanges(); logger.Info("User " + account.firstName + " " + account.lastName + " created birth record: " + birthRecord.birthRecordId); return(RedirectToAction("Index")); } return(View(birthRecord)); }