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); }