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

> 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 2017 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 2017 $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 2018 X $DBName1 FEDAndStateBackEndFileSendFileToTAV.xml tmp FEDAndStateBackEndFileSendFileToTAV.zip /BackEnd/FileCreateDate True True True Both XML Files are Equal








Keyboard Shortcuts ?

  • General

  • t Test page or suite
  • e Edit page
  • v View page (after test)
  • a Add new page

  • Go To

  • g u User Guide
  • g q Quick Reference Guide
  • g f Full Reference Guide
  • g c Recent Changes

  • Edit Mode

  • CTRL+s Save page
  • ESC Cancel edit

  • Tools

  • p Properties
  • w Where used?
  • AK+v Versions
  • AK+h Page History
  • / Focus on search bar
  • s Open search page
Close