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 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 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 ATC6908_CRMUpdateTenancyRequestPaymentTypeExceptionQueue()
{
#region Start Up Excel
MyBook = MyApp.Workbooks.Open(DatasourceDir + @"\TenancyRequests.xlsx", 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
MySheet = (Excel.Worksheet)MyBook.Sheets[Properties.Settings.Default.ENVIRONMENT.ToString()];
MyRange = MySheet.UsedRange;
//Get specific row for the data
int testDataRows = MyRange.Rows.Count;
int MyRow = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "TR_TestData")
{
MyRow = i;
break;
}
}
#endregion
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
//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 fields populated except Payment type
TenancyRequestsSearchPage tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.PopulateTenancyRequestWithoutPaymentType(
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());
//Record should save successfully
tenancyRequestPage.ClickSaveButton();
string tenancyRequest = tenancyRequestPage.GetRequestNumber();
StringAssert.Contains(tenancyRequest, "TR-BL-","Validating the Tenancy Request saved with the correct TR no fromat");
tenancyRequestPage.ClickSaveCloseButton();
//Open the record again and change the Status Reason to Ready for validation and save
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.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation failed","Validation should fail when payment type is balnk");
//There should be one exception in the queue for Pyment type missing
tenancyRequestPage.ClickQueueReasons();
Table queueTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueTable.GetCellContainsValue("Reason", "Payment Type is blank", "Reason"), "Payment Type is blank");
//Open the exception queue and change the reason to resolved. In the tenancy record select a payment type and change the status reason to Ready for validation - SAVE
UICommon.DoubleClickElement(queueTable.GetCellElementContainsValue("Reason", "Payment Type is blank", "Status Reason"), driver);
TenancyRequestQueueReasonStatusPage tenancyQueueReasonStatusPage = new TenancyRequestQueueReasonStatusPage(driver);
StringAssert.Contains(tenancyQueueReasonStatusPage.GetReasonValue(), "Payment Type is blank");
tenancyQueueReasonStatusPage.SetReasonValue("Resolved");
tenancyQueueReasonStatusPage.ClickSaveCloseButton();
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.SetPaymentType("BPay");
tenancyRequestPage.ClickSaveButton();
//Record should be saved and validation should be successful
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful","Validation should be successful after adding payment type");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC4483_CRMAutomaticallyrecordapaymentreferencenumberforthelodgement()
{
#region Start Up Excel
MyBook = MyApp.Workbooks.Open(DatasourceDir + @"\TenancyRequests.xlsx", 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
MySheet = (Excel.Worksheet)MyBook.Sheets[Properties.Settings.Default.ENVIRONMENT.ToString()];
MyRange = MySheet.UsedRange;
//Get specific row for the data
int testDataRows = MyRange.Rows.Count;
int MyRow = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "TR_TestData")
{
MyRow = i;
break;
}
}
#endregion
string managingParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString();
//string tenancyRequestReference;
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 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.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();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyrequest);
Assert.IsTrue(tenancyRequestSearchPage.GetPaymentRefernceRefreshTable(tenancyrequest));
Table table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyrequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
StringAssert.Contains(tenancyRequestPage.GetFundedStatus(), "Payment pending");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6905_CRMTenancyrequestStatusReasonRemoveValidationSuccessfuldropdownvalue()
{
#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() == "6905")
{
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();
//Attemp to save with Mandatory data
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-");
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
tenancyRequestPage.ClickSaveCloseButton();
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
public void ATC6907_CRMOverrideInvalidKeywordExceptionQueue()
{
#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() == "6907")
{
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();
//Create new Tenancy Request. Fillup the Rental Premises with some address which has keyword like garage
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(),
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.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.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation failed", "Validation should fail when invalid keyword entered in address details");
tenancyRequestPage.ClickQueueReasons();
Table queueTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueTable.GetCellContainsValue("Reason", "Invalid keyword detected", "Reason"), "Invalid keyword detected");
UICommon.DoubleClickElement(queueTable.GetCellElementContainsValue("Reason", "Invalid keyword detected", "Status Reason"),driver);
TenancyRequestQueueReasonStatusPage tenancyQueueReasonStatusPage = new TenancyRequestQueueReasonStatusPage(driver);
Assert.IsFalse(tenancyQueueReasonStatusPage.GetOverrideCheckBoxValue(),"Validating the override checkbox for Invalid keyword queue reason is available for RBS officer");
//Login with any other user other than RBS operation user and see the override can be done by that user
driver.Close();
driver = null;
this.TestSetup();
user = this.environment.GetUser(SecurityRole.GeneralStaff);
new LoginDialog().Login(user.Id, user.Password);
//Navigate to: Rental Bond Services > Tenancy Requests
homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyRequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClickQueueReasons();
queueTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueTable.GetCellContainsValue("Reason", "Invalid keyword detected", "Reason"), "Invalid keyword detected");
//Open the exception queue and change the reason to resolved. In the tenancy record select a payment type and change the status reason to Ready for validation - SAVE
UICommon.DoubleClickElement(queueTable.GetCellElementContainsValue("Reason", "Invalid keyword detected", "Status Reason"), driver);
tenancyQueueReasonStatusPage = new TenancyRequestQueueReasonStatusPage(driver);
tenancyQueueReasonStatusPage.SetOverrideCheckBox(true);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
StringAssert.Contains(tenancyRequestPage.GetAlertMessage(), "Your changes have not been saved");
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
//Create new Tenancy Request with fields populated except Payment type
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyRequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClickQueueReasons();
queueTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueTable.GetCellContainsValue("Reason", "Invalid keyword detected", "Override"), "No");
//Once override is done for that tenancy record for Invalid Keyword exception, it should appear as resolved in the queue in subsequent validations.
//Validation should be successful
driver.Close();
driver = null;
this.TestSetup();
user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
//Navigate to: Rental Bond Services > Tenancy Requests
homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
table.ClickCellValue("Name", tenancyRequest, "Name");
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClickQueueReasons();
queueTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueTable.GetCellContainsValue("Reason", "Invalid keyword detected", "Reason"), "Invalid keyword detected");
UICommon.DoubleClickElement(queueTable.GetCellElementContainsValue("Reason", "Invalid keyword detected", "Status Reason"), driver);
tenancyQueueReasonStatusPage = new TenancyRequestQueueReasonStatusPage(driver);
tenancyQueueReasonStatusPage.SetOverrideCheckBox(true);
tenancyQueueReasonStatusPage.ClickSaveCloseButton();
tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.ClickQueueReasons();
queueTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueTable.GetCellContainsValue("Reason", "Invalid keyword detected", "Override"), "Yes");
tenancyRequestPage.SetStatusReason("Ready for validation");
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
queueTable = new Table(tenancyRequestPage.GetQueueReasonTable());
StringAssert.Contains(queueTable.GetCellContainsValue("Reason", "Invalid keyword detected", "Status Reason"), "Resolved");
#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 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 ATC5512_CRMRaiseExceptionForLodgementExceedingBond()
{
#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() == "5512")
{
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);
//Click [+NEW] button.
tenancyRequestSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//Set {Type} field to Bond Lodgement.
tenancyRequestPage.SetRequestTypeListValue("Bond Lodgement");
//Enter details
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();
StringAssert.Contains(tenancyRequestPage.GetValidationStatusReason(), "Validation successful");
//Confirm Queue reason for excess bond not added
tenancyRequestPage.ClickQueueReasons();
Table table = new Table(tenancyRequestPage.GetQueueReasonTable());
Assert.IsTrue(table.GetNoRecordsInTable());
//Confirm Maximum Allowed Bond set correctly
//Assert: Maximum Allowed Bond set to $400
StringAssert.Contains(tenancyRequestPage.GetMaximumAllowedAmount(), "400");
#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
}
