public void WriteSetting(BackupSetting key, string value)
{
using (var fs = GetSettingsFileStream())
{
WriteSettingsFileStreamAsync(SettingsFileTools.WriteSetting(fs, key, value));
}
}
public static byte[] ClearSetting(Stream settingsfile, BackupSetting key)
{
Dictionary <BackupSetting, string> settings;
try
{
settings = ReadSettings(settingsfile);
}
catch
{
settings = new Dictionary <BackupSetting, string>();
}
if (settings != null)
{
if (settings.ContainsKey(key))
{
settings.Remove(key);
return(WriteSettings(settings));
}
MemoryStream ms = new MemoryStream();
settingsfile.CopyTo(ms);
return(ms.ToArray());
}
else
{
throw new Exception();
}
}
public void ClearSetting(BackupSetting key)
{
using (var fs = GetSettingsFileStream())
{
WriteSettingsFileStreamAsync(SettingsFileTools.ClearSetting(fs, key));
}
}
public string ReadSetting(BackupSetting key)
{
using (var fs = GetSettingsFileStream())
{
return(SettingsFileTools.ReadSetting(fs, key));
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
string saveFolder = this.txtSaveFolder.Text.Trim();
bool zipFile = this.chkZipFile.Checked;
if (this.Setting == null)
{
this.Setting = new BackupSetting()
{
DatabaseType = this.DatabaseType.ToString(), SaveFolder = saveFolder, ZipFile = zipFile
};
}
if (this.chkSetAsDefault.Checked)
{
var settings = BackupSettingManager.GetSettings();
var setting = settings.FirstOrDefault(item => item.DatabaseType == this.DatabaseType.ToString());
if (setting == null)
{
settings.Add(this.Setting);
}
else
{
setting.SaveFolder = saveFolder;
setting.ZipFile = zipFile;
}
BackupSettingManager.SaveConfig(settings);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
public bool Backup(BackupSetting setting, ConnectionInfo connectionInfo)
{
try
{
DbBackup backup = DbBackup.GetInstance(ManagerUtil.GetDatabaseType(setting.DatabaseType));
backup.Setting = setting;
backup.ConnectionInfo = connectionInfo;
this.FeedbackInfo("Begin to backup...");
string saveFilePath = backup.Backup();
if (File.Exists(saveFilePath))
{
this.FeedbackInfo($"Database has been backuped to {saveFilePath}.");
}
else
{
this.FeedbackInfo($"Database has been backuped.");
}
return(true);
}
catch (Exception ex)
{
this.FeedbackError(ExceptionHelper.GetExceptionDetails(ex));
}
return(false);
}
public void ClearSetting(BackupSetting key)
{
using (var fs = GetSettingsFileStream())
{
SettingsFileTools.ClearSetting(fs, key);
}
}
public void WriteSetting(BackupSetting key, string value)
{
try
{
using Stream fs = GetSettingsFileStream();
WriteSettingsFileStream(SettingsFileTools.WriteSetting(fs, key, value));
}
catch (Exception)
{
WriteSettingsFileStream(SettingsFileTools.WriteSetting(null, key, value));
}
}
public static string ReadSetting(Stream settingsfile, BackupSetting key)
{
var settings = ReadSettings(settingsfile);
if (settings != null)
{
if (settings.ContainsKey(key))
{
return(settings[key]);
}
}
throw new KeyNotFoundException();
}
public static byte[] WriteSetting(Stream settingsfile, BackupSetting key, string value)
{
Dictionary <BackupSetting, string> settings;
try
{
settings = ReadSettings(settingsfile);
}
catch
{
settings = new Dictionary <BackupSetting, string>();
}
settings[key] = value;
return(WriteSettings(settings));
}
private void InitControls()
{
this.Setting = BackupSettingManager.GetSettings().FirstOrDefault(item => item.DatabaseType == this.DatabaseType.ToString());
if (this.Setting != null)
{
this.txtSaveFolder.Text = this.Setting.SaveFolder;
this.chkZipFile.Checked = this.Setting.ZipFile;
}
if (this.DatabaseType == DatabaseType.SqlServer)
{
this.chkZipFile.Enabled = false;
}
}
private List <BackupSetting> GetSettings()
{
List <BackupSetting> settings = new List <BackupSetting>();
foreach (DataGridViewRow row in this.dgvSettings.Rows)
{
BackupSetting setting = new BackupSetting();
setting.DatabaseType = DataGridViewHelper.GetCellStringValue(row, this.colDatabaseType.Name);
setting.ClientToolFilePath = DataGridViewHelper.GetCellStringValue(row, this.colClientToolFilePath.Name);
setting.SaveFolder = DataGridViewHelper.GetCellStringValue(row, this.colSaveFolder.Name);
setting.ZipFile = DataGridViewHelper.GetCellBoolValue(row, this.colZipBackupFile.Name);
settings.Add(setting);
}
return(settings);
}
private void LoadSettings()
{
List <BackupSetting> settings = BackupSettingManager.GetSettings();
var dbTypes = Enum.GetNames(typeof(DatabaseType));
foreach (string dbType in dbTypes)
{
if (dbType != DatabaseType.Unknown.ToString())
{
BackupSetting setting = settings.FirstOrDefault(item => item.DatabaseType == dbType);
if (setting == null)
{
settings.Add(new BackupSetting()
{
DatabaseType = dbType
});
}
}
}
this.dgvSettings.DataSource = settings;
}
public SqlServerBackup(BackupSetting setting, ConnectionInfo connectionInfo) : base(setting, connectionInfo)
{
}
public DbBackup(BackupSetting setting, ConnectionInfo connectionInfo)
{
this.Setting = setting;
this.ConnectionInfo = connectionInfo;
}
public OracleBackup(BackupSetting setting, ConnectionInfo connectionInfo) : base(setting, connectionInfo)
{
}
public MySqlBackup(BackupSetting setting, ConnectionInfo connectionInfo) : base(setting, connectionInfo)
{
}
