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