public ActionResult AddEncounter(System.Web.Mvc.FormCollection form) { string cc = Request.Form["chiefComplaint"]; int aType = Convert.ToInt32(Request.Form["aType"]); int doctor = Convert.ToInt32(Request.Form["doctor"]); string insurance = Request.Form["insurance"]; int facility = Convert.ToInt32(Request.Form["facility"]); encounter pat = db.encounters.OrderByDescending(r => r.encounter_data_id).First(); string encounterID = "0000000000000" + (pat.encounter_data_id + 1); encounterID = encounterID.Substring(encounterID.Length - 14, 14); encounter newEncounter = new encounter(); newEncounter.encounter_id = encounterID; newEncounter.admission_date = DateTime.Now; newEncounter.chief_complaint = cc; newEncounter.admission_type_id = aType; newEncounter.attending_doctor_id = doctor; if (insurance == "0") { patient_insurance pi = new patient_insurance(); pi.patient_id = Convert.ToInt32(Request.Form["patientid"]); pi.insurance_id = 3; pi.individual_insurance_id = "Out Of Pocket"; pi.date_added = DateTime.Now; db.patient_insurance.Add(pi); db.SaveChanges(); newEncounter.patient_insurance_id = pi.patient_insurance_id; } else { patient_insurance pi = db.patient_insurance.Where(r => r.individual_insurance_id == insurance).FirstOrDefault(); newEncounter.patient_insurance_id = pi.patient_insurance_id; } newEncounter.facility_id = facility; db.encounters.Add(newEncounter); db.SaveChanges(); return(Redirect("../IndividualEncounter/" + newEncounter.encounter_data_id)); }
public ActionResult AddInsurance(System.Web.Mvc.FormCollection form) { string subscriberNumber = Request.Form["subscriberNumber"]; //individual_insurance_id string insuranceCompany = Request.Form["insuranceCompany"]; //insurance_id int patientID = Convert.ToInt32(Request.Form["patientID"]); patient p = db.patients.Where(r => r.patient_id == patientID).FirstOrDefault(); patient_insurance patientInsure = new patient_insurance(); patientInsure.patient_id = patientID; patientInsure.insurance_id = Convert.ToInt32(insuranceCompany); patientInsure.individual_insurance_id = subscriberNumber; db.patient_insurance.Add(patientInsure); db.SaveChanges(); return(Redirect("Details/" + p.medical_record_number)); }
public ActionResult IndividualEncounter(int?id, int?page) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } encounter indiviEncounter = db.encounters.Where(r => r.encounter_data_id == id).FirstOrDefault(); ViewBag.encounter = indiviEncounter.patient_insurance_id; ViewBag.encounter_data_id = indiviEncounter.encounter_data_id; patient_insurance pInsurance = db.patient_insurance.Where(r => r.patient_insurance_id == indiviEncounter.patient_insurance_id).FirstOrDefault(); ViewBag.pi = pInsurance.patient_id; patient p = db.patients.Where(r => r.patient_id == pInsurance.patient_id).FirstOrDefault(); ViewBag.patientID = p.patient_id; ViewBag.encounterID = indiviEncounter.encounter_id; ViewBag.patientMRN = p.medical_record_number; ViewBag.admissionDate = indiviEncounter.admission_date; ViewBag.dischargeDate = indiviEncounter.discharge_date; //Nursing group add new features here List <nursing_pca_record> pcaList = db.nursing_pca_record.Where(x => x.encounter_id == indiviEncounter.encounter_data_id).ToList(); PCADetail pcaModel = new PCADetail(); List <PCADetail> pcaModelList = new List <PCADetail>(); if (pcaList != null && pcaList.Count > 0) { pcaModelList = pcaList.Select(s => new PCADetail { pcaId = s.pca_id, datetime = s.date_vitals_added, }).OrderByDescending(s => s.datetime).ToList(); } int pageSize = 5; int pageNumber = (page ?? 1); //return View() return(View(pcaModelList.ToPagedList(pageNumber, pageSize))); }