예제 #1
0
        public void WhenIIntroduceTheTerminalICheckTerminalNameField()
        {
            BDMainPage BDMain = new BDMainPage();

            BDMain.OpenSorting();
            TerminalSettingPage TSettings = new TerminalSettingPage();

            IsTrue(TSettings.AssertForChooseTerminalName(), "Что-то пошло не так, нет поля или заголовка выбора терминала");
        }
예제 #2
0
        public void WhenIConfirmParent_BatchIdForStartSorting()
        {
            BDMainPage BDMain = new BDMainPage();

            BDMain.OpenSorting();
            IsTrue(BDMain.AssertOpenSorting(), "Заголовок рабочего места не найден");

            BDSortingPage sortingPage = new BDSortingPage();

            sortingPage.AssertTheButtonIsVisible();
            sortingPage.ClickCreateBatch();
            sortingPage.AssertTheConfirmBatchFieldIsVisible();
            sortingPage.SetParentBatchID();
        }
예제 #3
0
        public void ThenIFill_OutTheSorting_PlanchetBySamplesOwnOfUnionTestWithBiomaterialAndLocationAndVKAndOKOAndPKO(int count, string own, string union, List <String> testname, string bm, string location, List <String> VKName, List <String> OKOName, List <String> PKOName)
        {
            //переходим в РМ сортировка
            BDMainPage BDMain = new BDMainPage();

            BDMain.OpenSorting();
            IsTrue(BDMain.AssertOpenSorting(), "Заголовок рабочего места не найден");
            // создаем новый бэтч
            BDSortingPage sortingPage = new BDSortingPage();

            sortingPage.AssertTheButtonIsVisible();
            sortingPage.ClickCreateBatch();
            sortingPage.AssertTheConfirmBatchFieldIsVisible();
            sortingPage.SetParentBatchID();
            // подтверждаем своим ШК
            BDPlanshetPositionPage bDPlanshetPositionPage = new BDPlanshetPositionPage();

            IsTrue(bDPlanshetPositionPage.AssertConfirmBatchWindow(), "Нет окна для подтверждения установки планшета");
            bDPlanshetPositionPage.ConfirmUsercodeInPlanshetPositionPage();
            {
                int countOfTests = testname.Count();
                MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
                string command = "";

                if (own == "only") // для случая, когда образец назначен ТОЛЬКО на тест/тесты
                {
                    if (countOfTests == 1)
                    {
                        command = $@"USE LW08v6
                    select TOP({count}) s.TEXT_ID
                    from
                    (select SAMPLE_NUMBER, count(ANALYSIS) as TestCommonCount
                    from [LW08v6].[dbo].[TEST] t with (nolock) 
                    group by SAMPLE_NUMBER
                    having count(ANALYSIS) = 1) MonoSamples
                    join TEST t on t.SAMPLE_NUMBER = MonoSamples.SAMPLE_NUMBER
                    join SAMPLE s on S.SAMPLE_NUMBER = t.SAMPLE_NUMBER
                    where t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' 
                    and s.LOCATION = '{location}' and t.ANALYSIS='{testname[0]}' and s.SAMPLE_TYPE ='{bm}'";
                    }
                    if (countOfTests == 2)
                    {
                        if (union == "")
                        {
                            command = $@"USE LW08v6
                    select TOP({count}) s.TEXT_ID as Sample
                    from TEST t
                    join SAMPLE s on t.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                    where  t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and s.SAMPLE_TYPE ='{bm}'
                    and t.ANALYSIS = '{testname[0]}' 
                    and exists (select top 1 1 from TEST t1 where  t1.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                    and t1.ANALYSIS = '{testname[1]}') 
                    and not exists (select top 1 1 from TEST t1 where  t1.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                    and t1.ANALYSIS not in  ('{testname[0]}', '{testname[1]}'))";
                        }
                        else if (union == "on")
                        {
                            command = $@"USE LW08v6 
                    select top({count}) s.TEXT_ID, s.STATUS, t.STATUS, s.RECD_DATE, s.ORDER_NUM, s.sample_type, t.ANALYSIS from test t with(nolock)
                    inner join SAMPLE s with(nolock) on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    where t.status='I' and t.ANALYSIS='{testname[0]}' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and sample_type='{bm}'
                    union
                    select top({count}) s.TEXT_ID, s.STATUS, t.STATUS, s.RECD_DATE, s.ORDER_NUM, s.sample_type, t.ANALYSIS from test t with(nolock)
                    inner join SAMPLE s with(nolock) on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    where t.status='I' and t.ANALYSIS='{testname[1]}' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and sample_type='{bm}'";
                        }
                    }
                }

                if (countOfTests == 2) // если 2 теста в коллекции, выполняем скрипт:
                {
                    if (union == "")
                    {
                        command = $@"USE LW08v6
                    select TOP({count}) Sample
                    from
                    (select s.TEXT_ID as Sample, t.ANALYSIS as Test
                    from TEST t
                    join SAMPLE s on t.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                    where  t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and s.SAMPLE_TYPE ='{bm}'
                    and t.ANALYSIS in ('{testname[0]}', '{testname[1]}')
                    group by TEXT_ID, ANALYSIS) sub
                    group by Sample
                    having count(Test) = 2";
                    }
                    else if (union == "on")
                    {
                        command = $@"USE LW08v6 
                    select top({count}) s.TEXT_ID from test t with(nolock)
                    inner join SAMPLE s with(nolock) on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    where t.status='I' and t.ANALYSIS='{testname[0]}' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and sample_type='{bm}'
                    union
                    select top({count}) s.TEXT_ID from test t with(nolock)
                    inner join SAMPLE s with(nolock) on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    where t.status='I' and t.ANALYSIS='{testname[1]}' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and sample_type='{bm}'";
                    }
                }
                else if (countOfTests == 1) // если 1 тест в коллекции, выполняем скрипт:
                {
                    command = $@"USE LW08v6
                SELECT TOP({count}) s.TEXT_ID FROM test t with (nolock)
                inner join SAMPLE s on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                WHERE t.status='I' and t.ANALYSIS='{testname[0]}' 
                and s.TEMPLATE = 'smp_in' and s.status='I' and s.SAMPLE_TYPE ='{bm}' 
                and s.LOCATION = '{location}'";
                }
                else if (countOfTests == 3) // если 3 теста в коллекции, выполняем скрипт:
                {
                    command = $@"USE LW08v6
                select TOP ({count})Sample
                from
                (select s.TEXT_ID as Sample, t.ANALYSIS as Test
                from TEST t
                join SAMPLE s on t.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                where  t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and s.SAMPLE_TYPE ='{bm}'
                and t.ANALYSIS in ('{testname[0]}', '{testname[1]}','{testname[2]}')
                group by TEXT_ID, ANALYSIS) sub
                group by Sample
                having count(Test) = 3";
                }


                var result = _msBDConnectorLW.QueryExecutor(command);

                //sortingPage.IsSampleCodeFieldActive(); // закомментировано. 110719 стало зависать. Ранее работало.
                sortingPage.CodeInputField.WaitForClickability();

                foreach (string i in result)
                {
                    sortingPage.CodeInputField.SendKeys(i);
                    sortingPage.CodeInputField.SendKeys(Keys.Enter);
                    //sortingPage.IsSampleCodeFieldActive(); // закомментировано. 110719 стало зависать. Ранее работало.
                    sortingPage.CodeInputField.WaitForClickability();
                    if (sortingPage.FieldWithUsercodePlaceholder.Exists())
                    {
                        sortingPage.FieldWithUsercodePlaceholder.SendKeys(Config.UserBarCode);
                        sortingPage.FieldWithUsercodePlaceholder.SendKeys(Keys.Enter);
                    }
                }
                if (sortingPage.CompleteAddSamplesButton.Exists() && !sortingPage.CompleteAddSamplesButtonDisable.Disabled)
                {
                    sortingPage.CompleteAddSamplesButton.Click();
                    sortingPage.ConfirmEndOfSamplesButton.Click();
                }
                else if (sortingPage.CompleteAddSamplesButton.Exists() && sortingPage.CompleteAddSamplesButtonDisable.Disabled)
                {
                    sortingPage.CodeInputField.SendKeys(Config.UserBarCode);  //
                    sortingPage.CodeInputField.SendKeys(Keys.Enter);
                }
                else if (sortingPage.CompleteBatchButton.Exists())
                {
                    sortingPage.CompleteBatchButton.Click();
                    sortingPage.ConfirmEndOfSamplesButton.Click();
                }
                System.Threading.Thread.Sleep(500);

                if (sortingPage.CodeInputField.Exists())
                {
                    sortingPage.CodeInputField.WaitForAvailability();
                    sortingPage.CodeInputField.WaitForVisibility();
                    sortingPage.CodeInputField.WaitForClickability();
                }
                // Подтверждается раскапывание ВК
                if (VKName[0] != "")
                {
                    foreach (string j in VKName)
                    {
                        sortingPage.SetValueOfKM(j);
                        Debug.WriteLine("Раскапан " + j);
                    }
                    //     sortingPage.SetValueOfKM(VKName);
                }
                // Подтверждается раскапывание ОКО
                if (OKOName[0] != "")
                {
                    foreach (string k in OKOName)
                    {
                        sortingPage.SetValueOfKM(k);
                        Debug.WriteLine("Раскапан " + k);
                    }
                }
                // Подтверждается раскапывание ПКО
                if (PKOName[0] != "")
                {
                    foreach (string m in PKOName)
                    {
                        sortingPage.SetValueOfKM(m);
                        Debug.WriteLine(DateTime.Now + "Раскапан " + m);
                    }
                }
            }
        }
