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