How to pass Data to Web Api

Question

Hi   How to read data from Sql tables and pass it it Web Api using RestSharp in below Schema   { "Version": "1.1", "TranDtls": { "TaxSch": "GST", "SupTyp": "B2B", "RegRev": "Y", "EcmGstin": null, "IgstOnIntra": "N" }, "DocDtls": { "Typ": "INV", "No": "DOC/001", "Dt": "18/08/2020" }, "SellerDtls": { "Gstin": "37ARZPT4384Q1MT", "LglNm": "NIC company pvt ltd", "TrdNm": "NIC Industries", "Addr1": "5th block, kuvempu layout", "Addr2": "kuvempu layout", "Loc": "GANDHINAGAR", "Pin": 518001, "Stcd": "37", "Ph": "9000000000", "Em": "abc@gmail.com" }, "BuyerDtls": { "Gstin": "29AWGPV7107B1Z1", "LglNm": "XYZ company pvt ltd", "TrdNm": "XYZ Industries", "Pos": "12", "Addr1": "7th block, kuvempu layout", "Addr2": "kuvempu layout", "Loc": "GANDHINAGAR", "Pin": 562160, "Stcd": "29", "Ph": "91111111111", "Em": "xyz@yahoo.com" }, "DispDtls": { "Nm": "ABC company pvt ltd", "Addr1": "7th block, kuvempu layout", "Addr2": "kuvempu layout", "Loc": "Banagalore", "Pin": 562160, "Stcd": "29" }, "ShipDtls": { "Gstin": "29AWGPV7107B1Z1", "LglNm": "CBE company pvt ltd", "TrdNm": "kuvempu layout", "Addr1": "7th block, kuvempu layout", "Addr2": "kuvempu layout", "Loc": "Banagalore", "Pin": 562160, "Stcd": "29" }, "ItemList": [ { "SlNo": "1", "PrdDesc": "Rice", "IsServc": "N", "HsnCd": "1001", "Barcde": "123456", "Qty": 100.345, "FreeQty": 10, "Unit": "BAG", "UnitPrice": 99.545, "TotAmt": 9988.84, "Discount": 10, "PreTaxVal": 1, "AssAmt": 9978.84, "GstRt": 12.0, "IgstAmt": 1197.46, "CgstAmt": 0, "SgstAmt": 0, "CesRt": 5, "CesAmt": 498.94, "CesNonAdvlAmt": 10, "StateCesRt": 12, "StateCesAmt": 1197.46, "StateCesNonAdvlAmt": 5, "OthChrg": 10, "TotItemVal": 12897.7, "OrdLineRef": "3256", "OrgCntry": "AG", "PrdSlNo": "12345", "BchDtls": { "Nm": "123456", "ExpDt": "01/08/2020", "WrDt": "01/09/2020" }, "AttribDtls": [ { "Nm": "Rice", "Val": "10000" } ] } ], "ValDtls": { "AssVal": 9978.84, "CgstVal": 0, "SgstVal": 0, "IgstVal": 1197.46, "CesVal": 508.94, "StCesVal": 1202.46, "Discount": 10, "OthChrg": 20, "RndOffAmt": 0.3, "TotInvVal": 12908, "TotInvValFc": 12897.7 }, "PayDtls": { "Nm": "ABCDE", "AccDet": "5697389713210", "Mode": "Cash", "FinInsBr": "SBIN11000", "PayTerm": "100", "PayInstr": "Gift", "CrTrn": "test", "DirDr": "test", "CrDay": 100, "PaidAmt": 10000, "PaymtDue": 5000 }, "RefDtls": { "InvRm": "TEST", "DocPerdDtls": { "InvStDt": "01/08/2020", "InvEndDt": "01/09/2020" }, "PrecDocDtls": [ { "InvNo": "DOC/002", "InvDt": "01/08/2020", "OthRefNo": "123456" } ], "ContrDtls": [ { "RecAdvRefr": "Doc/003", "RecAdvDt": "01/08/2020", "TendRefr": "Abc001", "ContrRefr": "Co123", "ExtRefr": "Yo456", "ProjRefr": "Doc-456", "PORefr": "Doc-789", "PORefDt": "01/08/2020" } ] }, "AddlDocDtls": [ { "Url": "https://einv-apisandbox.nic.in", "Docs": "Test Doc", "Info": "Document Test" } ], "ExpDtls": { "ShipBNo": "A-248", "ShipBDt": "01/08/2020", "Port": "INABG1", "RefClm": "N", "ForCur": "AED", "CntCode": "AE", "ExpDuty": null }, "EwbDtls": { "TransId": "12AWGPV7107B1Z1", "TransName": "XYZ EXPORTS", "Distance": 100, "TransDocNo": "DOC01", "TransDocDt": "18/08/2020", "VehNo": "ka123456", "VehType": "R", "TransMode": "1" } } Thanks

