/// <summary>
/// Method to sorting the most population ,density largest value
/// </summary>
/// <param name="filePath"></param>
/// <param name="jsonFilepath"></param>
/// <param name="key"></param>
/// <returns></returns>
public static string ReturnDataNumberOfStatesSortCSVFileAndWriteInJson(string filePath, string jsonFilepath, string key)
{
string readFile = File.ReadAllText(filePath);
StringBuilder stringbuilder = new StringBuilder();
using (var loadText = ChoCSVReader.LoadText(readFile)
.WithFirstLineHeader())
{
using (var writer = new ChoJSONWriter(stringbuilder)) writer.Write(loadText);
}
File.WriteAllText(jsonFilepath, stringbuilder.ToString());
JArray array = CensusAnalyser.SortJsonBasedOnKeyAndValueIsNumber(jsonFilepath, key);
var jsonArray = JsonConvert.SerializeObject(array, Formatting.Indented);
File.WriteAllText(jsonFilepath, jsonArray);
return(CensusAnalyser.RetriveLastDataOnKey(jsonFilepath, key));
}
/// <summary>
/// Method to write the last state data using json
/// </summary>
/// <param name="filePath"></param>
/// <param name="jsonFilepath"></param>
/// <param name="key"></param>
/// <returns></returns>
public static string ReturnLastDataAfterSortingCsvFileWriteInJson(string filePath, string jsonFilepath, string key)
{
string readFile = File.ReadAllText(filePath);
StringBuilder stringbuilder = new StringBuilder();
using (var loadText = ChoCSVReader.LoadText(readFile)
.WithFirstLineHeader())
{
using (var writer = new ChoJSONWriter(stringbuilder)) writer.Write(loadText);
}
File.WriteAllText(jsonFilepath, stringbuilder.ToString());
JArray array = CensusAnalyser.SortingJsonBasedOnKey(jsonFilepath, key);
// serialize JSON to a string and then write string to a file
var jsonArray = JsonConvert.SerializeObject(array, Formatting.Indented);
File.WriteAllText(jsonFilepath, jsonArray);
return(CensusAnalyser.RetriveLastDataOnKey(jsonFilepath, key));
}