public void ATC6837c_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;
//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() == "Topup_6837")
{
tRow1 = i;
break;
}
}
#endregion
string managepingParty = MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
//Creating topup tenancy req for 6837
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();
tenancyRequestPage.PopulateTenancyRequestValidationSuccessful(
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString(),
managepingParty,
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("TENANCY_TYPE")].Value.ToString(),
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("MANAGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("NO_ROOMS")].Value.ToString(),
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString(),
(MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value + 50).ToString(),
"25",
"50",
"Top up",
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("TENANCY_START")].Value.ToString(),
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("ANTICIPATED_END")].Value.ToString(),
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
tenancyRequestPage.SetDwellingTypeListValue(MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("DWELLING_TYPE")].Value.ToString());
tenancyRequestPage.SetTenancyValue(MyRange.Cells[tRow1 , TenancyRequestSchema.GetColumnIndex("BOND_REF")].Value.ToString());
tenancyRequestPage.ClickSaveButton();
string topuptenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[tRow1, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = topuptenancyrequest;
tenancyRequestPage.ClickSaveCloseButton();
//Creating one initial tenacy request for 6837
int tRow2 = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "Initial_6837")
{
tRow2 = i;
break;
}
}
tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.PopulateTenancyRequestValidationSuccessful(
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString(),
managepingParty,
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("TENANCY_TYPE")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("MANAGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("NO_ROOMS")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("LODGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("TENANCY_START")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("ANTICIPATED_END")].Value.ToString(),
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
tenancyRequestPage.SetDwellingTypeListValue(MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("DWELLING_TYPE")].Value.ToString());
tenancyRequestPage.ClickSaveButton();
string initialtenancyrequest = tenancyRequestPage.GetRequestNumber();
tenancyRequestPage.ClickSaveCloseButton();
MyRange.Cells[tRow2, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = initialtenancyrequest;
}
public void ATC6904c_CRMTopupExcessBondValidation()
{
#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() == "Topup_6904")
{
MyRow = i;
break;
}
}
#endregion
string managepingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
//Login as RBS user
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();
//(Template) - Create new Tenancy Request (Bond Lodgement)
TenancyRequestsSearchPage tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
/*Enter details.Details entered
- Tenancy (prepared Tenancy)
- Rooming Accommodation
- Rent subsidy
- rent $200
- amount paId $701*/
tenancyRequestPage.SetRequestTypeListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString());
tenancyRequestPage.SetRentalPremisesValue("*"+MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString());
tenancyRequestPage.SetManagingPartyListValue(managepingParty);
tenancyRequestPage.SetTenancyTypeListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_TYPE")].Value.ToString());
tenancyRequestPage.SetTenancyManagementTypeListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGEMENT_TYPE")].Value.ToString());
tenancyRequestPage.SetInitialRequestPartyWithSearch(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString());
tenancyRequestPage.SetInitialConrtibution("701");
tenancyRequestPage.SetAmountPaidWithLodgement("701");
tenancyRequestPage.SetLodgementTypeListValue("Top up");
tenancyRequestPage.SetWeeklyRent(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value.ToString());
tenancyRequestPage.SetTenancyStartDate(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_START")].Value.ToString());
tenancyRequestPage.SetAnticipatedEndDate(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("ANTICIPATED_END")].Value.ToString());
tenancyRequestPage.SetPaymentType(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
tenancyRequestPage.SetDwellingTypeListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("DWELLING_TYPE")].Value.ToString());
tenancyRequestPage.SetSubsidy("Yes");
tenancyRequestPage.SetTenancyValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("BOND_REF")].Value.ToString());
//Save Tenancy Request
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
//Update Status Reason to 'Ready for validation'
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveCloseButton();
tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.SetTenancyRequestSearchText(tenancyrequest);
Table table = new Table(tenancyRequestsSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyrequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//Confirm Status Reason set to 'Validation failed'
StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Validation failed");
//Confirm Queue reason for excess bond added.Status set to 'To be resolved'
//tenancyRequestPage.ClickQueueReasons();
Table queueReasonTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueReasonTable.GetCellContainsValue("Reason", "Invalid bond amount : Exceeds maximum bond", "Status Reason"), "To be resolved");
//Confirm Maximum Allowed Bond set correctly
//Assert: Maximum Allowed Bond set to $2800
Assert.AreEqual(tenancyRequestPage.GetMaximumAllowedAmount(), "$800.00");
}
public void ATC6911c_TenancytopupvalidationSameaddresssamemanagingparty()
{
#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() == "6911")
{
MyRow = i;
break;
}
}
#endregion
string managepingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].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.ClickRtaTenancyRequestRibbonButton();
TenancyRequestsSearchPage tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.PopulateTenancyRequestValidationSuccessful(
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString(),
managepingParty,
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(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString(),
(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value + 50).ToString(),
"25",
"50",
"Top up",
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.SetTenancyValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("BOND_REF")].Value.ToString());
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
Thread.Sleep(5000);
tenancyRequestPage.ClickSaveButton();
Table table = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(table.GetCellContainsValue("Reason", "Invalid list of Parties", "Tenancy Request"), tenancyrequest);
table.ClickCellContainsValueEnterRow("Reason", "Invalid list of Parties", "Status Reason");
TenancyRequestQueueReasonPage tenancyRequestQueueReasonPage = new TenancyRequestQueueReasonPage(driver);
tenancyRequestQueueReasonPage.SetStatusReasonValue("Resolved", driver);
tenancyRequestQueueReasonPage.ClickSaveCloseButton();
tenancyRequestPage = new TenancyRequestPage(driver);
table = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Status Reason"), "Resolved");
//Add a new request party
string BaseWindow = driver.CurrentWindowHandle; //Records the current window handle
tenancyRequestPage.ClickAddNewRequestPartyImage();
//Enter Request Party details
driver = tenancyRequestPage.SwitchNewBrowser(driver, BaseWindow);
TenancyRequestPartyPage tenancyRequestPartyPage = new TenancyRequestPartyPage(driver);
tenancyRequestPartyPage.SetClientNameValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC1")].Value.ToString());
tenancyRequestPartyPage.SetAmountValue("25");
tenancyRequestPartyPage.ClickSaveCloseButton();
driver = driver.SwitchTo().Window(BaseWindow);
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
Assert.AreEqual(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
tenancyRequestPage.ClickSaveCloseButton();
tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.SetTenancyRequestSearchText(tenancyrequest);
Assert.IsTrue(tenancyRequestsSearchPage.GetPaymentRefernceRefreshTable(tenancyrequest));
table = new Table(tenancyRequestsSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyrequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
table = new Table(tenancyRequestPage.GetPaymentSummaryResultTable());
string referencenumber = table.GetCellValue("Tenancy Request", tenancyrequest, "Reference Number");
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAY_REF_NUMBER")].Value = referencenumber;
StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Pending Financials");
StringAssert.Contains(tenancyRequestPage.GetFundedStatus(), "Payment pending");
////Create EFT file with new reference number
//MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("OUTFILE")].Value = Utils.BAI2FileCreator.bAI2FileCreator(referencenumber, amountOtherParty);
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
