protected void GetProcedures(int PatientID, string FormName, string FormType) { DataSet ProcDs, ProcAsstDs; ProcedureDa ProcDa = new ProcedureDa(); ProcDs = ProcDa.FormGetRecords(PatientID, FormName, FormType); ProcAsstDs = ProcDa.FormGetProcAssistantRecords(PatientID, FormName, FormType); if (ProcDs.Tables.Count > 0 && ProcDs.Tables[0].Rows.Count > 0) { NoGynProcMsgTr2.Visible = false; ProcDs.Tables[0].TableName = "Procedures"; ProcAsstDs.Tables[0].TableName = "ProcedureAssistants"; DataSet ProcAsstCoreDs = new DataSet(); ProcAsstCoreDs.Tables.Add(ProcDs.Tables[0].Copy()); ProcAsstCoreDs.Tables.Add(ProcAsstDs.Tables[0].Copy()); ProcAsstCoreDs.Relations.Add("myrelation", ProcAsstCoreDs.Tables["Procedures"].Columns[Procedure.ProcedureId], ProcAsstCoreDs.Tables["ProcedureAssistants"].Columns[Procedure.ProcedureId]); GynProcRpt2.DataSource = ProcAsstCoreDs.Tables["Procedures"].DefaultView; GynProcRpt2.DataBind(); } else { NoGynProcMsgTr2.Visible = true; } }
protected void BuildCryotherapy() { ProcedureDa da = new ProcedureDa(); DataSet ds = da.FormGetSpecialRecords(this._patientId, this._eformName, "Dynamic", Procedure.ProcName, "LIKE", "'%CRYO%'"); if (ds.Tables[0].Rows.Count > 0) { rptCryo.DataSource = ds.Tables[0].DefaultView; rptCryo.DataBind(); } }
protected void BuildSurgicalHistory(int PatientID, string FormName, string FormType) { ProcedureDa procdedureDa = new ProcedureDa(); DataSet ds; ds = procdedureDa.FormGetRecords(PatientID, FormName, FormType); if (ds.Tables[0].Rows.Count > 0) { rptSurgicalHistory.DataSource = ds.Tables[0].DefaultView; rptSurgicalHistory.DataBind(); } }
protected void BuildSurgicalHistory() { ProcedureDa pDa = new ProcedureDa(); DataSet pDs = pDa.FormGetSpecialRecords(this._patientId, this._eformName, "Dynamic", BOL.Procedure.ProcName, "IN", "'Laparoscopic Distal Gastrectomy', 'Laparoscopic Proximal Gastrectomy', 'Laparoscopic Total Gastrectomy', 'Laparoscopic Esophagogastrectomy Proximal', 'Laparoscopic Esophagogastrectomy Total', 'Laparoscopic Wedge Resection', 'Diagnostic Laparoscopy'"); if (pDs.Tables.Count > 0 && pDs.Tables[0].Rows.Count > 0) { rptSurgicalHistory.DataSource = pDs.Tables[0].DefaultView; rptSurgicalHistory.DataBind(); NoSurgicalHistoryMsgTr.Visible = false; SurgicalHistoryMsg.Visible = true; } }
protected void BuildPlannedProcedures(int PatientId, string FormName, string FormType) { ProcedureDa da = new ProcedureDa(); DataSet ds; ds = da.FormGetRecords(PatientId, FormName, FormType); if (ds.Tables[0].Rows.Count > 0) { DataView dv = ds.Tables[0].DefaultView; dv.RowFilter = Procedure.ProcPending + " = " + true; rptPlannedProcedures.DataSource = dv; rptPlannedProcedures.DataBind(); } }
protected void BuildSurgicalHistory() { ProcedureDa pDa = new ProcedureDa(); DataSet pDs = pDa.FormGetSpecialRecords(this._patientId, this._eformName, "Dynamic", BOL.Procedure.ProcName, "IN", "'Laparoscopic Total Gastrectomy', 'Total Gastrectomy', 'Laparoscopic Distal Gastrectomy', 'Esophagogastrectomy Total', 'Laparoscopic Proximal Gastrectomy', 'Esophagogastrectomy Proximal', 'Laparoscopic Wedge Resection', 'Robotic Esophagogastrectomy Proximal', 'Other/Bypass', 'Robotic Esophagogastrectomy Total', 'Laparoscopic Esophagogastrectomy Proximal', 'Bypass/Gastrojejunostomy', 'Laparoscopic Esophagogastrectomy Total', 'Exploratory Laparotomy', 'Other Resection', 'Wedge Resection', 'Other surgery/Gastric Cancer', 'Completion Gastrectomy', 'Distal Gastrectomy', 'Proximal Gastrectomy'"); if (pDs.Tables.Count > 0 && pDs.Tables[0].Rows.Count > 0) { rptSurgicalHistory.DataSource = pDs.Tables[0].DefaultView; rptSurgicalHistory.DataBind(); // NoSurgicalHistoryMsgTr.Visible = false; SurgicalHistoryMsg.Visible = true; NoResectionHistoryMsg.Visible = false; ResectionHistoryMsg.Visible = true; } }
protected void BuildSurgicalHistory(int PatientId, string FormName, string FormType) { ProcedureDa da = new ProcedureDa(); DataSet ds = da.FormGetRecords(PatientId, FormName, FormType); DataView dv = new DataView(ds.Tables[0]); dv.RowFilter = Procedure.ProcPending + " IS NULL OR " + Procedure.ProcPending + " = " + false; DataTable dt = dv.ToTable(); if (dt.Rows.Count > 0) { rptSurgicalHistory.DataSource = dt.DefaultView; rptSurgicalHistory.DataBind(); NoSurgicalHistoryMsgTr.Visible = false; } }
protected DataRow PatientNephrectomy(int PatientID, string FormName, string FormType) { DataRow Nephrectomy = null; ProcedureDa procDa = new ProcedureDa(); DataSet procDs = procDa.FormGetSpecialRecords(PatientID, FormName, FormType, BOL.Procedure.ProcName, " IN ", "'Nephrectomy','Partial Nephrectomy','Laparoscopic Nephroureterectomy','Partial for Horshoe Kidney','Laparoscopic Partial Nephrectomy','Nephroureterectomy','Laparoscopic Radical Nephrectomy','Radical Nephrectomy', 'Robotic Partial Nephrectomy', 'Robotic Radical Nephrectomy'"); if (procDs.Tables.Count > 0 && procDs.Tables[0].Rows.Count > 0) { DataView procDv = new DataView(procDs.Tables[0]); procDv.RowFilter = BOL.Procedure.ProcDate + " IS NOT NULL"; procDv.Sort = BOL.Procedure.ProcDate + " ASC "; if (procDv.Count > 0) { Nephrectomy = procDv[0].Row; } } return(Nephrectomy); }
protected void GetBiopsies(int PatientID, string FormName, string FormType) { ProcedureDa procDa = new ProcedureDa(); DataSet procDs = procDa.FormGetSpecialRecords(PatientID, FormName, FormType, Procedure.ProcName, " IN ", "'Biopsy'"); if (procDs.Tables.Count > 0 && procDs.Tables[0].Rows.Count > 0) { // limit to last 10 records PastRecordsCountProcedure = procDs.Tables[0].Rows.Count; DataView procDv = new DataView(procDs.Tables[0]); procDv.Sort = Procedure.ProcDate + " DESC "; procDv = GetTopDataViewRows(procDv, 10); procDv.Sort = Procedure.ProcDate + " ASC "; BiopsyHx.DataSource = procDv; BiopsyHx.DataBind(); } else { PastRecordsCountProcedure = 0; } }
protected void BuildSurgicalHistory(int PatientID, string FormName, string FormType) { DataSet procDs, procpathDs; ProcedureDa procdedureDa = new ProcedureDa(); procDs = procdedureDa.FormGetRecords(PatientID, FormName, FormType); procpathDs = procdedureDa.FormGetProcPathRecords(PatientID, FormName, FormType); if (procDs.Tables.Count > 0 && procDs.Tables[0].Rows.Count > 0) { NoProcedureHistoryMsgTr.Visible = false; procDs.Tables[0].TableName = "ProcHistory"; procpathDs.Tables[0].TableName = "ProcPathHistory"; DataSet procpathDs2 = new DataSet(); procpathDs2.Tables.Add(procDs.Tables[0].Copy()); procpathDs2.Tables.Add(procpathDs.Tables[0].Copy()); procpathDs2.Relations.Add("myrelation", procpathDs2.Tables["ProcHistory"].Columns[Procedure.ProcedureId], procpathDs2.Tables["ProcPathHistory"].Columns[Procedure.ProcedureId]); rptSurgicalHistory.DataSource = procpathDs2.Tables["ProcPathHistory"].DefaultView; rptSurgicalHistory.DataBind(); } }
protected void GetInterventionalRadiology(int PatientID, string FormName, string FormType) { ProcedureDa procDa = new ProcedureDa(); DataSet taceDs = procDa.FormGetSpecialRecords(PatientID, FormName, FormType, Procedure.ProcName, " IN ", "'TACE'"); if (taceDs.Tables.Count > 0 && taceDs.Tables[0].Rows.Count > 0) { // limit to last 10 records PastRecordsCountTace = taceDs.Tables[0].Rows.Count; DataView taceDv = new DataView(taceDs.Tables[0]); taceDv.Sort = Procedure.ProcDate + " DESC "; taceDv = GetTopDataViewRows(taceDv, 10); taceDv.Sort = Procedure.ProcDate + " ASC "; TaceHx.DataSource = taceDv; TaceHx.DataBind(); } else { PastRecordsCountTace = 0; } DataSet pveDs = procDa.FormGetSpecialRecords(PatientID, FormName, FormType, Procedure.ProcName, " IN ", "'PVE'"); if (pveDs.Tables.Count > 0 && pveDs.Tables[0].Rows.Count > 0) { // limit to last 10 records PastRecordsCountPve = pveDs.Tables[0].Rows.Count; DataView pveDv = new DataView(pveDs.Tables[0]); pveDv.Sort = Procedure.ProcDate + " DESC "; pveDv = GetTopDataViewRows(pveDv, 10); pveDv.Sort = Procedure.ProcDate + " ASC "; PveHx.DataSource = pveDv; PveHx.DataBind(); } else { PastRecordsCountPve = 0; } DataSet rfaDs = procDa.FormGetSpecialRecords(PatientID, FormName, FormType, Procedure.ProcName, " IN ", "'RFA'"); if (rfaDs.Tables.Count > 0 && rfaDs.Tables[0].Rows.Count > 0) { // limit to last 10 records PastRecordsCountRfa = rfaDs.Tables[0].Rows.Count; DataView rfaDv = new DataView(rfaDs.Tables[0]); rfaDv.Sort = Procedure.ProcDate + " DESC "; rfaDv = GetTopDataViewRows(rfaDv, 10); rfaDv.Sort = Procedure.ProcDate + " ASC "; RfaHx.DataSource = rfaDv; RfaHx.DataBind(); } else { PastRecordsCountRfa = 0; } }