Serialize and desirialize multiple JSON to C#

Question

0.00/5 (No votes)

See more:

I have three txt files which contain the same Json data i want to read them all in c# class objects and overwrite all the objects from a textbox value in all the files at the same time

in short i have these fields common in all three text files
"time":"112429",
"code":"R123",
i want store their values in the c# object class from all three files at a time
and then overwrite the same object values supplied by a textbox value for all the attributes read by three different files

code to read single file data

C#

using (FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read))
           {
               _orderRequest = (OrderRequest)JsonReader.ReadRecord(fs, _recordManager, TicketingRecordNames.OrderRequest);
           }

my object class

C#

public class OrderRequest
{
public string org;
public string raff;
public string time;
public string user;
public OrderRequest _orderRequest;
}

FILE 1 data

{  
   "org":"OrgTest",
   "raff":"Raffle1",
  "time":"112828",
   "user":"User1",
  
}

FILE 2 data

{  
   "org":"OrgTest",
   "raff":"Raffle1",
  "time":"112828",
   "user":"User111",
  
}

What I have tried:

i have tried newtonsoft json package serializing but not able to load multiple json text files to read, as well as cannot overwrite the object values of multiple files

Posted 4-Jul-18 0:40am

Member 13888852

Updated 5-Jul-18 2:44am

v3

Add a Solution

Comments

F-ES Sitecore 4-Jul-18 6:53am

You might have to either load the contents of the three files and merge them in a single string that can then be deserialised to a single object, or create three objects for each of the files to deserialise to, then simply copy the properties from the file-specific objects to your main object.

Member 13888852 4-Jul-18 7:28am

but how can i combine three json text files data to one

F-ES Sitecore 4-Jul-18 8:28am

Now I see the files have the same stricture. A property can only hold one value, if you plan on having all the data from all of the files in one class you're better using a List of some sort

public class MyData
{
public List<OrderRequest> Requests { get; set; }
}

Load each file into a new instance of OrderRequest and add it to the Requests property.

Graeme_Grant 4-Jul-18 7:43am

Supply a sample of all 3 and the desired result.

One method is to load each JSON file and deserialize into separate lists, then merging all 3 into one. Now it's ready for your user to edit.

Member 13888852 4-Jul-18 8:02am

can u please help with the code to supply multiple files
i have used this code to read single file
using (FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read))
{
_orderRequest = (OrderRequest)JsonReader.ReadRecord(fs, _recordManager, TicketingRecordNames.OrderRequest);
}

Graeme_Grant 4-Jul-18 8:07am

Please update your question with your code so that we can see what you are doing...

I also have a detailed tutorial here: Working with JSON in C# & VB[^]

Member 13888852 4-Jul-18 8:17am

i have updated with code please consult

Graeme_Grant 5-Jul-18 1:22am

So, all 3 files have JSON in the same format? And the user input is conflict resolution when there are multiple entries with the same key? ie: the user chooses which records to keep?

[no name] 4-Jul-18 13:33pm

Perhaps the concept of "iterating" over the 3 files to accomplish what you want is foreign to you. See the "for loop".

Or are you trying to "merge files"? With or without "duplicates".

Are you trying to doctor log files?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bimal pedini · Answer 1 · 2018-07-05T02:44:00

Just try to merge all the json files first and keep it in a single Json file and do Serialize and Deserialize that.

bject o1 = JObject.Parse(@"{
  'FirstName': 'John',
  'LastName': 'Smith',
  'Enabled': false,
  'Roles': [ 'User' ]
}");
JObject o2 = JObject.Parse(@"{
  'Enabled': true,
  'Roles': [ 'User', 'Admin' ]
}");

o1.Merge(o2, new JsonMergeSettings
{
    // union array values together to avoid duplicates
    MergeArrayHandling = MergeArrayHandling.Union
});

string json = o1.ToString();
// {
//   "FirstName": "John",
//   "LastName": "Smith",
//   "Enabled": true,
//   "Roles": [
//     "User",
//     "Admin"
//   ]
// }