protected void Page_Command(Object sender, CommandEventArgs e)
{
if (e.CommandName == "Next")
{
NAME.Text = NAME.Text.Trim();
// 12/31/2007 Paul. The NAME is not required. If not provided, it will be generated.
//NAME_REQUIRED.Enabled = true;
//NAME_REQUIRED.Validate();
if (Page.IsValid)
{
try
{
// 01/28/2008 Paul. Cannot perform a backup or restore operation within a transaction. BACKUP DATABASE is terminating abnormally.
DbProviderFactory dbf = DbProviderFactories.GetFactory();
using (IDbConnection con = dbf.CreateConnection())
{
con.Open();
string sFILENAME = String.Empty;
string sTYPE = "FULL";
//SqlProcs.spSqlBackupDatabase(ref sNAME, "FULL");
using (IDbCommand cmd = con.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spSqlBackupDatabase";
IDbDataParameter parFILENAME = Sql.AddParameter(cmd, "@FILENAME", sFILENAME, 255);
IDbDataParameter parTYPE = Sql.AddParameter(cmd, "@TYPE", sTYPE, 20);
parFILENAME.Direction = ParameterDirection.InputOutput;
cmd.ExecuteNonQuery();
sFILENAME = Sql.ToString(parFILENAME.Value);
}
lblError.Text = L10n.Term("Administration.LBL_DONE") + " " + sFILENAME;
SplendidError.SystemMessage(Application, "Information", new StackTrace(true).GetFrame(0), "Database backup complete " + sFILENAME);
}
}
catch (Exception ex)
{
SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
lblError.Text = ex.Message;
return;
}
}
}
else if (e.CommandName == "Back")
{
}
}
