//UPDATE
protected void update_Click(object sender, EventArgs e)
{
try
{
//check to see if a insert is needed for deceased
person = person.Select(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
client = client.Select(person.person_id);
if (Update_deceasedYes.Checked == true)
{
person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
missing = missing_update(person.person_id);
//check if update of insert of deceased
deceased = deceased.Select(client.client_id);
if (deceased.deceased_id == 0)
{
deceased = deceased_insert_For_Update();
}
else
{
deceased = deceased_update(person.person_id);
}
}
else
{
person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
missing = missing_update(person.person_id);
}
address = address_update(person.address_id);
client = client_update(person.person_id);
encounter = encounter_insert();
Update_refreshclient();
}
catch { Update_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
finally { Update_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
}
public ActionResult AddEncounter(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
patient patient = db.patients.Find(id);
if (patient == null)
{
return(HttpNotFound());
}
user account = db.users.Find(UserAccount.GetUserID());
if (account.role.title == "Disabled")
{
ViewBag.isDisabled = true;
}
encounter newEncounter = new encounter();
ViewBag.id = id;
return(View());
}
public encounter Insert_encounter_select(int ID)
{
encounter = encounter.Select(ID);
Insert_case_id_txt.Text = Convert.ToString(encounter.case_id);
Insert_agency_id_txt.Text = Convert.ToString(encounter.agency_id);
Insert_call_center_id_txt.Text = Convert.ToString(encounter.call_center_id);
Insert_client_id_txt.Text = Convert.ToString(encounter.client_id);
Insert_create_date_txt.Text = Convert.ToString(encounter.create_date);
Insert_close_date_txt.Text = Convert.ToString(encounter.close_date);
Insert_disaster_id_txt.Text = Convert.ToString(encounter.disaster_id);
Insert_Location_ID_txt.Text = Convert.ToString(encounter.Location_ID);
Insert_Pet_Record_ID_txt.Text = Convert.ToString(encounter.Pet_Record_ID);
return(encounter);
}
public encounter encounter_insert()
{
encounter.case_id = case_intake.case_id;
encounter.agency_id = 0;//null
encounter.call_center_id = Convert.ToInt32(DDL_Call_Center.SelectedValue);
encounter.client_id = 0;
encounter.create_date = DateTime.Now;
encounter.close_date = Convert.ToDateTime(9 / 9 / 9); //null
encounter.disaster_id = Convert.ToInt32(DDL_Disaster.SelectedValue);
encounter.Location_ID = 0; //null
encounter.Pet_Record_ID = 0; //null
encounter = encounter.Insert(encounter);
return(encounter);
}
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 encounter encounter_insert()
{
encounter.agency_id = 0;
encounter.case_id = case_intake.case_id;
encounter.call_center_id = Convert.ToInt32(Insert_DDL_Call_Center.SelectedValue);
encounter.client_id = client.client_id;
encounter.create_date = DateTime.Now;
encounter.close_date = Convert.ToDateTime("1 / 1 / 1900");
encounter.disaster_id = Convert.ToInt32(Insert_DDlDisasters.SelectedValue);
encounter.Location_ID = 0;
encounter.Pet_Record_ID = 0;
encounter = encounter.Insert(encounter);
//GridView1.DataBind();
return(encounter);
}
public encounter encounter_insert()
{
encounter.case_id = Convert.ToInt32(Insert_case_id_txt.Text);
encounter.agency_id = Convert.ToInt32(Insert_agency_id_txt.Text);
encounter.call_center_id = Convert.ToInt32(Insert_call_center_id_txt.Text);
encounter.client_id = Convert.ToInt32(Insert_client_id_txt.Text);
encounter.create_date = Convert.ToDateTime(Insert_create_date_txt.Text);
encounter.close_date = Convert.ToDateTime(Insert_close_date_txt.Text);
encounter.disaster_id = Convert.ToInt32(Insert_disaster_id_txt.Text);
encounter.Location_ID = Convert.ToInt32(Insert_Location_ID_txt.Text);
encounter.Pet_Record_ID = Convert.ToInt32(Insert_Pet_Record_ID_txt.Text);
encounter = encounter.Insert(encounter);
Insert_encounter_GridView.DataBind();
Update_encounter_GridView.DataBind();
Delete_encounter_GridView.DataBind();
return(encounter);
}
protected void updateDatabase()
{
//product_id_array has all product ids
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//case_intake
case_intake = case_intake_insert();
//encounter
encounter = encounter_insert();
//requestor
requestor = requestor_insert();
//requestor_Order
requestor_Order = requestor_Order_insert();
//Order_product
Order_Product = Order_Product_insert();
}
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)));
}
//INSERT
protected void insert_Click(object sender, EventArgs e)
{
try
{
address = address_insert();
person = person_insert();
client = client_insert();
missing = missing_insert();
if (Insert_deceasedYes.Checked == true)
{
deceased = deceased_insert();
}
case_intake = case_intake_insert();
case_client = case_client_insert();
encounter = encounter_insert();
}
catch { Insert_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
finally { Insert_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
}
protected void UPDATE(object sender, EventArgs e)
{
encounter = encounter_update(Convert.ToInt32(Update_encounter_GridView.SelectedValue));
}
public ActionResult CreateVital(CreateVitals cr, int?id, string formButton)
{
if (ModelState.IsValid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
encounter indiviEncounter = db.encounters.Find(id);
ViewBag.encounterdataid = indiviEncounter.encounter_data_id;
//nursing_pca_record pca_Record = db.nursing_pca_record.Where(x => x.encounter_id == indiviEncounter.encounter_data_id).FirstOrDefault();
nursing_pca_record vi = new nursing_pca_record();
vi.encounter_id = ViewBag.encounterdataid;
vi.date_vitals_added = cr.datetime;
vi.temperature = cr.temperature;
vi.temp_route_type_id = cr.temp_route_value;
vi.pulse = cr.pulse;
vi.pulse_route_type_id = cr.pulse_route_value;
vi.pulse_oximetry = cr.pulse_oximetry;
vi.respiration = cr.respirations;
vi.oxygen_flow = cr.oxygen_flow;
vi.systolic_blood_pressure = cr.systolic_b_pressure;
vi.diastolic_blood_pressure = cr.diastolic_b_pressure;
vi.o_two_delivery_type_id = cr.o2_dev_method;
vi.pain_scale_type_id = cr.pain_scale_value;
vi.pain_level_actual = cr.pain_level_actual;
vi.pain_level_goal = cr.pain_level__goal;
nursing_care_system_assessment care = new nursing_care_system_assessment();
care.care_system_assessment_type_id = 1;
care.care_system_comment = cr.care_comment;
care.wdl_ex = cr.wdl_ex;
care.date_care_system_added = cr.datetime;
vi.nursing_care_system_assessment = new List <nursing_care_system_assessment>();
vi.nursing_care_system_assessment.Add(care);
nursing_pca_comment com = new nursing_pca_comment();
com.date_comment_added = cr.datetime;
com.pca_comment = cr.comment;
com.pca_comment_type_id = 1;
vi.nursing_pca_comment = new List <nursing_pca_comment>();
vi.nursing_pca_comment.Add(com);
indiviEncounter.nursing_pca_record = new List <nursing_pca_record>();
indiviEncounter.nursing_pca_record.Add(vi);
db.nursing_pca_record.Add(vi);
db.SaveChanges();
switch (formButton)
{
case "SaveList":
return(Redirect("../IndividualEncounter/" + indiviEncounter.encounter_id));
case "SaveContinue":
return(RedirectToAction("Create", "BodySystems", new { pcaID = vi.pca_id, typeID = 2 }));
default:
return(Redirect("../IndividualEncounter/" + indiviEncounter.encounter_id));
}
}
return(View());
}
//UPDATE
protected void update_Click(object sender, EventArgs e)
{
try
{
//check to see if a insert is needed for deceased
person = person.Select(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
client = client.Select(person.person_id);
if (Update_deceasedYes.Checked == true)
{
person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
missing = missing_update(person.person_id);
//check if update of insert of deceased
deceased = deceased.Select(client.client_id);
if (deceased.deceased_id == 0) { deceased = deceased_insert_For_Update(); }
else { deceased = deceased_update(person.person_id); }
}
else
{
person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue));
missing = missing_update(person.person_id);
}
address = address_update(person.address_id);
client = client_update(person.person_id);
encounter = encounter_insert();
Update_refreshclient();
}
catch { Update_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
finally { Update_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
}
//INSERT
protected void insert_Click(object sender, EventArgs e)
{
try
{
address = address_insert();
person = person_insert();
client = client_insert();
missing = missing_insert();
if (Insert_deceasedYes.Checked == true)
{
deceased = deceased_insert();
}
case_intake = case_intake_insert();
case_client = case_client_insert();
encounter = encounter_insert();
}
catch { Insert_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
finally { Insert_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
}
public encounter encounter_insert()
{
encounter.agency_id = 0;
encounter.case_id = case_intake.case_id;
encounter.call_center_id = Convert.ToInt32(Insert_DDL_Call_Center.SelectedValue);
encounter.client_id = client.client_id;
encounter.create_date = DateTime.Now;
encounter.close_date = Convert.ToDateTime("1 / 1 / 1900");
encounter.disaster_id = Convert.ToInt32(Insert_DDlDisasters.SelectedValue);
encounter.Location_ID = 0;
encounter.Pet_Record_ID = 0;
encounter = encounter.Insert(encounter);
//GridView1.DataBind();
return encounter;
}
protected void INSERT(object sender, EventArgs e)
{
encounter = encounter_insert();
}
protected void updateDatabase()
{
//product_id_array has all product ids
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//case_intake
case_intake = case_intake_insert();
//encounter
encounter = encounter_insert();
//requestor
requestor = requestor_insert();
//requestor_Order
requestor_Order = requestor_Order_insert();
//Order_product
Order_Product = Order_Product_insert();
}
public ActionResult UpdateVital([Bind(Include = "datetime, temperature, temp_route_value, pulse, pulse_route_value, pulse_oximetry, " +
"respirations, oxygen_flow, o2_dev_method, systolic_b_pressure, diastolic_b_pressure, " +
"comment, wdl_ex, pain_scale_value, pain_level_actual, pain_level__goal, care_comment")]
UpdateVitals update, int?id, string formButton)
{
if (ModelState.IsValid)
{
nursing_pca_record pca = db.nursing_pca_record.Where(x => x.pca_id == id).FirstOrDefault();
nursing_pca_comment com = db.nursing_pca_comment.Where(s => s.pca_id == pca.pca_id).FirstOrDefault();
nursing_care_system_assessment care = db.nursing_care_system_assessment.Where(h => h.pca_id == pca.pca_id).FirstOrDefault();
encounter path = db.encounters.Where(en => en.encounter_data_id == pca.encounter_id).FirstOrDefault();
ViewBag.encounterId = path.encounter_data_id;
//care = db.nursing_care_system_assessment.Select();
care.care_system_assessment_type_id = 1;
care.wdl_ex = Convert.ToBoolean(update.wdl_ex);
care.care_system_comment = update.care_comment;
care.date_care_system_added = update.datetime;
//nursing_pca_comment com = new nursing_pca_comment();
com.pca_comment = update.comment;
com.pca_comment_type_id = 1;
com.date_comment_added = update.datetime;
ViewBag.pca_id = pca.pca_id;
pca.date_vitals_added = update.datetime;
pca.temperature = update.temperature;
pca.temp_route_type_id = update.temp_route_value;
//update.temp_route_type = pca.temp_route_type_id.ToString();
pca.pulse = update.pulse;
pca.pulse_route_type_id = update.pulse_route_value;
pca.o_two_delivery_type_id = update.o2_dev_method;
pca.respiration = update.respirations;
pca.oxygen_flow = update.oxygen_flow;
pca.pulse_oximetry = update.pulse_oximetry;
pca.pain_scale_type_id = update.pain_scale_value;
pca.pain_level_actual = update.pain_level_actual;
pca.pain_level_goal = update.pain_level__goal;
nursing_pca_record_history historyPca = new nursing_pca_record_history();
historyPca.pca_id = ViewBag.pca_id;
historyPca.date_pca_record_orginal = pca.date_vitals_added;
historyPca.date_pca_record_modified = update.datetime;
historyPca.temperature = update.temperature;
historyPca.temp_route_type_id = update.temp_route_value;
historyPca.pulse = update.pulse;
historyPca.pulse_route_type_id = update.pulse_route_value;
historyPca.respiration = update.respirations;
historyPca.pulse_oximetry = update.pulse_oximetry;
historyPca.oxygen_flow = update.oxygen_flow;
historyPca.pain_scale_type_id = update.pain_scale_value;
historyPca.pain_level_actual = update.pain_level_actual;
historyPca.pain_level_goal = update.pain_level__goal;
db.nursing_pca_record_history.Add(historyPca);
nursing_care_system_assessment_history historyCaresys = new nursing_care_system_assessment_history();
ViewBag.careSysId = care.care_system_assessment_id;
historyCaresys.pca_id = ViewBag.pca_id;
historyCaresys.care_system_assessment_id = ViewBag.careSysId;
historyCaresys.care_system_assessment_type_id = 1;
historyCaresys.date_care_system_added = pca.date_vitals_added;
historyCaresys.date_care_system_modified = update.datetime;
historyCaresys.care_system_comment = update.care_comment;
historyCaresys.wdl_ex = Convert.ToBoolean(update.wdl_ex);
db.nursing_care_system_assessment_history.Add(historyCaresys);
nursing_pca_comment_history historyCom = new nursing_pca_comment_history();
ViewBag.commentId = com.pca_comment_id;
historyCom.pca_id = ViewBag.pca_id;
historyCom.pca_comment_id = ViewBag.commentId;
historyCom.date_comment_original = pca.date_vitals_added;
historyCom.date_comment_modified = update.datetime;
historyCom.pca_comment = update.comment;
historyCom.pca_comment_type_id = 1;
db.nursing_pca_comment_history.Add(historyCom);
db.SaveChanges();
switch (formButton)
{
case "SaveList":
return(Redirect("../IndividualEncounter/" + path.encounter_id));
case "SaveContinue":
return(RedirectToAction("Edit", "BodySystems", new { pcaID = pca.pca_id, typeID = 2 }));
default:
return(Redirect("../IndividualEncounter/" + path.encounter_id));
}
}
ViewBag.CareSystems = db.nursing_care_system_assessment_type;
return(View(update));
}
public encounter encounter_insert()
{
encounter.case_id = case_intake.case_id;
encounter.agency_id = 0;//null
encounter.call_center_id = Convert.ToInt32(DDL_Call_Center.SelectedValue);
encounter.client_id = 0;
encounter.create_date = DateTime.Now;
encounter.close_date = Convert.ToDateTime(9/9/9);//null
encounter.disaster_id = Convert.ToInt32(DDL_Disaster.SelectedValue);
encounter.Location_ID = 0;//null
encounter.Pet_Record_ID = 0;//null
encounter = encounter.Insert(encounter);
return encounter;
}
protected void Save_Disaster_Enconter_info()
{
clientencounter.case_id = GlobalVariables.CaseID;
clientencounter.client_id = GlobalVariables.ClientID;
clientencounter.encounter_id = GlobalVariables.EncounterID;
clientencounter.call_center_id = Convert.ToInt32(DDL_Call_Center.SelectedValue);
clientencounter.create_date = DateTime.Now;
clientencounter.close_date = Convert.ToDateTime("9/9/9999");
EncCallCenter = EncCallCenter.Select(clientencounter.call_center_id);
if (clientencounter.encounter_id == 0)
{
clientencounter = clientencounter.Insert(clientencounter);
}
else
{
clientencounter.Update(clientencounter);
}
disasterEncounter.disaster_id = Convert.ToInt32(DDlDisasters.SelectedValue);
GlobalVariables.DisasterID = disasterEncounter.disaster_id;
disasterEncounter.encounter_id = clientencounter.encounter_id;
GlobalVariables.EncounterID = clientencounter.encounter_id;
//disasterEncounter.address_id = EncCallCenter.address_id;
if (disasterEncounter.disaster_encounter_id == 0)
{
disasterEncounter = disasterEncounter.Insert(disasterEncounter);
}
else
{
disasterEncounter.Update(disasterEncounter);
}
}
protected void Update_Select_Record(object sender, EventArgs e)
{
encounter = Update_encounter_select(Convert.ToInt32(Update_encounter_GridView.SelectedValue));
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
encounter = Insert_encounter_select(Convert.ToInt32(Insert_encounter_GridView.SelectedValue));
}
