private static void FetchData(IWebDriver drive, SearchPage apa)
{
drive.Navigate().GoToUrl(SearchPage.Url);
var data = apa.FetchData();
//CleanUpData(data);
//var sortedData = data.OrderBy(x => int.Parse(x.Sqft));
if (File.Exists(file))
File.Delete(file);
int ctr = 2;
var rowData = "Address,price,sqft,$sqft";
WriteData(rowData);
foreach (var d in data)
{
rowData = string.Format("{0},{1},{2},=(B{3}/C{3})", d.Address, d.Price, d.Sqft, ctr);
WriteData(rowData);
ctr++;
}
rowData = string.Format(",=AVERAGE(B2:B{0}),=AVERAGE(c2:c{0}),=AVERAGE(d2:d{0}),", ctr - 1);
WriteData(rowData);
}
static void Main(string[] args)
{
file = string.Format("realtor.property.data.{0}.{1}.{2}.csv", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
var drive = WebDriverFactory.GetBrowser(SearchPage.Url);
var apa = new SearchPage(drive);
FetchData(drive, apa);
drive.Quit();
}
