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;
}
}
