public void ATC7120a_CRMAC1Fileformatverification()
{
#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()== "7120")
{
MyRow = i;
break;
}
}
#endregion
string managepingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
string amountPaidLodgement = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].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.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
amountPaidLodgement,
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;
tenancyrequest = tenancyRequestPage.GetRequestNumber();
StringAssert.Equals(tenancyrequest, "TR-BL-");
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
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();
StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Pending Financials");
StringAssert.Contains(tenancyRequestPage.GetFundedStatus(), "Payment pending");
table = new Table(tenancyRequestPage.GetPaymentSummaryResultTable());
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Tenancy Request"), tenancyrequest);
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Payment Type"), "BPay");
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Amount"),
((double)Int32.Parse(amountPaidLodgement)).ToString("C"));
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Client"), managepingParty);
string referencenumber = table.GetCellValue("Tenancy Request", tenancyrequest, "Reference Number");
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAY_REF_NUMBER")].Value = referencenumber;
//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 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 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 ATC6629c_CRMTESTINGEndtoEndSingleFormBPayCRM()
{
#region Start Up Excel
MyApp = new Excel.Application();
MyApp.Visible = false;
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()== "6629")
{
MyRow = i;
break;
}
}
#endregion
string tenancyrequest = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value.ToString();
string bond = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("BOND_REF")].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.ClickRtaTenancyRibbonButton();
TenancySearchPage tenancySearchPage = new TenancySearchPage(driver);
tenancySearchPage.SetTenancySearchText(bond);
Table table = new Table(tenancySearchPage.GetSearchResultTable());
table.SelectTableRow("Bond Number", bond);
TenancyPage tenancyPage = new TenancyPage(driver);
tenancyPage.HoverBondPropertyRibbonTab();
tenancyPage.ClickBondTenancyRequestRibbonButton();
tenancyPage.ClickSelectViewButton();
tenancyPage.SetViewList("All Tenancy Requests");
table = new Table(tenancyPage.GetSearchResultTable());
StringAssert.Contains(table.GetCellValue("Name", tenancyrequest, "Name"), tenancyrequest);
table.ClickCellValue("Name", tenancyrequest, "Name");
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
StringAssert.Contains(tenancyRequestPage.GetFundedStatus(), "Financials processing successful");
StringAssert.Contains(tenancyRequestPage.GetPropertyDataControlModeRTAFundedStatus(), "deactivated");
StringAssert.Contains(tenancyRequestPage.GetAmountMatched(), "$1,000.00");
StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Completed");
//reveiced date?? step 19
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
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 ATC9851_CRMChangeOfMPMandatoryFieldsValidationsAC3NoContributorsExceptionOverride()
{
#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() == "9851")
{
MyRow = i;
break;
}
}
#endregion
//Login as RBS Claims Officer user role.
User user = this.environment.GetUser(SecurityRole.RBSClaimsOfficer);
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);
//Click [+NEW] button.
tenancyRequestSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//Set {Type} field to Change of Managing Party.
//
tenancyRequestPage.SetRequestTypeListValue("Change of Managing Party");
//Populate all other mandatory fields required for successful validation (as per stories 6792/6793) without a Request Party
tenancyRequestPage.PopulateTenancyRequestChangeOfManagingPartyWithoutRequestParty(
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")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC1")].Value.ToString(),
DateTime.Now.ToString("dd/MM/yyyy"),
DateTime.Now.ToString("dd/MM/yyyy"),
DateTime.Now.ToString("dd/MM/yyyy"),
DateTime.Now.ToString("dd/MM/yyyy"),
"Signature verified",
"Signature verified");
//Click [Save] button to unlock {Status Reason}
tenancyRequestPage.ClickSaveButton();
//Set {Status Reason} to "Ready for validation".
tenancyRequestPage.SetStatusReason("Ready for validation");
//Click [Save] button.
tenancyRequestPage.ClickSaveButton();
//Assert: {Status Reason} becomes "Validation failed".
StringAssert.Equals(tenancyRequestPage.GetStatusReason(), "Validation failed");
//Inspect Queue Reasons section.
tenancyRequestPage.ClickQueueReasons(); //This may not be necessary.
//Assert: An exception queue entry is created with reason type: "At least one contributor required"
Table table = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(table.GetCellContainsValue("Reason", "Invalid number of contributors", "Reason"), "Invalid number of contributors");
//Double-click on exception queue record.
//UICommon.DoubleClickElement(table.GetCellElementContainsValue("Reason", "Invalid Contributor : At least one contributor required", "Status Reason"), driver);
table.ClickCellContainsValueEnterRow("Reason", "Invalid number of contributors", "Status Reason");
TenancyRequestQueueReasonPage tenancyRequestQueueReasonPage = new TenancyRequestQueueReasonPage(driver);
//Click {Override} checkbox to select/tick it.
tenancyRequestQueueReasonPage.SetOverrideCheckBox(true);
//Click [SAVE & CLOSE] button.
tenancyRequestQueueReasonPage.ClickSaveCloseButton();
tenancyRequestPage = new TenancyRequestPage(driver);
//Set {Status Reason} to "Ready for validation".
tenancyRequestPage.SetStatusReason("Ready for validation");
//Click [Save] button.
tenancyRequestPage.ClickSaveButton();
string tenancyRequest = tenancyRequestPage.GetRequestNumber();
tenancyRequestPage.ClickSaveCloseButton();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
table.GetCellValue("", "", "");
//Assert: {Status Reason} becomes "Validation successful".
//StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Validation successful");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6629a_CRMTESTINGEndtoEndSingleFormBPayCRM()
{
#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()== "6629")
{
MyRow = i;
break;
}
}
#endregion
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
//read excel file and get test data for this test
// store test data in a class so that it can be used later
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(),
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(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
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();
StringAssert.Equals(tenancyrequest, "TR-BL-");
//Add a new request party
//tenancyRequestPage.ClickRequestPartyAssociated();
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("500.00");
tenancyRequestPartyPage.ClickSaveCloseButton();
string amountOtherParty = (MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value + 500).ToString();
driver = driver.SwitchTo().Window(BaseWindow);
tenancyRequestPage = new TenancyRequestPage(driver);
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());
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Tenancy Request"), tenancyrequest);
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Request Batch"), "");
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Payment Type"), "BPay");
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Amount"), "$2,000.00");
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Client"), "BLAIR TEST");
string referencenumber = table.GetCellValue("Tenancy Request", tenancyrequest, "Reference Number");
StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Pending Financials");
StringAssert.Contains(tenancyRequestPage.GetFundedStatus(), "Payment pending");
string dateValue = DateTime.Today.AddDays(-1).ToString("yyyyMMdd");
string fileLocation = Utils.BPayFileCreator.bPayFileCreator(referencenumber, dateValue, tenancyrequest, "200000");
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("OUTFILE")].Value = fileLocation;
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAY_REF_NUMBER")].Value = referencenumber;
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6751a_CRMBTriggerUpdateToCheque()
{
#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() == "6751")
{
MyRow = i;
break;
}
}
#endregion
string managingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
string initialRequestParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString();
string amountOtherParty = (MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value +
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC2")].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.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(),
managingParty,
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.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
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 = new TenancyRequestPage(driver);
tenancyRequestPage.SetDwellingTypeListValue("House");
tenancyRequestPage.ClickSaveButton();
string tenancyRequest = tenancyRequestPage.GetRequestNumber();
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
tenancyRequestPage.ClickSaveCloseButton();
//Reopen the record and change the status reason to Ready for Validation and save.The record should show an exception with Invalid Keyword
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
Table table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyRequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
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
}
public void ATC7632_TopUpEFTReferenceTRSuccessful()
{
#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() == "7632")
{
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();
//Attemp to save with Mandatory data
string managingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
tenancyRequestPage.PopulateTenancyRequestTopUpValidationSuccessful(
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString(),
managingParty,
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.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
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(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY")].Value.ToString());
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
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(tenancyRequestPage.GetPaymentSummaryResultTable());
table.ClickCellValue("Name", tenancyrequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
table = new Table(tenancyRequestPage.GetPaymentSummaryResultTable());
//asserts if Payment Reference Number is >= 30000000
string referencenumber = table.GetCellValue("Tenancy Request", tenancyrequest, "Reference Number");
StringAssert.StartsWith(referencenumber, "3");
Assert.IsTrue(referencenumber.Length == 8);
Assert.IsTrue(int.Parse(referencenumber.Substring(1).TrimStart('0')) > 0);
StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Pending Financials");
//asserts if record is read only
Console.Write(tenancyRequestPage.GetRecordStatus());
StringAssert.Equals(tenancyRequestPage.GetRecordStatus(), "Read only");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6738_RaiseExceptionInvalidKeyword()
{
#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() == "6362")
{
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();
string rentalPremises = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].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);
//(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");
/*Select 'Australian Physical' as the Type.Enter an address into the fields on the Address Detail record. As part of the address that you enter, Type in the word 'Garage' into the 'Complex Unit Number' field
Click on the Save & Close button*/
string[] address = rentalPremises.Split(',');
string complexunitno = address[0];
string roadno = address[1].Split(' ')[1];
string roadname = address[1].Split(' ')[2];
string locality = address[2].Split(' ')[1] + "," + address[3] + "," + address[4];
tenancyRequestPage.CreateNewAddress(roadno,roadname,locality,"","",complexunitno);
tenancyRequestPage = new TenancyRequestPage(driver);
//Select the mandatory fields for the Tenancy Request.Add a new Request Party whose contribution amount is the same as the Amount Paid with Lodgement
tenancyRequestPage.PopulateTenancyRequestWithoutRentalPremisesFromAddressDetailAssociatedView(
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].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.SetDwellingTypeListValue("House");
//Save the Tenancy Request
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
//Set the status of the Tenancy Request to be 'Ready for Validation' Validation process for the Tenancy Request is started
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
Thread.Sleep(3000);
//The status of the Tenancy Request should be set to Validation failed
StringAssert.Contains(tenancyRequestPage.GetStatusReason(), "Validation failed");
//Check the Queue Reasons of the Tenancy Request.There should be a queue reason that exists which is for 'Invalid address: Invalid key word detected'
//tenancyRequestPage.ClickQueueReasons();
Table queueReasonTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueReasonTable.GetCellContainsValue("Reason", "Invalid address : Invalid keyword detected", "Status Reason"), "To be resolved");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6362a_E2ESingleBPAYCancelTenancyRequest()
{
#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() == "6362")
{
MyRow = i;
break;
}
}
#endregion
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();
string managingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
string initialRequestParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString();
/*Data prep:
1 x Address Detail record including the word "Garage";
1 x Tenancy Request (Bond Lodgment) record at "New" that will fail address validation for invalid keyword (i.e. using prepared address), not already associated to a Tenancy, not associated to a batch, Amount Paid with Lodgement matches Sum of Contributions, Managing Party client that does not already exist within AX;
n x Tenancy Request Party records associated to the Tenancy Request using Client records that do not already exist within AX*/
TenancyRequestsSearchPage tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.PopulateTenancyRequestWithNoInitialAndManagingParty(
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].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(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
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.CreateNewClient(managingParty);
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.SetInitialRequestPartyWithSearch(initialRequestParty);
tenancyRequestPage.SetDwellingTypeListValue("House");
tenancyRequestPage.ClickSaveButton();
string tenancyRequest = tenancyRequestPage.GetRequestNumber();
StringAssert.Contains(tenancyRequest, "TR-BL-", "Validating the Tenancy Request saved with the correct TR no fromat");
tenancyRequestPage.ClickSaveCloseButton();
//Reopen the record and change the status reason to Ready for Validation and save.The record should show an exception with Invalid Keyword
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();
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveCloseButton();
//Navigate to Queue - BL failed validation
homePage.HoverRBSRibbonTab();
homePage.ClickRtaQueuesButton();
QueueSearchPage queuePage = new QueueSearchPage(driver);
queuePage.SetPageFilterList("All Items");
queuePage.SetQueue("Bond lodgement failed validation");
Table queueTable = new Table(queuePage.GetSearchResultTable());
//Open the Tenancy Request from the queue.Tenancy Request record displayed, status reason "Validation failed"at least one Request Queue Reason record created for invalid address keyword with status reason "To be resolved"
queueTable.ClickCellContainsValue("Title", tenancyRequest, "Title");
tenancyRequestPage = new TenancyRequestPage(driver);
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation failed", "Validation should fail when invalid keyword entered in address details");
//tenancyRequestPage.ClickQueueReasons();
Table queueReasonTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueReasonTable.GetCellContainsValue("Reason", "Invalid keyword detected", "Status Reason"), "To be resolved");
//De-activate the Tenancy Request and refresh the record.Tenancy Request record updated with Status "Inactive", Status Reason "Cancelled", Tenancy not populated
tenancyRequestPage.ClickDeactivateButton();
WarningDialogueFramePage warningPage = new WarningDialogueFramePage(driver);
warningPage.ClickProcessBeginButton();
Thread.Sleep(5000);
tenancyRequestPage = new TenancyRequestPage(driver);
Assert.AreEqual(tenancyRequestPage.GetStatusReason(), "Cancelled", "Validating that TR:" + tenancyRequest + " Status Reason becomes Cancelled after deactivating the record");
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
//Validate whether TR found in the list of recent Inactive Tenancy Requests
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetPageFilterList("Inactive Tenancy Requests");
//Table tenancyRequestSearchHeaderTable = new Table(tenancyRequestSearchPage.GetHeaderSearchResultTable());
//tenancyRequestSearchHeaderTable.ClickTableColumnHeader("Created On");
// tenancyRequestSearchHeaderTable.ClickTableColumnHeader("Created On");
Table tenancyRequestSearchTable = new Table(tenancyRequestSearchPage.GetSearchResultTable());
StringAssert.Contains(tenancyRequestSearchTable.GetCellContainsValue("Name", tenancyRequest, "Name"), tenancyRequest,"Validating the inactive tenancy request table has the deactivated tenancy request");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC4520_RaiseExceptionForExcessBond()
{
#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() == "4520")
{
MyRow = i;
break;
}
}
#endregion
//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);
//(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");
/*Enter details:Details entered
- Residential Tenancy
- No rent subsidy
- rent $700
- amount paId $2801*/
tenancyRequestPage.PopulateTenancyRequestFormBondLodgement(
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("WEEKLY_RENT")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
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(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC1")].Value.ToString()); //Rental subsidy
//Save Tenancy Request
tenancyRequestPage.ClickSaveButton();
//Update Status Reason to 'Ready for validation' and Save
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
//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
StringAssert.Contains(tenancyRequestPage.GetMaximumAllowedAmount(), "2,800.00");
//TODO:Step is not clear.To be implemented
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC7081a_CRMEFTreceiptforSingleBond()
{
#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() == "7081")
{
MyRow = i;
break;
}
}
#endregion
string managepingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
string tenancyrequest;
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 amountPaidLodgement = ((double)Int32.Parse(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString())).ToString("C");
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.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString(),
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();
tenancyrequest = tenancyRequestPage.GetRequestNumber();
StringAssert.Contains(tenancyrequest, "TR-BL-");
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
//Add a new request party
//tenancyRequestPage.ClickRequestPartyAssociated();
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(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC2")].Value.ToString());
tenancyRequestPartyPage.ClickSaveCloseButton();
string amountOtherParty = (MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value +
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MISC2")].Value).ToString();
driver = driver.SwitchTo().Window(BaseWindow);
tenancyRequestPage = new TenancyRequestPage(driver);
Thread.Sleep(2000);
tenancyRequestPage.CheckForErrors();
tenancyRequestPage.ClickPageTitle();
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());
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Tenancy Request"), tenancyrequest);
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Payment Type"), "EFT");
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Amount"), amountPaidLodgement);
StringAssert.Contains(table.GetCellValue("Tenancy Request", tenancyrequest, "Client"), managepingParty);
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
//string fileLocation = Utils.EFTFileCreator.eFTFileCreator(tenancyrequest, referencenumber);
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("OUTFILE")].Value = Utils.BAI2FileCreator.bAI2FileCreator(referencenumber, amountOtherParty);
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
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
}
