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 ATC6790_TenancyRequestRoomingAccomodation()
{
#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() == "6790")
{
MyRow = i;
break;
}
}
#endregion
string initialRequestParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString();
string initialContribution = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString();
//Login as RBS user
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
//Navigate to: Rental Bond Services > Tenancy Requests
HomePage homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
TenancyRequestsSearchPage tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetPageFilterList("All Tenancy Requests");
Table table = new Table(tenancyRequestSearchPage.GetHeaderSearchResultTable());
table.ClickTableColumnHeader("Created On");
table.ClickTableColumnHeader("Created On");
Table searchTable = new Table(tenancyRequestSearchPage.GetSearchResultTable());
string lastCreatedTenancyReqNo = searchTable.GetCellContainsValue("Name", "TR-BL", "Name");
//(Template) - Create new Tenancy Request (Bond Lodgement)
tenancyRequestSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//Set {Type} field to Bond Lodgement.
tenancyRequestPage.SetRequestTypeListValue("Bond Lodgement");
tenancyRequestPage.SetTenancyTypeListValue("Rooming Accommodation");
//Check Dwelling Type field 1. Lookup list filtered to only: [ Boarding House | Supported Accommodation | Student Accommodation off Campus |Studio]
Assert.IsTrue(tenancyRequestPage.GetDwellingTypeText("Boarding House"));
tenancyRequestPage.ClickPageTitle();
Assert.IsTrue(tenancyRequestPage.GetDwellingTypeText("Supported Accommodation"));
tenancyRequestPage.ClickPageTitle();
Assert.IsTrue(tenancyRequestPage.GetDwellingTypeText("Student Accommodation off Campus"));
tenancyRequestPage.ClickPageTitle();
Assert.IsTrue(tenancyRequestPage.GetDwellingTypeText("Studio"));
//Set Dwelling Type to Boarding House.Number of Bedrooms defaults to 1 and shows as read only
tenancyRequestPage.SetDwellingTypeListValue("Boarding House");
tenancyRequestPage.ClickPageTitle();
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedrooms(), "1");
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedroomsProperty("data-controlmode"), "locked");
//Set Dwelling Type to Supported Accommodation.Number of Bedrooms defaults to 1 and shows as read only
tenancyRequestPage.SetDwellingTypeListValue("Supported Accommodation");
tenancyRequestPage.ClickPageTitle();
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedrooms(), "1");
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedroomsProperty("data-controlmode"), "locked");
//Set Dwelling Type to Studio Number of Bedrooms defaults to 1 and shows as read only
tenancyRequestPage.SetDwellingTypeListValue("Studio");
tenancyRequestPage.ClickPageTitle();
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedrooms(), "1");
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedroomsProperty("data-controlmode"), "locked");
//Set Dwelling Type to Student Accommodation off Campus.Number of Bedrooms defaults to 1 and shows as read only
tenancyRequestPage.SetDwellingTypeListValue("Student Accommodation off Campus");
tenancyRequestPage.ClickPageTitle();
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedrooms(), "1");
StringAssert.Contains(tenancyRequestPage.GetNumberOfBedroomsProperty("data-controlmode"), "locked");
//Check Management Type field. Lookup list filtered to only: [ Owner (or can be Lessor/Owner) | Real Estate Agent | Manager/provider | Other ]
Assert.IsTrue(tenancyRequestPage.GetTenancyManagementTypeListValue("Lessor/Owner"));
Assert.IsTrue(tenancyRequestPage.GetTenancyManagementTypeListValue("Real Estate Agent"));
Assert.IsTrue(tenancyRequestPage.GetTenancyManagementTypeListValue("Manager/provider"));
Assert.IsTrue(tenancyRequestPage.GetTenancyManagementTypeListValue("Other"));
//Set Rental Premise to an address with the following details: [Type, "Australian Physical" | Locality populated | Room/Site Number NOT populated]
//Example:"33 SHORE ST, EAST BRISBANE, QLD, 4169"
string roadnumber = "33";
string roadname = "SHORE ST";
string locality = "EAST BRISBANE, QLD, 4169";
tenancyRequestPage.CreateNewAddress(roadnumber,roadname,locality);
tenancyRequestPage = new TenancyRequestPage(driver);
//Populate mandatory fields. Save record.
tenancyRequestPage.SetManagingPartyListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].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(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString());
tenancyRequestPage.SetAmountPaidWithLodgement(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString());
tenancyRequestPage.SetLodgementTypeListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("LODGEMENT_TYPE")].Value.ToString());
tenancyRequestPage.ClickSaveButton();
//Record saves. Soft warning (Missing room number): DISPLAYED
StringAssert.Contains(tenancyRequestPage.GetWarningMessage(), "The selected address does not have a Room/Site number.");
/*The Name field for the Tenancy Request will be populated with 'TR-BL-' and concatenated with the Reference Number field that will be populated
with increments of 1 from the most recent Tenancy request record. Example: Given the most recent Tenancy Request name is 'TR-BL-20000016' then this record will be 'TR-BL-20000017'*/
string tenancyRequest = tenancyRequestPage.GetRequestNumber();
StringAssert.Contains(tenancyRequest, "TR-BL", "Validating the newly created tenancy request has TR-BL format");
int oldTRNo = Int32.Parse(lastCreatedTenancyReqNo.Split('-')[2]);
int newTRNo = Int32.Parse(tenancyRequest.Split('-')[2]);
Assert.AreEqual(oldTRNo + 1, newTRNo, "Validating the TR No is incremented by 1 from the last created TR");
tenancyRequestPage.ClickSaveCloseButton();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
searchTable = new Table(tenancyRequestSearchPage.GetSearchResultTable());
//Check record in record grid. As updated/entered
StringAssert.Contains(searchTable.GetCellContainsValue("Name",tenancyRequest,"Tenancy Type"), "Rooming Accommodation");
StringAssert.Contains(searchTable.GetCellContainsValue("Name",tenancyRequest,"Managing Party"),MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString());
StringAssert.Contains(searchTable.GetCellContainsValue("Name",tenancyRequest,"Rental Premises"),MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString());
StringAssert.Contains(searchTable.GetCellContainsValue("Name", tenancyRequest, "Dwelling Type"), "Student Accommodation off Campus");
StringAssert.Contains(searchTable.GetCellContainsValue("Name", tenancyRequest, "Amount Bond Paid with Lodgement").Replace(",",""), MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString());
searchTable.ClickCellContainsValue("Name", tenancyRequest, "Name");
//Remove Rental Premise address. Save record. Record not saved as field is mandatory.
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClearRentalPremisesValue();
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetRentalPremiseAddressErrorText(), "You must provide a value for Rental Premises.");
tenancyRequestPage.ClickPageTitle();
//Set Rental Premise to an address with the following details: [Type, "Australian Physical" | Locality populated | Room/Site Number populated]
//Example: "RM 4, 33 SHORE ST, EAST BRISBANE, QLD, 4101" Record saves. Soft warning (Missing room number): NOT DISPLAYED
string roomtype = "Room";
string roomno = "4";
tenancyRequestPage.CreateNewAddress(roadnumber, roadname, locality, roomtype, roomno);
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickSaveButton();
Assert.IsFalse(tenancyRequestPage.GetWarningMessage().Contains("The selected address does not have a Room/Site number."));
tenancyRequestPage.ClickSaveCloseButton();
//Check record in record grid As updated/entered
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
searchTable = new Table(tenancyRequestSearchPage.GetSearchResultTable());
StringAssert.Contains(searchTable.GetCellContainsValue("Name", tenancyRequest, "Rental Premises"), "RM 4, 33 SHORE ST, EAST BRISBANE, QLD, 4169");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6904a_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
//Data preparation step-Tenancy with bond balance of 100
//Creating a tenancy request for the data prep
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.SetRequestTypeListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString());
string rentalPremises = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString();
string[] address = rentalPremises.Split(',');
string roadno = address[0].Split(' ')[0];
string roadname = address[0].Split(' ')[1];
string locality = address[1].Split(' ')[1] + "," + address[2] + "," + address[3];
tenancyRequestPage.CreateNewAddress(roadno,roadname,locality,"Room");
tenancyRequestPage = new TenancyRequestPage(driver);
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(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString());
tenancyRequestPage.SetAmountPaidWithLodgement(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString());
tenancyRequestPage.SetLodgementTypeListValue(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("LODGEMENT_TYPE")].Value.ToString());
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.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
string amount = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString();
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
tenancyRequestPage.ClickSaveCloseButton();
tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.SetTenancyRequestSearchText(tenancyrequest);
Assert.IsTrue(tenancyRequestsSearchPage.GetPaymentRefernceRefreshTable(tenancyrequest));
Table 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 BPay file with new reference number
string dateValue = DateTime.Today.ToString("yyyyMMdd");
string fileLocation = Utils.BPayFileCreator.bPayFileCreator(referencenumber, dateValue, tenancyrequest, MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString() + "00");
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("OUTFILE")].Value = fileLocation;
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6708_CRMDistributeAmountForContributors()
{
#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() == "6708")
{
MyRow = i;
break;
}
}
#endregion
string secondContributor = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC1")].Value.ToString();
string thridContributor = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC2")].Value.ToString();
//Login as RBS Operations Standard user role.
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
//Navigate to: Rental Bond Services > Tenancy Requests
HomePage homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
//Create new Tenancy Request with mandatory fields populated
TenancyRequestsSearchPage tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.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.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());
//Save Tenancy Record
tenancyRequestPage.ClickSaveButton();
string tenancyRequest = tenancyRequestPage.GetRequestNumber();
//Inspect Screen for Warnings "Warning displays that {Amount Paid with Lodgement} field <> sum of contributors."
string warningMessage = tenancyRequestPage.GetWarningMessage();
StringAssert.Contains(warningMessage, "Sum of Request does not equal the amount entered for Amount Paid with Lodgement","Validating the warning appears");
//Click the ribbon button Distribute and Save the record. Warnings should disappear
string alertMessage = tenancyRequestPage.ClickDistributeButton();
StringAssert.Contains(alertMessage, "Distribution process has been initiated");
//TODO:This is an issue an extra save dialog pops up and clicking OK button on this.
string saveMessage = tenancyRequestPage.GetAlertMessage();
StringAssert.Contains(saveMessage, "Your changes have not been saved");
warningMessage = tenancyRequestPage.GetWarningMessage();
Assert.AreEqual(warningMessage, "","Validating that warning message disappeared");
//Add another contributor and populate amount field with > $1. Save Record. Warning should appear.
string BaseWindow = driver.CurrentWindowHandle; //Records the current window handle
tenancyRequestPage.ClickAddNewRequestPartyImage();
Thread.Sleep(2000);
driver = tenancyRequestPage.SwitchNewBrowser(driver, BaseWindow);
TenancyRequestPartyPage tenancyRequestPartyPage = new TenancyRequestPartyPage(driver);
tenancyRequestPartyPage.ClickPageTitle();
tenancyRequestPartyPage.SetClientNameValue(secondContributor);
tenancyRequestPartyPage.SetAmountValue("100");
tenancyRequestPartyPage.ClickSaveCloseButton();
driver = driver.SwitchTo().Window(BaseWindow);
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClickSaveButton();
//TODO:Issue the waning does not appear without refreshing the record.This is a workaround.
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
Table table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
StringAssert.Contains(table.GetCellValue("Name", tenancyRequest, "Status Reason"), "New");
table.ClickCellValue("Name", tenancyRequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//Inspect warning appears
warningMessage = tenancyRequestPage.GetWarningMessage();
StringAssert.Contains(warningMessage, "Sum of Request does not equal the amount entered for Amount Paid with Lodgement","Validating that the warning appears");
//Add another contributor and populate amount field with > $1. Save Record. Warning should appear.
BaseWindow = driver.CurrentWindowHandle; //Records the current window handle
tenancyRequestPage.ClickAddNewRequestPartyImage();
Thread.Sleep(2000);
driver = tenancyRequestPage.SwitchNewBrowser(driver, BaseWindow);
tenancyRequestPartyPage = new TenancyRequestPartyPage(driver);
tenancyRequestPartyPage.ClickPageTitle();
tenancyRequestPartyPage.SetClientNameValue(thridContributor);
tenancyRequestPartyPage.SetAmountValue("100");
tenancyRequestPartyPage.ClickSaveCloseButton();
driver = driver.SwitchTo().Window(BaseWindow);
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClickSaveButton();
//Inspect warning appears
warningMessage = tenancyRequestPage.GetWarningMessage();
StringAssert.Contains(warningMessage, "Sum of Request does not equal the amount entered for Amount Paid with Lodgement","Validating that the warning appears");
//Click the ribbon button Distribute and Save the record. Warning should disappear.
alertMessage = tenancyRequestPage.ClickDistributeButton();
StringAssert.Contains(alertMessage, "Distribution process has been initiated");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickSaveButton();
//Issue the waning does disappear not appear without refreshing the record.This is a workaround.
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
StringAssert.Contains(table.GetCellValue("Name", tenancyRequest, "Status Reason"), "New");
table.ClickCellValue("Name", tenancyRequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//Warning disappears
warningMessage = tenancyRequestPage.GetWarningMessage();
Assert.AreEqual(warningMessage, "", "Validating that warning message disappeared");
//Modify amount paid with lodgemnt to $1500 and inspect warning appears
tenancyRequestPage.SetAmountPaidWithLodgement("1500");
tenancyRequestPage.ClickSaveButton();
warningMessage = tenancyRequestPage.GetWarningMessage();
StringAssert.Contains(warningMessage, "Sum of Request does not equal the amount entered for Amount Paid with Lodgement","Validating that the warning appears");
//TODO:Modify Contibutor amount to be different but still adds up to amount. Inspect warning disappears
Table requestPartyTable = new Table(tenancyRequestPage.GetRequestPartyTable());
StringAssert.Contains(requestPartyTable.GetCellContainsValue("Client", secondContributor, "Request Amount"), "400");
BaseWindow = driver.CurrentWindowHandle;
UICommon.DoubleClickElement(requestPartyTable.GetCellElementContainsValue("Client", secondContributor, "Client"), driver);
Thread.Sleep(1000);
driver = tenancyRequestPage.SwitchNewBrowser(driver, BaseWindow);
tenancyRequestPartyPage = new TenancyRequestPartyPage(driver);
tenancyRequestPartyPage.ClickPageTitle();
tenancyRequestPartyPage.SetAmountValue("700");
tenancyRequestPage.ClickSaveCloseButton();
driver = driver.SwitchTo().Window(BaseWindow);
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClickSaveButton();
//TODO.WArnings does not disappear without refreshing the record. This is a workaround.
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
StringAssert.Contains(table.GetCellValue("Name", tenancyRequest, "Status Reason"), "New");
table.ClickCellValue("Name", tenancyRequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//Warning disappears
warningMessage = tenancyRequestPage.GetWarningMessage();
Assert.AreEqual(warningMessage, "", "Validating that warning message disappeared");
//Modify amount paid with lodgement to be $900
tenancyRequestPage.SetAmountPaidWithLodgement("900");
tenancyRequestPage.ClickSaveButton();
//Warning appears
warningMessage = tenancyRequestPage.GetWarningMessage();
StringAssert.Contains(warningMessage, "Sum of Request does not equal the amount entered for Amount Paid with Lodgement","Validating that the warning appesrs");
//Click Distribute and save the record. Warning should disappear
tenancyRequestPage.ClickDistributeButton();
tenancyRequestPage.ClickSaveButton();
warningMessage = tenancyRequestPage.GetWarningMessage();
Assert.AreEqual(warningMessage, "", "Validating that warning message disappeared");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
