public void WhenIAddDNK_SampleOfTestToField(int count, string name, string workplace)
{
MSDatabaseConnector _msBDConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
string command = $@"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='{name}' and s.TEMPLATE = 'smp_in' and s.status='I' and s.LOCATION = 'HELIX-SPB' ";
var result = _msBDConnectorLW.QueryExecutor(command);
if (workplace.Equals("IsolationDNK")) // переход в выделение в ДНК и добавление образца
{
BDMainPage bDMainPage = new BDMainPage();
bDMainPage.OpenDNKWorkplace();
BDIsolationDNKPage bDIsolationDNKPage = new BDIsolationDNKPage();
bDIsolationDNKPage.AssertTheButtonIsVisible();
bDIsolationDNKPage.ClickCreateBatch();
bDIsolationDNKPage.AssertBatchIsCreated();
bDIsolationDNKPage.SetParentBatchID();
BDPlanshetPositionPage bDPlanshetPositionPage = new BDPlanshetPositionPage();
Thread.Sleep(500);
// bDPlanshetPositionPage.NewWindowConfirmUsercode();
bDIsolationDNKPage.AddSample(result);
}
else if (workplace.Equals("ProductionAcceptance")) // переход в Прием в постановке и добавление образца
{
BDMainPage bDMainPage = new BDMainPage();
bDMainPage.OpenProductionAcceptance();
BDProductionAcceptancePage bDProductionAcceptancePage = new BDProductionAcceptancePage();
bDProductionAcceptancePage.AddSample(result);
}
}
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);
}
}
