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