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