Included page: .FrontPage.SAT.BalanceDue.SetUp (edit)

import

TBOT.Generic.Database

ddt: SetUp
key	value
ConnectionString	Server=10.184.25.4,1605;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	\\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue
DownloadPath	\\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue\Actuals
SourceDirectory	\\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue\Actuals
TargetDirectory	\\C605ZPUOTTFS2.tztst.loc\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in
CompareResultDir	\\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\SAT\YrSpecSuites\2017\BatchAutomation\BalDues
ignorePathValidations	false
DeleteFile	true

Import Necessary Libraries

import

TBOT.Business

TBOT.Generic.Database

Execute BTMDB..Package

ddt: DynamicQuery	SELECT LTRIM(RTRIM(Server)) AS Server, LTRIM(RTRIM(DB_NAME)) AS DB_NAME ,AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number,CONVERT(varchar(10),getdate(),111) as ActionDate from BTMDB..Package where AcctNo='{{PAN}}'
Comments#	PAN	TaxYear	SeqNumber	DB_NAME?	AcctNo?	Tax_Year?	Seq_Number?	ActionDate?	Server?
Test0001	5010	2017	1	$DBName1=	$AcctNo1=	$Tax_Year1=	$Seq_Number1=	$Action_DT1=	$Server1=

Mark Filing Record as Un-Filed.

ddt: KeywordFixture	exec {{DBName}}.BANKDB_P.spUpdBankData @AcctNo='{{PAN}}',@Year={{Year}},@SeqNo=1,@ProductCd='F',@ProdOpt=107,@ChngIni='@SP',@State='MN ',@ActionCd=0
Server	DBName	PAN	Year
$Server1	$DBName1	$AcctNo1	$Tax_Year1

Deleting Record from operationsdb.

ddt: KeywordFixture	delete from operationsdb..status where product_cd = 'F' and yrseq = '{{Year}}'
Server	DBName	PAN	Year
$Server1	$DBName1	$AcctNo1	$Tax_Year1

Clear all Orphan Records, If Present

ddt: KeywordFixture	delete from {{Server}}.{{DBName}}.dbo.EEStateSet where state_CD='MN' and Year='{{Year}}' and PrimAcct='{{PAN}}' and Product_CD='F' delete from {{Server}}.{{DBName}}.dbo.EEStateList where state_CD='MN' and Year='{{Year}}' and Product_CD='F' and trustkey in ('584118069','53962350','549153626','537487209','410488308','6505574','9647879','1918784') UPDATE BTMPRODDB.DBO.EFTPS_WIPHist set Status_Cd='V' WHERE PrimAcct='{{PAN}}' AND Status_Cd <>'V' and ProdOpt='107' AND Product_Cd='F' delete from {{Server}}.{{DBName}}.dbo.BankData WHERE AcctNo='{{PAN}}' and Year='{{Year}}' and ProdOpt='107' AND Product_Cd='F' and State='MN' delete from {{Server}}.{{DBName}}.dbo.Acct_WIP WHERE AcctNo='{{PAN}}' and Year='{{Year}}' and ProdOpt='107' AND Product_Cd='F' and State='MN' delete from OPERATIONSDB.dbo.Status WHERE TrustKey=0 and ProdOpt=107 and Product_Cd='F' AND YrSeq='{{Year}}' AND Key_Field='{{PAN}}{{Year}}{{SeqNumber}}EE107MNF' --delete from {{Server}}.{{DBName}}.dbo.[BatchHistory] where batchopt1='MN' and AcctNo='{{PAN}}'and BatchType_CD='M'
Server	DBName	PAN	Year	SeqNumber
$Server1	$DBName1	$AcctNo1	$Tax_Year1	$Seq_Number1