public tlrGSTAdditionalInfo(DataSet DS)
{
String GLBadDebt = "", GLCapitalGoods = "";
InitializeComponent();
if (!Object.Equals(DS, null))
{
DataRow DTCompany = DS.Tables[0].Rows[0];
GLBadDebt = DTCompany["GLCodeBadDebt"].ToString();
GLCapitalGoods = DTCompany["CapitalGoods"].ToString();
string FromDate = string.Format("{0:dd/MM/yyyy}", DTCompany["FromDate"]);
string Todate = string.Format("{0:dd/MM/yyyy}", DTCompany["ToDate"]);
txtTaxPeriod.Value = string.Format(" for Taxable Period {0} To {1}", FromDate, Todate);
List <GstReport> lstGstReport = new GstReport().GetGstReport(DS.Tables[1]);
txtRLS1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "ZRL")).Sum(P => P.GstBaseAmount));
txtRLS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRL").Sum(P => P.GstAmount));
txtVES1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "ZRE")).Sum(P => P.GstBaseAmount));
txtVES2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRE").Sum(P => P.GstAmount));
txtExmS1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "ES")).Sum(P => P.GstBaseAmount));
txtExmS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ES").Sum(P => P.GstAmount));
txtSGR1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "RS")).Sum(P => P.GstBaseAmount));
txtSGR2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "RS").Sum(P => P.GstAmount));
txtSGS1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "IM")).Sum(P => P.GstBaseAmount));
txtSGS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstAmount));
txtVDS1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "GS")).Sum(P => P.GstBaseAmount));
txtVDS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "GS").Sum(P => P.GstAmount));
txtGT1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRL" ||
P.GstCode == "ZRE" ||
P.GstCode == "ES" ||
P.GstCode == "RS" ||
P.GstCode == "GS" ||
P.GstCode == "IM" ||
P.GstCode == "GS"
).Sum(P => P.GstBaseAmount));
txtGT2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRL" ||
P.GstCode == "ZRE" ||
P.GstCode == "ES" ||
P.GstCode == "RS" ||
P.GstCode == "GS" ||
P.GstCode == "IM" ||
P.GstCode == "GS"
).Sum(P => P.GstAmount));
}
}
public tlrGoodsAndServiceTaxReturn(DataSet DS)
{
String GLBadDebt = "";
InitializeComponent();
if (!Object.Equals(DS, null))
{
DataRow DTCompany = DS.Tables[0].Rows[0];
GLBadDebt = DTCompany["GLCodeBadDebt"].ToString();
txtGSTNo.Value = DTCompany["GSTCode"].ToString();
txtBusinessName.Value = DTCompany["CompanyName"].ToString();
string FromDate = string.Format("{0:dd/MM/yyyy}", DTCompany["FromDate"]);
string Todate = string.Format("{0:dd/MM/yyyy}", DTCompany["ToDate"]);
txtTaxableDate.Value = string.Format("{0} To {1}", FromDate, Todate);
List <GstReport> lstGstReport = new GstReport().GetGstReport(DS.Tables[1]);
txtTotStandRate.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstType == "OUT" && P.GstAmount > 0).Sum(P => P.GstBaseAmount));
txtOtherAdjustment.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstType == "OUT" && P.GstAmount > 0).Sum(P => P.GstAmount));
txtINTotStanRate.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstType == "IN" && P.GstAmount > 0).Sum(P => P.GstBaseAmount));
txtInTotOtherAdj.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstType == "IN" && P.GstAmount > 0).Sum(P => P.GstAmount));
if (decimal.Parse(txtOtherAdjustment.Value) > decimal.Parse(txtInTotOtherAdj.Value))
{
txtGSTAmtPayable.Value = MiscUtil.MyFormat(decimal.Parse(txtOtherAdjustment.Value) - decimal.Parse(txtInTotOtherAdj.Value));
}
else
{
txtGSTAmtClamable.Value = MiscUtil.MyFormat(decimal.Parse(txtInTotOtherAdj.Value) - decimal.Parse(txtOtherAdjustment.Value));
}
txtZeroRatedSup.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRL").Sum(P => P.GstBaseAmount));
txtTotExpSuplies.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRE").Sum(P => P.GstBaseAmount));
txtTotExeSupplies.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ES" || P.GstCode == "ES43").Sum(P => P.GstBaseAmount));
txtTotSupGSTRel.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "RS").Sum(P => P.GstBaseAmount));
txtTotTradScheme.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstBaseAmount));
txtTotItem14.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstAmount));
txttotGoodsAcq.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" || P.GstCode == "EP").Sum(P => P.GstBaseAmount));
txtTotRecIncTax.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GLCode == GLBadDebt && P.GstType == "IN").Sum(P => P.GstAmount));
}
}
public tlrGSTSummaryTotAcqInTax(DataSet DS)
{
String GLBadDebt = "", GLCapitalGoods = "";
InitializeComponent();
if (!Object.Equals(DS, null))
{
DataRow DTCompany = DS.Tables[0].Rows[0];
GLBadDebt = DTCompany["GLCodeBadDebt"].ToString();
GLCapitalGoods = DTCompany["CapitalGoods"].ToString();
string FromDate = string.Format("{0:dd/MM/yyyy}", DTCompany["FromDate"]);
string Todate = string.Format("{0:dd/MM/yyyy}", DTCompany["ToDate"]);
txtTaxPeriod.Value = string.Format(" for Taxable Period {0} To {1}", FromDate, Todate);
List <GstReport> lstGstReport = new GstReport().GetGstReport(DS.Tables[1]);
txtNPSRS1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "TX" || P.GstCode == "BL") && P.GLCode != GLCapitalGoods).Sum(P => P.GstBaseAmount));
txtNPSRS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX").Sum(P => P.GstAmount));
txtNPSRS3.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "BL").Sum(P => P.GstAmount));
txtNPMES1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstBaseAmount));
//txtNPSRS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));
txtNPMES3.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));
txtNPIES1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-E43" || P.GstCode == "TX-N43").Sum(P => P.GstBaseAmount));
txtNPIES2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-E43").Sum(P => P.GstAmount));
txtNPIES3.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-N43").Sum(P => P.GstAmount));
txtCGSRS1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" && P.GLCode == GLCapitalGoods).Sum(P => P.GstBaseAmount));
txtCGSRS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" && P.GLCode == GLCapitalGoods).Sum(P => P.GstAmount));
//txtNPIES3.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-N43").Sum(P => P.GstAmount));
txtCGMES1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstBaseAmount));
//txtNPSRS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));
txtCGMES3.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));
txtGI1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IS" || P.GstCode == "IM").Sum(P => P.GstBaseAmount));
txtGI2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IS").Sum(P => P.GstAmount));
txtGI3.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstAmount));
txtST1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" ||
P.GstCode == "BL" ||
P.GstCode == "EP" ||
P.GstCode == "TX-E43" ||
P.GstCode == "TX-N43" ||
P.GstCode == "IS" ||
P.GstCode == "IM").Sum(P => P.GstBaseAmount));
txtST2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" ||
P.GstCode == "TX-E43" ||
P.GstCode == "IS").Sum(P => P.GstAmount));
txtST3.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "BL" ||
P.GstCode == "EP" ||
P.GstCode == "TX-N43" ||
P.GstCode == "IM").Sum(P => P.GstAmount));
txtBDR1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "BDR").Sum(P => P.GstBaseAmount));
txtBDR2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "BDR").Sum(P => P.GstAmount));
txtCNDN1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CNDN").Sum(P => P.GstBaseAmount));
txtCNDN2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CNDN").Sum(P => P.GstAmount));
txtCGA1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CGA").Sum(P => P.GstBaseAmount));
txtCGA2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CGA").Sum(P => P.GstAmount));
txtAAd1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "AAD").Sum(P => P.GstBaseAmount));
txtAAd2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "AAD").Sum(P => P.GstAmount));
txtOAd1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "OAD").Sum(P => P.GstBaseAmount));
txtOAd2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "OAD").Sum(P => P.GstAmount));
txtAST1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" &&
P.AdjType != "").Sum(P => P.GstBaseAmount));
txtAST2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" &&
P.AdjType != "").Sum(P => P.GstAmount));
txtGT1.Value = MiscUtil.MyFormat(decimal.Parse(txtST1.Value) + decimal.Parse(txtAST1.Value));
txtGT2.Value = MiscUtil.MyFormat(decimal.Parse(txtST2.Value) + decimal.Parse(txtAST2.Value));
txtGT3.Value = MiscUtil.MyFormat(decimal.Parse(txtST3.Value) + decimal.Parse(txtAST3.Value));
}
}
public tlrTotSuppNOutTax(DataSet DS)
{
String GLBadDebt = "", GLCapitalGoods = "";
InitializeComponent();
if (!Object.Equals(DS, null))
{
DataRow DTCompany = DS.Tables[0].Rows[0];
GLBadDebt = DTCompany["GLCodeBadDebt"].ToString();
GLCapitalGoods = DTCompany["CapitalGoods"].ToString();
string FromDate = string.Format("{0:dd/MM/yyyy}", DTCompany["FromDate"]);
string Todate = string.Format("{0:dd/MM/yyyy}", DTCompany["ToDate"]);
txtTaxPeriod.Value = string.Format(" for Taxable Period {0} To {1}", FromDate, Todate);
List <GstReport> lstGstReport = new GstReport().GetGstReport(DS.Tables[1]);
txtSRNS1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "SR")).Sum(P => P.GstBaseAmount));
txtSRNS2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "SR").Sum(P => P.GstAmount));
//txtSRDBA1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstBaseAmount));
//txtSRDBA2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstAmount));
//txtSRAUP1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstBaseAmount));
//txtSRAUP2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstAmount));
txtSRDBA1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstBaseAmount));
txtSRDBA2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstAmount));
txtSRAUP1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstBaseAmount));
txtSRAUP2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstAmount));
txtST1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "SR" || P.GstCode == "DS").Sum(P => P.GstBaseAmount));
txtST2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "SR" || P.GstCode == "DS").Sum(P => P.GstAmount));
txtBDR1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "BDR").Sum(P => P.GstBaseAmount));
txtBDR2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "BDR").Sum(P => P.GstAmount));
txtCNDN1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CNDN").Sum(P => P.GstBaseAmount));
txtCNDN2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CNDN").Sum(P => P.GstAmount));
txtCGA1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CGA").Sum(P => P.GstBaseAmount));
txtCGA2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CGA").Sum(P => P.GstAmount));
txtAAd1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "AAD").Sum(P => P.GstBaseAmount));
txtAAd2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "AAD").Sum(P => P.GstAmount));
txtOAd1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "OAD").Sum(P => P.GstBaseAmount));
txtOAd2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "OAD").Sum(P => P.GstAmount));
txtAST1.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && (P.AdjType == "BDR" ||
P.AdjType == "CNDN" || P.AdjType == "CGA" || P.AdjType == "AAD" || P.AdjType == "OAD")).Sum(P => P.GstBaseAmount));
txtAST2.Value = MiscUtil.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && (P.AdjType == "BDR" ||
P.AdjType == "CNDN" || P.AdjType == "CGA" || P.AdjType == "AAD" || P.AdjType == "OAD")).Sum(P => P.GstAmount));
txtGT1.Value = MiscUtil.MyFormat(decimal.Parse(txtST1.Value) + decimal.Parse(txtAST1.Value));
txtGT2.Value = MiscUtil.MyFormat(decimal.Parse(txtST2.Value) + decimal.Parse(txtAST2.Value));
}
}