public void ATC7121b_AXDuplicateBPAYpayment() { #region Start Up Excel //MyApp = new Excel.Application(); //MyApp.Visible = false; //MyBook = MyApp.Workbooks.Open(DatasourceDir + "\\TenancyRequests.xlsx"); MyBook = MyApp.Workbooks.Open(DatasourceDir + @"\TenancyRequests.xlsx", 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); MySheet = (Excel.Worksheet)MyBook.Sheets[Properties.Settings.Default.ENVIRONMENT.ToString()]; MyRange = MySheet.UsedRange; //Get specific row for the data int testDataRows = MyRange.Rows.Count; int MyRow = 0; for (int i = 2; i <= testDataRows; i++) { if (MyRange.Cells[i, 1].Value.ToString() == "7121") { MyRow = i; break; } } #endregion string referenceNumber = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAY_REF_NUMBER")].Value.ToString(); string tenancyrequest = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value.ToString(); string fileLocation = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("OUTFILE")].Value.ToString(); string fileLocation2 = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC1")].Value.ToString(); Homepage homePage = new Homepage(); homePage.ClickHomeTab(); homePage.ClickBondManagementTab(); homePage.ClickPaymentsLink(); homePage.ClickBPayFileLink(); ; BPayFilePage bPayFilePage = new BPayFilePage(); //import 1st file bPayFilePage.ClickImportMenuItem(); BPayFileImportPage bPayFileImportPage = new BPayFileImportPage(); Assert.IsTrue(bPayFileImportPage.GetWindowExistStatus()); bPayFileImportPage.SetMoveFileCheckBox(true); bPayFileImportPage.SetProcessFileCheckBox(true); bPayFileImportPage.SetImportPathEdit(""); bPayFileImportPage.SetFileNameEdit(fileLocation); bPayFileImportPage.ClickOKButton(); InfoLogPage infoLogPage = new InfoLogPage(); //check that file imported successful Assert.IsTrue(infoLogPage.GetTreeItemExists("File imported with identifier", "Importing BPAY file")); infoLogPage.ClickClearButton(); infoLogPage.ClickCloseButton(); //import 2nd file bPayFilePage.ClickImportMenuItem(); bPayFileImportPage = new BPayFileImportPage(); Assert.IsTrue(bPayFileImportPage.GetWindowExistStatus()); bPayFileImportPage.SetMoveFileCheckBox(true); bPayFileImportPage.SetProcessFileCheckBox(true); bPayFileImportPage.SetImportPathEdit(""); bPayFileImportPage.SetFileNameEdit(fileLocation2); bPayFileImportPage.ClickOKButton(); infoLogPage = new InfoLogPage(); //check that file imported successful Assert.IsTrue(infoLogPage.GetTreeItemExists("File imported with identifier", "Importing BPAY file")); infoLogPage.ClickClearButton(); infoLogPage.ClickCloseButton(); bPayFilePage.ClickCloseButton(); //Navigate to Outbound CRM and click ok homePage.ClickCRMOutboundNotificationsLink(); OutboundCRMIntegrationPage outBoundCRMIntegration = new OutboundCRMIntegrationPage(); Assert.IsTrue(outBoundCRMIntegration.GetWindowExistStatus()); outBoundCRMIntegration.ClickOKButton(); //Navigate to Payments/BPay file exceptions homePage.ClickPaymentsLink(); homePage.ClickBPayFileExceptionLink(); //Order by created date //Confirm customer referance number exists BPayFileExceptionsPage bPayFileExceptionPage = new BPayFileExceptionsPage(); Table table = new Table(bPayFileExceptionPage.GetFileExceptionTable()); table.FilterCellValue("Customer reference number"); bPayFileExceptionPage.ClickFilterMenuItem(); FilterPage filterPage = new FilterPage(); filterPage.SetFilterText("Customer reference number", referenceNumber); filterPage.ClickOkButton(); StringAssert.Contains(table.GetCellValue("Customer reference number", referenceNumber, "Rejection reason"), "Duplicate CRN"); bPayFileExceptionPage.ClickCloseButton(); #region Shut down Excel MyBook.Save(); MyBook.Close(); MyApp.Quit(); #endregion }
public void ATC6740_AXPostBPAYpaymentswithunknownreferencenumber() { string dateValue = DateTime.Today.AddDays(-1).ToString("yyyyMMdd"); string transDesc = "BPAY " + DateTime.Today.AddDays(-1).ToString("d/MM/yyyy"); Random random = new Random(); int randomNum = random.Next(1000, 9999); string fileLocation = Utils.BPayFileCreator.bPayUnknownClientFileCreator(dateValue, randomNum); string referenceNumber = Utils.BPayFileReaderClass.GetPaymentReference1File(fileLocation).ToString(); Homepage homePage = new Homepage(); homePage.ClickCompanyButton(); SelectCompanyPage selectCompanyPage = new SelectCompanyPage(); Table table = new Table(selectCompanyPage.GetCompanyListTable()); table.ClickCellValue("Company", "RTB", "Company"); selectCompanyPage.ClickOkButton(); homePage.ClickHomeTab(); homePage.ClickBondManagementTab(); homePage.ClickPaymentsLink(); homePage.ClickBPayFileLink(); ; BPayFilePage bPayFilePage = new BPayFilePage(); bPayFilePage.ClickImportMenuItem(); BPayFileImportPage bPayFileImportPage = new BPayFileImportPage(); Assert.IsTrue(bPayFileImportPage.GetWindowExistStatus()); bPayFileImportPage.SetMoveFileCheckBox(true); bPayFileImportPage.SetProcessFileCheckBox(true); //bPayFileImportPage.SetImportPathEdit(@"P:\Dynamics AX\Bank files\Bpay\Paul"); bPayFileImportPage.SetImportPathEdit(""); bPayFileImportPage.SetFileNameEdit(fileLocation); bPayFileImportPage.ClickOKButton(); InfoLogPage infoLogPage = new InfoLogPage(); string rtbTreeItem = infoLogPage.GetTreeItemName("Processing BPAY file RTB-", "Importing BPAY file"); string RTB = rtbTreeItem.Substring(21, 10); string bvdTreeItem = infoLogPage.GetTreeItemName("Posting journal BDV", "Importing BPAY file"); string BVD = bvdTreeItem.Substring(16, 9); Assert.IsTrue(infoLogPage.GetTreeItemExists("BPAY exception 'Invalid CRN' has been recorded for this line", "Importing BPAY file")); infoLogPage.ClickClearButton(); infoLogPage.ClickCloseButton(); bPayFilePage.ClickCloseButton(); homePage.ClickHomeTab(); homePage.ClickBondManagementTab(); homePage.ClickCRMOutboundNotificationsLink(); OutboundCRMIntegrationPage outboundCRMIntegrationPage = new OutboundCRMIntegrationPage(); outboundCRMIntegrationPage.ClickOKButton(); //Navigate to Payments/BPay file exceptions homePage.ClickPaymentsLink(); homePage.ClickBPayFileExceptionLink(); //Confirm customer referance number exists BPayFileExceptionsPage bPayFileExceptionPage = new BPayFileExceptionsPage(); table = new Table(bPayFileExceptionPage.GetFileExceptionTable()); table.FilterCellValue("Customer reference number"); bPayFileExceptionPage.ClickFilterMenuItem(); FilterPage filterPage = new FilterPage(); filterPage.SetFilterText("Customer reference number", referenceNumber); filterPage.ClickOkButton(); StringAssert.Contains(table.GetCellValue("Customer reference number", referenceNumber, "Rejection reason"), "Invalid CRN"); bPayFileExceptionPage.ClickCloseButton(); }