private static void LoadDepartmentsAndDoctors(FirebirdClient firebirdClient) { Logging.ToLog("DataProvider - Получение данных для оценки врачей"); using (DataTable dataTableSurvey = firebirdClient.GetDataTable(InfoKiosk.Services.Config.Instance.SqlGetSurveyInfo)) { Logging.ToLog("DataProvider - Получено строк: " + dataTableSurvey.Rows.Count); foreach (DataRow dataRow in dataTableSurvey.Rows) { string dept = ControlsFactory.FirstCharToUpper(dataRow["DEPARTMENT"].ToString(), true); if (!Survey.ContainsKey(dept)) { Survey.Add(dept, new List <ItemDoctor>()); } string docname = dataRow["DOCNAME"].ToString(); string depNum = dataRow["DEPNUM"].ToString(); string dCode = dataRow["DCODE"].ToString(); string docPosition = dataRow["DOCPOSITION"].ToString(); ItemDoctor doc = new ItemDoctor(docname, docPosition, dept, dCode, depNum); #pragma warning disable CA1307 // Specify StringComparison if (Survey[dept].FindAll(x => x.Code.Equals(dCode)).Count == 0) #pragma warning restore CA1307 // Specify StringComparison { Survey[dept].Add(doc); } } } }