public WindowReportEditor()
 {
     InitializeComponent();
     txtCaseNumber.Text = SqliteDataAcces.CaseNumberPrefix;
     foreach (var a in SqliteDataAcces.GetListAuthor())
     {
         cmbAuthor.Items.Add(a.AuthorID);
     }
     foreach (var a in SqliteDataAcces.GetUniqueService())
     {
         cmbService.Items.Add(a);
     }
 }
        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);
                }
            }
        }