/// <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 SortCsvFileWriteInJsonAndReturnLastData(string filePath, string jsonFilepath, string key)
{
string readFile = File.ReadAllText(filePath);
StringBuilder stringbuilder = new StringBuilder();
using (var reader = ChoCSVReader.LoadText(readFile)
.WithFirstLineHeader())
{
using (var writer = new ChoJSONWriter(stringbuilder)) writer.Write(reader);
}
File.WriteAllText(jsonFilepath, stringbuilder.ToString());
JArray array = CsvStateCensusReadRecord.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(CsvStateCensusReadRecord.RetriveLastDataOnKey(jsonFilepath, key));
}
/// <CsvStateCodeReadRecord>
/// Creating object of class 'StateCensusAnalyser' as 'stateCodePathObject,
/// return object is returnrd to test case.
/// </CsvStateCodeReadRecord>
/// <returns></returnObject>
public static object CsvStateCodeReadRecord(string[] header, char delimeter, string givenPath)
{
CsvStateCensusReadRecord stateCodePathObject = new CsvStateCensusReadRecord(stateCodePath);
var returnObject = stateCodePathObject.ReadRecords(header, delimeter, givenPath);
return returnObject;
}
