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); }