void GetGSTR2Data() { // DropDownList ddlMonthYear = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); DataSet ds1 = CLSCommon.CallApiGet("api/PurchaseData/GetPurchaseData?ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString() + "&ClientGSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCode=" + Session["MonthYrCode"].ToString()); GrdTable3.DataSource = ds1.Tables[0]; GrdTable3.DataBind(); Grd4A.DataSource = ds1.Tables[1]; Grd4A.DataBind(); Grd4B.DataSource = ds1.Tables[2]; Grd4B.DataBind(); grd4C.DataSource = ds1.Tables[3]; grd4C.DataBind(); grd5A.DataSource = ds1.Tables[4]; grd5A.DataBind(); grd5B.DataSource = ds1.Tables[5]; grd5B.DataBind(); grd6A.DataSource = ds1.Tables[6]; grd6A.DataBind(); grd6B.DataSource = ds1.Tables[7]; grd6B.DataBind(); grd6C.DataSource = ds1.Tables[8]; grd6C.DataBind(); grd6D.DataSource = ds1.Tables[9]; grd6D.DataBind(); grd8.DataSource = ds1.Tables[10]; grd8.DataBind(); grd9.DataSource = ds1.Tables[11]; grd9.DataBind(); grd10A1.DataSource = ds1.Tables[12]; grd10A1.DataBind(); grd10A2.DataSource = ds1.Tables[13]; grd10A2.DataBind(); grd10b1.DataSource = ds1.Tables[14]; grd10b1.DataBind(); grd10b2.DataSource = ds1.Tables[15]; grd10b2.DataBind(); grd7A.DataSource = ds1.Tables[16]; grd7A.DataBind(); grd7B.DataSource = ds1.Tables[17]; grd7B.DataBind(); grd11.DataSource = ds1.Tables[18]; grd11.DataBind(); grd13.DataSource = ds1.Tables[19]; grd13.DataBind(); }
void GetGSTR2Data() { // DropDownList ddlMonthYear = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); DataSet ds1 = CLSCommon.CallApiGet("api/PurchaseData/GetPurchaseData?ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString() + "&ClientGSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCode=" + Session["MonthYrCode"].ToString()); // For display b2b if (ds1 != null) { if (ds1.Tables[0].Rows.Count > 0) { GrdTable3.DataSource = ds1.Tables[0]; GrdTable3.DataBind(); } else { GrdTable3.DataSource = null; GrdTable3.DataBind(); } if (ds1.Tables[1].Rows.Count > 0) { lblb2bTotalInvoice.Text = ds1.Tables[1].Rows[0]["TotalInvoice"].ToString(); lblb2bInvoiceValue.Text = ds1.Tables[1].Rows[0]["TotalInvoiceValue"].ToString(); lblb2bTaxableValue.Text = ds1.Tables[1].Rows[0]["TotalTaxableValue"].ToString(); lblb2bIGST.Text = ds1.Tables[1].Rows[0]["TotalIGST"].ToString(); lblb2bCGST.Text = ds1.Tables[1].Rows[0]["TotalCGST"].ToString(); lblb2bSGST.Text = ds1.Tables[1].Rows[0]["TotalSGST"].ToString(); lblb2bCess.Text = ds1.Tables[1].Rows[0]["TotalCESS"].ToString(); lblb2bITCIGST.Text = ds1.Tables[1].Rows[0]["TotalITCIGST"].ToString(); lblb2bITCCGST.Text = ds1.Tables[1].Rows[0]["TotalITCCGST"].ToString(); lblb2bITCSGST.Text = ds1.Tables[1].Rows[0]["TotalITCSGST"].ToString(); lblb2bITCCESS.Text = ds1.Tables[1].Rows[0]["TotalITCCESS"].ToString(); } else { lblb2bTotalInvoice.Text = "0"; lblb2bInvoiceValue.Text = "0"; lblb2bTaxableValue.Text = "0"; lblb2bIGST.Text = "0"; lblb2bCGST.Text = "0"; lblb2bSGST.Text = "0"; lblb2bCess.Text = "0"; lblb2bITCIGST.Text = "0"; lblb2bITCCGST.Text = "0"; lblb2bITCSGST.Text = "0"; lblb2bITCCESS.Text = "0"; } // For display b2bur if (ds1.Tables[2].Rows.Count > 0) { Grd4A.DataSource = ds1.Tables[2]; Grd4A.DataBind(); } else { Grd4A.DataSource = null; Grd4A.DataBind(); } if (ds1.Tables[3].Rows.Count > 0) { lblb2burTotalInvoice.Text = ds1.Tables[3].Rows[0]["TotalInvoice"].ToString(); lblb2burInvoiceValue.Text = ds1.Tables[3].Rows[0]["TotalInvoiceValue"].ToString(); lblb2burTaxableValue.Text = ds1.Tables[3].Rows[0]["TotalTaxableValue"].ToString(); lblb2burIGST.Text = ds1.Tables[3].Rows[0]["TotalIGST"].ToString(); lblb2burCGST.Text = ds1.Tables[3].Rows[0]["TotalCGST"].ToString(); lblb2burSGST.Text = ds1.Tables[3].Rows[0]["TotalSGST"].ToString(); lblb2burCESS.Text = ds1.Tables[3].Rows[0]["TotalCESS"].ToString(); lblb2burITCIGST.Text = ds1.Tables[3].Rows[0]["TotalITCIGST"].ToString(); lblb2burITCCGST.Text = ds1.Tables[3].Rows[0]["TotalITCCGST"].ToString(); lblb2burITCSGST.Text = ds1.Tables[3].Rows[0]["TotalITCSGST"].ToString(); lblb2burITCCESS.Text = ds1.Tables[3].Rows[0]["TotalITCCESS"].ToString(); } else { lblb2burTotalInvoice.Text = "0"; lblb2burInvoiceValue.Text = "0"; lblb2burTaxableValue.Text = "0"; lblb2burIGST.Text = "0"; lblb2burCGST.Text = "0"; lblb2burSGST.Text = "0"; lblb2burCESS.Text = "0"; lblb2burITCIGST.Text = "0"; lblb2burITCCGST.Text = "0"; lblb2burITCSGST.Text = "0"; lblb2burITCCESS.Text = "0"; } // For display imps if (ds1.Tables[4].Rows.Count > 0) { grd5A.DataSource = ds1.Tables[4]; grd5A.DataBind(); } else { grd5A.DataSource = null; grd5A.DataBind(); } if (ds1.Tables[5].Rows.Count > 0) { lblIMPSTotalInvoice.Text = ds1.Tables[5].Rows[0]["TotalInvoice"].ToString(); lblIMPSTotalInvoiceValue.Text = ds1.Tables[5].Rows[0]["TotalInvoiceValue"].ToString(); lblIMPSTotalTaxableValue.Text = ds1.Tables[5].Rows[0]["TotalTaxableValue"].ToString(); lblIMPSTotalIGST.Text = ds1.Tables[5].Rows[0]["TotalIGST"].ToString(); lblIMPSTotalCESS.Text = ds1.Tables[5].Rows[0]["TotalCESS"].ToString(); lblIMPSTotalITCIGST.Text = ds1.Tables[5].Rows[0]["TotalITCIGST"].ToString(); lblIMPSTotalITCCESS.Text = ds1.Tables[5].Rows[0]["TotalITCCESS"].ToString(); } else { lblIMPSTotalInvoice.Text = "0"; lblIMPSTotalInvoiceValue.Text = "0"; lblIMPSTotalTaxableValue.Text = "0"; lblIMPSTotalIGST.Text = "0"; lblIMPSTotalCESS.Text = "0"; lblIMPSTotalITCIGST.Text = "0"; lblIMPSTotalITCCESS.Text = "0"; } // For display impg if (ds1.Tables[6].Rows.Count > 0) { Gridimpg.DataSource = ds1.Tables[6]; Gridimpg.DataBind(); } else { Gridimpg.DataSource = null; Gridimpg.DataBind(); } if (ds1.Tables[7].Rows.Count > 0) { lblIMPGTotalInvoice.Text = ds1.Tables[7].Rows[0]["TotalInvoice"].ToString(); lblIMPGTotalInvoiceValue.Text = ds1.Tables[7].Rows[0]["TotalInvoiceValue"].ToString(); lblIMPGTotalTaxableValue.Text = ds1.Tables[7].Rows[0]["TotalTaxableValue"].ToString(); lblIMPGTotalIGST.Text = ds1.Tables[7].Rows[0]["TotalIGST"].ToString(); lblIMPGTotalCESS.Text = ds1.Tables[7].Rows[0]["TotalCESS"].ToString(); lblIMPGTotalITCIGST.Text = ds1.Tables[7].Rows[0]["TotalITCIGST"].ToString(); lblIMPGTotalITCCESS.Text = ds1.Tables[7].Rows[0]["TotalITCCESS"].ToString(); } else { lblIMPGTotalInvoice.Text = "0"; lblIMPGTotalInvoiceValue.Text = "0"; lblIMPGTotalTaxableValue.Text = "0"; lblIMPGTotalIGST.Text = "0"; lblIMPGTotalCESS.Text = "0"; lblIMPGTotalITCIGST.Text = "0"; lblIMPGTotalITCCESS.Text = "0"; } //For display cdnr if (ds1.Tables[8].Rows.Count > 0) { lblCdnrTotNoteRefVoucherValue.Text = ds1.Tables[8].Rows[0]["TotalNoteRefVoucherValue"].ToString(); lblCdnrTotTax.Text = ds1.Tables[8].Rows[0]["TotalTaxableValue"].ToString(); lblCdnrTotITC.Text = ds1.Tables[8].Rows[0]["TotalITC"].ToString(); lblCdnrTotInvoRow.Text = ds1.Tables[8].Rows[0]["TotalInvoice"].ToString(); } else { lblCdnrTotNoteRefVoucherValue.Text = "0"; lblCdnrTotTax.Text = "0"; lblCdnrTotITC.Text = "0"; lblCdnrTotInvoRow.Text = "0"; } if (ds1.Tables[9].Rows.Count > 0) { Gridcdnr.DataSource = ds1.Tables[9]; Gridcdnr.DataBind(); } else { Gridcdnr.DataSource = null; Gridcdnr.DataBind(); } //For display cdnur if (ds1.Tables[10].Rows.Count > 0) { lblCdnurTotNoteRefVoucherValue.Text = ds1.Tables[10].Rows[0]["TotalNoteRefVoucherValue"].ToString(); lblCdnurTotTax.Text = ds1.Tables[10].Rows[0]["TotalTaxableValue"].ToString(); lblCdnurTotITC.Text = ds1.Tables[10].Rows[0]["TotalITC"].ToString(); lblCdnurTotInvoRow.Text = ds1.Tables[10].Rows[0]["TotalInvoice"].ToString(); } else { lblCdnurTotNoteRefVoucherValue.Text = "0"; lblCdnurTotTax.Text = "0"; lblCdnurTotITC.Text = "0"; lblCdnurTotInvoRow.Text = "0"; } if (ds1.Tables[11].Rows.Count > 0) { Gridcdnur.DataSource = ds1.Tables[11]; Gridcdnur.DataBind(); } else { Gridcdnur.DataSource = null; Gridcdnur.DataBind(); } //For display at if (ds1.Tables[12].Rows.Count > 0) { lblAtGrossAdv.Text = ds1.Tables[12].Rows[0]["TotalAdvPaid"].ToString(); lblAtTotalCESS.Text = ds1.Tables[12].Rows[0]["TotalCESS"].ToString(); lblatTotRow.Text = ds1.Tables[12].Rows[0]["TotalInvoice"].ToString(); } else { lblAtGrossAdv.Text = "0"; lblAtTotalCESS.Text = "0"; lblatTotRow.Text = "0"; } if (ds1.Tables[13].Rows.Count > 0) { Gridat.DataSource = ds1.Tables[13]; Gridat.DataBind(); } else { Gridat.DataSource = null; Gridat.DataBind(); } //For display atadj if (ds1.Tables[14].Rows.Count > 0) { lblAtAdjGrossAdv.Text = ds1.Tables[14].Rows[0]["TotalAdvPaid"].ToString(); lblAtadjTotalCESS.Text = ds1.Tables[14].Rows[0]["TotalCESS"].ToString(); lblatadjTotRow.Text = ds1.Tables[14].Rows[0]["TotalInvoice"].ToString(); } else { lblAtAdjGrossAdv.Text = "0"; lblAtadjTotalCESS.Text = "0"; lblatadjTotRow.Text = "0"; } if (ds1.Tables[15].Rows.Count > 0) { Gridatadj.DataSource = ds1.Tables[15]; Gridatadj.DataBind(); } else { Gridatadj.DataSource = null; Gridatadj.DataBind(); } // For display exemp if (ds1.Tables[16].Rows.Count > 0) { lblExempCompTax.Text = ds1.Tables[16].Rows[0]["TotalCompositionTax"].ToString(); lblExempTotalNilRatedTax.Text = ds1.Tables[16].Rows[0]["TotalNilRatedTax"].ToString(); lblExempTotalNonGSTTax.Text = ds1.Tables[16].Rows[0]["TotalNonGSTTax"].ToString(); lblexempTotRow.Text = ds1.Tables[16].Rows[0]["TotalInvoice"].ToString(); } else { lblExempTotalNilRatedTax.Text = "0"; lblExempCompTax.Text = "0"; lblExempTotalNonGSTTax.Text = "0"; lblexempTotRow.Text = "0"; } if (ds1.Tables[17].Rows.Count > 0) { Gridexemp.DataSource = ds1.Tables[17]; Gridexemp.DataBind(); } else { Gridexemp.DataSource = null; Gridexemp.DataBind(); } // For display itcr if (ds1.Tables[18].Rows.Count > 0) { lblItcrTotalITC.Text = ds1.Tables[18].Rows[0]["TotalITC"].ToString(); lblitcrTotRow.Text = ds1.Tables[18].Rows[0]["TotalInvoice"].ToString(); } else { lblItcrTotalITC.Text = "0"; lblitcrTotRow.Text = "0"; } if (ds1.Tables[19].Rows.Count > 0) { Griditcr.DataSource = ds1.Tables[19]; Griditcr.DataBind(); } else { Griditcr.DataSource = null; Griditcr.DataBind(); } //For display hsn summary if (ds1.Tables[20].Rows.Count > 0) { lblHsnTotalQuantity.Text = ds1.Tables[20].Rows[0]["TotalQuantity"].ToString(); lblHsnTotalTaxableValue.Text = ds1.Tables[20].Rows[0]["TotalTaxableValue"].ToString(); lblHsnTotalValue.Text = ds1.Tables[20].Rows[0]["TotalValue"].ToString(); lblhsnTotRow.Text = ds1.Tables[20].Rows[0]["TotalInvoice"].ToString(); } else { lblHsnTotalQuantity.Text = "0"; lblHsnTotalTaxableValue.Text = "0"; lblHsnTotalValue.Text = "0"; lblhsnTotRow.Text = "0"; } if (ds1.Tables[21].Rows.Count > 0) { Gridhsn.DataSource = ds1.Tables[21]; Gridhsn.DataBind(); } else { Gridhsn.DataSource = null; Gridhsn.DataBind(); } } }