public void ATC6837d_CRMCancelBPayRequestBatchWithTopup()
{
#region Start Up Excel
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;
/*Data preparation:
Request batch is required with the following:
- Several TRs (Type = Bond Lodgment) under it, including initial lodgement and at least one top-up (i.e. linked to existing Bond Number via {Tenancy} field, must have same managing party / contributors / tenancy address)
- RB and TR all have {Payment Type} = BPay
- RB has been successfully validated i.e. RB and TRs have {Status Reason} = Pending financials; are read only (bar bug 6343)
- RB BPay reference is generated for total amount of all TRs*/
//Get specific row for the data
int testDataRows = MyRange.Rows.Count;
int tRow1 = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "Initial_6837")
{
tRow1 = i;
break;
}
}
#endregion
string initialtenancyrequest = MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value.ToString();
int tRow2 = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "Topup_6837")
{
tRow2 = i;
break;
}
}
string topuptenancyrequest = MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value.ToString();
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
HomePage homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
RequestBatchesSearchPage requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.ClickNewRequestBatchButton();
RequestBatchPage requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickPageTitle();
requestBatchPage.SetManagingPartyText(MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString());
requestBatchPage.SetPaymentType(MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
requestBatchPage.ClickSaveButton();
string requestBatch = requestBatchPage.GetRequestNumber();
StringAssert.Contains(requestBatch, "TRB-BL-");
requestBatchPage.ClickAddAssociatedRequestsButton();
requestBatchPage.SetAssociatedRequest(initialtenancyrequest);
requestBatchPage.ClickSaveCloseButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
Table reqBatchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
reqBatchTable.ClickCellValue("Name", requestBatch, "Name");
requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickAddAssociatedRequestsButton();
requestBatchPage.SetAssociatedRequest(topuptenancyrequest);
requestBatchPage.ClickSaveButton();
requestBatchPage.SetStatusReason("Ready for validation");
requestBatchPage.ClickSaveCloseButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
Assert.IsTrue(requestBatchSearchPage.GetPaymentRefernceRefreshTable(requestBatch));
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
Table requestBatchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
requestBatchTable.ClickCellValue("Name", requestBatch, "Name");
requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickPageTitle();
Assert.AreEqual(requestBatchPage.GetSumBondamountPaid(), "$2,050.00");
requestBatchTable = new Table(requestBatchPage.GetPaymentSummaryResultTable());
StringAssert.Contains(requestBatchTable.GetCellValue("Request Batch", requestBatch, "Request Batch"), requestBatch,"Validate the payment ref record in req batch");
StringAssert.Contains(requestBatchTable.GetCellValue("Request Batch", requestBatch, "Payment Type"), "BPay","Validate the payment ref record in req batch");
StringAssert.Contains(requestBatchTable.GetCellValue("Request Batch", requestBatch, "Amount"), "$2,050.00","Validate the payment ref record in req batch");
StringAssert.Contains(requestBatchTable.GetCellValue("Request Batch", requestBatch, "Client"), MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(),"Validate the payment ref record in req batch");
string reqbatreferencenumber = requestBatchTable.GetCellValue("Request Batch", requestBatch, "Reference Number");
Thread.Sleep(5000);
Assert.AreEqual(requestBatchPage.GetStatusReason(), "Pending Financials","Validate the status reason of req batch:"+requestBatch);
Assert.AreEqual(requestBatchPage.GetFundedStatus(), "Payment pending","Validate the processing status of req batch:"+requestBatch);
Assert.AreEqual(requestBatchPage.GetRecordStatus(), "Read only","Validate the record status of req bact:"+requestBatch);
Table tenancyReqTable = new Table(requestBatchPage.GetTenancyRequestTable());
tenancyReqTable.ClickCellValue("Name", initialtenancyrequest, "Name");
TenancyRequestPage tenancyReqPage = new TenancyRequestPage(driver);
tenancyReqPage.ClickPageTitle();
Assert.AreEqual(tenancyReqPage.GetStatusReason(), "Pending Financials", "Validating the status reason of TR" + initialtenancyrequest);
Assert.AreEqual(tenancyReqPage.GetRecordStatus(), "Read only","Validating the record status of TR:"+initialtenancyrequest);
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
reqBatchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
reqBatchTable.ClickCellValue("Name", requestBatch, "Name");
requestBatchPage = new RequestBatchPage(driver);
tenancyReqTable = new Table(requestBatchPage.GetTenancyRequestTable());
tenancyReqTable.ClickCellValue("Name", topuptenancyrequest, "Name");
tenancyReqPage = new TenancyRequestPage(driver);
tenancyReqPage.ClickPageTitle();
Assert.AreEqual(requestBatchPage.GetStatusReason(), "Pending Financials", "Validating the status reason of TR" + topuptenancyrequest);
Assert.AreEqual(tenancyReqPage.GetRecordStatus(), "Read only","Validating the record status of TR"+topuptenancyrequest);
//Double-click on the BPay Payment Reference record under the Administration section.
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
reqBatchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
reqBatchTable.ClickCellValue("Name", requestBatch, "Name");
requestBatchPage = new RequestBatchPage(driver);
requestBatchTable = new Table(requestBatchPage.GetPaymentSummaryResultTable());
IWebElement elem = requestBatchTable.GetCellElementContainsValue("Request Batch", requestBatch, "Reference Number");
UICommon.DoubleClickElement(elem, driver);
//Click the [Deactivate] button.Record is deactivated.
PaymentReferncePage payRefPage = new PaymentReferncePage(driver);
payRefPage.ClickDeactivateButton();
WarningDialogueFramePage warnPage = new WarningDialogueFramePage(driver);
warnPage.ClickProcessBeginButton();
Thread.Sleep(3000);
payRefPage = new PaymentReferncePage(driver);
payRefPage.ClickPageTitle();
Assert.AreEqual("Inactive", payRefPage.GetInactiveStatusFooter(),"Validate whether payment record of req batch:"+requestBatch+",is inactive after deactivating the record");
//Inspect Batch Request record.
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
reqBatchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
reqBatchTable.ClickCellValue("Name", requestBatch, "Name");
/*Record is active again, editable.
{Status Reason} = New.
Processing Status is blank.*/
requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickPageTitle();
Assert.AreEqual(requestBatchPage.GetStatusReason(), "New","Validating the status reason is New for req batch:"+requestBatch);
Assert.AreEqual(requestBatchPage.GetFundedStatus(), "--","Validating the processing status is blank for req batch:"+requestBatch);
try
{
requestBatchPage.SetPaymentType("BPay");
}
catch (Exception)
{
new AssertFailedException("Payment Type in Req batch not editable after deactivating the payment ref record:" + requestBatch);
}
//Inspect all child Tenancy Request records.
tenancyReqTable = new Table(requestBatchPage.GetTenancyRequestTable());
tenancyReqTable.ClickCellValue("Name", initialtenancyrequest, "Name");
/*Records are active again, editable.
{Status Reason} = New.
Processing Status is blank.*/
tenancyReqPage = new TenancyRequestPage(driver);
StringAssert.Contains(tenancyReqPage.GetStatusReason(), "New", "Validating the status reason is New for TR" + initialtenancyrequest);
StringAssert.Contains(tenancyReqPage.GetFundedStatus(), "","Validating the processing status is blank for TR"+initialtenancyrequest);
try
{
tenancyReqPage.SetRequestTypeListValue("Bond Lodgement");
}
catch (Exception)
{
new AssertFailedException("Request Type in Child Tenacy Req" + initialtenancyrequest + " not editable after deactivating the payment ref record in req batch:" + requestBatch);
}
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
reqBatchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
reqBatchTable.ClickCellValue("Name", requestBatch, "Name");
requestBatchPage = new RequestBatchPage(driver);
tenancyReqTable = new Table(requestBatchPage.GetTenancyRequestTable());
tenancyReqTable.ClickCellValue("Name", topuptenancyrequest, "Name");
tenancyReqPage = new TenancyRequestPage(driver);
StringAssert.Contains(tenancyReqPage.GetStatusReason(), "New", "Validating the status reason is New for TR:" + topuptenancyrequest);
StringAssert.Contains(tenancyReqPage.GetFundedStatus(), "","Validating the processing status is blank for TR:" + topuptenancyrequest);
try
{
tenancyReqPage.SetRequestTypeListValue("Bond Lodgement");
}
catch (Exception)
{
new AssertFailedException("Request Type in Child Tenacy Req" + topuptenancyrequest + " not editable after deactivating the payment ref record in req batch:" + requestBatch);
}
}
public void ATC5511_CRMBPayReferenceNewLodgement()
{
#region Start Up Excel
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() == "5511")
{
MyRow = i;
break;
}
}
#endregion
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
HomePage homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
string initialRequestParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString();
string initialContribution = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString();
//Create New Tenancy Request(Bond Lodgement)
TenancyRequestsSearchPage tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.PopulateMandatoryFieldValues(
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("NO_ROOMS")].Value.ToString(),
initialRequestParty,
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value.ToString(),
initialContribution,
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("LODGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_START")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("ANTICIPATED_END")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
//Create New Batch Request from Tenancy Reuest Page and confirm batch number format correct
string requestBatch = tenancyRequestPage.CreateNewBatchRequest(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(), MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
StringAssert.Contains(requestBatch, "TRB-BL-");
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
StringAssert.Contains(tenancyrequest, "TR-BL-");
tenancyRequestPage.ClickSaveCloseButton();
tenancyRequestPage = new TenancyRequestPage(driver);
//Open RBS>New BatchRequest
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
//Confirm Tenancy request listed in the New Batch Request
RequestBatchesSearchPage requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
Table searchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
searchTable.ClickCellValue("Name", requestBatch, "Name");
RequestBatchPage requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickPageTitle();
Table trTable = new Table(requestBatchPage.GetTenancyRequestTable());
string actualTenancyRequest = trTable.GetCellValue("Managing Party", MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(),"Name");
Assert.AreEqual(tenancyrequest, actualTenancyRequest,"Validating the Tenancy request listed in NewBatch Request");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public string CreateNewBatchRequest(string managingParty,string paymentType)
{
this.ClickNewRequestBatch();
RequestBatchPage requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickPageTitle();
requestBatchPage.SetManagingPartyText(managingParty);
requestBatchPage.SetPaymentType(paymentType);
requestBatchPage.ClickSaveButton();
string requestBatch = requestBatchPage.GetRequestNumber();
requestBatchPage.ClickSaveCloseButton();
WebDriverWait waitHandle = new WebDriverWait(driver, TimeSpan.FromSeconds(waitsec));
waitHandle.Until((d) => { return d.WindowHandles.Count == 1; });
driver.SwitchTo().Window(driver.WindowHandles[0]);
return requestBatch;
}
public void ATC5506_CRMAutomaticallyrecordapaymentreferencenumberforthelodgement()
{
#region Start Up Excel
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() == "TR_TestData")
{
MyRow = i;
break;
}
}
#endregion
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
HomePage homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
TenancyRequestsSearchPage tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
string initialRequestParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString();
string initialContribution = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString();
tenancyRequestPage.PopulateTenancyRequestValidationSuccessful(
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("NO_ROOMS")].Value.ToString(),
initialRequestParty,
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value.ToString(),
initialContribution,
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("LODGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_START")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("ANTICIPATED_END")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
StringAssert.Contains(tenancyrequest, "TR-BL-");
tenancyRequestPage.ClickSaveCloseButton();
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
RequestBatchesSearchPage requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.ClickNewRequestBatchButton();
RequestBatchPage requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickPageTitle();
requestBatchPage.ClickPageTitle();
requestBatchPage.SetManagingPartyText(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString());
requestBatchPage.SetPaymentType(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
requestBatchPage.ClickSaveButton();
string requestBatch = requestBatchPage.GetRequestNumber();
StringAssert.Contains(requestBatch, "TRB-BL-");
//Add tenancy requests
string TR1reference = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value.ToString();
requestBatchPage.ClickAddAssociatedRequestsButton();
requestBatchPage.SetAssociatedRequest(TR1reference);
requestBatchPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
tenancyRequestPage.ClickSaveCloseButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
Table table = new Table(requestBatchSearchPage.GetSearchResultTable());
Assert.IsTrue(requestBatchSearchPage.GetPaymentRefernceRefreshTable(requestBatch));
table = new Table(requestBatchSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", requestBatch, "Name");
requestBatchPage = new RequestBatchPage(driver);
table = new Table(requestBatchPage.GetPaymentSummaryResultTable());
table.GetCellValue("Request Batch", requestBatch, "Reference Number");
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.SetTenancyRequestSearchText(tenancyrequest);
table = new Table(tenancyRequestsSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyrequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
StringAssert.Contains(tenancyRequestPage.GetFundedStatus(), "Payment pending");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6709c_CRMTenancyRequestBatchReadOnlywhenBPaygenerated()
{
#region Start Up Excel
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() == "6709c")
{
MyRow = i;
break;
}
}
#endregion
User user = this.environment.GetUser(SecurityRole.Default);
new LoginDialog().Login(user.Id, user.Password);
HomePage homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
RequestBatchesSearchPage requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.ClickNewRequestBatchButton();
RequestBatchPage requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.SetManagingPartyText(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString());
requestBatchPage.SetPaymentType(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
requestBatchPage.ClickSaveButton();
string requestBatch = requestBatchPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = requestBatch;
StringAssert.Contains(requestBatch, "TRB-BL-");
//Add tenancy requests
//Get specific row for the data
int TR1Row = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "6709a")
{
TR1Row = i;
break;
}
}
string TR1reference = MyRange.Cells[TR1Row, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value.ToString();
//Get specific row for the data
int TR2Row = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "6709b")
{
TR2Row = i;
break;
}
}
string TR2reference = MyRange.Cells[TR2Row, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value.ToString();
requestBatchPage.ClickAddAssociatedRequestsButton();
requestBatchPage.SetAssociatedRequest(TR1reference);
requestBatchPage.ClickAddAssociatedRequestsButton();
requestBatchPage.SetAssociatedRequest(TR2reference);
requestBatchPage.SetStatusReason("Ready for validation");
//requestBatchPage.ClickSaveButton();
//StringAssert.Contains(requestBatchPage.GetValidationStatusReason(), "Validation successful");
requestBatchPage.ClickSaveCloseButton();
requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
Assert.IsTrue(requestBatchSearchPage.GetPaymentRefernceRefreshTable(requestBatch));
Table table = new Table(requestBatchSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", requestBatch, "Name");
requestBatchPage = new RequestBatchPage(driver);
table = new Table(requestBatchPage.GetPaymentSummaryResultTable());
StringAssert.Contains(table.GetCellValue("Request Batch", requestBatch, "Request Batch"), requestBatch);
StringAssert.Contains(table.GetCellValue("Request Batch", requestBatch, "Payment Type"), "BPay");
StringAssert.Contains(table.GetCellValue("Request Batch", requestBatch, "Amount"), "$1,600.00");
StringAssert.Contains(table.GetCellValue("Request Batch", requestBatch, "Client"), MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString());
string referencenumber = table.GetCellValue("Request Batch", requestBatch, "Reference Number");
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAY_REF_NUMBER")].Value = referencenumber;
StringAssert.Contains(requestBatchPage.GetStatusReason(), "Pending Financials");
StringAssert.Contains(requestBatchPage.GetFundedStatus(), "Payment pending");
//Create EFT file with new reference number
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("OUTFILE")].Value =
Utils.BAI2FileCreator.bAI2FileCreator(referencenumber, MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString());
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
