public void WhenIConfirmParent_BatchIdForStartIsalatiion() { { BDMainPage bDMainPage = new BDMainPage(); bDMainPage.OpenDNKWorkplace(); IsTrue(bDMainPage.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(); } }
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 WhenBeingInWorkplaceIAddSampleOfTestAndLocationAndBiomaterialResults(string wp, int count, string test, string location, string bm, string type) { // ОПИСЫВАЕТ ДОБАВЛЕНИЕ В ОТКРЫТОЕ РМ СОРТИРОВКА/ВЫДЕЛЕНИЕ НЕСКОЛЬКИХ ОБРАЗЦОВ, КОТОРЫХ ЕЩЕ НЕ ДОБАВЛЯЛИ. // ПРОСТО ДОБАВЛЕНИЕ, ПОПЫТКА. НЕГАТИВНЫЙ КЕЙС. BDMainPage BDMain = new BDMainPage(); if (wp == "sorting") { IsTrue(BDMain.AssertOpenSorting(), "Заголовок рабочего места не найден"); MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW); string command = ""; if (type == "with") // выбор образцов с результатами, которые еще НЕ были добавлены в базу BD { 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}' and s.SAMPLE_NUMBER not in (select [LwSampleNumber] from [BatchDropperStab].[dbo].[Samples] )"; } else if (type == "without") // выбор образцов без результатов, которые еще НЕ были добавлены в базу BD { 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}' and s.SAMPLE_NUMBER not in (select [LwSampleNumber] from [BatchDropperStab].[dbo].[Samples] )"; } var result = _msBDConnectorLW.QueryExecutor(command); BDSortingPage sortingPage = new BDSortingPage(); sortingPage.CodeInputField.WaitForClickability(); foreach (string i in result) { sortingPage.CodeInputField.SendKeys(i); sortingPage.CodeInputField.SendKeys(Keys.Enter); } } else if (wp == "isolation") { IsTrue(BDMain.AssertOpenDNKWorkplace(), "Заголовок рабочего места не найден"); MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW); string command = ""; if (type == "with") // выбор образцов с результатами, которые еще НЕ были добавлены в базу BD { 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}' and s.SAMPLE_NUMBER not in (select [LwSampleNumber] from [BatchDropperStab].[dbo].[Samples] )"; } else if (type == "without") // выбор образцов без результатов, которые еще НЕ были добавлены в базу BD { 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}' and s.SAMPLE_NUMBER not in (select [LwSampleNumber] from [BatchDropperStab].[dbo].[Samples] )"; } var result = _msBDConnectorLW.QueryExecutor(command); BDIsolationDNKPage isolationDNKPage = new BDIsolationDNKPage(); isolationDNKPage.AddSample(result); } }