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

Get Data from Package Table

Get Data from Package Table

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=

Assert Filing Status as Transmitting

ddt:DynamicQuery	EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}}	Filing = 'Federal EFTPS (1041 and 990)'
Comments#	PAN	YEAR	SeqNumber	DataBaseName	FilingType	FiledStatus?	IsFiled?
Test0001	5010	2017	$Seq_Number1	$DBName1	Federal EFTPS (1041 and 990)	Transmitting	False

Download EDI File

Download Block

DDT: KeywordFixture	use {{DataBaseName}} select Action_Cd,DataObject,CONVERT(varchar(10),Action_DT,111) as Action_DT from bankdata where acctno='{{PAN}}' and year='{{TaxYear}}' and state='' and prodopt=27 and SeqNo={{SeqNumber}} and Product_CD='F'
Comment	PAN	TaxYear	SeqNumber	DataBaseName	FileName	DOWNLOAD?	UNZIP?	GETFILES?
Test0001	$AcctNo1	$Tax_Year1	$Seq_Number1	$DBName1	FederalEFTPS1041And990Base.zip	True	True	$EDIFile1=