예제 #4
0
        public void ThenITryToAddASampleOfTestAndLocationAndBiomaterialResultsInSortingWorkplace(string test, string location, string bm, string type, string wp)
        {
            BDMainPage BDMain = new BDMainPage();

            if (wp == "sorting")
            {
                BDMain.OpenSorting();
                IsTrue(BDMain.AssertOpenSorting(), "Заголовок рабочего места не найден");
                // создаем новый бэтч
                BDSortingPage sortingPage = new BDSortingPage();
                sortingPage.AssertTheButtonIsVisible();
                sortingPage.ClickCreateBatch();
                sortingPage.AssertTheConfirmBatchFieldIsVisible();
                sortingPage.SetParentBatchID();
                // подтверждаем своим ШК
                BDPlanshetPositionPage bDPlanshetPositionPage = new BDPlanshetPositionPage();
                IsTrue(bDPlanshetPositionPage.AssertConfirmBatchWindow(), "Нет окна для подтверждения установки планшета");
                bDPlanshetPositionPage.ConfirmUsercodeInPlanshetPositionPage();
                MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
                string command = "";
                if (type == "with")
                {
                    command = $@"select top 1 s.TEXT_ID
                    from test t with (nolock)
                    inner join SAMPLE s on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    left join RESULT r on s.SAMPLE_NUMBER = r.SAMPLE_NUMBER
                    where t.status='A' and s.TEMPLATE = 'smp_in' and r.RESULT_NUMBER is not NULL and r.ENTRY is not NULL 
                    and s.LOCATION = '{location}' and t.ANALYSIS = '{test}' and s.SAMPLE_TYPE ='{bm}'";
                }
                else if (type == "without")
                {
                    command = $@"select top 1 s.TEXT_ID from test t 
                    inner join SAMPLE s on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    inner join [RESULT] r on s.SAMPLE_NUMBER = r.SAMPLE_NUMBER
                    where t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I'
                    and s.LOCATION = '{location}'and t.ANALYSIS = '{test}'and s.SAMPLE_TYPE ='{bm}'";
                }
                var result = _msBDConnectorLW.QueryExecutor(command);
                sortingPage.CodeInputField.WaitForClickability();

                foreach (string i in result)
                {
                    sortingPage.CodeInputField.SendKeys(i);
                    sortingPage.CodeInputField.SendKeys(Keys.Enter);
                    Thread.Sleep(1500);
                }
            }
            else if (wp == "isolation")
            {
                BDMain.OpenDNKWorkplace();
                IsTrue(BDMain.AssertOpenDNKWorkplace(), "Заголовок рабочего места не найден");
                BDIsolationDNKPage bDIsolationDNKPage = new BDIsolationDNKPage();
                bDIsolationDNKPage.AssertTheButtonIsVisible();
                bDIsolationDNKPage.ClickCreateBatch();
                bDIsolationDNKPage.AssertBatchIsCreated();
                bDIsolationDNKPage.SetParentBatchID();
                BDPlanshetPositionPage bDPlanshetPositionPage = new BDPlanshetPositionPage();
                Thread.Sleep(500);
                // подтверждаем своим ШК
                IsTrue(bDPlanshetPositionPage.AssertConfirmBatchWindow(), "Нет окна для подтверждения установки планшета");
                bDPlanshetPositionPage.ConfirmUsercodeInPlanshetPositionPage();
                // bDPlanshetPositionPage.NewWindowConfirmUsercode();

                MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
                string command = "";
                if (type == "with")
                {
                    command = $@"select top 1 s.TEXT_ID
                    from test t with (nolock)
                    inner join SAMPLE s on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    left join RESULT r on s.SAMPLE_NUMBER = r.SAMPLE_NUMBER
                    where t.status='A' and s.TEMPLATE = 'smp_in' and r.RESULT_NUMBER is not NULL and r.ENTRY is not NULL 
                    and s.LOCATION = '{location}' and t.ANALYSIS = '{test}' and s.SAMPLE_TYPE ='{bm}'";
                }
                else if (type == "without")
                {
                    command = $@"select top 1 s.TEXT_ID from test t 
                    inner join SAMPLE s on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                    inner join [RESULT] r on s.SAMPLE_NUMBER = r.SAMPLE_NUMBER
                    where t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I'
                    and s.LOCATION = '{location}'and t.ANALYSIS = '{test}'and s.SAMPLE_TYPE ='{bm}'";
                }
                var result = _msBDConnectorLW.QueryExecutor(command);
                bDIsolationDNKPage.AddSample(result);
            }
        }
        public void ThenITryToFill_OutTheSorting_PlanchetBySamplesOfTestWithBiomaterialAndLocationAndVKAndOKOAndPKO(int count, string own, List <String> testname, string bm, string location, List <String> VKName, List <String> OKOName, List <String> PKOName)
        {
            //переходим в РМ сортировка
            BDMainPage BDMain = new BDMainPage();

            BDMain.OpenSorting();
            IsTrue(BDMain.AssertOpenSorting(), "Заголовок рабочего места не найден");
            // создаем новый бэтч
            BDSortingPage sortingPage = new BDSortingPage();

            sortingPage.AssertTheButtonIsVisible();
            sortingPage.ClickCreateBatch();
            sortingPage.AssertTheConfirmBatchFieldIsVisible();
            sortingPage.SetParentBatchID();
            // подтверждаем своим ШК
            BDPlanshetPositionPage bDPlanshetPositionPage = new BDPlanshetPositionPage();

            IsTrue(bDPlanshetPositionPage.AssertConfirmBatchWindow(), "Нет окна для подтверждения установки планшета");
            bDPlanshetPositionPage.ConfirmUsercodeInPlanshetPositionPage();
            {
                int countOfTests = testname.Count();
                MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
                string command = "";

                if (own == "only") // для случая, когда образец назначен ТОЛЬКО на тест/тесты
                {
                    if (countOfTests == 1)
                    {
                        command = $@"USE LW08v6
                    select TOP({count}) s.TEXT_ID
                    from
                    (select SAMPLE_NUMBER, count(ANALYSIS) as TestCommonCount
                    from [LW08v6].[dbo].[TEST] t with (nolock) 
                    group by SAMPLE_NUMBER
                    having count(ANALYSIS) = 1) MonoSamples
                    join TEST t on t.SAMPLE_NUMBER = MonoSamples.SAMPLE_NUMBER
                    join SAMPLE s on S.SAMPLE_NUMBER = t.SAMPLE_NUMBER
                    where t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' 
                    and s.LOCATION = '{location}' and t.ANALYSIS='{testname[0]}' and s.SAMPLE_TYPE ='{bm}'";
                    }
                    if (countOfTests == 2)
                    {
                        command = $@"USE LW08v6
                    select TOP({count}) s.TEXT_ID as Sample
                    from TEST t
                    join SAMPLE s on t.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                    where  t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and s.SAMPLE_TYPE ='{bm}'
                    and t.ANALYSIS = '{testname[0]}' 
                    and exists (select top 1 1 from TEST t1 where  t1.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                    and t1.ANALYSIS = '{testname[1]}') 
                    and not exists (select top 1 1 from TEST t1 where  t1.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                    and t1.ANALYSIS not in  ('{testname[0]}', '{testname[1]}'))";
                    }
                }

                if (countOfTests == 2) // если 2 теста в коллекции, выполняем скрипт:
                {
                    command = $@"USE LW08v6
                select TOP({count}) Sample
                from
                (select s.TEXT_ID as Sample, t.ANALYSIS as Test
                from TEST t
                join SAMPLE s on t.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                where  t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and s.SAMPLE_TYPE ='{bm}'
                and t.ANALYSIS in ('{testname[0]}', '{testname[1]}')
                group by TEXT_ID, ANALYSIS) sub
                group by Sample
                having count(Test) = 2";
                }
                else if (countOfTests == 1) // если 1 тест в коллекции, выполняем скрипт:
                {
                    command = $@"USE LW08v6
                SELECT TOP({count}) s.TEXT_ID FROM test t with (nolock)
                inner join SAMPLE s on t.SAMPLE_NUMBER=s.SAMPLE_NUMBER
                WHERE t.status='I' and t.ANALYSIS='{testname[0]}' 
                and s.TEMPLATE = 'smp_in' and s.status='I' and s.SAMPLE_TYPE ='{bm}' 
                and s.LOCATION = '{location}'";
                }
                else if (countOfTests == 3) // если 3 теста в коллекции, выполняем скрипт:
                {
                    command = $@"USE LW08v6
                select TOP ({count})Sample
                from
                (select s.TEXT_ID as Sample, t.ANALYSIS as Test
                from TEST t
                join SAMPLE s on t.SAMPLE_NUMBER = s.SAMPLE_NUMBER
                where  t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = '{location}' and s.SAMPLE_TYPE ='{bm}'
                and t.ANALYSIS in ('{testname[0]}', '{testname[1]}','{testname[2]}')
                group by TEXT_ID, ANALYSIS) sub
                group by Sample
                having count(Test) = 3";
                }


                var result = _msBDConnectorLW.QueryExecutor(command);


                //sortingPage.IsSampleCodeFieldActive(); // закомментировано. 110719 стало зависать. Ранее работало.
                sortingPage.CodeInputField.WaitForClickability();

                foreach (string i in result)
                {
                    sortingPage.CodeInputField.SendKeys(i);
                    sortingPage.CodeInputField.SendKeys(Keys.Enter);
                    //sortingPage.IsSampleCodeFieldActive(); // закомментировано. 110719 стало зависать. Ранее работало.
                    //sortingPage.CodeInputField.WaitForClickability();
                    IsTrue(sortingPage.DNASampleMessage.Exists(), "Не появилось сообщение об ошибке");
                }
            }
        }
        public void ThenIFill_OutTheIsolation_PlanchetBySamplesOfTestWithBiomaterialFromFirstLocationAndSecondLocationAndVKAndOKOAndPKO(int count, string testname, string bm, string location1, string location2, List <String> VKName, List <String> OKOName, List <String> PKOName)
        {
            //переходим в РМ сортировка
            BDMainPage BDMain = new BDMainPage();

            BDMain.OpenSorting();
            IsTrue(BDMain.AssertOpenSorting(), "Заголовок рабочего места не найден");
            // создаем новый бэтч
            BDSortingPage sortingPage = new BDSortingPage();

            sortingPage.AssertTheButtonIsVisible();
            sortingPage.ClickCreateBatch();
            sortingPage.AssertTheConfirmBatchFieldIsVisible();
            sortingPage.SetParentBatchID();
            // подтверждаем своим ШК
            BDPlanshetPositionPage bDPlanshetPositionPage = new BDPlanshetPositionPage();

            IsTrue(bDPlanshetPositionPage.AssertConfirmBatchWindow(), "Нет окна для подтверждения установки планшета");
            bDPlanshetPositionPage.ConfirmUsercodeInPlanshetPositionPage();
            {
                //int countOfTests = testname.Count();
                MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
                string command1 = "";
                command1 = $@"USE LW08v6
                    select TOP({count}) s.TEXT_ID
                    from
                    (select SAMPLE_NUMBER, count(ANALYSIS) as TestCommonCount
                    from [LW08v6].[dbo].[TEST] t with (nolock) 
                    group by SAMPLE_NUMBER
                    having count(ANALYSIS) = 1) MonoSamples
                    join TEST t on t.SAMPLE_NUMBER = MonoSamples.SAMPLE_NUMBER
                    join SAMPLE s on S.SAMPLE_NUMBER = t.SAMPLE_NUMBER
                    where t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' 
                    and s.LOCATION = '{location1}' and t.ANALYSIS='{testname}' and s.SAMPLE_TYPE ='{bm}'";
                string command2 = "";
                command2 = $@"USE LW08v6
                    select TOP({count}) s.TEXT_ID
                    from
                    (select SAMPLE_NUMBER, count(ANALYSIS) as TestCommonCount
                    from [LW08v6].[dbo].[TEST] t with (nolock) 
                    group by SAMPLE_NUMBER
                    having count(ANALYSIS) = 1) MonoSamples
                    join TEST t on t.SAMPLE_NUMBER = MonoSamples.SAMPLE_NUMBER
                    join SAMPLE s on S.SAMPLE_NUMBER = t.SAMPLE_NUMBER
                    where t.status='I' and s.TEMPLATE = 'smp_in' and s.status='I' 
                    and s.LOCATION = '{location2}' and t.ANALYSIS='{testname}' and s.SAMPLE_TYPE ='{bm}'";

                var result1 = _msBDConnectorLW.QueryExecutor(command1); // образцы для первой локации
                var result2 = _msBDConnectorLW.QueryExecutor(command2); // образцы для второй локации
                //result.AddRange(result2); //объединить списки

                sortingPage.CodeInputField.WaitForClickability();

                foreach (string i in result1)
                {
                    sortingPage.CodeInputField.SendKeys(i);
                    sortingPage.CodeInputField.SendKeys(Keys.Enter);
                    sortingPage.CodeInputField.WaitForClickability();
                    IsFalse(sortingPage.AssertSampleFromAnotherLocationMessage(location1), $"Что то пришло не так, не проходят пробы из локации {location1}");
                    if (sortingPage.FieldWithUsercodePlaceholder.Exists())
                    {
                        sortingPage.FieldWithUsercodePlaceholder.SendKeys(Config.UserBarCode);
                        sortingPage.FieldWithUsercodePlaceholder.SendKeys(Keys.Enter);
                    }
                }
                foreach (string n in result2)
                {
                    sortingPage.CodeInputField.SendKeys(n);
                    sortingPage.CodeInputField.SendKeys(Keys.Enter);
                    sortingPage.CodeInputField.WaitForClickability();
                    IsTrue(sortingPage.AssertSampleFromAnotherLocationMessage(location2), $"Что то пришло не так, не так - не приходит ошибка о добавлении пробы из локации {location2}");
                    if (sortingPage.FieldWithUsercodePlaceholder.Exists())
                    {
                        sortingPage.FieldWithUsercodePlaceholder.SendKeys(Config.UserBarCode);
                        sortingPage.FieldWithUsercodePlaceholder.SendKeys(Keys.Enter);
                    }
                }
                if (sortingPage.CompleteAddSamplesButton.Exists() && !sortingPage.CompleteAddSamplesButtonDisable.Disabled)
                {
                    sortingPage.CompleteAddSamplesButton.Click();
                    sortingPage.ConfirmEndOfSamplesButton.Click();
                }
                else if (sortingPage.CompleteAddSamplesButton.Exists() && sortingPage.CompleteAddSamplesButtonDisable.Disabled)
                {
                    sortingPage.CodeInputField.SendKeys(Config.UserBarCode);  //
                    sortingPage.CodeInputField.SendKeys(Keys.Enter);
                }
                else if (sortingPage.CompleteBatchButton.Exists())
                {
                    sortingPage.CompleteBatchButton.Click();
                    sortingPage.ConfirmEndOfSamplesButton.Click();
                }
                System.Threading.Thread.Sleep(500);

                if (sortingPage.CodeInputField.Exists())
                {
                    sortingPage.CodeInputField.WaitForAvailability();
                    sortingPage.CodeInputField.WaitForVisibility();
                    sortingPage.CodeInputField.WaitForClickability();
                }
                // Подтверждается раскапывание ВК
                if (VKName[0] != "")
                {
                    foreach (string j in VKName)
                    {
                        sortingPage.SetValueOfKM(j);
                        Debug.WriteLine("Раскапан " + j);
                    }
                    //     sortingPage.SetValueOfKM(VKName);
                }
                // Подтверждается раскапывание ОКО
                if (OKOName[0] != "")
                {
                    foreach (string k in OKOName)
                    {
                        sortingPage.SetValueOfKM(k);
                        Debug.WriteLine("Раскапан " + k);
                    }
                }
                // Подтверждается раскапывание ПКО
                if (PKOName[0] != "")
                {
                    foreach (string m in PKOName)
                    {
                        sortingPage.SetValueOfKM(m);
                        Debug.WriteLine(DateTime.Now + "Раскапан " + m);
                    }
                }
            }
        }