Sachin Singh · Answer

first create following classes // Root myDeserializedClass = JsonConvert.DeserializeObject (myJsonResponse);          public   class  TranDtls    {            public  string TaxSch { get; set; }             public  string SupTyp { get; set; }             public  string RegRev { get; set; }             public  object EcmGstin { get; set; }             public  string IgstOnIntra { get; set; }        }           public   class  DocDtls    {            public  string Typ { get; set; }             public  string No { get; set; }             public  string Dt { get; set; }        }           public   class  SellerDtls    {            public  string Gstin { get; set; }             public  string LglNm { get; set; }             public  string TrdNm { get; set; }             public  string Addr1 { get; set; }             public  string Addr2 { get; set; }             public  string Loc { get; set; }             public   int  Pin { get; set; }             public  string Stcd { get; set; }             public  string Ph { get; set; }             public  string Em { get; set; }        }           public   class  BuyerDtls    {            public  string Gstin { get; set; }             public  string LglNm { get; set; }             public  string TrdNm { get; set; }             public  string Pos { get; set; }             public  string Addr1 { get; set; }             public  string Addr2 { get; set; }             public  string Loc { get; set; }             public   int  Pin { get; set; }             public  string Stcd { get; set; }             public  string Ph { get; set; }             public  string Em { get; set; }        }           public   class  DispDtls    {            public  string Nm { get; set; }             public  string Addr1 { get; set; }             public  string Addr2 { get; set; }             public  string Loc { get; set; }             public   int  Pin { get; set; }             public  string Stcd { get; set; }        }           public   class  ShipDtls    {            public  string Gstin { get; set; }             public  string LglNm { get; set; }             public  string TrdNm { get; set; }             public  string Addr1 { get; set; }             public  string Addr2 { get; set; }             public  string Loc { get; set; }             public   int  Pin { get; set; }             public  string Stcd { get; set; }        }           public   class  BchDtls    {            public  string Nm { get; set; }             public  string ExpDt { get; set; }             public  string WrDt { get; set; }        }           public   class  AttribDtl    {            public  string Nm { get; set; }             public  string Val { get; set; }        }           public   class  ItemList    {            public  string SlNo { get; set; }             public  string PrdDesc { get; set; }             public  string IsServc { get; set; }             public  string HsnCd { get; set; }             public  string Barcde { get; set; }             public   double  Qty { get; set; }             public   int  FreeQty { get; set; }             public  string Unit { get; set; }             public   double  UnitPrice { get; set; }             public   double  TotAmt { get; set; }             public   int  Discount { get; set; }             public   int  PreTaxVal { get; set; }             public   double  AssAmt { get; set; }             public   double  GstRt { get; set; }             public   double  IgstAmt { get; set; }             public   int  CgstAmt { get; set; }             public   int  SgstAmt { get; set; }             public   int  CesRt { get; set; }             public   double  CesAmt { get; set; }             public   int  CesNonAdvlAmt { get; set; }             public   int  StateCesRt { get; set; }             public   double  StateCesAmt { get; set; }             public   int  StateCesNonAdvlAmt { get; set; }             public   int  OthChrg { get; set; }             public   double  TotItemVal { get; set; }…