private void BuildDiseaseTables()
{
if (QueryDiseaseId.HasValue && !string.IsNullOrEmpty(QueryTable) && !string.IsNullOrEmpty(QueryField))
{
// set grid keys
string tablePriKeyName = BOL.BusinessObject.GetPrimaryKeyName(QueryTable);
DiseaseTableGrid.DataKeyNames = new string[] { DiseaseAttributeValue.DiseaseAttributeValueId, tablePriKeyName };
// get normalized table
var tableDiseaseRecords = dc.GetTableRecordsByDisease(QueryDiseaseId.Value, QueryTable).DefaultView;
tableDiseaseRecords.Sort = QueryField + " ASC";
// bind to main grid
DiseaseTableGrid.DataSource = tableDiseaseRecords;
DiseaseTableGrid.DataBind();
}
}
/// <summary>
/// Builds a list of avaiable surveys (optionally filtered by disease)
/// </summary>
private void BuildSurveys()
{
DataView surveys;
// filter by disease
if (QueryDiseaseId.HasValue)
{
Caisis.Controller.DiseaseController dc = new Caisis.Controller.DiseaseController();
surveys = dc.GetTableRecordsByDisease(QueryDiseaseId.Value, new MetadataSurvey().TableName).DefaultView;
surveys.RowFilter = Disease.DiseaseId + " IS NOT NULL";
}
// otherwise normal
else
{
surveys = BOL.BusinessObject.GetAllAsDataView <BOL.MetadataSurvey>();
}
surveys.Sort = BOL.MetadataSurvey.SurveyType + " ASC";
SurveysRptr.DataSource = surveys;
SurveysRptr.DataBind();
NoTablesMessage.Visible = surveys.Count == 0;
}
