public void ATC5511_CRMBPayReferenceNewLodgement()
{
#region Start Up Excel
MyBook = MyApp.Workbooks.Open(DatasourceDir + @"\TenancyRequests.xlsx", 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
MySheet = (Excel.Worksheet)MyBook.Sheets[Properties.Settings.Default.ENVIRONMENT.ToString()];
MyRange = MySheet.UsedRange;
//Get specific row for the data
int testDataRows = MyRange.Rows.Count;
int MyRow = 0;
for (int i = 2; i <= testDataRows; i++)
{
if (MyRange.Cells[i, 1].Value.ToString() == "5511")
{
MyRow = i;
break;
}
}
#endregion
User user = this.environment.GetUser(SecurityRole.RBSOfficer);
new LoginDialog().Login(user.Id, user.Password);
HomePage homePage = new HomePage(driver);
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRtaTenancyRequestRibbonButton();
string initialRequestParty = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_REQUEST_PARTY")].Value.ToString();
string initialContribution = MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("INITIAL_CONTRIBUTION")].Value.ToString();
//Create New Tenancy Request(Bond Lodgement)
TenancyRequestsSearchPage tenancyRequestsSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
tenancyRequestsSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.PopulateMandatoryFieldValues(
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("REQUEST_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("RENTAL_PREMISES")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("NO_ROOMS")].Value.ToString(),
initialRequestParty,
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("WEEKLY_RENT")].Value.ToString(),
initialContribution,
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("LODGEMENT_TYPE")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TENANCY_START")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("ANTICIPATED_END")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
//Create New Batch Request from Tenancy Reuest Page and confirm batch number format correct
string requestBatch = tenancyRequestPage.CreateNewBatchRequest(MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(), MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("PAYMENT_TYPE")].Value.ToString());
StringAssert.Contains(requestBatch, "TRB-BL-");
tenancyRequestPage.ClickSaveButton();
string tenancyrequest = tenancyRequestPage.GetRequestNumber();
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("TR_NUMBER")].Value = tenancyrequest;
StringAssert.Contains(tenancyrequest, "TR-BL-");
tenancyRequestPage.ClickSaveCloseButton();
tenancyRequestPage = new TenancyRequestPage(driver);
//Open RBS>New BatchRequest
homePage.HoverCRMRibbonTab();
homePage.ClickRBSRibbonButton();
homePage.HoverRBSRibbonTab();
homePage.ClickRequestBatchRibbonButton();
//Confirm Tenancy request listed in the New Batch Request
RequestBatchesSearchPage requestBatchSearchPage = new RequestBatchesSearchPage(driver);
requestBatchSearchPage.SetRequestBatchSearchText(requestBatch);
Table searchTable = new Table(requestBatchSearchPage.GetSearchResultTable());
searchTable.ClickCellValue("Name", requestBatch, "Name");
RequestBatchPage requestBatchPage = new RequestBatchPage(driver);
requestBatchPage.ClickPageTitle();
Table trTable = new Table(requestBatchPage.GetTenancyRequestTable());
string actualTenancyRequest = trTable.GetCellValue("Managing Party", MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("MANAGING_PARTY")].Value.ToString(),"Name");
Assert.AreEqual(tenancyrequest, actualTenancyRequest,"Validating the Tenancy request listed in NewBatch Request");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
