private BackupProgress StartBackup(Models.Backup backup) { if (CoreBaseSettings.Standalone) { TenantExtra.DemandControlPanelPermission(); } var storageType = backup.StorageType == null ? BackupStorageType.Documents : (BackupStorageType)Int32.Parse(backup.StorageType); var storageParams = backup.StorageParams == null ? new Dictionary <string, string>() : backup.StorageParams.ToDictionary(r => r.Key.ToString(), r => r.Value.ToString()); BackupHandler.StartBackup(storageType, storageParams, backup.BackupMail); return(BackupHandler.GetBackupProgress()); }
public static async Task CleanupRestoreErrorAsync(BackupHandler handler, Guid appId, Guid id, ISemanticLog log) { try { await handler.CleanupRestoreErrorAsync(appId); } catch (Exception ex) { log.LogError(ex, id.ToString(), (logOperationId, w) => w .WriteProperty("action", "cleanupRestore") .WriteProperty("status", "failed") .WriteProperty("operationId", logOperationId)); } }
void timer_Elapsed(object sender, ElapsedEventArgs e) { try { timer.Interval = Helper.Add24HrsInterval; log.Info("Next backup will be taken on : " + DateTime.Now.AddMilliseconds(Helper.Add24HrsInterval).ToString(Helper.AppConstants.DateTimeFormat)); var ObjBackupConfig = ProcessHandler.GetBackConfig(); BackupHandler.BackupDatabase(ObjBackupConfig); } catch (Exception ex) { log.Error(ex); } }
protected async override void OnAppearing() { base.OnAppearing(); DataTable dt = new DataTable(); BackupHandler edf = new BackupHandler(); var temp = (measunit)BindingContext; using (var stream = await FileSystem.OpenAppPackageFileAsync("MEASUNIT.EDF")) { using (var reader = new StreamReader(stream)) { dt = edf.readEDF(reader); reader.Close(); } stream.Close(); } }
void TestBackupWorker_DoWork(object sender, DoWorkEventArgs e) { try { ImageVisibility(true); var ObjBackupConfig = GetBackupConfig(); ProcessingStatus("Taking Backup @ " + ObjBackupConfig.BackupLocation); BackupHandler.BackupDatabase(ObjBackupConfig); ImageVisibility(false); MessageBox.Show("Test Backup successfull.", "Success"); } catch (Exception) { ImageVisibility(false); // } }
/// <summary> /// Creates a backup of the database specified in the job details. /// </summary> /// <param name="context">The execution context.</param> public void Execute(IJobExecutionContext context) { Guid databaseId; if (Guid.TryParse(context.JobDetail.JobDataMap.GetString(CreateBackupJob.Properties.DatabaseId.ToString()), out databaseId)) { BackupHandler backupHandler = new BackupHandler(); try { backupHandler.CreateBackup(databaseId); } catch (Exception ex) { new LogHandler().LogMessage(LogHandler.MessageType.ERROR, "Job: " + context.JobDetail.Key + Environment.NewLine + ex.ToString()); } } }
/// <summary> /// Handles the Click event of the MakeManualBackupButton control: Creates a manual backup of the selected database. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> private void MakeManualBackupButton_Click(object sender, RoutedEventArgs e) { try { BackupHandler backupHandler = new BackupHandler(); if (backupHandler.CreateBackup(CurrentDbInfo.ID)) { FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage(string.Format("A backup of the database {0} has been created!", CurrentDbInfo.DatabaseName), "Success", MessageBoxButton.OK); } else { FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage(string.Format("The backup of database {0} failed. Please check the log for details", CurrentDbInfo.DatabaseName), "Error", MessageBoxButton.OK); } } catch (Exception ex) { FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage(ex.ToString(), "Error", MessageBoxButton.OK); } }
private bool CreateBackupSchedule(BackupSchedule backupSchedule) { if (CoreBaseSettings.Standalone) { TenantExtra.DemandControlPanelPermission(); } var storageType = backupSchedule.StorageType == null ? BackupStorageType.Documents : (BackupStorageType)Int32.Parse(backupSchedule.StorageType); var storageParams = backupSchedule.StorageParams == null ? new Dictionary <string, string>() : backupSchedule.StorageParams.ToDictionary(r => r.Key.ToString(), r => r.Value.ToString()); var backupStored = backupSchedule.BackupsStored == null ? 0 : Int32.Parse(backupSchedule.BackupsStored); var cron = new CronParams() { Period = backupSchedule.CronParams.Period == null ? BackupPeriod.EveryDay : (BackupPeriod)Int32.Parse(backupSchedule.CronParams.Period), Hour = backupSchedule.CronParams.Hour == null ? 0 : Int32.Parse(backupSchedule.CronParams.Hour), Day = backupSchedule.CronParams.Day == null ? 0 : Int32.Parse(backupSchedule.CronParams.Day), }; BackupHandler.CreateSchedule(storageType, storageParams, backupStored, cron, backupSchedule.BackupMail); return(true); }
/// <summary> /// Deletes a user /// </summary> /// <param name="user"></param> public void DeleteUser(User user) { Users.Remove(user); BackupHandler.DeleteBackup(user); }
public async void LoadDataAsync() { HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://192.168.4.1/Services?Backup"); HttpWebResponse response = (HttpWebResponse)request.GetResponse(); Stream resStream = response.GetResponseStream(); StreamReader reader = new StreamReader(resStream); string text = reader.ReadToEnd(); loading.IsEnabled = true; loading.IsVisible = true; loading.IsRunning = true; loadingLBL.IsVisible = true; BackupHandler handler = new BackupHandler(); string path = Environment.GetFolderPath(Environment.SpecialFolder.Personal); string filename = Path.Combine(path, "KASA.txt"); string content = ""; using (var streamReader = new StreamReader(filename)) { content = streamReader.ReadToEnd(); } /*string text = ""; * using (var stream = await FileSystem.OpenAppPackageFileAsync("backup.tsv")) * { * using (var reader = new StreamReader(stream)) * { * UTF8Encoding uTF8 = new UTF8Encoding(); * byte[] output = uTF8.GetBytes(reader.ReadToEnd()); * string tempString = Encoding.ASCII.GetString(output, 0, output.Length); * text = tempString; * * reader.Close(); * } * stream.Close(); * }*/ List <string> tables = handler.readToListofTables(text); List <DataTable> dataTables = new List <DataTable>(); foreach (string t in tables) { dataTables.Add(handler.stringToDT(t)); } var kasa = await App.Database.getKasaPLU(content); if (kasa == null) { foreach (DataTable d in dataTables) { if (d.TableName.Equals("PLU")) { List <plu> plus = await App.Database.getPLU(); int dlzka = d.Rows.Count; plus.Clear(); string[] columnNames = d.Columns.Cast <DataColumn>() .Select(x => x.ColumnName) .ToArray(); for (int i = 0; i < dlzka; i++) { plus.Add(new plu { PLU = Convert.ToInt32(d.Rows[i][0]), PLU_PRICE = d.Rows[i][1].ToString(), PLU_NAME = d.Rows[i][2].ToString(), PLU_BARCODE = d.Rows[i][3].ToString(), PLU_TAXRATE = d.Rows[i][4].ToString(), PLU_SPEC_REG = d.Rows[i][5].ToString(), PLU_DPT = d.Rows[i][6].ToString(), PLU_UNIT = d.Rows[i][7].ToString(), PLU_LINK = d.Rows[i][8].ToString(), PLU_OTHERPRICE = d.Rows[i][9].ToString(), PLU_DESCRIPTOR = d.Rows[i][10].ToString(), PLU_CONTAINER = d.Rows[i][11].ToString(), KASA = content, }); } foreach (plu p in plus) { await App.Database.savePLU(p); } } if (d.TableName.Equals("DPT")) { List <dpt> dpts = await App.Database.getDPT(); int dlzka = d.Rows.Count; dpts.Clear(); for (int i = 0; i < dlzka; i++) { dpts.Add(new dpt { DPT = Convert.ToInt32(d.Rows[i][0]), DPT_NAME = d.Rows[i][1].ToString(), KASA = content }); } foreach (dpt p in dpts) { await App.Database.saveDPT(p); } } if (d.TableName.Equals("OPERATOR")) { List <@operator> operators = await App.Database.getOPERATOR(); int dlzka = d.Rows.Count; operators.Clear(); for (int i = 0; i < dlzka; i++) { operators.Add(new @operator { OPERATOR = Convert.ToInt32(d.Rows[i][0]), OPERATOR_NAME = d.Rows[i][1].ToString(), OPERATOR_PSWD = d.Rows[i][2].ToString(), OPERATOR_XMODE = d.Rows[i][3].ToString(), OPERATOR_ZMODE = d.Rows[i][4].ToString(), OPERATOR_PMODE = d.Rows[i][5].ToString(), OPERATOR_TMODE = d.Rows[i][6].ToString(), OPERATOR_REFUND = d.Rows[i][7].ToString(), OPERATOR_VOID = d.Rows[i][8].ToString(), OPERATOR_SURDISC = d.Rows[i][9].ToString(), KASA = content }); } foreach (@operator p in operators) { await App.Database.saveOPERATOR(p); } } if (d.TableName.Equals("MEASUREUNIT")) { List <measunit> measunits = await App.Database.getMEASUNIT(); int dlzka = d.Rows.Count; measunits.Clear(); for (int i = 0; i < dlzka; i++) { measunits.Add(new measunit { MEASUREUNIT = Convert.ToInt32(d.Rows[i][0]), MEASUREUNIT_NAME = d.Rows[i][1].ToString(), KASA = content }); } foreach (measunit p in measunits) { await App.Database.saveMEASUNIT(p); } } if (d.TableName.Equals("SURDISC")) { List <surdisc> surdiscs = await App.Database.getSURDISC(); int dlzka = d.Rows.Count; surdiscs.Clear(); for (int i = 0; i < dlzka; i++) { surdiscs.Add(new surdisc { SURDISC = Convert.ToInt32(d.Rows[i][0]), PERCDISCRATE = d.Rows[i][1].ToString(), PERCDISCLIMIT = d.Rows[i][2].ToString(), KASA = content }); } foreach (surdisc p in surdiscs) { await App.Database.saveSURDISC(p); } } if (d.TableName.Equals("TEXTLOGO")) { List <textlogo> textlogos = await App.Database.getTEXTLOGO(); int dlzka = d.Rows.Count; textlogos.Clear(); for (int i = 0; i < dlzka; i++) { textlogos.Add(new textlogo { TEXTLOGO = Convert.ToInt32(d.Rows[i][0]), LOGOLINE1 = d.Rows[i][1].ToString(), LOGOLINE2 = d.Rows[i][2].ToString(), LOGOLINE3 = d.Rows[i][3].ToString(), LOGOLINE4 = d.Rows[i][4].ToString(), LOGOLINE5 = d.Rows[i][5].ToString(), LOGOLINE6 = d.Rows[i][6].ToString(), LOGOLINE7 = d.Rows[i][7].ToString(), LOGOLINE8 = d.Rows[i][8].ToString(), LOGOLINE9 = d.Rows[i][9].ToString(), KASA = content }); } foreach (textlogo p in textlogos) { await App.Database.saveTEXTLOGO(p); } } if (d.TableName.Equals("FUNCTEXT")) { List <functext> functexts = await App.Database.getFUNCTEXT(); int dlzka = d.Rows.Count; functexts.Clear(); for (int i = 0; i < dlzka; i++) { functexts.Add(new functext { FUNCTEXT = Convert.ToInt32(d.Rows[i][0]), FUNCTEXT_REFERENCE_NUMBER_TEXT = d.Rows[i][1].ToString(), KASA = content }); } foreach (functext p in functexts) { await App.Database.saveFUNCTEXT(p); } } if (d.TableName.Equals("ECRLOC")) { List <ecrloc> ecrlocs = await App.Database.getECRLOC(); int dlzka = d.Rows.Count; ecrlocs.Clear(); for (int i = 0; i < dlzka; i++) { ecrlocs.Add(new ecrloc { ECRLOC = Convert.ToInt32(d.Rows[i][0]), ECRLOC_LOCTYPE = d.Rows[i][1].ToString(), ECRLOC_LOCDESC = d.Rows[i][2].ToString(), ECRLOC_MUNICIPALITY = d.Rows[i][3].ToString(), ECRLOC_STREETNAME = d.Rows[i][4].ToString(), ECRLOC_BUILDINGNUMBER = d.Rows[i][5].ToString(), ECRLOC_PROPERTYREGNUMBER = d.Rows[i][6].ToString(), ECRLOC_POSTALCODE = d.Rows[i][7].ToString(), KASA = content }); } foreach (ecrloc p in ecrlocs) { await App.Database.saveECRLOC(p); } } if (d.TableName.Equals("TRAILLOG")) { List <traillog> traillogs = await App.Database.getTRAILLOG(); int dlzka = d.Rows.Count; traillogs.Clear(); for (int i = 0; i < dlzka; i++) { traillogs.Add(new traillog { TRAILERTEXTLOGO = Convert.ToInt32(d.Rows[i][0]), LOGOLINE1 = d.Rows[i][1].ToString(), LOGOLINE2 = d.Rows[i][2].ToString(), LOGOLINE3 = d.Rows[i][3].ToString(), LOGOLINE4 = d.Rows[i][4].ToString(), LOGOLINE5 = d.Rows[i][5].ToString(), LOGOLINE6 = d.Rows[i][6].ToString(), LOGOLINE7 = d.Rows[i][7].ToString(), LOGOLINE8 = d.Rows[i][8].ToString(), LOGOLINE9 = d.Rows[i][9].ToString(), KASA = content }); } foreach (traillog p in traillogs) { await App.Database.saveTRAILLOG(p); } } if (d.TableName.Equals("ADVERTXT")) { List <advertxt> advertxts = await App.Database.getADVERTXT(); int dlzka = d.Rows.Count; advertxts.Clear(); for (int i = 0; i < dlzka; i++) { advertxts.Add(new advertxt { ADVERTEXT = Convert.ToInt32(d.Rows[i][0]), ADVERTISEMENT_TEXT = d.Rows[i][1].ToString(), ADVERTISEMENT_TYPE = d.Rows[i][2].ToString(), ADVERTISEMENT_LOOKUP = d.Rows[i][3].ToString(), KASA = content }); } foreach (advertxt p in advertxts) { await App.Database.saveADVERTXT(p); } } } loading.IsEnabled = false; loading.IsVisible = false; loading.IsRunning = false; loadingLBL.IsVisible = false; await Navigation.PushAsync(new Tabbed()); } }
public void BackupModelLocallyUsingRevit(Document doc) { var handler = new BackupHandler(); handler.BackupModelLocallyUsingRevit(doc); }