/// <summary>
///
/// </summary>
/// <param name="typeMatch"></param>
/// <returns></returns>
protected DataTable GetSurveyItemsByType(string typeMatch)
{
string sqlMatch = typeMatch + "%";
// i.e., "Breast Q: Implants" => ["Breast Q: Implants 2 weeks", "Breast Q: Implants 6 weeks", ...]
DataTable surveysByType = surveyDA.GetSurveysAndItemsByType(patientID, sqlMatch, null, null);
return(surveysByType);
}
private DataTable AllKidneyQOLSurveys()
{
// account for special naming conventions
var surveys = from type in KIDNEY_SURVEY_TYPES
// search by wild card
let searchType = type + "%"
let rows = da.GetSurveysAndItemsByType(patientID, searchType, null, null).AsEnumerable()
select rows;
var allRows = surveys.Where(r => r.Count() > 0).SelectMany(r => r);
if (allRows.Count() > 0)
{
return(allRows.CopyToDataTable());
}
else
{
return(new DataTable());
}
}