Included page: .FrontPage.QA.BalanceDue.2022.QA.SetUp (edit)

import
TBOT.Generic.Database

variable defined: ENV=QA
variable defined: QA=http://10.184.7.166:9510/
variable defined: SAT=http://10.184.73.99:9510/
variable defined: URL=http://10.184.7.166:9510/

ddt: SetUp
key value
ConnectionString Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30
BytesColumn DataObject
FileExtension ZIP
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals
SourceDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals
TargetDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\OTTDataQA\TrustElf\acks\EFTPS\incoming
CompareResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue\Actuals
ResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2022\BatchAutomation\BalanceDue
Debug TRUE
ignorePathValidations false
DeleteFile true

> Execute BTM Package


ddt: KeywordFixture SELECT LTRIM(RTRIM(DB_NAME)) as DBNAME , LTRIM(RTRIM(Server)) as Server, AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number from BTMDB..Package where AcctNo='{{PAN}}'
Comments# PAN TaxYear SeqNumber WorkingDayStartCount DBNAME? Server? AcctNo? Tax_Year? Seq_Number?
Test0001 5010 2022 1 2 $DBName1= $Server1= $AcctNo1= $Tax_Year1= $Seq_Number1=



> Filing status Validations


ddt:DynamicQuery WAITFOR DELAY '00:00:10';EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}} Filing = 'Federal and State Tax History Back-End file'
Comments# PAN YEAR SeqNumber DataBaseName FilingType FiledStatus?
Test0001 5010 2022 $Seq_Number1 $DBName1 Federal and State Tax History Back-End file Complete



Download and Validate XML

DDT:KeywordFixture select DataObject from {{DataBaseName}}..bankdata where acctno='{{AcctNo}}'and year='{{TaxYear}}' and product_cd='{{ProdCd}}'
AcctNo TaxYear ProdCd DataBaseName XMLExpectedFilename EfileFileExtn FileName replaceNode DOWNLOAD? UNZIP? GETEFILEXML? COMPAREXML?
5010 2022 X $DBName1 FEDAndStateIncludeEstimatePayments.xml tmp FEDAndStateIncludeEstimatePayments.zip /BackEnd/FileCreateDate;/BackEnd/ProgVer True True True Both XML Files are Equal