Json Object inside a Json Array

Abhishek Singh

public List GetInvItm(string CustGST,string CustInvNo,string CustInvDt)
{
    List ItmD = new List();
    var k = GetInvItmDtl(CustGST, CustInvNo, CustInvDt);
    DataTable dt = GetData("SELECT SUM(BILL_FREIGHT)BILL_AMNT,SUM(CGST_RATE+SGST_RATE+IGST_RATE)GST_RATE,SUM(CGST)CGST,SUM(SGST)SGST,SUM(IGST)IGST,SUM(NET_AMNT)  FROM INVOICE_SUMMARY_VW WHERE  " +
                           "BRANCH_GSTIN='" + ddlGSTINNo.SelectedValue + "' AND CUST_GSTIN='" + CustGST + "' AND BILL_MONTH='" + drpMonth.SelectedValue + "' " +
                           "AND BILL_NO='" + CustInvNo + "' AND TO_CHAR(BILL_DATE,'DD-MM-RRRR')='" + CustInvDt.Trim() + "'  ");
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        ItmD.Add(new Itm
        {
            num = 1201,
            itm_det = null,[How to map item detail]
        });
    }
    return ItmD;
}
public List GetInvItmDtl(string CustGST, string CustInvNo, string CustInvDt)
{
    List ItmDtl = new List();
    DataTable dt = GetData("SELECT SUM(BILL_FREIGHT)BILL_AMNT,SUM(CGST_RATE+SGST_RATE+IGST_RATE)GST_RATE,SUM(CGST)CGST,SUM(SGST)SGST,SUM(IGST)IGST  FROM INVOICE_SUMMARY_VW WHERE  " +
                           "BRANCH_GSTIN='" + ddlGSTINNo.SelectedValue + "' AND CUST_GSTIN='" + CustGST + "' AND BILL_MONTH='" + drpMonth.SelectedValue + "' " +
                           "AND BILL_NO='" + CustInvNo + "' AND TO_CHAR(BILL_DATE,'DD-MM-RRRR')='" + CustInvDt.Trim() + "' ");
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        ItmDtl.Add(new ItmDet
        {
            txval = Convert.ToDouble(dt.Rows[i]["BILL_AMNT"]),
            rt = Convert.ToDouble(dt.Rows[i]["GST_RATE"]),
            camt = Convert.ToDouble(dt.Rows[i]["CGST"]),
            samt = Convert.ToDouble(dt.Rows[i]["SGST"]),
            csamt = Convert.ToDouble(dt.Rows[i]["IGST"])
        });
    }
    return ItmDtl;
}
public class Itm
{
    public int num { get; set; }
    public ItmDet itm_det { get; set; }
}
public class ItmDet
{
    public double txval { get; set; }
    public double rt { get; set; }
    public double camt { get; set; }
    public double samt { get; set; }
    public double csamt { get; set; }
}

OUTPUT

"itms":[
   {
      "num":1,
      "itm_det":{
         "txval":23475.00,
         "rt":12,
         "camt":1408.50,
         "samt":1408.50,
         "csamt":0.00
      }
   }
],

7 Replies

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

Gajendra Jangid4y ago
Try this code
try {
        JSONArray jArray = response.getJSONArray("list");
        for (int i = 0; i < jArray.length(); i++) {
            JSONObject jsonObject = jArray.getJSONObject(i);
            if (jsonObject.has("addressBean")){
                JSONObject addressObject = jsonObject.getJSONObject("addressBean");
                int cadId = addressObject.getInt("cadId");
                String phone = addressObject.getString("phone2");
                String address = addressObject.getString("address1");
            }
        }
    } catch (JSONException e) {
        e.printStackTrace();
    }
Abhishek Singh4y ago
Dear Sir
I was just Trying like this. Please help me out.

hsn = {data[new ]}
public class root
{
public Hsn hsn { get; set; }
}
public class Hsn
{
public List data { get; set; }
}
public class Datum
{
public int num { get; set; }
public string hsn_sc { get; set; }
public string desc { get; set; }
public string uqc { get; set; }
public int qty { get; set; }
public double val { get; set; }
public double txval { get; set; }
public double iamt { get; set; }
public double camt { get; set; }
public double samt { get; set; }
public double csamt { get; set; }
}

Output

"hsn":{
"data":[
{
"num":1,
"val":1481657.69,
"txval":1322908.70,
"iamt":37091.69,
"camt":60828.65,
"samt":60828.65,
"csamt":0.00
}
]
}
Abhishek Singh4y ago
Dear Sir

I was just Trying like this. Please help me out.

hsn = {data[new ]}
public class root
{
public Hsn hsn { get; set; }
}
public class Hsn
{
public List data { get; set; }
}
public class Datum
{
public int num { get; set; }
public string hsn_sc { get; set; }
public string desc { get; set; }
public string uqc { get; set; }
public int qty { get; set; }
public double val { get; set; }
public double txval { get; set; }
public double iamt { get; set; }
public double camt { get; set; }
public double samt { get; set; }
public double csamt { get; set; }
}

Output

"hsn":{
"data":[
{
"num":1,
"val":1481657.69,
"txval":1322908.70,
"iamt":37091.69,
"camt":60828.65,
"samt":60828.65,
"csamt":0.00
}
]
}
Rijwan Ansari4y ago
You can as shown below:
public List GetInvItm(string CustGST,string CustInvNo,string CustInvDt)
{
    List ItmD = new List();
    var k = GetInvItmDtl(CustGST, CustInvNo, CustInvDt);
    DataTable dt = GetData("SELECT SUM(BILL_FREIGHT)BILL_AMNT,SUM(CGST_RATE+SGST_RATE+IGST_RATE)GST_RATE,SUM(CGST)CGST,SUM(SGST)SGST,SUM(IGST)IGST,SUM(NET_AMNT)  FROM INVOICE_SUMMARY_VW WHERE  " +
                           "BRANCH_GSTIN='" + ddlGSTINNo.SelectedValue + "' AND CUST_GSTIN='" + CustGST + "' AND BILL_MONTH='" + drpMonth.SelectedValue + "' " +
                           "AND BILL_NO='" + CustInvNo + "' AND TO_CHAR(BILL_DATE,'DD-MM-RRRR')='" + CustInvDt.Trim() + "'  ");
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        Itm nItm = new Itm();
        nItm.num = 1201;
        nItm.itm_det = new ItmDet() { txVal = 12.22, rt =22.00, camt = 12.22, samt =32.00, csamt = 233.00};
        ItmD.Add(nItm);
    }
    return ItmD;
}
Muhammad Imran Ansari4y ago
Serialize Itm object with below line to get your output.

string output = JsonConvert.SerializeObject(item);

List ItmDtl = new List();
Itm item = new Itm();
item.num = 1;
item.itm_det = new ItmDet() { txval = 23475.00, rt = 12, camt = 1408.50, samt = 1408.50, csamt = 0.00 };

ItmDtl.Add(item);
string output = "itms:" + JsonConvert.SerializeObject(ItmDtl);

Output:

itms:[{"num":1,"itm_det":{"txval":23475.0,"rt":12.0,"camt":1408.5,"samt":1408.5,"csamt":0.0}}]
Abhishek Singh4y ago
Dear Sir

How can i map itm_det = ?

My output will be
"itms":[ { "num":1, "itm_det":{ "txval":23475.00, "rt":12, "camt":1408.50, "samt":1408.50, "csamt":0.00 } } ],
Muhammad Imran Ansari4y ago
Please describe, what is your question? and what issue you are facing?