private void btnReport_Click(object sender, EventArgs e)
        {
            custCode  = txtCustCode.Text;
            _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString());
            _toDate   = Convert.ToDateTime(dtToDate.Value.ToShortDateString());
            DataSet                        TaxDataSet                      = new DataSet();
            DataTable                      TaxStatement                    = new DataTable();
            DataTable                      BonusRightIPOSatement           = new DataTable();
            TaxStatementBAL                TaxStatementBAL                 = new TaxStatementBAL();
            crTaxStatement                 crTaxStatement                  = new crTaxStatement();
            crTaxStatementBonusIPO         crTaxStatementBonusRightIPO_Rpt = new crTaxStatementBonusIPO();
            frmPaymentReceiptSummaryViewer ReportViewer                    = new frmPaymentReceiptSummaryViewer();

            TaxDataSet = TaxStatementBAL.GetData(custCode, _fromDate, _toDate);
            if (TaxDataSet.Tables.Count == 3)
            {
                TaxStatement          = TaxDataSet.Tables[0];
                BonusRightIPOSatement = TaxDataSet.Tables[1];
            }
            crTaxStatement.DataSourceConnections.Clear();
            crTaxStatement.SetDataSource(TaxStatement);
            crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].DataSourceConnections.Clear();
            crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].SetDataSource(BonusRightIPOSatement);
            GetCommonInfo();
            ((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
            ((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text  = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
            ((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text    = dtFromDate.Value.ToString("dd/MM/yyyy");
            ((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text      = dtToDate.Value.ToString("dd/MM/yyyy");

            ReportViewer.crystalReportViewer1.DisplayGroupTree = false;
            ReportViewer.crystalReportViewer1.ReportSource     = crTaxStatement;

            ReportViewer.Show();
        }
Exemplo n.º 2
0
        private void btnGrnerateReport_Click(object sender, EventArgs e)
        {
            if (rdbTaxCertificate.Checked == true)
            {
                if (txtCustCode.Text.Trim() != "")
                {
                    if (_reportNo == "1")
                    {
                        ShowCustTaxStatement();
                    }
                    else
                    {
                        ShowCustMoneyLedgerReport();
                    }
                }
                else
                {
                    MessageBox.Show("Select a customer first.", "Warning!");
                }
            }
            if (rdbTaxStatement.Checked == true)
            {
                custCode  = txtCustCode.Text;
                _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString());
                _toDate   = Convert.ToDateTime(dtToDate.Value.ToShortDateString());
                DataSet                        TaxDataSet                      = new DataSet();
                DataTable                      TaxStatement                    = new DataTable();
                DataTable                      BonusRightIPOSatement           = new DataTable();
                DataTable                      TaxStatementSummary             = new DataTable();
                TaxStatementBAL                TaxStatementBAL                 = new TaxStatementBAL();
                crTaxStatement                 crTaxStatement                  = new crTaxStatement();
                crTaxStatementBonusIPO         crTaxStatementBonusRightIPO_Rpt = new crTaxStatementBonusIPO();
                crTaxStatementSummarySubReport crTaxStatementSummarySubReport  = new crTaxStatementSummarySubReport();
                frmPaymentReceiptSummaryViewer ReportViewer                    = new frmPaymentReceiptSummaryViewer();

                RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Tax_TaxStatement);
                string T_Custcode           = obj.FilterCustCode(_custCode, ResourceName.Tax_TaxStatement);
                if (T_Custcode == "")
                {
                    MessageBox.Show("You are restricted");
                    return;
                }

                TaxDataSet = TaxStatementBAL.GetData(custCode, _fromDate, _toDate);

                if (TaxDataSet.Tables.Count > 3)
                {
                    TaxStatement          = TaxDataSet.Tables[0];
                    BonusRightIPOSatement = TaxDataSet.Tables[1];
                    TaxStatementSummary   = TaxDataSet.Tables[3];
                }

                crTaxStatement.DataSourceConnections.Clear();
                crTaxStatement.SetDataSource(TaxStatement);
                crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].DataSourceConnections.Clear();
                crTaxStatement.Subreports["crTaxStatementBonusIPO.rpt"].SetDataSource(BonusRightIPOSatement);
                crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].DataSourceConnections.Clear();
                crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].SetDataSource(TaxStatementSummary);



                GetCommonInfo();
                ((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
                ((TextObject)crTaxStatement.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text  = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
                ((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text    = dtFromDate.Value.ToString("dd/MM/yyyy");
                ((TextObject)crTaxStatement.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text      = dtToDate.Value.ToString("dd/MM/yyyy");
                ((TextObject)crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = _fromDate.ToString("dd-MM-yyyy");
                ((TextObject)crTaxStatement.Subreports["crTaxStatementSummarySubReport.rpt"].ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text   = _toDate.ToString("dd-MM-yyyy");

                ReportViewer.crystalReportViewer1.DisplayGroupTree = false;
                ReportViewer.crystalReportViewer1.ReportSource     = crTaxStatement;

                ReportViewer.Show();
            }
        }