static void Main(string[] args)
{
CustomStringArrayTest();
using (var file = new FileStream("t.json", FileMode.Append))
{
using (var w = new ChoJSONWriter(file))
{
}
}
}
static void Yaml2JSON()
{
StringBuilder json = new StringBuilder();
using (var r = ChoYamlReader.LoadText(yamlText2))
{
using (var w = new ChoJSONWriter(json))
w.Write(r);
}
Console.WriteLine(json.ToString());
}
public void CSV_To_Json_Data_Load(string csvSource, string jsonDestination)
{
string csvData = File.ReadAllText(csvSource);
StringBuilder stringBuilder = new StringBuilder();
using (var jsonDataValue = ChoCSVReader.LoadText(csvData).WithFirstLineHeader())
{
using (var data = new ChoJSONWriter(stringBuilder)) data.Write(jsonDataValue);
}
File.WriteAllText(jsonDestination, stringBuilder.ToString());
}
//// Method Convert Csv file to Json file
public static void ConvertCsvFileToJsonObject(string cSVFile, string jsonFile)
{
string reader = File.ReadAllText(cSVFile);
StringBuilder sb = new StringBuilder();
using (var value = ChoCSVReader.LoadText(reader).WithFirstLineHeader())
{
using var w = new ChoJSONWriter(sb);
w.Write(value);
}
File.WriteAllText(jsonFile, sb.ToString());
}
public void CSVToJson_Data_Load_And_Sort_By_Numeric_key(string csvSource, string jsonDestination, string sortJson, string key)
{
string csvData = File.ReadAllText(csvSource);
StringBuilder stringBuilder = new StringBuilder();
using (var jsonDataValue = ChoCSVReader.LoadText(csvData).WithFirstLineHeader())
{
using (var data = new ChoJSONWriter(stringBuilder)) data.Write(jsonDataValue);
}
File.WriteAllText(jsonDestination, stringBuilder.ToString());
obj.SortingForCSVFileForNum(jsonDestination, sortJson, key);
}
static void DataReaderTest()
{
string connectionstring = @"Data Source=(localdb)\v11.0;Initial Catalog=TestDb;Integrated Security=True";
using (var conn = new SqlConnection(connectionstring))
{
conn.Open();
var comm = new SqlCommand("SELECT * FROM Customers", conn);
using (var parser = new ChoJSONWriter("customers.json"))
parser.Write(comm.ExecuteReader());
}
}
static void HierarchyCSV()
{
using (var p = new ChoCSVReader("Players.csv").WithFirstLineHeader())
{
using (var w = new ChoJSONWriter <Players>("Players.json").Configure(c => c.UseJSONSerialization = true).Configure(c => c.SupportMultipleContent = true))
{
w.Write(new Players {
players = p.Select(e => new Player(e)).ToArray()
});
}
}
}
static void Test1()
{
using (var r = ChoYamlReader <MyModel> .LoadText(yamlText1))
{
foreach (var rec in r)
{
Console.WriteLine(rec.Dump());
}
return;
Console.WriteLine(ChoJSONWriter <MyModel> .ToTextAll(r));
}
}
static void ListTest()
{
List <data> _data = new List <data>();
_data.Add(new data()
{
Id = 1,
SSN = 2,
Message = "A Message"
});
Console.WriteLine(ChoJSONWriter.ToTextAll <data>(_data));
}
static void IPAddressTest()
{
using (var jr = new ChoJSONWriter <SomeOuterObject>("ipaddr.json")
.WithField("stringValue")
.WithField("ipValue", valueConverter: (o) => o.ToString())
)
{
var x1 = new SomeOuterObject {
stringValue = "X1", ipValue = IPAddress.Parse("12.23.21.23")
};
jr.Write(x1);
}
}
static void Sample8Test()
{
using (var parser = new ChoXmlReader("sample8.xml").WithXPath("/root/data")
.WithField("id", xPath: "@name")
.WithField("text", xPath: "/value")
)
{
using (var writer = new ChoJSONWriter("sample8.json")
.Configure(c => c.SupportMultipleContent = true)
)
writer.Write(new { Texts = parser.ToArray() });
}
}
//Loads a CSV up and converts/outputs it to a Json file
private void WriteCSVToJson(string path, string outputName)
{
var csv = File.ReadAllText(path);
StringBuilder json = new StringBuilder();
using (var p = ChoCSVReader.LoadText(csv).WithFirstLineHeader(false).ThrowAndStopOnMissingField(false).QuoteAllFields(true).IgnoreFieldValueMode(ChoIgnoreFieldValueMode.None))
{
using (var w = new ChoJSONWriter(json))
w.Write(p);
}
File.WriteAllText(outputName, json.ToString(), Encoding.UTF8);
}
static void EnumTest()
{
StringBuilder sb = new StringBuilder();
using (var jr = new ChoJSONWriter <Person>(sb)
)
{
jr.Write(new Person {
Age = 1, Gender = Gender.Female
});
}
Console.WriteLine(sb.ToString());
}
public void CSVStateCensusJsonDataLoad()
{
StateCensusAnalyser obj = new StateCensusAnalyser();
string path = @"D:\Anoop_kumar\CensusAnalyzer\CensusAnalyzer\File\StateCensusData.csv";
//obj.SortingForCSVFile(path, "State");
string csvData = File.ReadAllText(path);
StringBuilder stringBuilder = new StringBuilder();
using (var jsonDataValue = ChoCSVReader.LoadText(csvData).WithFirstLineHeader())
{
using (var data = new ChoJSONWriter(stringBuilder)) data.Write(jsonDataValue);
}
File.WriteAllText(@"D:\Anoop_kumar\CensusAnalyzer\CensusAnalyzer\StateCensusData.json", stringBuilder.ToString());
}
public static void SaveDict()
{
Dictionary <int, string> list = new Dictionary <int, string>();
list.Add(1, "1/1/2012");
list.Add(2, null);
//Hashtable list = new Hashtable();
//list.Add(1, "33");
//list.Add(2, null);
using (var w = new ChoJSONWriter("emp.json")
)
w.Write(list);
}
static void CustomLabel()
{
string codfis = "Example1";
var jsonCF = new
{
codfis = new
{ // codfis is the name of the variable as you can see
Cognome = "vcgm",
Nome = "vnm",
Sesso = "ss",
LuogoDiNascita = "ldn",
Provincia = "pr",
DataDiNascita = "ddn"
}
};
var jsonCF1 = new Dictionary <string, object>();
jsonCF1.Add(codfis, new
{ // codfis is the name of the variable as you can see
Cognome = "vcgm",
Nome = "vnm",
Sesso = "ss",
LuogoDiNascita = "ldn",
Provincia = "pr",
DataDiNascita = "ddn"
});
jsonCF1.Add(codfis + "1", new
{ // codfis is the name of the variable as you can see
Cognome = "vcgm",
Nome = "vnm",
Sesso = "ss",
LuogoDiNascita = "ldn",
Provincia = "pr",
DataDiNascita = "ddn"
});
StringBuilder json = new StringBuilder();
using (var w = new ChoJSONWriter(json)
.SupportMultipleContent(true)
//.Configure(c => c.SingleElement = true)
)
{
w.Write(jsonCF1);
}
Console.WriteLine(json.ToString());
}
public static JObject GetCsvToJson(string location)
{
StringBuilder sb = new StringBuilder( );
using (var p = ChoCSVReader.LoadText(location)
.WithFirstLineHeader( )
)
{
using (var w = new ChoJSONWriter(sb))
w.Write(p);
}
JArray jsonArray = JArray.Parse(sb.ToString( ));
JObject json = JObject.Parse(jsonArray[1].ToString( ));
return(json);
}
static void DataReaderTest()
{
//string connectionstring = @"Data Source=(localdb)\v11.0;Initial Catalog=TestDb;Integrated Security=True";
string connectionstring = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Northwind;Integrated Security=True";
StringBuilder sb = new StringBuilder();
using (var conn = new SqlConnection(connectionstring))
{
conn.Open();
var comm = new SqlCommand("SELECT top 2 * FROM Customers", conn);
using (var parser = new ChoJSONWriter(sb))
parser.Write(comm.ExecuteReader());
}
Console.WriteLine(sb.ToString());
}
//Coverting CSV To JSON
public void ConvertingCSVToJSON(string path, string destination)
{
//Read CSV Data
string csv = File.ReadAllText(path);
StringBuilder builder = new StringBuilder();
using (var p = ChoCSVReader.LoadText(csv).WithFirstLineHeader())
{
var w = new ChoJSONWriter(builder);
w.Write(p);
}
//Data Storing In Destination Path(File)
File.WriteAllText(destination, builder.ToString());
}
static void SelectiveNodeTest()
{
StringBuilder json = new StringBuilder();
using (var r = ChoYamlReader.LoadText(yamlText2)
.WithField("receipt")
.WithField("date", fieldType: typeof(DateTimeOffset))
)
{
//foreach (var rec in r)
// Console.WriteLine(rec.Dump());
using (var w = new ChoJSONWriter(json))
w.Write(r);
}
Console.WriteLine(json.ToString());
}
private Task ReadFromFileAsync(string filename)
{
return(Task.Run(() => {
string csv = File.ReadAllText(filename);
StringBuilder sb = new StringBuilder();
using (var p = ChoCSVReader.LoadText(csv)
.WithFirstLineHeader()
)
{
using (var w = new ChoJSONWriter(sb))
w.Write(p);
}
_charges = JsonConvert.DeserializeObject <List <FuelCharge> >(sb.ToString());
}));
}
private static void ConvertAllDataWithNativetype()
{
using (var jw = new ChoJSONWriter("sample.json"))
{
using (var cr = new ChoCSVReader("sample.csv")
.WithFirstLineHeader()
.WithField("firstName")
.WithField("lastName")
.WithField("salary", fieldType: typeof(double))
)
{
//foreach (var x in cr)
// Console.WriteLine(ChoUtility.ToStringEx(x));
jw.Write(cr);
}
}
}
/// <summary>
/// Sorts the CSV file write in json and return number of states sorted.
/// </summary>
/// <param name="filePath">The file path.</param>
/// <param name="jsonFilepath">The json filepath.</param>
/// <param name="key">The key.</param>
/// <returns></returns>
public static int SortCSVFileOnNumberAndWriteInJsonAndReturnNumberOfStatesSorted(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());
int count = CSVOperations.SortJsonBasedOnKeyAndReturnNumberOfStatesSorted(jsonFilepath, key);
return(count);
}
static void Main(string[] args)
{
JSON2XML();
return;
JSON2XmlDateTimeTest();
return;
CustomStringArrayTest();
using (var file = new FileStream("t.json", FileMode.Append))
{
using (var w = new ChoJSONWriter(file))
{
}
}
}
static void CustomFormat2()
{
StringBuilder sb = new StringBuilder();
using (var w = new ChoJSONWriter <PlaceObj>(sb)
//.WithField(m => m.SkuNumber, valueConverter: (o) => String.Format("SKU_{0}", o.ToNString()))
)
{
PlaceObj o1 = new PlaceObj();
o1.Place = "1";
o1.SkuNumber = 100;
w.Write(o1);
}
Console.WriteLine(sb.ToString());
}
static void DataTableTest()
{
string connectionstring = @"Data Source=(localdb)\v11.0;Initial Catalog=TestDb;Integrated Security=True";
using (var conn = new SqlConnection(connectionstring))
{
conn.Open();
var comm = new SqlCommand("SELECT * FROM Customers", conn);
SqlDataAdapter adap = new SqlDataAdapter(comm);
DataTable dt = new DataTable("Customer");
adap.Fill(dt);
using (var parser = new ChoJSONWriter("customers.json").Configure(c => c.UseJSONSerialization = true))
parser.Write(dt);
}
}
public string ConvertToJson()
{
string path = Mapper.MapFile("~/input_cut.csv");
var csv = File.ReadAllText(path);
StringBuilder sb = new StringBuilder();
using (var p = ChoCSVReader.LoadText(csv)
.WithFirstLineHeader()
)
{
using (var w = new ChoJSONWriter(sb))
w.Write(p);
}
return(sb.ToString());
}
static void DifferentDateFormatTest()
{
CultureInfo newCulture = CultureInfo.CreateSpecificCulture("en-GB");
//Thread.CurrentThread.CurrentCulture = newCulture;
StringBuilder json = new StringBuilder();
using (var r = ChoYamlReader <CustomerWithDate> .LoadText(yamlText3))
{
r.First().Date.ToString("yyyy-MMM-dd").Print();
return;
using (var w = new ChoJSONWriter(json))
w.Write(r);
}
Console.WriteLine(json.ToString());
}
static void DynamicTest()
{
List <ExpandoObject> objs = new List <ExpandoObject>();
dynamic rec1 = new ExpandoObject();
rec1.Id = 1;
rec1.Name = "Mark";
rec1.Date = DateTime.Now;
rec1.Active = true;
rec1.Salary = new ChoCurrency(10.01);
rec1.EmpType = EmpType.FullTime;
rec1.Array = new int[] { 1, 2, 4 };
rec1.Dict = new Dictionary <int, string>()
{
{ 1, "xx" }
};
objs.Add(rec1);
dynamic rec2 = new ExpandoObject();
rec2.Id = 2;
rec2.Name = "Jason";
rec2.Date = DateTime.Now;
rec2.Salary = new ChoCurrency(10.01);
rec2.Active = false;
rec2.EmpType = EmpType.Contract;
rec2.Array = new int[] { 1, 2, 4 };
rec2.Dict = new string[] { "11", "12", "14" };
objs.Add(rec2);
objs.Add(null);
using (var w = new ChoJSONWriter("emp.json")
.Configure(c => c.ThrowAndStopOnMissingField = false)
.Configure(c => c.NullValueHandling = ChoNullValueHandling.Empty)
)
{
w.Write(objs);
//w.Write(ChoEnumerable.AsEnumerable(() =>
//{
// return new { Address = new string[] { "NJ", "NY" }, Name = "Raj", Zip = "08837" };
//}));
//w.Write(new { Name = "Raj", Zip = "08837", Address = new { City = "New York", State = "NY" } });
}
}
//Method to sorting the least populated state.
public static string ReturnDataNumberOfStatesSortLowestCSVFileAndWriteInJson(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.SortJsonBasedOnKeyAndValueIsNumber(jsonFilepath, key);
var jsonArray = JsonConvert.SerializeObject(array, Formatting.Indented);
File.WriteAllText(jsonFilepath, jsonArray);
return(CsvStateCensusReadRecord.RetriveFirstDataOnKey(jsonFilepath, key));
}
