//Backup
private void simpleButton4_Click(object sender, EventArgs e)
{
FolderBrowserDialog fbd = new FolderBrowserDialog();
string LastBackupFolder = CurrDp.GetVariable <string>("System",
"LastBackupFolder", string.Empty);
fbd.SelectedPath = LastBackupFolder;
fbd.Description = "Pilih Folder yang digunakan untuk membackup Database :";
if (fbd.ShowDialog() != DialogResult.OK)
{
return;
}
CurrDp.SetVariable("System", "LastBackupFolder", fbd.SelectedPath);
Type EngineType = BaseFramework.DpEngine.DictEngine[comboBoxEdit1.Text];
if (EngineType.Equals(typeof(SqlServerPersistance)))
{
string FileName = string.Concat(fbd.SelectedPath, "\\",
((SqlServerPersistance)CurrDp).DatabaseName,
"_", DateTime.Today.ToString("yyyy_MM_dd"), ".bak");
if (File.Exists(FileName))
{
XtraMessageBox.Show(string.Concat(
"File Tujuan Backup '", FileName,
"' sudah ada. Hapus File tersebut untuk melanjutkan !"),
"Error Backup Database",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
try
{
using (new FormWaitCursor())
{
CurrDp.ExecuteNonQuery(string.Concat(
"BACKUP DATABASE [",
((SqlServerPersistance)CurrDp).DatabaseName,
"] TO DISK = '", FileName, "'"));
}
XtraMessageBox.Show(string.Concat(
"Backup Database ",
((SqlServerPersistance)CurrDp).DatabaseName,
" telah sukses dilakukan di File '", FileName,
"' !"), "Konfirmasi Backup Database",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error Backup Database",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
XtraMessageBox.Show("Backup untuk database " + comboBoxEdit1.Text + "belum didukung !",
"Konfirmasi Backup Database", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}