public void ATC4394_CRMEnterdatafromForm()
{
#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() == "4394")
{
MyRow = i;
break;
}
}
#endregion
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 tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.ClickNewTenancyRequestButton();
TenancyRequestPage tenancyRequestPage = new TenancyRequestPage(driver);
tenancyRequestPage.ClickPageTitle();
//tenancyRequestPage.PopulateTenancyRequestFormResidentialTenancy("1 THOMAS ST, BIRKDALE, QLD, 4159", "Residential Tenancy", "AMANDA TEST", "3", "AARON BALL", "700", "700", "Initial");
tenancyRequestPage.PopulateTRNoTenancyType(
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("INITIAL_CONTRIBUTION")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("AMOUNT_PAID_LODGEMENT")].Value.ToString(),
MyRange.Cells[MyRow, TenancyRequestSchema.GetColumnIndex("LODGEMENT_TYPE")].Value.ToString());
tenancyRequestPage.ClickSaveButton();
tenancyRequestPage.ClickSaveButton();
//Assert Save unsuccessful without Tenancy Type
StringAssert.StartsWith(tenancyRequestPage.GetTenancyTypeErrorText(), "You must provide a value for Tenancy Type.");
tenancyRequestPage.ClickPageTitle();
tenancyRequestPage.SetResidentialTenancyTypeList("Residential Tenancy");
tenancyRequestPage.SetResidentialManagementTypeList("Lessor/Owner");
//Assert Save Successful
tenancyRequestPage.ClickSaveButton();
StringAssert.Contains(tenancyRequestPage.GetRequestNumber(), "TR-BL-");
tenancyRequest = tenancyRequestPage.GetRequestNumber();
//Assert List Values
//tenancyRequestPage.ClickTenancyTypeList();
Assert.IsTrue(tenancyRequestPage.GetTenancyTypeListValue("Residential Tenancy"));
Assert.IsTrue(tenancyRequestPage.GetTenancyTypeListValue("Rooming Accommodation"));
tenancyRequestPage.SetResidentialManagementTypeList("Lessor/Owner");
tenancyRequestPage.ClickSaveCloseButton();
//Assert record in search table
tenancyRequestSearchPage = new TenancyRequestsSearchPage(driver);
tenancyRequestSearchPage.SetTenancyRequestSearchText(tenancyRequest);
Table table = new Table(tenancyRequestSearchPage.GetSearchResultTable());
StringAssert.Contains(table.GetCellValue("Name", tenancyRequest, "Status Reason"), "New");
#region Shut down Excel
MyBook.Save();
MyBook.Close();
MyApp.Quit();
#endregion
}
