コード例 #1
0
        private string SyncMahasiswa(bool firstSync)
        {
            string err = string.Empty;    //tampungan error message

            deleteMahasiswaTmp();         //hapus tmp

            err = downloadMahasiswaTmp(); //insert tmp

            //cek fisrtSync
            if (firstSync == true)
            {
                if (err != string.Empty)
                { //jika terjadi error
                    return(err);
                }
            }

            cQuery qr = new cQuery();

            //string qrTmp = "SELECT nik FROM penggunaTmp WHERE kategori = 1 LIMIT 1";//cek data mhs di tmp
            if (cekDataSqlLIte(qr.qSelectMhsTmpLimit1(), false) == true) //cek tabel tmp
            {                                                            //jika ada datanya
               //pindah tabel tmp ke kendaraan

                deleteMahasiswa();
                copyTmpToMahasiswa();

                if (ProgressBarSinkron.Value == ProgressBarSinkron.Maximum)//jika sudah selesai tampilkan download complete
                {
                    if (LbDownload.InvokeRequired)
                    {
                        LbDownload.BeginInvoke(
                            new Action(() =>
                        {
                            LbDownload.Text = "Download Complete";
                        }
                                       ));
                    }
                }

                //Cek firstSync
                if (firstSync == false)
                {
                    MessageBox.Show("" + ProgressBarSinkron.Value + " Data Berhasil di Download", "BSI UMY", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            else
            {
                MessageBox.Show("Synchronize Failed", "BSI UMY", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                //ProgressBarSinkron.Visible = false;// hiden panel progressbar
            }

            return(err);
        }