//description of the RentDataModel attributes
//public string TA { get; set; }
//public string marketRentArea { get; set; }
//public string propertyType { get; set; }
//public string bedrooms { get; set; }
//public float averageRentPrice { get; set; }
public List<RentDataModel> Handler()
{
var reader = new StreamReader(File.OpenRead(@"~/CSV/detailed-mean-rents-total.csv"));
List<RentDataModel> listData = new List<RentDataModel>();
while (!reader.EndOfStream)
{
//init rentdata object
var rentdata = new RentDataModel();
//read line from csv
var line = reader.ReadLine();
var values = line.Split(',');
//set values of rentdata object
rentdata.region = values[0];
rentdata.marketRentArea = values[1];
rentdata.propertyType = values[2];
rentdata.averageRentPrice = float.Parse(values.Last());
//add rentdata object to list
listData.Add(rentdata);
}
return listData;
}
public List<RentDataModel> Handler()
{
//var reader = new StreamReader(File.OpenRead("~/CSV/detailed-mean-rents-total.csv"));
List<RentDataModel> listData = new List<RentDataModel>();
//wile (!reader.EndOfStream)
String csvf = new csvFile().csvFileData;
String[] csvArray = csvf.Split('~');
foreach (string line in csvArray)
{
//init rentdata object
var rentdata = new RentDataModel();
//read line from csv
var values = line.Split(',');
//set values of rentdata object
rentdata.region = values[0];
rentdata.marketRentArea = values[1];
rentdata.propertyType = values[2];
rentdata.averageRentPrice = float.Parse(values.Last());
//add rentdata object to list
listData.Add(rentdata);
Console.WriteLine(csvArray.Length);
}
return listData;
}