public Food(SuperFood superFood)
{
MonthYear = superFood.MonthYear;
vec1 = superFood.vec1;
vec2 = superFood.vec2;
Region = superFood.Region;
Category = superFood.Category;
try
{
Value = Convert.ToDouble(superFood.ValueString);
}
catch
{
Value = 0;
}
}
/// <summary>
/// Static Method to read a csv to a list of food objects
/// </summary>
/// <param name="maxRecords">number of record to read from csv</param>
/// <returns>list of food objects</returns>
public static List <SuperFood> ReadInCSV()
{
List <SuperFood> results = new List <SuperFood>();
// TODO: don use hard code path
string path = HostingEnvironment.MapPath("~/App_Data/03290040-eng.csv");
// TODO: exception handling
TextReader fileReader = File.OpenText(path);
var csv = new CsvReader(fileReader);
csv.Configuration.HasHeaderRecord = false;
while (csv.Read())
{
SuperFood f = csv.GetRecord <SuperFood>();
results.Add(f);
}
return(results);
}