protected void SortAndBindRecords(string sortCriteria) { string datasetSql = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]); ReportDa da = new ReportDa(); DataTable sortdt = da.GetNeuroPendingItems(datasetSql); string SortField; switch (sortCriteria) { case "PtName": SortField = "PtFirstName"; SortData(sortdt, SortField); break; case "PtMRN": SortField = "PtMRN"; SortData(sortdt, SortField); break; case "VitalStatus": SortField = "VitalStatus"; SortData(sortdt, SortField); break; case "LastAccessed": SortField = "LastAccessed"; SortData(sortdt, SortField); break; } reportResults.DataSource = sortdt.DefaultView; reportResults.DataBind(); }
override protected void Page_Load(object sender, System.EventArgs e) { datasetSql = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]); ReportDa da = new ReportDa(); DataTable dt = da.GetNeuroPendingItems(datasetSql); if (dt.Rows.Count > 0) { reportResults.DataSource = dt.DefaultView; reportResults.DataBind(); // log report view base.LogReportView(); resultMessage = +dt.Rows.Count + " patient(s) returned"; } else { resultMessage = "There are no neuro patients with pending items"; } }