public void Page_Load(object sender, EventArgs e) { wsEMR = (EmrSvc)Session[SessionVariables.Service]; var patient = wsEMR.select(Request.QueryString["localPid"]); author.Text = Session[SessionVariables.Name].ToString(); Patient.Text = patient.patientName; //var ID = Request.QueryString["localpid"]; //var PatientSID = Request.QueryString["PatientSID"]; //System.Timers.Timer aTimer = new System.Timers.Timer(); //aTimer.Elapsed += new ElapsedEventHandler(OnTimedEvent); //aTimer.Interval = 35000; //aTimer.Enabled = true; //aTimer.Start(); //if (aTimer.Interval < 30000) //{ // MessageBox.Show("This session is ending in two minutes. Be sure to submit your note to CPRS, or you will be redirected to the login screen"); //} //if (aTimer.Interval < 0001) //{ // aTimer.Stop(); // aTimer.Enabled = false; // MessageBox.Show("This session has ended. You will now be redirected to the CPRS Login Page"); // Session.Abandon(); // wsEMR.disconnect(); // Session.Contents.RemoveAll(); // Response.Redirect("CPRSLogin.aspx?localpid=" + ID + "&PatientSID=" + PatientSID); //} }
protected void BiopsyResults_SelectedIndexChanged(object sender, EventArgs e) { try { wsEMR = (EmrSvc)Session[SessionVariables.Service]; if (!IsPostBack) { var patient = wsEMR.select(Request.QueryString["localPid"]); author.Text = Session[SessionVariables.Name].ToString(); Patient.Text = patient.patientName; } else if (IsPostBack) { var patient = wsEMR.select(Request.QueryString["localPid"]); int pt = Convert.ToInt32(Request.QueryString["PatientSID"]); //author.Text = Session[SessionVariables.Name].ToString(); //Patient.Text = patient.patientName; var context = new CohortDBContext(); //Database.SetInitializer<CohortDBContext>(null); //var pid = context.PatientCohorts.Where(p => p.PatientSSN == patient.ssn).SingleOrDefault(); var genotype = (from pc in context.PatientCohorts where pc.PatientSID == pt select pc.Genotype).First(); //var lab = pid.PatientLabs.OrderByDescending(Lab => Lab.LabChemSpecimenDateTime).Where(Lab => Lab.HepCAntibody != null) // .Select(Lab => Lab.HepCAntibody).First(); //var lab = pid.PatientLabs.OrderByDescending(Lab => Lab.LabChemSpecimenDateTime).First(); string br = drpBiopsyResults.Text; string week = drpWeek.Text; string drug = drpDrug.Text; string therapy = drpTherapy.Text; string duration = drpDuration.Text; string physical = drpPhysical.Text; string mental = drpMental.Text; string doses = drpDoses.Text; string biopsyDone = drpLiverBiopsy.Text; //string biopsyDone = hide.Value.ToString(); string physExam = null; string GeneralcbAlert = null; string strPhysical = ""; foreach(ListItem Item in PhysicalSymptoms.Items) { if(Item.Selected) { if (strPhysical.StartsWith("Physical Symptoms: ")) { strPhysical = strPhysical + ", " + Item.Value; } else strPhysical = "Physical Symptoms: " + Item.Value; } } txtboxNote.Text = patient.name.ToString() + " is currently on week " + week + " of a planned total duration of therapy of " + duration + " weeks for treatment of cHCV genotype " + genotype + " with \n" + drug + ". " + biopsyDone + br + " \nPatient " + physical + " physical adverse drug effects " + " \nPatient " + mental + " mental health adverse drug effects " + " \nSince last visit, adherence to therapy has been " + therapy + " as patient reports a total of " + doses + " missed doses.\n" + physExam + GeneralcbAlert + strPhysical ; } } catch(NullReferenceException ex) { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('" + ex.Message + "')", true); } }
protected void submit_Click(object sender, EventArgs e) { string connString = ConfigurationManager.ConnectionStrings["CDSTProductionConnectionString"].ConnectionString; SqlConnection Conn = null; var patient = wsEMR.select(Request.QueryString["localPid"]); Conn = new SqlConnection(connString); Conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = Conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO HepCTracking(PatientSID, PatientIEN, PatientName, Author, CycleWeek, PlannedDuration, TreatmentRegimen, BiopsyResults, AdherenceToTherapy, MissedDoses, NoteDate) VALUES(@PatientSID, @PatientIEN, @PatientName, @Author, @CycleWeek, @PlannedDuration, @TreatmentRegimen, @BiopsyResults, @AdherenceToTherapy, @MissedDoses, @NoteDate)"; cmd.Parameters.AddWithValue("@PatientSID", Request.QueryString["PatientSID"]); cmd.Parameters.AddWithValue("@PatientIEN", Request.QueryString["localPID"]); cmd.Parameters.AddWithValue("@PatientName", patient.name.ToString()); cmd.Parameters.AddWithValue("@Author", Session[SessionVariables.Name].ToString()); cmd.Parameters.AddWithValue("@CycleWeek", drpWeek.SelectedValue); cmd.Parameters.AddWithValue("@PlannedDuration", drpDuration.SelectedValue); cmd.Parameters.AddWithValue("@TreatmentRegimen", drpDrug.SelectedValue); cmd.Parameters.AddWithValue("@BiopsyResults", drpBiopsyResults.SelectedValue); cmd.Parameters.AddWithValue("@AdherenceToTherapy", drpTherapy.SelectedValue); cmd.Parameters.AddWithValue("@MissedDoses", drpDoses.SelectedValue); cmd.Parameters.AddWithValue("@NoteDate", DateTime.Now.ToString()); cmd.ExecuteReader(); } if (Conn != null) { Conn.Close(); } wsEMR = (EmrSvc)Session[SessionVariables.Service]; if (wsEMR == null) { Response.Redirect("CPRSLogin.aspx"); } String strExamDate1 = DateTime.Now.ToString("yyyyMMdd.HHmmss"); var EncounterString = "182;" + strExamDate1 + ";E"; if (IsPostBack) { //1971 was the TIUDocumentDefinitionIEN for the 10-10 M note, 4514 Is the new IEN for the //Hepatitis C Treatment Follow-up note var NoteResult = wsEMR.writeNote("4514", EncounterString, txtboxNote.Text, Session[SessionVariables.UserDUZ].ToString(), "", "", ""); if (!string.IsNullOrWhiteSpace(txtSigCode.Text)) { var SignNote = wsEMR.signNote(NoteResult.id, Session[SessionVariables.UserDUZ].ToString(), txtSigCode.Text); } } Session.Abandon(); wsEMR.disconnect(); Session.Contents.RemoveAll(); Response.Redirect("Success.aspx"); }
public VistaDao() { _emrSvc = new EmrSvc(); _emrSvc.CookieContainer = new System.Net.CookieContainer(); }