internal void GetDataFromExcel()
{
try
{
// Populating the data from Excel
ExcelLib.PopulateInCollection(Base.ExcelPath, "FinanceDetails");
//Edit PurchasePrice textbox
PurchasePrice.Clear();
Thread.Sleep(1000);
PurchasePrice.SendKeys(ExcelLib.ReadData(2, "Purchase Price"));
//Edit Mortgage textbox
Mortgage.Clear();
Thread.Sleep(1000);
Mortgage.SendKeys(ExcelLib.ReadData(2, "Mortgage"));
//Edit HomeValue textbox
HomeValue.Clear();
Thread.Sleep(1000);
HomeValue.SendKeys(ExcelLib.ReadData(2, "Home Value"));
HomeValue.SendKeys(Keys.Enter);
//Click on the "Save" button
NextButton.Click();
Thread.Sleep(2000);
}
catch (Exception e)
{
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Test Failed, Add Finance Details Unsuccessfull", e.Message);
}
}
//Adding Repayment,Expenses and Liabilities
internal void RepaymentExpensesLiabilities()
{
//To skip the highlighted option
SkipButton?.Click();
System.Threading.Thread.Sleep(5000);
// Populating the data from Excel
ExcelLib.PopulateInCollection(Base.ExcelPath, "AddNewProperty");
OwnersSelect.Click();
System.Threading.Thread.Sleep(5000);
PropertiesSelect.Click();
ClickingAddNewProperty.Click();
//Value set for property page details
PropertyName.SendKeys(ExcelLib.ReadData(2, "Value"));
SearchAddress.SendKeys(ExcelLib.ReadData(33, "Value"));
System.Threading.Thread.Sleep(5000);
//Value set using google api
var address = Global.Driver.driver.FindElements(By.ClassName("pac-item"))[0];
address.Click();
TargetRent.SendKeys(ExcelLib.ReadData(14, "Value"));
LandArea.SendKeys(ExcelLib.ReadData(10, "Value"));
BedRooms.SendKeys(ExcelLib.ReadData(11, "Value"));
CarParks.SendKeys(ExcelLib.ReadData(12, "Value"));
Description.SendKeys(ExcelLib.ReadData(13, "Value"));
FloorArea.SendKeys(ExcelLib.ReadData(15, "Value"));
BathRooms.SendKeys(ExcelLib.ReadData(16, "Value"));
YearBuilt.SendKeys(ExcelLib.ReadData(9, "Value"));
NextButton.Click();
//Value set for financial details page
System.Threading.Thread.Sleep(2000);
PurchasePrice.SendKeys(ExcelLib.ReadData(17, "Value"));
HomeValue.SendKeys(ExcelLib.ReadData(18, "Value"));
Mortgage.SendKeys(ExcelLib.ReadData(19, "Value"));
//Adding repayment option
AddRepayment.Click();
RepaymentAmount.SendKeys(ExcelLib.ReadData(2, "AddRepaymentfieldValue"));
RepaymentStartDate.SendKeys(ExcelLib.ReadData(3, "AddRepaymentfieldValue"));
//Adding expenses option
AddExpense.Click();
ExpenseAmount.SendKeys(ExcelLib.ReadData(2, "AddExpensefieldValue"));
var ExpenseDescription = Global.Driver.driver.FindElement(By.ClassName("seven")).FindElement(By.ClassName("width")).FindElement(By.Id("Text1"));
ExpenseDescription.SendKeys(ExcelLib.ReadData(3, "AddExpensefieldValue"));
ExpenseDate.SendKeys(ExcelLib.ReadData(4, "AddExpensefieldValue"));
NextButton2.Click();
//Value set for financial details page
TenantEmail.SendKeys(ExcelLib.ReadData(20, "Value"));
FirstName.SendKeys(ExcelLib.ReadData(21, "Value"));
LastName.SendKeys(ExcelLib.ReadData(22, "Value"));
StartDate.SendKeys(ExcelLib.ReadData(23, "Value"));
EndDate.SendKeys(ExcelLib.ReadData(24, "Value"));
RentAmount.SendKeys(ExcelLib.ReadData(25, "Value"));
PaymentStartDate.SendKeys(ExcelLib.ReadData(26, "Value"));
//Adding liability option
NewLiability.Click();
Amount.SendKeys(ExcelLib.ReadData(2, "NewLiabilityFieldValue"));
Save.Click();
}
//Add new property
internal void AddingProperty()
{
//To skip the highlighted option
SkipButton?.Click();
System.Threading.Thread.Sleep(5000);
// Populating the data from Excel
ExcelLib.PopulateInCollection(Base.ExcelPath, "AddNewProperty");
System.Threading.Thread.Sleep(5000);
OwnersSelect.Click();
System.Threading.Thread.Sleep(5000);
PropertiesSelect.Click();
ClickingAddNewProperty.Click();
//Value set for property details page
PropertyName.SendKeys(ExcelLib.ReadData(2, "Value"));
SearchAddress.SendKeys(ExcelLib.ReadData(33, "Value"));
System.Threading.Thread.Sleep(5000);
//Value set using google api
var address = Global.Driver.driver.FindElements(By.ClassName("pac-item"))[0];
address.Click();
TargetRent.SendKeys(ExcelLib.ReadData(14, "Value"));
LandArea.SendKeys(ExcelLib.ReadData(10, "Value"));
BedRooms.SendKeys(ExcelLib.ReadData(11, "Value"));
CarParks.SendKeys(ExcelLib.ReadData(12, "Value"));
Description.SendKeys(ExcelLib.ReadData(13, "Value"));
FloorArea.SendKeys(ExcelLib.ReadData(15, "Value"));
BathRooms.SendKeys(ExcelLib.ReadData(16, "Value"));
YearBuilt.SendKeys(ExcelLib.ReadData(9, "Value"));
imagebox.Click();
//Image upload
Global.Driver.driver.FindElement(By.Id("file-upload")).Click();
System.Threading.Thread.Sleep(10000);
SendKeys.SendWait("E:\\Document\\house.jpg");
System.Threading.Thread.Sleep(10000);
SendKeys.SendWait(@"{Enter}");
System.Threading.Thread.Sleep(5000);
NextButton.Click();
System.Threading.Thread.Sleep(5000);
//Value set for financial details page
PurchasePrice.SendKeys(ExcelLib.ReadData(17, "Value"));
HomeValue.SendKeys(ExcelLib.ReadData(18, "Value"));
Mortgage.SendKeys(ExcelLib.ReadData(19, "Value"));
NextButton2.Click();
//Value set for Tenant details page
TenantEmail.SendKeys(ExcelLib.ReadData(20, "Value"));
FirstName.SendKeys(ExcelLib.ReadData(21, "Value"));
LastName.SendKeys(ExcelLib.ReadData(22, "Value"));
StartDate.SendKeys(ExcelLib.ReadData(23, "Value"));
EndDate.SendKeys(ExcelLib.ReadData(24, "Value"));
RentAmount.SendKeys(ExcelLib.ReadData(25, "Value"));
PaymentStartDate.SendKeys(ExcelLib.ReadData(26, "Value"));
Save.Click();
}
internal void FinDetailsMethod()
{
ExcelLib.PopulateInCollection(Base.ExcelPath, "FinancialDetails");
Driver.wait(2);
//Verify the title of Webpage
Assert.IsTrue(Driver.driver.PageSource.Contains("Purchase Price"));
try
{
PurchasePrice.SendKeys(ExcelLib.ReadData(2, "PurchasePrice"));
decimal d;
if (decimal.TryParse(ExcelLib.ReadData(2, "PurchasePrice"), out d))
{
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Pass, "Purchase Price field has been filled with integer");
Mortgage.SendKeys(ExcelLib.ReadData(2, "Mortgage"));
decimal dM;
if (decimal.TryParse(ExcelLib.ReadData(2, "Mortgage"), out d))
{
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Pass, "Purchase Price field has been filled with integer");
Homevalue.SendKeys(ExcelLib.ReadData(2, "HomeValue"));
Driver.wait(2);
if (ClickNext.Enabled)
{
ClickNext.Click();
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Info, "Method to enter Financial details executed and mandatory fileds verified");
}
else
{
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Next button is not enabled");
}
}
else
{
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Mortgage Field has been not been filled with numeric value");
}
}
else
{
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Purchase Price field has not been filled with a numeric character");
}
}
catch (Exception ex)
{
string excepMesg = ex.Message;
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Fail, "Exception Message:" + excepMesg);
}
}
void AddFinanceDetails()
{
ExcelLib.PopulateInCollection(Base.ExcelPath, "FinanceDetails");
PurchasePrice.SendKeys(ExcelLib.ReadData(2, "PurchasePrice"));
Mortage.SendKeys(ExcelLib.ReadData(2, "Mortgage"));
HomeValue.SendKeys(ExcelLib.ReadData(2, "HomeValue"));
if (owneroccupied == "Yes")
{
SaveInFinance.Click();
}
else
{
NextInfinance.Click();
AddTenantDetails();
}
}
internal void SaveFinanceDetails(int TestDataSet)
{
try
{
//Enter the testdata into the relevant input fields
PurchasePrice.SendKeys(ExcelLib.ReadData(TestDataSet, "PurchasePrice"));
Mortgage.SendKeys(ExcelLib.ReadData(TestDataSet, "Mortgage"));
HomeValue.SendKeys(ExcelLib.ReadData(TestDataSet, "HomeValue"));
Thread.Sleep(1000);
//Click on the Next Button to move to the Tenant Details
NextButton.Click();
}
catch (Exception e)
{
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Error, "Error occured when entering Finance Details for the new property: " + e.Message.ToString());
}
}
public void FinanceDetails()
{
//Enter Purchase Prise value
PurchasePrice.SendKeys(ExcelLib.ReadData(2, "PurchasePrice"));
Driver.wait(2000);
//Enter Mortgage value
Mortgage.SendKeys(ExcelLib.ReadData(2, "Mortgage"));
Driver.wait(2000);
//Enter Home Value
HomeValue.SendKeys(ExcelLib.ReadData(2, "HomeValue"));
Driver.wait(2000);
//Clicking on next button
NextFinance.Click();
Thread.Sleep(1000);
}
//A method to enter and save a given test data set for finance details
internal bool SaveFinanceDetails(int TestDataSet)
{
try
{
//Enter the testdata into the relevant input fields
PurchasePrice.SendKeys(ExcelLib.ReadData(TestDataSet, "PurchasePrice"));
Mortgage.SendKeys(ExcelLib.ReadData(TestDataSet, "Mortgage"));
HomeValue.SendKeys(ExcelLib.ReadData(TestDataSet, "HomeValue"));
Thread.Sleep(1000);
//Click on the Next Button to move to the Tenant Details
FinanceNextButton.Click();
return(true);
}
catch (Exception e)
{
// Add details of the error into the report
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Error, "Error occured when entering Finance Details for the new property: " + e.Message.ToString());
// Save Screenshot to display the error
String img = SaveScreenShotClass.SaveScreenshot(Driver.driver, "Exception Report");
Base.test.Log(RelevantCodes.ExtentReports.LogStatus.Info, "Image example: " + img);
return(false);
}
}
