} // Done... Tested... private void LoadData(int intPatientID, bool Complete) { DataTable tblResults; if (AppMode) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } string strProc; strProc = "wsGetPatientByID"; InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection(); parameters.Add(new SqlParameter("@PatientID", intPatientID)); tblResults = clsUtility.ExecuteSP_DataTable(strProc, parameters); if (Complete == true) { LoadControls(tblResults); } else { LoadControlsIncomplete(tblResults); } } // Obsolete...
public DataTable getMedicalRecords(int PatientID) { clsUtility.Connection = getConnectionString(); InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection(); parameters.Add(new SqlParameter("@PatientID", PatientID)); DataTable dT = clsUtility.ExecuteSP_DataTable("getMedicalInfoByPatientID", parameters); return(dT); }