public bool sendDataToServer(string tableName = "", string PKField = "", string keyword = "") { bool result = false; Data_Access DS_HQ = new Data_Access(); string localDate = ""; string fileName = ""; localDate = String.Format(culture, "{0:ddMMyyyy}", DateTime.Now); fileName = "EXPORT_LOCAL_DATA_" + tableName + "_" + localDate + ".sql"; // EXPORT LOCAL DATA exportData(fileName, tableName, PKField, keyword); if (DS_HQ.HQ_mySQLConnect(true)) { gUtil.saveSystemDebugLog(0, "[SYNC] CONNECTION TO SERVER CREATED"); result = syncLocalDataToServer(DS_HQ, fileName, Data_Access.HQ_SERVER); try { File.Delete(fileName); } catch (Exception ex) { gUtil.saveSystemDebugLog(0, "[SYNC] FAILED TO DELETE EXPORT FILE [" + ex.Message + "]"); } } else { MessageBox.Show("KONEKSI KE PUSAT GAGAL"); gUtil.saveSystemDebugLog(0, "[SYNC] FAILED TO CONNECT TO SERVER"); result = false; } return(result); }
private bool syncToCentralHQ() { bool result = false; Data_Access DS_HQ = new Data_Access(); // CREATE CONNECTION TO CENTRAL HQ DATABASE SERVER gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "TRY TO CREATE CONNECTION TO CENTRAL HQ"); if (DS_HQ.HQ_mySQLConnect(true)) { gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "CONNECTION TO CENTRAL HQ CREATED"); // DUMP NECESSARY DATA TO LOCAL COPY exportData(syncFileName, DS_HQ, true); gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "CENTRAL HQ DATA EXPORTED"); // CLOSE CONNECTION TO CENTRAL HQ DATABASE SERVER DS_HQ.mySqlClose(); gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "CLOSE CONNECTION TO CENTRAL HQ"); // INSERT TO LOCAL DATA gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "SYNC LOCAL INFORMATION WITH DATA FROM CENTRAL HQ [" + syncFileName + "]"); syncInformation(syncFileName); gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "SYNC LOCAL INFORMATION FINISHED"); result = true; } else { MessageBox.Show("KONEKSI KE PUSAT GAGAL"); gutil.saveSystemDebugLog(globalConstants.MENU_SINKRONISASI_INFORMASI, "FAILED TO CONNECT TO CENTRAL HQ"); result = false; } return(result); }