private void btnBackupDatabase_Click(object sender, RoutedEventArgs e) { DBBackupManager manager = new DBBackupManager(); string dbBackupFolder = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location) + System.IO.Path.DirectorySeparatorChar.ToString() + Constants.DBBackup; string backupFileName = dbBackupFolder + System.IO.Path.DirectorySeparatorChar.ToString() + Constants.DatabaseName + "-" + DateTime.Now.ToString("yyyyMMdd") + Constants.BackupExtension; manager.SetupBackupFolder(dbBackupFolder); manager.BackupDatabase(backupFileName, Constants.DatabaseServerName, Constants.DatabaseName); string message = "Database backup done! Do you want to open backup folder?"; var result = MessageBox.Show(message, "Case Control System", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes || result == MessageBoxResult.OK) { Process.Start(dbBackupFolder); } }
void scheduler_Elapsed(object sender, ElapsedEventArgs e) { if (DateTime.Now.TimeOfDay.Hours == scheduledBackupTime.Hours && DateTime.Now.TimeOfDay.Minutes == scheduledBackupTime.Minutes && DateTime.Now.TimeOfDay.Seconds== scheduledBackupTime.Seconds ) { string backupFolderName = System.Configuration.ConfigurationManager.AppSettings["BackupFolder"]; string backupDate = DateTime.Now.ToString("yyyyMMdd"); string databaseName = System.Configuration.ConfigurationManager.AppSettings["DatabaseName"]; string dbServerName = System.Configuration.ConfigurationManager.AppSettings["DbServerName"]; try { DBBackupManager dbManager = new DBBackupManager(); dbManager.TakeDailyBackupDatabase(backupFolderName, backupDate, databaseName, dbServerName); } catch (Exception ex) { File.AppendAllText(@"c:\temp\error.txt", ex.Message); } } }
void scheduler_Elapsed(object sender, ElapsedEventArgs e) { if (DateTime.Now.TimeOfDay.Hours == scheduledBackupTime.Hours && DateTime.Now.TimeOfDay.Minutes == scheduledBackupTime.Minutes && DateTime.Now.TimeOfDay.Seconds == scheduledBackupTime.Seconds) { string backupFolderName = System.Configuration.ConfigurationManager.AppSettings["BackupFolder"]; string backupDate = DateTime.Now.ToString("yyyyMMdd"); string databaseName = System.Configuration.ConfigurationManager.AppSettings["DatabaseName"]; string dbServerName = System.Configuration.ConfigurationManager.AppSettings["DbServerName"]; try { DBBackupManager dbManager = new DBBackupManager(); dbManager.TakeDailyBackupDatabase(backupFolderName, backupDate, databaseName, dbServerName); } catch (Exception ex) { File.AppendAllText(@"c:\temp\error.txt", ex.Message); } } }