private DealyReturns parceCsvFileToList(List <string> csvFileContent)
{
DealyReturns dealyReturns = new DealyReturns();
dealyReturns.Performances = new List <Performance>();
foreach (var item in csvFileContent)
{
var columns = item.Split(',');
DateTime date = Convert.ToDateTime(columns[0]);
string number = columns[1];
dealyReturns.Performances.Add(new Performance
{
PerformanceDate = date,
MonthlyReturn = number
});
}
return(dealyReturns);
}
public string GetFundPerformance()
{
string filePath = Path.Combine(HostingEnvironment.ApplicationPhysicalPath + @"data\PerformanceData.csv");
List <string> results = readCsvFile(filePath);
DealyReturns dealyReturns = parceCsvFileToList(results);
dealyReturns.Performances = sortBydate(dealyReturns.Performances);
dealyReturns.Performances = calculateTotalReturn(dealyReturns.Performances);
// Serialize the results as JSON
DataContractJsonSerializer serializer = new DataContractJsonSerializer(dealyReturns.GetType());
MemoryStream memoryStream = new MemoryStream();
serializer.WriteObject(memoryStream, dealyReturns);
// Return the results serialized as JSON
string json = Encoding.Default.GetString(memoryStream.ToArray());
return(json);
}
