public static string SortCSVFileWriteInJsonAndReturnLastData(string filePath, string jsonFilepath, string key)
{
string re = File.ReadAllText(filePath);
StringBuilder sb = new StringBuilder();
using (var p = ChoCSVReader.LoadText(re)
.WithFirstLineHeader()
)
{
using (var w = new ChoJSONWriter(sb))
w.Write(p);
}
File.WriteAllText(jsonFilepath, sb.ToString());
JArray arr = CSVOperations.SortJsonBasedOnKey(jsonFilepath, key);
var jsonArr = JsonConvert.SerializeObject(arr, Formatting.Indented);
File.WriteAllText(jsonFilepath, jsonArr);
return(CSVOperations.RetriveLastDataOnKey(jsonFilepath, key));
}
/// <summary>
///Method for sort last value from json file
/// </summary>
/// <param name="path"> State Code data path </param>
/// <param name="jsonFilepath"> Delimiter </param>
/// <param name="key"> Header </param>
/// <returns> Sort the file and return Last value </returns>
public static string SortCSVFileWriteInJsonAndReturnLastData(string path, string jsonFilepath, string key)
{
//create a object to read file
string csvfile = File.ReadAllText(path);
StringBuilder json = new StringBuilder();
//read a csv file
using (var p = ChoCSVReader.LoadText(csvfile)
.WithFirstLineHeader()
)
{
//write json file
using (var w = new ChoJSONWriter(json))
w.Write(p);
}
File.WriteAllText(jsonFilepath, json.ToString());
JArray arr = CSVOperations.SortJsonBasedOnKey(jsonFilepath, key);
//convert into json format
var jsonArr = JsonConvert.SerializeObject(arr, Formatting.Indented);
File.WriteAllText(jsonFilepath, jsonArr);
return(CSVOperations.RetriveLastDataOnKey(jsonFilepath, key));
}
