void FillGRID(int RecordNo)
{
lblTabName.Text = "";
DataSet ds = null;
if (RecordNo == 20)
{
lblTabName.Text = "3,4A - Inward Supplies received from Registerd person including reverse charge supplies";
panelb2b.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridb2b.DataSource = ds.Tables[0];
Gridb2b.DataBind();
}
if (RecordNo == 21)
{
lblTabName.Text = "4B - Inward supplies from an unregistered supplier";
panelb2bur.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=2&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridb2bur.DataSource = ds.Tables[0];
Gridb2bur.DataBind();
}
if (RecordNo == 24)
{
lblTabName.Text = "4C - Import of service";
panelImps.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=4&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridimps.DataSource = ds.Tables[0];
Gridimps.DataBind();
}
if (RecordNo == 22) // for GSTR2 cdn
{
lblTabName.Text = "6C - Debit/Credit Notes for supplies from registered person";
panelCdnr.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=5&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridcdn.DataSource = ds.Tables[0];
Gridcdn.DataBind();
}
if (RecordNo == 30) // for GSTR2 cdnur
{
lblTabName.Text = "6C - Debit Notes/Credit Notes for Unregistered Supplier";
panelCdnur.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=6&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridcdnur.DataSource = ds.Tables[0];
Gridcdnur.DataBind();
}
if (RecordNo == 23)
{
lblTabName.Text = "5 - Import of Inputs/Capital goods and Supplies received from SEZ";
panelImpg.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=3&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridimpg.DataSource = ds.Tables[0];
Gridimpg.DataBind();
}
if (RecordNo == 26) // GSTR2 At
{
lblTabName.Text = "10(I) - 10A - Advance amount paid for reverse charge supplies";
panelAt.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=7&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridat.DataSource = ds.Tables[0];
Gridat.DataBind();
}
if (RecordNo == 27) // GSTR2 Atadj
{
lblTabName.Text = "10(I) - 10B - Adjustment of Advance amount paid earilier for reverse charge supplies";
panelAtadj.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=8&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridatadj.DataSource = ds.Tables[0];
Gridatadj.DataBind();
}
if (RecordNo == 25) // GSTR2 exemp
{
lblTabName.Text = "7 - Supplies from composition taxable person and other exempt/nil rated/non GST supplies";
panelexemp.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=9&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridexemp.DataSource = ds.Tables[0];
Gridexemp.DataBind();
}
if (RecordNo == 28) // GSTR2 itcr
{
lblTabName.Text = "11 - Input Tax Credit Reversal/Reclaim";
panelitcr.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=10&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Griditcr.DataSource = ds.Tables[0];
Griditcr.DataBind();
}
if (RecordNo == 29) // GSTR2 hsn
{
lblTabName.Text = "13 - HSN summary of inward supplies";
panelhsn.Visible = true;
ds = CLSCommon.CallApiGet("api/GSTR2Action/GetGSTR2Data?ind=11&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString() + "&RecordNo=" + RecordNo.ToString());
Gridhsn.DataSource = ds.Tables[0];
Gridhsn.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();
}
}
}