int doDowunload()
        {
            try
            {
                //    SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);

                System.Data.DataSet dsonline = new System.Data.DataSet();

                using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
                {
                    connect.Open();

                    command = new SqlCommand("doGetStationInfo", connect)
                    {
                        CommandType = CommandType.StoredProcedure, CommandTimeout = 0
                    };

                    using (System.Data.DataSet ds = new System.Data.DataSet())
                    {
                        adp = new SqlDataAdapter(command);

                        adp.SelectCommand.CommandTimeout = 0;

                        adp.Fill(ds);

                        Dts = ds.Tables[0];

                        connect.Close();

                        if (ds.Tables[0].Rows.Count < 1)
                        {
                            label7.Text = "Not Configured for this station";
                            return(0);
                        }
                        else
                        {
                            label5.Text = string.Format("Receipt Data Download [ {0} ]", ds.Tables[0].Rows[0]["StationName"]);

                            switch (Program.intCode)
                            {
                            case 13:    //Akwa Ibom state
                                using (var receiptAka = new AkwaIbomReceiptServices.ReceiptService())
                                {
                                    dataSet = receiptAka.DownloadData(ds, Program.stateCode);
                                }

                                if (dataSet.Tables.Count == 0)
                                {
                                    timer1.Stop(); timer1.Enabled = false;
                                    //btnStop.Visible = false; btnStart.Visible = true;
                                    return(0);
                                }
                                if (dataSet.Tables[0].Rows.Count < 1)
                                {
                                    label7.Text = String.Format("No More Records for the Station {0}", Program.stationName);
                                    timer1.Stop(); timer1.Enabled = false;
                                    //btnStop.Visible = false; btnStart.Visible = true;
                                    return(0);
                                }
                                else
                                {
                                    dataSet2 = InsertData(dataSet);
                                }

                                if (dataSet2.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
                                {
                                    timer1.Stop();
                                    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;
                                    return(0);
                                }
                                else
                                {
                                    dataSet3.Clear();
                                    using (var receiptAka = new AkwaIbomReceiptServices.ReceiptService())
                                    {
                                        dataSet3 = receiptAka.DownloadDataUpdate(dataSet2, Program.stationCode);
                                    }
                                }
                                break;

                            case 20:    //Delta State
                                using (var receiptDelta = new DeltaBir.ReceiptService())
                                {
                                    System.Data.DataSet dsnew = new System.Data.DataSet();
                                    //dsnew = Logic.GetMacAddress();
                                    //gridControl1.DataSource = dsnew.Tables[0];
                                    //gridControl1.DataSource = Logic.GetMacAddress();
                                    dataSet = receiptDelta.DownloadData(Logic.GetMacAddress(), Program.stationCode);
                                }

                                if (dataSet.Tables.Count == 0)
                                {
                                    timer1.Stop(); timer1.Enabled = false;
                                    //btnStop.Visible = false; btnStart.Visible = true;
                                    return(0);
                                }

                                if (dataSet.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
                                {
                                    timer1.Stop();
                                    Common.setMessageBox(string.Format("{0}...Status Messages", dataSet.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3);
                                    btnStart.Visible = true;
                                    timer1.Enabled   = false;
                                    return(0);
                                }
                                if (dataSet.Tables[1] != null && dataSet.Tables[1].Rows.Count < 1)
                                {
                                    label7.Text = String.Format("No More Records for the Station {0}", Program.stationName);
                                    timer1.Stop(); timer1.Enabled = false;
                                    btnStop.Visible = false; btnStart.Visible = true; btnStart.Enabled = true;
                                    return(0);
                                }
                                else
                                {
                                    dataSet2 = InsertData(dataSet);

                                    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;
                                        return(0);
                                    }
                                    else
                                    {
                                        dataSet3.Clear();

                                        //dsonline = dataSet2.Tables[1];

                                        DataTable dtt = new DataTable();
                                        dtt = dataSet2.Tables[1].Copy();

                                        //dtsoff = ds.Tables[2].DataSet;
                                        dsonline.Tables.Add(dtt);

                                        using (var receiptDelta = new DeltaBir.ReceiptService())
                                        {
                                            dataSet3 = receiptDelta.DownloadDataUpdate(dsonline, Program.stationCode);
                                        }
                                    }
                                }

                                break;

                            case 32:    //kogi state
                                break;

                            case 37:    //ogun state

                                using (var receiptsserv = new ReceiptService())
                                {
                                    System.Data.DataSet dsnew = new System.Data.DataSet();
                                    //dsnew = Logic.GetMacAddress();
                                    //gridControl1.DataSource = dsnew.Tables[0];
                                    dataSet = receiptsserv.DownloadData(Logic.GetMacAddress(), Program.stationCode);
                                }

                                if (dataSet.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
                                {
                                    timer1.Stop();
                                    Common.setMessageBox(string.Format("{0}...Status Messages", dataSet.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3);
                                    btnStart.Visible = true;
                                    timer1.Enabled   = false;
                                    return(0);
                                }

                                if (dataSet.Tables.Count == 0)
                                {
                                    timer1.Stop(); timer1.Enabled = false;
                                    //btnStop.Visible = false; btnStart.Visible = true;
                                    return(0);
                                }

                                if (dataSet.Tables[1] != null && dataSet.Tables[1].Rows.Count < 1)
                                {
                                    label7.Text = String.Format("No More Records for the Station {0}", Program.stationName);
                                    timer1.Stop(); timer1.Enabled = false;
                                    btnStop.Visible = false; btnStart.Visible = true; btnStart.Enabled = true;
                                    return(0);
                                }
                                else
                                {
                                    dataSet2 = InsertData(dataSet);

                                    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;
                                        return(0);
                                    }
                                    else
                                    {
                                        dataSet3.Clear();

                                        using (var receiptsserv = new ReceiptService())
                                        {
                                            dataSet3 = receiptsserv.DownloadDataUpdate(dataSet2, Program.stationCode);
                                        }
                                    }
                                }
                                break;

                            case 40:    //oyo state

                                using (var receiptsServices = new OyoReceiptServices.ReceiptService())
                                {
                                    System.Data.DataSet dsnew = new System.Data.DataSet();
                                    dsnew = Logic.GetMacAddress();
                                    gridControl1.DataSource = dsnew.Tables[0];
                                    dataSet = receiptsServices.DownloadData(Logic.GetMacAddress(), Program.stationCode);
                                }

                                if (dataSet.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
                                {
                                    timer1.Stop();
                                    Common.setMessageBox(string.Format("{0}...Status Messages", dataSet.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3);
                                    btnStart.Visible = true;
                                    timer1.Enabled   = false;
                                    return(0);
                                }

                                if (dataSet.Tables.Count == 0)
                                {
                                    timer1.Stop(); timer1.Enabled = false;
                                    //btnStop.Visible = false; btnStart.Visible = true;
                                    return(0);
                                }

                                if (dataSet.Tables[1] != null && dataSet.Tables[1].Rows.Count < 1)
                                {
                                    label7.Text = String.Format("No More Records for the Station {0}", Program.stationName);
                                    timer1.Stop(); timer1.Enabled = false;
                                    btnStop.Visible = false; btnStart.Visible = true; btnStart.Enabled = true;
                                    return(0);
                                }
                                else
                                {
                                    dataSet2 = InsertData(dataSet);

                                    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;
                                        return(0);
                                    }
                                    else
                                    {
                                        dataSet3.Clear();

                                        using (var receiptsServices = new OyoReceiptServices.ReceiptService())
                                        {
                                            dataSet3 = receiptsServices.DownloadDataUpdate(dataSet2, Program.stationCode);
                                        }
                                    }
                                }
                                break;

                            default:
                                break;
                            }
                            if (dataSet3.Tables[0].Rows[0]["returnCode"].ToString() == "00")
                            {
                                lblAll.Text = dataSet3.Tables[1].Rows[0]["ALLRecords"].ToString();

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

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

                                lblError.Text = dataSet3.Tables[4].Rows[0]["ErrorRecords"].ToString();

                                return(1);
                            }
                            else
                            {
                                timer1.Stop();
                                Common.setMessageBox(string.Format("{0}...Download Data to Local Station...", dataSet3.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3);
                                timer1.Enabled = false;
                                //btnStop.Visible = false;
                                //btnStart.Visible = true;
                                return(0);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                timer1.Stop();
                Common.setMessageBox(String.Format("{0}----{1}...Do Download to Station,doDowunload", ex.Message, ex.StackTrace), Program.ApplicationName, 3); timer1.Stop(); timer1.Enabled = false;
                return(0);
            }
            finally
            {
                //SplashScreenManager.CloseForm(false);
            }
        }