Esempio n. 1
0
        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 = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "ZRL")).Sum(P => P.GstBaseAmount));
                txtRLS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRL").Sum(P => P.GstAmount));

                txtVES1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "ZRE")).Sum(P => P.GstBaseAmount));
                txtVES2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRE").Sum(P => P.GstAmount));

                txtExmS1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "ES")).Sum(P => P.GstBaseAmount));
                txtExmS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ES").Sum(P => P.GstAmount));

                txtSGR1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "RS")).Sum(P => P.GstBaseAmount));
                txtSGR2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "RS").Sum(P => P.GstAmount));

                txtSGS1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "IM")).Sum(P => P.GstBaseAmount));
                txtSGS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstAmount));

                txtVDS1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "GS")).Sum(P => P.GstBaseAmount));
                txtVDS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "GS").Sum(P => P.GstAmount));

                txtGT1.Value = ReportsUtility.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 = ReportsUtility.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    = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstType == "OUT" && P.GstAmount > 0).Sum(P => P.GstBaseAmount));
                txtOtherAdjustment.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstType == "OUT" && P.GstAmount > 0).Sum(P => P.GstAmount));

                txtINTotStanRate.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstType == "IN" && P.GstAmount > 0).Sum(P => P.GstBaseAmount));
                txtInTotOtherAdj.Value = ReportsUtility.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 = ReportsUtility.MyFormat(decimal.Parse(txtOtherAdjustment.Value) - decimal.Parse(txtInTotOtherAdj.Value));
                }
                else
                {
                    txtGSTAmtClamable.Value = ReportsUtility.MyFormat(decimal.Parse(txtInTotOtherAdj.Value) - decimal.Parse(txtOtherAdjustment.Value));
                }

                txtZeroRatedSup.Value   = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRL").Sum(P => P.GstBaseAmount));
                txtTotExpSuplies.Value  = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ZRE").Sum(P => P.GstBaseAmount));
                txtTotExeSupplies.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "ES" || P.GstCode == "ES43").Sum(P => P.GstBaseAmount));

                txtTotSupGSTRel.Value  = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "RS").Sum(P => P.GstBaseAmount));
                txtTotTradScheme.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstBaseAmount));

                txtTotItem14.Value   = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstAmount));
                txttotGoodsAcq.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" || P.GstCode == "EP").Sum(P => P.GstBaseAmount));

                txtTotRecIncTax.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GLCode == GLBadDebt && P.GstType == "IN").Sum(P => P.GstAmount));
            }
        }
Esempio n. 3
0
        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 = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "SR")).Sum(P => P.GstBaseAmount));
                txtSRNS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "SR").Sum(P => P.GstAmount));

                //txtSRDBA1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstBaseAmount));
                //txtSRDBA2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstAmount));

                //txtSRAUP1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstBaseAmount));
                //txtSRAUP2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstAmount));

                txtSRDBA1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstBaseAmount));
                txtSRDBA2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode == GLCapitalGoods).Sum(P => P.GstAmount));

                txtSRAUP1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstBaseAmount));
                txtSRAUP2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "DS" && P.GLCode != GLCapitalGoods).Sum(P => P.GstAmount));


                txtST1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "SR" || P.GstCode == "DS").Sum(P => P.GstBaseAmount));
                txtST2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "SR" || P.GstCode == "DS").Sum(P => P.GstAmount));



                txtBDR1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "BDR").Sum(P => P.GstBaseAmount));
                txtBDR2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "BDR").Sum(P => P.GstAmount));

                txtCNDN1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CNDN").Sum(P => P.GstBaseAmount));
                txtCNDN2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CNDN").Sum(P => P.GstAmount));

                txtCGA1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CGA").Sum(P => P.GstBaseAmount));
                txtCGA2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "CGA").Sum(P => P.GstAmount));

                txtAAd1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "AAD").Sum(P => P.GstBaseAmount));
                txtAAd2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "AAD").Sum(P => P.GstAmount));

                txtOAd1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "OAD").Sum(P => P.GstBaseAmount));
                txtOAd2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJS" && P.AdjType == "OAD").Sum(P => P.GstAmount));

                txtAST1.Value = ReportsUtility.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 = ReportsUtility.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 = ReportsUtility.MyFormat(decimal.Parse(txtST1.Value) + decimal.Parse(txtAST1.Value));
                txtGT2.Value = ReportsUtility.MyFormat(decimal.Parse(txtST2.Value) + decimal.Parse(txtAST2.Value));
            }
        }
