/// <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()); } }