protected void btnBackup_Click(object sender, EventArgs e)
{
DateTime fileDateTime = AppUtils.ServerDateTime();
string strTempPath = HROne.Common.Folder.GetOrCreateSessionTempFolder(Session.SessionID).FullName;
string databaseFile = System.IO.Path.Combine(strTempPath, "HROne_" + fileDateTime.ToString("yyyyMMddHHmmss") + ".bak");
string errorMessage = string.Empty;
AppUtils.BackUpDatabase(dbConn, databaseFile, out errorMessage);
if (System.IO.File.Exists(databaseFile))
{
System.IO.FileInfo sourceFileInfo = new System.IO.FileInfo(databaseFile);
string destinationZipFile = System.IO.Path.Combine(strTempPath, "HROne_" + fileDateTime.ToString("yyyyMMddHHmmss") + ".zip");
zip.Compress(strTempPath, sourceFileInfo.Name, destinationZipFile, ZipPassword.Text);
sourceFileInfo.Delete();
if (System.IO.File.Exists(destinationZipFile))
{
// WebUtils.RegisterDownloadFileJavaScript(this, destinationZipFile, "HROne_" + fileDateTime.ToString("yyyyMMddHHmmss") + ".zip", true, 0);
WebUtils.TransmitFile(this.Response, destinationZipFile, "HROne_" + fileDateTime.ToString("yyyyMMddHHmmss") + ".zip", true);
}
}
else
{
PageErrors errors = PageErrors.getErrors(HROne.Lib.Entities.ESystemParameter.db, Page.Master);
if (errors != null)
{
errors.addError(errorMessage);
}
}
}
private static bool AutoBackUpDatabase(DatabaseConnection dbConn, string VersionNo)
{
string filePath = string.Empty;
if (dbConn.dbType == DatabaseConnection.DatabaseType.MSSQL)
{
System.Data.SqlClient.SqlConnection conn = (System.Data.SqlClient.SqlConnection)dbConn.Connection;
filePath = conn.Database + "_" + VersionNo + "_" + AppUtils.ServerDateTime().ToString("yyyyMMddHHmmss") + ".bak";
}
return(AppUtils.BackUpDatabase(dbConn, filePath, out strLastErrorMessage));
//if (perspectivemind.common.DBUtil.type is perspectivemind.common.SQLType)
//{
// System.Data.SqlClient.SqlConnection conn = (System.Data.SqlClient.SqlConnection)perspectivemind.common.DBUtil.getConnection();
// string backupSQL = "BACKUP DATABASE " + conn.Database + "\r\n" +
// "TO DISK='" + conn.Database + "_" + VersionNo + "_" + AppUtils.ServerDateTime().ToString("yyyyMMddHHmmss") + ".bak'";
// if (AppUtils.DBPatch(backupSQL, out strLastErrorMessage))
// {
// return true;
// }
//}
//return false;
}