Esempio n. 4
0
        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 = ReportsUtility.MyFormat(lstGstReport.FindAll(P => (P.GstCode == "TX" || P.GstCode == "BL") && P.GLCode != GLCapitalGoods).Sum(P => P.GstBaseAmount));
                txtNPSRS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX").Sum(P => P.GstAmount));
                txtNPSRS3.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "BL").Sum(P => P.GstAmount));

                txtNPMES1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstBaseAmount));
                //txtNPSRS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));
                txtNPMES3.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));

                txtNPIES1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-E43" || P.GstCode == "TX-N43").Sum(P => P.GstBaseAmount));
                txtNPIES2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-E43").Sum(P => P.GstAmount));
                txtNPIES3.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-N43").Sum(P => P.GstAmount));

                txtCGSRS1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" && P.GLCode == GLCapitalGoods).Sum(P => P.GstBaseAmount));
                txtCGSRS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" && P.GLCode == GLCapitalGoods).Sum(P => P.GstAmount));
                //txtNPIES3.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX-N43").Sum(P => P.GstAmount));

                txtCGMES1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstBaseAmount));
                //txtNPSRS2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));
                txtCGMES3.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "EP").Sum(P => P.GstAmount));

                txtGI1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IS" || P.GstCode == "IM").Sum(P => P.GstBaseAmount));
                txtGI2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IS").Sum(P => P.GstAmount));
                txtGI3.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "IM").Sum(P => P.GstAmount));

                txtST1.Value = ReportsUtility.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 = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "TX" ||
                                                                            P.GstCode == "TX-E43" ||
                                                                            P.GstCode == "IS").Sum(P => P.GstAmount));

                txtST3.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "BL" ||
                                                                            P.GstCode == "EP" ||
                                                                            P.GstCode == "TX-N43" ||
                                                                            P.GstCode == "IM").Sum(P => P.GstAmount));

                txtBDR1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "BDR").Sum(P => P.GstBaseAmount));
                txtBDR2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "BDR").Sum(P => P.GstAmount));

                txtCNDN1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CNDN").Sum(P => P.GstBaseAmount));
                txtCNDN2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CNDN").Sum(P => P.GstAmount));

                txtCGA1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CGA").Sum(P => P.GstBaseAmount));
                txtCGA2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "CGA").Sum(P => P.GstAmount));

                txtAAd1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "AAD").Sum(P => P.GstBaseAmount));
                txtAAd2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "AAD").Sum(P => P.GstAmount));

                txtOAd1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "OAD").Sum(P => P.GstBaseAmount));
                txtOAd2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" && P.AdjType == "OAD").Sum(P => P.GstAmount));

                txtAST1.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" &&
                                                                             P.AdjType != "").Sum(P => P.GstBaseAmount));

                txtAST2.Value = ReportsUtility.MyFormat(lstGstReport.FindAll(P => P.GstCode == "AJP" &&
                                                                             P.AdjType != "").Sum(P => P.GstAmount));


                txtGT1.Value = ReportsUtility.MyFormat(decimal.Parse(txtST1.Value) + decimal.Parse(txtAST1.Value));
                txtGT2.Value = ReportsUtility.MyFormat(decimal.Parse(txtST2.Value) + decimal.Parse(txtAST2.Value));
                txtGT3.Value = ReportsUtility.MyFormat(decimal.Parse(txtST3.Value) + decimal.Parse(txtAST3.Value));
            }
        }