private void toolStripRestoreBackup_Click(object sender, EventArgs e)
{
string RestoreCommand = "";
string BackupFileName = "";
string Password = "";
OpenFileDialog DBBackupFile = new OpenFileDialog();
DBBackupFile.InitialDirectory = @"C:\";
DBBackupFile.Title = "Choose Backup File";
DBBackupFile.ShowReadOnly = true;
if (DBBackupFile.ShowDialog() == DialogResult.OK)
{
BackupFileName = DBBackupFile.FileName;
}
FrmChoosePassword ChoosePassword = new FrmChoosePassword();
ChoosePassword.Font = this.Font;
ChoosePassword.BackColor = Color.Teal;
ChoosePassword.StartPosition = FormStartPosition.CenterScreen;
var Res = ChoosePassword.ShowDialog();
if (Res == DialogResult.OK)
{
Password = ChoosePassword.ReturnValue;
}
RestoreCommand = "restore database ExMon from disk = '" + BackupFileName + "' with password = '******'";
try {
CommFunc.Execute_DB_Command(RestoreCommand);
}
catch (Exception Ex)
{
MessageBox.Show("ERROR: " + Ex, "error:", MessageBoxButtons.OK);
}
}
private void toolStripBackupData_Click(object sender, EventArgs e)
{
string BackupCommand = "";
string BackupFileName = "";
string Password = "";
SaveFileDialog DBBackupFile = new SaveFileDialog();
DBBackupFile.InitialDirectory = @"C:\";
DBBackupFile.Title = "Choose Backup File";
if (DBBackupFile.ShowDialog() == DialogResult.OK)
{
BackupFileName = DBBackupFile.FileName;
}
if (BackupFileName != "")
{
FrmChoosePassword ChoosePassword = new FrmChoosePassword();
ChoosePassword.Font = this.Font;
ChoosePassword.BackColor = Color.SteelBlue;
ChoosePassword.StartPosition = FormStartPosition.CenterScreen;
var Res = ChoosePassword.ShowDialog();
if (Res == DialogResult.OK)
{
Password = ChoosePassword.ReturnValue;
}
BackupCommand = "backup database ExMon to disk = '" + BackupFileName + "' with password = '******'";
CommFunc.Execute_DB_Command(BackupCommand);
}
}
