public void refreshSuggestions() { List <string> standardSuggestOS = new List <string>(); standardSuggestOS.Add("Gastrointestinal"); standardSuggestOS.Add("Gynecological"); standardSuggestOS.Add("Cardiovascular"); standardSuggestOS.Add("Dermatological"); standardSuggestOS.Add("Genitourinary"); standardSuggestOS.Add("Hematological"); standardSuggestOS.Add("Bone and soft tissue"); standardSuggestOS.Add("Hepatobiliary"); standardSuggestOS.Add("Nervous"); standardSuggestOS.Add("Pulmonary"); standardSuggestOS.Add("Endocrine"); suggestionOrganSystem = new List <string>(SqliteDataAcces.GetListOrganSystem()); foreach (string st in standardSuggestOS) { if (suggestionOrganSystem.IndexOf(st) == -1) { suggestionOrganSystem.Add(st); } } // adds standard suggestions for diagnostic category List <string> standardSuggestCategory = new List <string>(); standardSuggestCategory.Add("Benign"); standardSuggestCategory.Add("Malignant"); standardSuggestCategory.Add("Infectious"); standardSuggestCategory.Add("Normal"); suggestionCategory = new List <string>(SqliteDataAcces.GetUniqueDiagnosticCategory()); foreach (string st in standardSuggestCategory) { if (suggestionCategory.IndexOf(st) == -1) { suggestionCategory.Add(st); } } suggestionDiagnosis = new List <string>(SqliteDataAcces.GetUniqueDiagnosis().Where(x => x.ToString().Trim() != "")); suggestionOrgan = new List <string>(SqliteDataAcces.GetListOrgan().Where(x => x.ToString().Trim() != "")); suggestionEvaluation = new ObservableCollection <string>(SqliteDataAcces.GetUniqueEvaluations().Where(x => x.ToString().Trim() != "")); suggestionService = new ObservableCollection <string>(SqliteDataAcces.GetUniqueService().Where(x => x.ToString().Trim() != "")); var listeval = new List <string>() { "NA", "1 - Style changes", "2 - Grammar and spelling", "3 - Interpretation - Minor diagnostic alteration", "3 - Microscopic - Minor diagnostic alteration", "4 - Interpretation - Major diagnostic alteration", "4 - Interpretation - Major diagnostic alteration", "1 - Perfect" }; foreach (var lv in listeval) { if (!(suggestionEvaluation.Contains(lv))) { suggestionEvaluation.Add(lv); } } suggestionEvaluation = new ObservableCollection <string>(suggestionEvaluation.OrderBy(x => x.ToString())); var listService = new List <string>() { "Routine", "Frozen", "Biopsy" }; foreach (var lv in listService) { if (!(suggestionService.Contains(lv))) { suggestionService.Add(lv); } } }