private bool BackupObjectNewStatus()
{
bool Result = false;
string ProcComment = string.Empty;
ProcComment = "--SVC: " + DateTime.Now.ToString() + " Backup copy of current checked out version - user undoing check out without restoring previous version - " + UserName;
CurrentObjectText = AddProcComment(CurrentObjectText, ProcComment);
try
{
string BackupComment;
BackupComment = UserName + " - Backup copy of current checked out version before undoing check out";
using (DataStuff sn = new DataStuff())
{
Result = sn.BackupObject(AliasName, "Check-out Undo", UserName, ObjectName, DatabaseName, CurrentObjectText, BackupComment, tPartOfProject.Text, "", "", "N", "N");
}
return(Result);
}
catch
{
return(false);
}
}
private bool BackupObject()
{
bool Result = false;
string ProcComment = string.Empty;
//string ProcComment = "--SVC: " + DateTime.Now.ToString() + " New Base From " + cbCheckOutFrom.Text + " - " + UserName + " - " + NewStatus + " - " + tComment.Text + Environment.NewLine;
ProcComment = "--SVC: " + DateTime.Now.ToString() + " Backup copy of current checked out version before undoing check out " + " - " + UserName;
CurrentObjectText = AddProcComment(CurrentObjectText, ProcComment);
try
{
string BackupComment;
BackupComment = UserName + " - Backup copy of current checked out version before undoing check out";
using (DataStuff sn = new DataStuff())
{
Result = sn.BackupObject(AliasName, "Check-out Undo", UserName, ObjectName, DatabaseName, CurrentObjectText, BackupComment, tPartOfProject.Text, "", "", "N", "N");
}
return(Result);
}
catch
{
return(false);
}
}
private bool BackupObject()
{
bool Result = false;
try
{
string BackupComment;
BackupComment = UserName + " - Backup Copy - Before " + NewStatus + " - " + tComment.Text;
using (DataStuff sn = new DataStuff())
{
Result = sn.BackupObject(AliasName, NewStatus, UserName, ObjectName, DatabaseName, CurrentObjectText, BackupComment, tPartOfProject.Text, "", "", "N", "Y");
}
return(Result);
}
catch
{
return(false);
}
}
private bool BackupReleaseToServerObject(string ReleaseToServer, string DatabaseName, string ObjectName, string ProjectName)
{
string ObjectText = string.Empty;
string ObjectDescription = string.Empty;
string ConnectionStr = string.Empty;
bool Result = false;
ConnectionStr = GetServerConnectionString(ReleaseToServer);
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetDatabaseObjectText(ConnectionStr, DatabaseName, ObjectName);
if (dt.Rows.Count > 1)
{
foreach (DataRow row in dt.Rows)
{
ObjectText = row["FullDefinition"].ToString();
ObjectDescription = row["ROUTINE_NAME"].ToString() + ": " + row["ROUTINE_TYPE"].ToString();
}
}
}
}
catch
{
DialogResult result = MessageBox.Show("An error occurred getting the object text for server " + ReleaseToServer + ". Release anyway?", "Backup Object", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (result == DialogResult.No)
{
return(false);
}
else
{
IsNewObject = true;
return(true);
}
}
if (ObjectText.Trim() == "")
{
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetObjectHelpText(ConnectionStr, DatabaseName, ObjectName);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
ObjectText = ObjectText + row[0].ToString();
}
}
}
}
catch
{
DialogResult result = MessageBox.Show("An error occurred getting the object text for server " + ReleaseToServer + ". Release anyway?", "Backup Object", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (result == DialogResult.No)
{
return(false);
}
else
{
IsNewObject = true;
return(true);
}
}
}
try
{
if (ObjectText.Trim() == "")
{
DialogResult result = MessageBox.Show("An error occurred getting the object text for server " + ReleaseToServer + ". Release anyway?", "Backup Object", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (result == DialogResult.No)
{
return(false);
}
else
{
IsNewObject = true;
return(true);
}
}
string BackupComment;
BackupComment = UserName + " - " + "Backup before restore from project backup";
using (DataStuff sn = new DataStuff())
{
Result = sn.BackupObject(ReleaseToServer, "Backup", UserName, ObjectName, DatabaseName, ObjectText, BackupComment, ProjectName, "", "", "N", "N");
if (!Result)
{
MessageBox.Show("There was an error creating a backup for this object. Please ensure that your servers have been set up correctly.", "Change Status", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
lStatus.Text = "Creating backup of " + ReleaseToServer + " - " + DatabaseName + ": " + ObjectName + "...";
}
}
catch
{
MessageBox.Show("An error occurred while creating the backup record.", "Backup Object", MessageBoxButtons.OK, MessageBoxIcon.Error);
lStatus.Text = "Error creating backup of " + ReleaseToServer + " - " + DatabaseName + ": " + ObjectName + ".";
return(false);
}
return(true);
}
