Esempio n. 1
0
        public FrmReceipts()
        {
            InitializeComponent();

            publicInstance = this;

            publicStreetGroup = this;

            setImages();

            ToolStripEvent();

            iTransType = TransactionTypeCode.New;

            Load += OnFormLoad;

            OnFormLoad(null, null);

            //cboZone.Items.Add("All Zones");

            if (Program.UserID == "" || Program.UserID == null)
            {
                user = "******";
            }
            else
            {
                user = Program.UserID;
            }
        }
Esempio n. 2
0
        void OnNavBarItemsClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
        {
            if (sender != navBarItemExit)
            {
                RemoveControls();
            }

            //if (sender == navBarItemCollImpt)
            //{
            //    FrmImports.tableType = 1;

            //    tableLayoutPanel2.Controls.Add((new FrmImports().panelContainer), 1, 0);

            //    FrmImports.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmImports.publicStreetGroup.RefreshForm();
            //}
            //else if (sender == navBarItemTaxAgentImpt)
            //{
            //    FrmImports.tableType = 2;

            //    tableLayoutPanel2.Controls.Add((new FrmImports().panelContainer), 1, 0);

            //    FrmImports.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmImports.publicStreetGroup.RefreshForm();

            //}
            //else if (sender == navBarItemTaxPayerImpt)
            //{
            //    FrmImports.tableType = 3;

            //    tableLayoutPanel2.Controls.Add((new FrmImports().panelContainer), 1, 0);

            //    FrmImports.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmImports.publicStreetGroup.RefreshForm();
            //}
            //if (sender == navBarItemCollExp)
            //{
            //    FrmExport.tableType = 1;

            //    tableLayoutPanel2.Controls.Add((new FrmExport().panelContainer), 1, 0);

            //    FrmExport.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmExport.publicStreetGroup.RefreshForm();
            //}

            if (sender == navBarItemSplitTransaction)
            {
                tableLayoutPanel2.Controls.Add((new FrmSplit().panelContainer), 1, 0);

                FrmSplit.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmSplit.publicInstance.RefreshForm();
            }
            else if (sender == navBarItem8)//change password
            {
                using (var frm = new FrmChangePassword())
                {
                    frm.ShowDialog();
                }
            }
            else if (sender == navBarItCheck)
            {
                //string paths = AppDomain.CurrentDomain.BaseDirectory;
                CheckUpdate();
            }
            else if (sender == navBarItem1)
            {
                tableLayoutPanel2.Controls.Add((new FrmPayment().panelContainer), 1, 0);

                FrmPayment.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmPayment.publicInstance.RefreshForm();

                FrmPayment.boolIsUpdate = true;
            }
            else if (sender == navBarItem6)
            {
                tableLayoutPanel2.Controls.Add((new FrmCreatMainfest().panelContainer), 1, 0);

                FrmCreatMainfest.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmCreatMainfest.publicInstance.RefreshForm();
            }
            else if (sender == navBarItem2)
            {
                tableLayoutPanel2.Controls.Add((new FrmPayment().panelContainer), 1, 0);

                FrmPayment.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmPayment.publicInstance.RefreshForm();

                FrmPayment.boolIsUpdate = false;
            }
            else if (sender == navBarItmTCO)
            {
                tableLayoutPanel2.Controls.Add((new FrmTCO().panelContainer), 1, 0);

                FrmTCO.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmTCO.publicInstance.RefreshForm();
            }
            //else if (sender == navBarItemTaxPayerExp)
            //{
            //    FrmExport.tableType = 3;

            //    tableLayoutPanel2.Controls.Add((new FrmExport().panelContainer), 1, 0);

            //    FrmExport.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmExport.publicStreetGroup.RefreshForm();
            //}
            //else if (sender == navBarItemTransactionPending)
            //{
            //    tableLayoutPanel2.Controls.Add((new FrmPending().panelContainer), 1, 0);

            //    FrmPending.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmPending.publicStreetGroup.RefreshForm();
            //}
            //else if (sender == navBarItemCashBank)
            //{
            //    tableLayoutPanel2.Controls.Add((new FrmCashiers().panelContainer), 1, 0);

            //    FrmCashiers.publicInstance.Tag = ((sender) as NavBarItem).Tag;

            //    FrmCashiers.publicInstance.RefreshForm();

            //}
            else if (sender == navBarItmArmsSearch)
            {
                tableLayoutPanel2.Controls.Add((new FrmArmsSearch().panelContainer), 1, 0);
                FrmArmsSearch.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
                FrmArmsSearch.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItmArmsApproval)
            {
                tableLayoutPanel2.Controls.Add((new FrmArmsApproval().panelContainer), 1, 0);
                FrmArmsApproval.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
                FrmArmsApproval.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItemReceiptIssuedReport)
            {
                tableLayoutPanel2.Controls.Add((new FrmIssueReport().panelContainer), 1, 0);
                FrmIssueReport.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
                FrmIssueReport.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItemReceiptModification)
            {
                tableLayoutPanel2.Controls.Add((new FrmModification().panelContainer), 1, 0);
                FrmModification.publicInstance.Tag = ((sender) as NavBarItem).Tag;
                FrmModification.publicInstance.RefreshForm();
            }
            else if (sender == navBarItem5)
            {
                tableLayoutPanel2.Controls.Add((new FrmStations().panelContainer), 1, 0);
                //FrmStations.publicInstance.Tag = ((sender) as NavBarItem).Tag;
                FrmStations.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
                FrmStations.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItem4)
            {
                tableLayoutPanel2.Controls.Add((new FrmGetApproved().panelContainer), 1, 0);
                FrmGetApproved.publicInstance.Tag = ((sender) as NavBarItem).Tag;
                FrmGetApproved.publicInstance.RefreshForm();
            }
            else if (sender == navBarImtProfile)
            {
                tableLayoutPanel2.Controls.Add((new FrmProfile().panelContainer), 1, 0);
                FrmProfile.publicInstance.Tag = ((sender) as NavBarItem).Tag;
                FrmProfile.publicInstance.RefreshForm();
            }
            //else if (sender == navBarItemCollect)
            //{
            //    ////tableLayoutPanel2.Controls.Add((new FrmDownload().panelContainer), 1, 0);
            //    tableLayoutPanel2.Controls.Add((new FrmDownloadSources().panelContainer), 1, 0);

            //    //FrmDownloadSources

            //}
            else if (sender == navBarItemDemandReceipt)
            {
                tableLayoutPanel2.Controls.Add((new FrmDemand().panelContainer), 1, 0);

                FrmDemand.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

                FrmDemand.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItem7)
            {
                tableLayoutPanel2.Controls.Add((new FrmFirstApproval().panelContainer), 1, 0);

                FrmFirstApproval.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

                FrmFirstApproval.publicStreetGroup.RefreshForm();
            }
            //else if (sender == navBarItemSummary)
            //{
            //    //FrmSummaryReport
            //    tableLayoutPanel2.Controls.Add((new FrmSummaryReport().panelContainer), 1, 0);

            //    //FrmSummaryReport.publicInstance.Tag = ((sender) as NavBarItem).Tag;

            //    //FrmSummaryReport.publicInstance.RefreshForm();

            //    FrmSummaryReport.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
            //    FrmSummaryReport.publicStreetGroup.RefreshForm();

            //}
            else if (sender == navBarItemReceiptCentre)
            {
                tableLayoutPanel2.Controls.Add((new FrmReceiptsCentre().panelContainer), 1, 0);

                FrmReceiptsCentre.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmReceiptsCentre.publicInstance.RefreshForm();
            }
            //else if (sender == navBarItemPrrintingCentreMap)
            //{
            //    tableLayoutPanel2.Controls.Add((new FrmReceiptCentreMap().panelContainer), 1, 0);

            //    FrmReceiptCentreMap.publicInstance.Tag = ((sender) as NavBarItem).Tag;

            //    FrmReceiptCentreMap.publicInstance.RefreshForm();
            //}
            //else if (sender == navBarItemCheckUpdate)
            //{
            //    Process prupdate = Process.Start("wyUpdate.exe");

            //}
            else if (sender == navBarItemReceiptGenerated)
            {
                tableLayoutPanel2.Controls.Add((new FrmGenerate().panelContainer), 1, 0);

                FrmGenerate.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                //FrmGenerate.publicInstance.RefreshForm();
            }
            else if (sender == navBarItem3)
            {
                tableLayoutPanel2.Controls.Add((new FrmAgecnyMainfest().panelContainer), 1, 0);

                FrmAgecnyMainfest.publicInstance.Tag = ((sender) as NavBarItem).Tag;
            }
            else if (sender == navBarItemReceiptDemand)
            {
                //tableLayoutPanel2.Controls.Add((new FrmReceiptDemand().panelContainer), 1, 0);
                tableLayoutPanel2.Controls.Add((new FrmPendReceipts().panelContainer), 1, 0);

                FrmPendReceipts.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmPendReceipts.publicInstance.RefreshForm();
            }
            else if (sender == navBarItemStationData)
            {
                tableLayoutPanel2.Controls.Add((new FrmStationDownload().panelContainer), 1, 0);

                FrmStationDownload.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

                FrmStationDownload.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItemCentreData)
            {
                tableLayoutPanel2.Controls.Add((new FrmCentralData().panelContainer), 1, 0);

                FrmCentralData.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

                FrmCentralData.publicStreetGroup.RefreshForm();
            }
            //else if (sender == navBarItemStations)
            //{
            //    tableLayoutPanel2.Controls.Add((new FrmStations().panelContainer), 1, 0);

            //    //FrmStations.publicInstance.Tag = ((sender) as NavBarItem).Tag;

            //    FrmStations.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmStations.publicStreetGroup.RefreshForm();

            //}
            //else if (sender == navBarItemReceiptCancel)
            //{
            //    tableLayoutPanel2.Controls.Add((new FrmReceiptCancel().panelContainer), 1, 0);

            //    FrmReceiptCancel.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmReceiptCancel.publicStreetGroup.RefreshForm();
            //}
            else if (sender == navBarItemPrintReceipt)
            {
                //tableLayoutPanel2.Controls.Add((new FrmPrintOption().panelContainer), 1, 0);
                var rec = new FrmReceipts();
                if (!rec.IsDisposed)
                {
                    tableLayoutPanel2.Controls.Add((rec.panelContainer), 1, 0);
                }

                FrmReceipts.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmReceipts.publicInstance.RefreshForm();
            }
            //else if (sender == navBarItemStationMap)
            //{
            //    tableLayoutPanel2.Controls.Add((new FrmStationMap().panelContainer), 1, 0);

            //    FrmStationMap.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

            //    FrmStationMap.publicStreetGroup.RefreshForm();
            //}
            else if (sender == navBarItemReceipt)
            {
                tableLayoutPanel2.Controls.Add((new FrmDetailsReceipts().panelContainer), 1, 0);

                FrmDetailsReceipts.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmDetailsReceipts.publicInstance.RefreshForm();
            }
            else if (sender == navBarItemSearchReceipts)
            {
                tableLayoutPanel2.Controls.Add((new FrmSearchReceipts().panelContainer), 1, 0);

                FrmSearchReceipts.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmSearchReceipts.publicInstance.RefreshForm();
            }
            else if (sender == navBarItemPriningRevenueCode)
            {
                tableLayoutPanel2.Controls.Add((new FrmRevException().panelContainer), 1, 0);

                //FrmRevException.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmRevException.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

                //FrmRevException.publicInstance.RefreshForm();
                FrmRevException.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItemReceiptReportDetails)
            {
                using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport"))
                {
                    SqlDataAdapter ada;

                    DataTable Dt = dds.Tables.Add("CollectionReportTable");
                    ada = new SqlDataAdapter((string)"SELECT ID, Provider, Channel, Collection.tblCollectionReport.PaymentRefNumber, DepositSlipNumber, PaymentDate, PayerID, PayerName, Amount, PaymentMethod, ChequeNumber, ChequeValueDate, ChequeStatus, DateChequeReturned, TelephoneNumber, ReceiptNo, ReceiptDate, PayerAddress, [User], RevenueCode, Description, ChequeBankCode, ChequeBankName, AgencyName, AgencyCode, BankCode, BankName, BranchCode, BranchName, ZoneCode, ZoneName, Username,  AmountWords, Collection.tblCollectionReport.EReceipts, Collection.tblCollectionReport.EReceiptsDate, GeneratedBy,  Receipt.tblCollectionReceipt.UploadStatus, Receipt.tblCollectionReceipt.PrintedBY,Receipt.tblCollectionReceipt.ControlNumber, Receipt.tblCollectionReceipt.BatchNumber, Collection.tblCollectionReport.StationCode,(SELECT StationName FROM Receipt.tblStation WHERE StationCode = Collection.tblCollectionReport.StationCode) AS Stationname, Receipt.tblCollectionReceipt.isPrinted,Receipt.tblCollectionReceipt.IsPrintedDate FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber", Logic.ConnectionString);
                    ada.Fill(dds, "CollectionReportTable");

                    Report.XRepReceiptReport receiptReport = new XRepReceiptReport {
                        DataSource = dds /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable"
                    };

                    receiptReport.ShowPreviewDialog();
                }
            }
            else if (sender == navBarStationCollection)
            {
                using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport"))
                {
                    SqlDataAdapter ada;

                    string query = "SELECT ID, Provider, Channel, Collection.tblCollectionReport.PaymentRefNumber, DepositSlipNumber, PaymentDate, PayerID, PayerName, Amount, PaymentMethod, ChequeNumber, ChequeValueDate, ChequeStatus, DateChequeReturned, TelephoneNumber, ReceiptNo, ReceiptDate, PayerAddress, [User], RevenueCode, Description, ChequeBankCode, ChequeBankName, AgencyName, AgencyCode, BankCode, BankName, BranchCode, BranchName, ZoneCode, ZoneName, Username,  AmountWords, Collection.tblCollectionReport.EReceipts, Collection.tblCollectionReport.EReceiptsDate, GeneratedBy,  Receipt.tblCollectionReceipt.UploadStatus, Receipt.tblCollectionReceipt.PrintedBY,Receipt.tblCollectionReceipt.ControlNumber, Receipt.tblCollectionReceipt.BatchNumber, Collection.tblCollectionReport.StationCode,(SELECT StationName FROM Receipt.tblStation WHERE StationCode = Collection.tblCollectionReport.StationCode) AS Stationname, Receipt.tblCollectionReceipt.isPrinted,Receipt.tblCollectionReceipt.IsPrintedDate FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblCollectionReceipt ON Collection.tblCollectionReport.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber";

                    DataTable Dt = dds.Tables.Add("CollectionReportTable");
                    ada = new SqlDataAdapter(query, Logic.ConnectionString);
                    ada.Fill(dds, "CollectionReportTable");

                    //Report.XtraRepDetails repost = new XtraRepDetails();
                    //repost.ShowPreviewDialog();

                    Report.XtraRepDetails repost = new XtraRepDetails {
                        DataSource = dds /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable"
                    };
                    repost.ShowPreviewDialog();
                }
            }
            else if (sender == navBarItemReprintReceipt)
            {
                tableLayoutPanel2.Controls.Add((new FrmReprinted().panelContainer), 1, 0);
            }
            else if (sender == navBarItemGeneral)
            {
                tableLayoutPanel2.Controls.Add((new FrmGeneral().panelContainer), 1, 0);

                FrmGeneral.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmGeneral.publicInstance.RefreshForm();


                //                string vquery;
                //                try
                //                {
                //                    //vquery = String.Format(@"SELECT * FROM dbo.tblCollectionReport WHERE ID IN (SELECT * FROM [fnConvertCSVToINT]('{0}'))", IDList);

                //                    #region SQL
                //                    vquery = @"SELECT  [ID] ,
                //                                         [Provider] ,
                //                                         [Channel] ,
                //                                         [PaymentRefNumber] ,
                //                                         [DepositSlipNumber] ,
                //                                         CONVERT(VARCHAR,CONVERT(DATE,[PaymentDate]),103) AS PaymentDate,
                //                                         [PayerID] ,
                //                                         UPPER([PayerName]) AS [PayerName],
                //                                         [Amount] ,
                //                                         [PaymentMethod] ,
                //                                         [ChequeNumber] ,
                //                                         [ChequeValueDate] ,
                //                                         [ChequeStatus] ,
                //                                         [DateChequeReturned] ,
                //                                         [TelephoneNumber] ,
                //                                         [ReceiptNo] ,
                //                                         [ReceiptDate] ,
                //                                         [PayerAddress] ,
                //                                         [Status] ,
                //                                         [User] ,
                //                                         [RevenueCode] ,
                //                                         [Description] ,
                //                                         [ChequeBankCode] ,
                //                                         [ChequeBankName] ,
                //                                         [AgencyName] ,
                //                                         [AgencyCode] ,
                //                                         [BankCode] ,
                //                                         [BankName] ,
                //                                         [BranchCode] ,
                //                                         [BranchName] ,
                //                                         [ZoneCode] ,
                //                                         [ZoneName] ,
                //                                         [Username] ,
                //                                         [State] ,
                //                                         [AmountWords] ,
                //                                         [URL] ,
                //                                         [EReceipts] ,
                //                                         [EReceiptsDate] ,
                //                                         [GeneratedBy] ,
                //                                         [DateValidatedAgainst] ,
                //                                         [DateDiff] ,
                //                                         [UploadStatus] ,
                //                                         [PrintedBY] ,
                //                                         [DatePrinted] ,
                //                                         [ControlNumber] ,
                //                                         [BatchNumber] ,
                //                                         [StationCode] ,
                //--                                         [StationName]
                //--[StationName]
                //                                         (Select StationName from tblStation WHERE tblStation.StationCode = ViewCollectionReport.[StationCode]) AS StationName
                //                                 FROM    [dbo].[ViewCollectionReport]
                //                                  WHERE EReceipts IS NOT NULL ORDER BY ViewCollectionReport.AgencyCode,ViewCollectionReport.StationCode  ,ViewCollectionReport.RevenueCode,ViewCollectionReport.EReceipts";
                //                    #endregion
                //                    using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport"))
                //                    {
                //                        using (SqlDataAdapter ada = new SqlDataAdapter(vquery, Logic.ConnectionString))
                //                        {
                //                            ada.Fill(dds, "CollectionReportTable");
                //                            Report.XRepGlobalManifest Global = new Collection.Report.XRepGlobalManifest { DataSource = dds, DataAdapter = ada, DataMember = "CollectionReportTable", RequestParameters = true };
                //                            //Global.paramStartDate.Value = "EReceiptsDate";
                //                            //Global.paramEndDate.Value = "EReceiptsDate";
                //                            // Global.paramEndDate.Visible = false;
                //                            Global.ShowPreviewDialog();
                //                        }
                //                    }
                //                }
                //                catch
                //                {
                //                    vquery = @"SELECT [ID] ,
                //                                         [Provider] ,
                //                                         [Channel] ,
                //                                         [PaymentRefNumber] ,
                //                                         [DepositSlipNumber] ,
                //                                         [PaymentDate],
                //                                         [PayerID] ,
                //                                         UPPER([PayerName]) AS [PayerName],
                //                                         [Amount] ,
                //                                         [PaymentMethod] ,
                //                                         [ChequeNumber] ,
                //                                         [ChequeValueDate] ,
                //                                         [ChequeStatus] ,
                //                                         [DateChequeReturned] ,
                //                                         [TelephoneNumber] ,
                //                                         [ReceiptNo] ,
                //                                         [ReceiptDate] ,
                //                                         [PayerAddress] ,
                //                                         [Status] ,
                //                                         [User] ,
                //                                         [RevenueCode] ,
                //                                         [Description] ,
                //                                         [ChequeBankCode] ,
                //                                         [ChequeBankName] ,
                //                                         [AgencyName] ,
                //                                         [AgencyCode] ,
                //                                         [BankCode] ,
                //                                         [BankName] ,
                //                                         [BranchCode] ,
                //                                         [BranchName] ,
                //                                        [BankName]+' / '+ [BranchName] AS calcBankBranchCol,
                //                                         [ZoneCode] ,
                //                                         [ZoneName] ,
                //                                         [Username] ,
                //                                         [State] ,
                //                                         [AmountWords] ,
                //                                         [URL] ,
                //                                         [EReceipts] ,
                //                                         [EReceiptsDate] ,
                //                                         [GeneratedBy] ,
                //                                         [DateValidatedAgainst] ,
                //                                         [DateDiff] ,
                //                                         [UploadStatus] ,
                //                                         [PrintedBY] ,
                //                                         [DatePrinted] ,
                //                                         [ControlNumber] ,
                //                                         [BatchNumber] ,
                //                                         [StationCode] ,
                //                                     --[StationName]
                //--[StationName]
                //                                         (Select StationName from tblStation WHERE tblStation.StationCode = ViewCollectionReport.[StationCode]) AS StationName
                //                                 FROM    ViewCollectionReport WHERE EReceipts IS NOT NULL ORDER BY  ViewCollectionReport.AgencyCode ,ViewCollectionReport.StationCode ,ViewCollectionReport.RevenueCode,ViewCollectionReport.EReceipts";
                //                    using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport"))
                //                    {
                //                        using (SqlDataAdapter ada = new SqlDataAdapter(vquery, Logic.ConnectionString))
                //                        {
                //                            ada.Fill(dds, "CollectionReportTable");
                //                            Report.XRepGlobalManifest Global = new Collection.Report.XRepGlobalManifest { DataSource = dds, DataAdapter = ada, DataMember = "CollectionReportTable", RequestParameters = false };
                //                            Global.ShowPreviewDialog();
                //                        }
                //                    }
                //                }



                //Report.XRepGlobalManifest Global = new Collection.Report.XRepGlobalManifest();
                //Global.ShowPreviewDialog();
            }
            else if (sender == navBarItemPending)
            {
                Report.XRepPendTransaction pending = new Collection.Report.XRepPendTransaction();
                pending.ShowPreviewDialog();
            }
            else if (sender == navBarItemReprint)
            {
                tableLayoutPanel2.Controls.Add((new FrmPrintOption().panelContainer), 1, 0);

                FrmPrintOption.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmPrintOption.publicInstance.RefreshForm();
            }
            else if (sender == navBarItemReceiptReceive)
            {
                tableLayoutPanel2.Controls.Add((new FrmReceiveRec().panelContainer), 1, 0);

                FrmReceiveRec.publicInstance.Tag = ((sender) as NavBarItem).Tag;


                FrmReceiveRec.publicInstance.RefreshForm();
            }
            else if (sender == navBarItemReceiptIssue)
            {
                tableLayoutPanel2.Controls.Add((new FrmIssueReceipts().panelContainer), 1, 0);

                //FrmIssueReceipts.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmIssueReceipts.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;

                //FrmIssueReceipts.publicInstance.RefreshForm();

                FrmIssueReceipts.publicStreetGroup.RefreshForm();
            }
            else if (sender == navBarItemRevenueException)
            {
                tableLayoutPanel2.Controls.Add((new FrmRevException().panelContainer), 1, 0);

                //FrmRevException.publicInstance.Tag = ((sender) as NavBarItem).Tag;

                FrmRevException.publicStreetGroup.RefreshForm();

                FrmRevException.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
            }
            else if (sender == navBarItemLogout)
            {
                Program.App_LOGOUT = true;
                Application.Restart();
                Close();
            }
            else if (sender == navBarItemExit)
            {
                Close();
            }
        }