Included page: .FrontPage.QA.BalanceDue.2021.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\2021\BatchAutomation\BalanceDue
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2021\BatchAutomation\BalanceDue\Actuals
SourceDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2021\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\2021\BatchAutomation\BalanceDue
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2021\BatchAutomation\BalanceDue
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2021\BatchAutomation\BalanceDue\Actuals
ResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2021\BatchAutomation\BalanceDue
Debug TRUE
ignorePathValidations false
DeleteFile true

> Execute BTM Package


ddt: KeywordFixture SELECT DB_NAME , 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 DB_NAME? Server? AcctNo? Tax_Year? Seq_Number? GETNEXTWORKINGDAY?
Test0001 5010 2021 1 1 $DBName1= $Server1= $AcctNo1= $Tax_Year1= $Seq_Number1= $SetDate1=

Get Filename


ddt: DynamicQuery declare @filename nvarchar(max) set @filename = '{{FileVal}}' select @filename as FileName
Comments# FileVal FileName?
Test0001 PennsylvaniaActual.txt $File1=


Capturing Action Date


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.dbo.Package WHERE AcctNo='{{PAN}}'
Comments# PAN TaxYear SeqNumber DB_NAME? AcctNo? Tax_Year? Seq_Number? ActionDate?
Test0001 5010 2021 1 $DBName1= $AcctNo1= $Tax_Year1= $Seq_Number1= $Action_DT1=


> Download Block

DDT: KeywordFixture SELECT DataObject, Action_Cd,DataObject,CONVERT(varchar(10),Action_DT,111) as Action_DT, LTRIM(RTRIM(REPLACE(REPLACE(COMMENTS,'PA,',''),'.',''))) AS JulianDtSeq, SUBSTRING(COMMENTS, 1, CHARINDEX(',',COMMENTS)-1) AS filingState, SUBSTRING(COMMENTS,CHARINDEX(',',COMMENTS)+1,CHARINDEX('.',COMMENTS)-CHARINDEX(',',COMMENTS)-1) AS JulianDate, SUBSTRING(COMMENTS,CHARINDEX('.',COMMENTS)+1,LEN(COMMENTS)-CHARINDEX('.',COMMENTS)) AS SequenceNumber,SeqNo FROM {{DataBaseName}}.dbo.bankdata WHERE acctno='{{PAN}}' and year={{TaxYear}} and state='PA' and prodopt=107 and SeqNo={{SeqNumber}} and Product_CD='F'
Comment PAN TaxYear SeqNumber DataBaseName FileName Action_Cd? Action_DT? DataObject? DOWNLOAD? DateInput DateFormat FORMATDATE? JulianDtSeq? filingState? JulianDate? SeqNo?
Test0001 $AcctNo1 $Tax_Year1 $Seq_Number1 $DBName1 $File1 1 $Action_DT1 System.Byte[] True $Action_DT1 yyyyMMdd $ActionDate1= $JulianDtSeq1= $filingState1= $JulianDate1= $SequenceNumber1=

> Capturing settilement Date

DDT: KeywordFixture select * from BTMDB..Package
Comment DateInput DateFormat FORMATDATE?
Test0001 $SetDate1 yyyyMMdd $FormateDate1=

> Filing status Validations


ddt:DynamicQuery EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}} Filing = 'Pennsylvania'
Comments# PAN YEAR SeqNumber DataBaseName FilingType IsFiled?
Test0001 5010 2021 $Seq_Number1 $DBName1 Pennsylvania True


> if we filed with 'Do not send option',there should not be any record releated to PA in ELECFILEDB


ddt:DynamicQuery declare @PAFiling nvarchar(100) IF (select count(*) FROM ELECFILEDB..TEZ_IRS_Trans where FedIndSt='{{State}}' and Julian_Dt=Julian_Dt and TransSeq={{SequenceNumber}}) > 0 select @PAFiling = 'PA is not filed' ELSE select @PAFiling = 'PA filed' select @PAFiling as Filing
Comments# Julian_Dt State SequenceNumber Filing?
Test0001 $JulianDate1 PA $SequenceNumber1 PA filed



> File Compare

TBOT.Generic.SFTP
Comments sourceFile destinationFile resultFileName IgnorePattern compareFiles?
Test0001 PennsylvaniaBase.txt $File1 20220825;20220826;$ActionDate1;$FormateDate1;$JulianDtSeq1;2370001 Both 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