private void RunReport()
{
DataTable report = GetReport();
string[] columns = report.Columns.Cast <DataColumn>().Select(c => c.ColumnName).ToArray();
// build header
HeaderRptr.DataSource = columns;
HeaderRptr.DataBind();
// build results
ResultsGrid.DataSource = report;
ResultsGrid.DataBind();
}
private void BuildInventory(DataView inventoryView)
{
selectedColumns = GetSpecimenColumns();
// build header
HeaderRptr.DataSource = selectedColumns;
HeaderRptr.DataBind();
// build data
string sortColumn = SortColumn.Value;
string sortDirection = SortDirection.Value;
if (!string.IsNullOrEmpty(sortColumn))
{
// special case
if (sortColumn == "PtProtocolStudyId" && inventoryView.Count > 0)
{
inventoryView = PatientProtocolController.SortPatientsByStudyId(inventoryView.ToTable(), sortDirection);
}
else
{
inventoryView.Sort = sortColumn + " " + sortDirection;
}
}
// do not show NULL statuses
inventoryView.RowFilter = Specimen.SpecimenStatus + " IS NOT NULL";
bool hideBankedSpeicmens = BankedSpecimensPreference.Checked && BankedSpecimensPreference.Visible;
if (hideBankedSpeicmens)
{
inventoryView.RowFilter += " AND SpecimenSubType NOT IN ('Serum', 'Plasma', 'PAXGen')";
}
SpecimenInventoryRows.DataSource = inventoryView;
SpecimenInventoryRows.DataBind();
RecordCount.Text = inventoryView.Count + " Record(s)";
}
