private void btnrestore_Click(object sender, RoutedEventArgs e)
{
DataBackup dbca = new DataBackup();
if (!String.IsNullOrEmpty(txtRestore.Text) && !String.IsNullOrWhiteSpace(txtRestore.Text))
{
string path = txtRestore.Text.ToString().Replace("\\", "\\\\");
if (dbca.restoreDatabase(path))
{
txtRestore.Text = "";
MessageBox.Show("Restored successfully ", "Successful", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
MessageBox.Show("Faild to Restore", "Faild", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
MessageBox.Show("Please browse a backup file to restore database", "Brows file", MessageBoxButton.OK, MessageBoxImage.Error);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
DataBackup dbck = new DataBackup();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "AdoraSystemBackup" + DateTime.Now.ToString().Replace(':', '_').Replace(' ', '_').Replace('/', '_'); // Default file name
dlg.DefaultExt = ".bak"; // Default file extension
dlg.Filter = "SQL server backup (.bak)|*.bak"; // Filter files by extension
// Show save file dialog boxS
Nullable<bool> result = dlg.ShowDialog();
if (result == true)
{
txtRestore.Text = dlg.FileName;
}
}
private void btnBackUp_Click(object sender, RoutedEventArgs e)
{
DataBackup dbck = new DataBackup();
if (!String.IsNullOrEmpty(txtBackupLoc.Text) && !String.IsNullOrWhiteSpace(txtBackupLoc.Text))
{
string path = txtBackupLoc.Text.ToString().Replace("\\", "\\\\");
if (dbck.backup(path))
{
txtBackupLoc.Text = "";
MessageBox.Show("Backup created successfully ", "Successfucl", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
MessageBox.Show("Faild to create backup", "Faild", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
MessageBox.Show("Please browse a location to save the database", "Brows Location", MessageBoxButton.OK, MessageBoxImage.Error);
}
