public List<Itm> GetInvItm(string CustGST,string CustInvNo,string CustInvDt)
{
List<Itm> ItmD = new List<Itm>();
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<ItmDet> GetInvItmDtl(string CustGST, string CustInvNo, string CustInvDt)
{
List<ItmDet> ItmDtl = new List<ItmDet>();
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
}
}
],