Json data to separate variables for saving in DB

Riven Joy

I have a console application which receives data from a website

The format of the returned JSon data which is stored in a string is:

{ "echo_req":{ "subscribe":1,"transaction":1},"msg_type":"transac tion","transaction":{ "action":"buy","amount":"-250.0000","balance":"530800.61","contract_id":"108 32430388","currency":"USD","date_expiry":147824233 5," display_name":"Volatility 10 Index","id":"de7cc6e6-218c-86a5-805f-093c1176f605","longcode":"Win payout if Volatility 10 Index is strictly lower than entry spot at 15 minutes after contract start time.","symbol":"R_10","transaction_id":"215802164 88","transaction_time":1478241435}}

How can I make the Json into separate variables or class object so that i can save them in the database.

To further add I found a json2csharp. I am more interested in saving the data in the Transaction class but don't know what to do from here:

publicclassEchoReq
{
publicint subscribe {get;set;}
publicint transaction {get;set;}
}
publicclassTransaction
{
publicstring action {get;set;}
publicstring amount {get;set;}
publicstring balance {get;set;}
publicstring contract_id {get;set;}
publicstring currency {get;set;}
publicint date_expiry {get;set;}
publicstring display_name {get;set;}
publicstring id {get;set;}
publicstring longcode {get;set;}
publicstring symbol {get;set;}
publicstring transaction_id {get;set;}
publicint transaction_time {get;set;}
}
publicclassRootObject
{
publicEchoReq echo_req {get;set;}
publicstring msg_type {get;set;}
publicTransaction transaction {get;set;}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
It is possible to go directly to a datatable, with JSON.NET and code like this

DataTable dt =(DataTable)JsonConvert.DeserializeObject(json,(typeof(DataTable)));

Download JSON.NET from http://json.codeplex.com
Rajeev Punhani9y ago
Hi Riven ,

Please have a look at below fiddle .Hope it helps.

https://dotnetfiddle.net/FO7cWN

If the above solution is helpful then,accept the answer.
Ravi Patel9y ago
Hi,

your json string have some error

please use the online json viewer to check the error
use bellow url for nice view
http://json.parser.online.fr/

here is your json file
step1
{
"echo_req":{
"subscribe":1,
"transaction":1
},
"msg_type":"transac tion",
"transaction":{
"action":"buy",
"amount":"-250.0000",
"balance":"530800.61",
"contract_id":"108 32430388",
"currency":"USD",
"date_expiry":"1478242335",
"display_name":"Volatility 10 Index",
"id":"de7cc6e6-218c-86a5-805f-093c1176f605",
"longcode":"Win payout if Volatility 10 Index is strictly lower than entry spot at 15 minutes after contract start time.",
"symbol":"R_10",
"transaction_id":"215802164 88",
"transaction_time":1478241435
}
}
step 2 create model class

public class Rootobject
{
public Echo_Req echo_req { get; set; }
public string msg_type { get; set; }
public Transaction transaction { get; set; }
}
public class Echo_Req
{
public int subscribe { get; set; }
public int transaction { get; set; }
}
public class Transaction
{
public string action { get; set; }
public string amount { get; set; }
public string balance { get; set; }
public string contract_id { get; set; }
public string currency { get; set; }
public string date_expiry { get; set; }
public string display_name { get; set; }
public string id { get; set; }
public string longcode { get; set; }
public string symbol { get; set; }
public string transaction_id { get; set; }
public int transaction_time { get; set; }
}

step3 if you are using mvc with jquery

public class HomeController : Controller
{

public ActionResult Index(Rootobject obj)
{
// write here logic to store the data in data base

return View();
}
}

step 4 if you are posting data from jquery

if you want to use javscriptSerizer class please refer this

http://www.c-sharpcorner.com/uploadfile/858292/parsing-a-json-file-with-c-sharp/
Prakash Kumar9y ago
You can use two methods,
1. Javascript serializer
string jsonInput="have your valid json input here";
// JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
Customer objCustomer = jsonSerializer.Deserialize(jsonInput)
2. Newtonsoft
var jsonInput = "{ org:'myOrg',des:'hello'}";
MyFlightDto flight = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonInput);
try this methods