public static async Task <bool> CreateBackUp(string dbName, string fileName, BackUpSettingBussines cls)
{
try
{
var path = Path.Combine(cls.BackUpAddress, fileName);
var command = @"BACKUP DATABASE " + dbName + " TO Disk='" + path + "'";
var dataConnection = new SqlConnection(Properties.Resources.ConnectionString);
if (dataConnection.State != ConnectionState.Open)
{
dataConnection.Open();
}
var cmd = new SqlCommand {
Connection = dataConnection, CommandText = command
};
cmd.ExecuteNonQuery();
cls.LastBackUpDate = DateConvertor.M2SH(DateTime.Now);
cls.LastBackUpTime = DateTime.Now.Hour + ":" + DateTime.Now.Minute;
await cls.SaveAsync();
RaiseEvent();
if (cls.IsSendInTelegram)
{
await SendBackUpToTelegram(path);
}
return(true);
}
catch (Exception e)
{
WebErrorLog.ErrorInstence.StartErrorLog(e);
return(false);
}
}
private async void btnFinish_Click(object sender, EventArgs e)
{
try
{
btnFinish.Enabled = false;
if (cls.Guid == Guid.Empty)
{
cls.Guid = Guid.NewGuid();
cls.DateSabt = DateConvertor.M2SH(DateTime.Now);
}
cls.BackUpAddress = txtAddress.Text;
cls.AutoBackUp = chbAuto.Checked;
cls.Status = true;
cls.IsSendInTelegram = chbIsSentToTelegram.Checked;
cls.AutoTime = txtAutoSecond.Text.ParseToInt() * 60;
cls.IsSendInEmail = chbIsSendToEmail.Checked;
cls.EmailAddress = txtEmailAddress.Text;
await cls.SaveAsync();
WebErrorLog.ErrorInstence.StartErrorLog("اطلاعات ذخیره شد", true);
SetData();
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
}
finally
{
btnFinish.Enabled = true;
}
}