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
}