Example #1
0
        void doDownload()
        {
            try
            {
                switch (Program.intCode)
                {
                case 13:    //Akwa Ibom state
                    using (var receiptAka = new AkwaIbomReceiptServices.ReceiptService())
                    {
                        dataSet = receiptAka.DownloadDataCentral(Program.stateCode);
                    }

                    break;

                case 20:    //Delta state
                    using (var receiptDelta = new DeltaBir.ReceiptService())
                    {
                        dataSet = receiptDelta.DownloadDataCentral(Program.stateCode);
                    }
                    break;

                case 32:    //kogi state
                    using (var receiptservic = new Kogireceiptservice.ReceiptService())
                    {
                        dataSet = receiptservic.DownloadDataCentral(Program.stateCode);
                    }
                    break;

                case 37:    //ogun state
                    using (var receiptsserv = new ReceiptService())
                    {
                        dataSet = receiptsserv.DownloadDataCentral(Program.stateCode);
                    }
                    break;

                case 40:    //oyo state

                    using (var receiptsServices = new OyoReceiptServices.ReceiptService())
                    {
                        dataSet = receiptsServices.DownloadDataCentral(Program.stateCode);
                    }
                    break;

                //http://www.ogunstaterevenue.com/OGS_IPS/ReceiptService.asmx
                default:
                    break;
                }

                if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
                {
                    #region
                    ////insert records into local tabale

                    //if (gridControl1.InvokeRequired)
                    //{
                    //    gridControl1.Invoke(new MethodInvoker(UpdateMainUI));
                    //}

                    ////gridControl1.RefreshDataSource();
                    //if (gridControl1.InvokeRequired)
                    //{
                    //    gridControl1.BeginInvoke(new MethodInvoker(delegate
                    //    {
                    //gridControl1.DataSource = null;
                    //gridControl1.DataSource = dataSet.Tables[0];
                    //gridView1.Columns["Amount"].DisplayFormat.FormatType = FormatType.Numeric;
                    //gridView1.Columns["Amount"].DisplayFormat.FormatString = "n2";
                    //gridView1.Columns["PaymentDate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
                    //gridView1.Columns["PaymentDate"].DisplayFormat.FormatString = "dd/MM/yyyy";
                    ////gridView1.Columns["Provider"].Visible = false;
                    ////gridView1.Columns["Channel"].Visible = false;
                    //gridView1.Columns["TelephoneNumber"].Visible = false;
                    //gridView1.Columns["ZoneCode"].Visible = false;
                    //gridView1.Columns["ZoneName"].Visible = false;
                    //gridView1.Columns["DateChequeReturned"].Visible = false;
                    //gridView1.Columns["DateValidatedAgainst"].Visible = false;
                    ////gridView1.Columns["PaymentRefNumber"].Visible = false;
                    //gridView1.Columns["DepositSlipNumber"].Visible = false;
                    //gridView1.Columns["PayerID"].Visible = false;
                    //gridView1.Columns["RevenueCode"].Visible = false;
                    //gridView1.Columns["Description"].Visible = false;
                    //gridView1.Columns["PaymentMethod"].Visible = false;
                    //gridView1.Columns["ChequeNumber"].Visible = false;
                    //gridView1.Columns["ChequeValueDate"].Visible = false;

                    //gridView1.Columns["ChequeBankCode"].Visible = false;
                    //gridView1.Columns["ChequeBankName"].Visible = false;
                    //gridView1.Columns["ChequeStatus"].Visible = false;
                    //gridView1.Columns["DateChequeReturned"].Visible = false;
                    //gridView1.Columns["AgencyName"].Visible = false;
                    //gridView1.Columns["AgencyCode"].Visible = false;
                    //gridView1.Columns["BankCode"].Visible = false;
                    //gridView1.Columns["BankName"].Visible = false;
                    //gridView1.Columns["BranchCode"].Visible = false;
                    //gridView1.Columns["BranchName"].Visible = false;
                    //gridView1.Columns["ReceiptNo"].Visible = false;
                    //gridView1.Columns["ReceiptDate"].Visible = false;
                    //gridView1.Columns["PayerAddress"].Visible = false;
                    ////gridView1.Columns["AmountWords"].Visible = false;
                    ////gridView1.Columns["GeneratedBy"].Visible = false;
                    //gridView1.Columns["DateValidatedAgainst"].Visible = false;
                    //gridView1.Columns["StationCode"].Visible = false;

                    //gridView1.BestFitColumns();
                    //    }));
                    //}
                    //gridControl1.RefreshDataSource();
                    #endregion

                    dataSet2 = InsertData(dataSet);

                    if (dataSet2.Tables.Count > 0 && dataSet2.Tables[0].Rows.Count > 0)
                    {
                        //if (dataSet2.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
                        //{
                        //    Common.setMessageBox(string.Format("{0}...Error Occur During Data Insert After download.... Insert Download", dataSet2.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3);

                        //    timer1.Stop();
                        //    timer1.Enabled = false;
                        //    btnStop.Enabled = false;
                        //    btnStart.Enabled = true;
                        //    //m_oWorker.CancelAsync();
                        //    return;
                        //}
                        //else
                        {
                            dataSet.Clear();
                            switch (Program.intCode)
                            {
                            case 13:    //Akwa Ibom state
                                using (var receiptAka = new AkwaIbomReceiptServices.ReceiptService())
                                {
                                    dataSet = receiptAka.DownloadDataUpdateCentral(dataSet2, Program.stateCode);
                                }
                                break;

                            case 20:    //Delta state
                                using (var receiptDelta = new DeltaBir.ReceiptService())
                                {
                                    dataSet = receiptDelta.DownloadDataUpdateCentral(dataSet2, Program.stateCode);
                                }
                                break;

                            case 32:    //kogi state
                                break;

                            case 37:    //ogun state

                                using (var receiptsserv = new ReceiptService())
                                {
                                    dataSet = receiptsserv.DownloadDataUpdateCentral(dataSet2, Program.stateCode);
                                }

                                break;

                            case 40:    //oyo state

                                using (var receiptsServices = new OyoReceiptServices.ReceiptService())
                                {
                                    dataSet = receiptsServices.DownloadDataUpdateCentral(dataSet2, Program.stateCode);
                                }


                                break;

                            default:
                                break;
                            }

                            if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
                            {
                                label6.Text = "Download In Progress";

                                if (dataSet.Tables[0].Rows[0]["returnCode"].ToString() == "00")
                                {
                                    lblAll.Text = dataSet.Tables[1].Rows[0]["ALLRecords"].ToString();

                                    lblDownload.Text = dataSet.Tables[2].Rows[0]["DownloadedRecords"].ToString();

                                    lblRemain.Text = dataSet.Tables[3].Rows[0]["RemainRecords"].ToString();

                                    lblError.Text = dataSet.Tables[4].Rows[0]["ErrorRecords"].ToString();
                                }
                                else
                                {
                                    timer1.Stop();
                                    Common.setMessageBox(string.Format("{0}...Download Data to Local Station,Update Data Download", dataSet.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3);
                                    timer1.Enabled = false;

                                    return;
                                }
                            }
                        }
                    }
                }
                else
                {
                    label6.Text = "No More Records to Download";


                    timer1.Stop();
                    timer1.Enabled = false;

                    return;
                }
            }
            catch (Exception e)
            {
                timer1.Stop();
                Common.setMessageBox(string.Format("{0}----{1}..Do Down load to station", e.Message, e.StackTrace), Program.ApplicationName, 3); timer1.Enabled = false;

                return;
            }
        }