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); }