public DTVelocityObj PtDTVelocity(int patientId, DateTime startDate, DateTime endDate, string threshold) { DTVelocityObj dtv = new DTVelocityObj(); DataSet ds = BCMPSAGraphDA.GetPSADTVelocity(patientId, startDate, endDate, threshold); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; dtv.PSAVelocity = dr["Velocity"].ToString(); dtv.DT = dr["DoubleTime"].ToString(); } else { dtv = null; } return(dtv); }
public PatStatObj PtGraph(int patientId) { // SqlCommand cmd; PatStatObj a = new PatStatObj(); //conn.Open(); try { /* Lab Tests */ DataSet ds = BCMPSAGraphDA.GetAllPSAs(patientId); //SqlCommand cmd = new SqlCommand("select * from LabTests where patientID = " + patientId + " and (LabTest = 'PSA' or LabTest = 'uPSA') and LabDate is not null order by LabDate;",conn); //rdr = cmd.ExecuteReader(); ArrayList aout = new ArrayList(); TimePoint thisTimePoint; foreach (DataRow dr in ds.Tables[0].Rows) { thisTimePoint = new TimePoint(); thisTimePoint.date = dr["LabDate"].ToString(); thisTimePoint.testType = dr["LabTest"].ToString(); thisTimePoint.psa = dr["LabResult"].ToString(); aout.Add(thisTimePoint); } a.patTimePt = (TimePoint[])aout.ToArray(typeof(TimePoint)); a.nTimePoints = a.patTimePt.Length; /* Operation Date */ Hashtable ht = BCMPSAGraphDA.GetProstSurgeryRecord(patientId); if (ht["RP_Date"] != null && ht["RP_Date"].ToString() != "") { a.primaryTx = a.primaryTx = ht["RP_Date"].ToString(); } else { a.primaryTx = ""; } /* Biopsies */ ds = BCMPSAGraphDA.GetAllBiopsiesFlash(patientId); aout = new ArrayList(); Biopsies thisBx; foreach (DataRow dr in ds.Tables[0].Rows) { thisBx = new Biopsies(); thisBx.date = dr["BxDate"].ToString(); thisBx.bxResult = dr["BxResult"].ToString(); thisBx.bxPositive = dr["BxPositive"].ToString(); aout.Add(thisBx); } a.patBx = (Biopsies[])aout.ToArray(typeof(Biopsies)); a.nBx = a.patBx.Length; /* Get various status entries (METS, Death and Recurrence) */ ds = BCMPSAGraphDA.GetChronoListStatusEntries(patientId); a.mets = ""; a.death = ""; if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["VarValue"].ToString() == "DOD") { a.death = dr["VarDate"].ToString(); } else if (dr["VarValue"].ToString() == "METS") { a.mets = dr["VarDate"].ToString(); } } } ds = BCMPSAGraphDA.GetRecurredDate(patientId); if (ds.Tables[0].Rows.Count > 0) { a.BCR = ds.Tables[0].Rows[0]["RecurredDate"].ToString(); } else { a.BCR = ""; } /* Patient Name */ string ptName = BCMPSAGraphDA.GetPtFullName(patientId); if (ptName.Length > 0) { a.patientName = ptName; } else { a.patientName = ""; } /* Path Summary */ ds = BCMPSAGraphDA.GetPathSummaryFlash(patientId); if (ds.Tables[0].Rows.Count > 0) { // use calculated column instead to match value in chron list, updated fs 7/7/05 // a.pathSummary = ds.Tables[0].Rows[0]["PathSummary"].ToString(); a.pathSummary = ds.Tables[0].Rows[0]["CalcPathSummary"].ToString(); } else { a.pathSummary = ""; } /* Hormone Therapy (only returns the first date. Can expand later if needed) */ // DEPENDENCY: sp looks on for MedTxType IN ('AA','AA/LHRH','HORM','LHRH','ADT', '5_ALPHA') ds = BCMPSAGraphDA.GetFirstHormoneTherapy(patientId); if (ds.Tables[0].Rows.Count > 0) { a.hormoneTx = ds.Tables[0].Rows[0]["MedTxDate"].ToString(); } else { a.hormoneTx = ""; } /* Radiation Therapy (only returns the first date. Can expand later if needed) */ // DEPENDENCY: sp looks only for type IN ('Rad Tx','Conventional', 'Conformal','XRT') ds = BCMPSAGraphDA.GetFirstRadiationTherapy(patientId); if (ds.Tables[0].Rows.Count > 0) { a.XRT = ds.Tables[0].Rows[0]["RadTxDate"].ToString(); } else { a.XRT = ""; } } catch (Exception ex) { // updated 7/7/05 fs ExceptionHandler.Publish(ex); //System.Diagnostics.EventLog.WriteEntry("PSAGraph",ex.Message,EventLogEntryType.Error); } return(a); }