Exemple #1
0
        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);
            }
        }
        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);
            }
        }