private void DBObject_Load(object sender, EventArgs e)
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.SingleUser(Environment.UserName, "SSMSDBObject");
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
UserName = row["UserName"].ToString();
UserID = Convert.ToInt32(row["UserID"].ToString());
}
}
}
tsbViewObject.Enabled = false;
//tsbCheckInOut.Enabled = false;
tsbHistory.Enabled = false;
//tsbCompare.Enabled = false;
tDatabaseName.Text = DatabaseName;
tObjectName.Text = ObjectName;
LoadSelectedObject();
}
private void LoadServerGroups()
{
try
{
cbServerGroup.Items.Clear();
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetServerGroups();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbServerGroup.Items.Add(row["ServerGroupDesc"].ToString());
}
}
}
}
catch
{
throw;
}
}
private void ViewObjectStatus_Load(object sender, EventArgs e)
{
try
{
gbCheckoutStatus.Text = "Status for " + ObjectName + " on " + AliasName;
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetObjectStatusDetail(AliasName, ObjectName);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
tCurrentStatus.Text = row["ObjectStatusDesc"].ToString();
tLastStatusDate.Text = row["HistoryDate"].ToString();
tResponsiblePerson.Text = row["UserName"].ToString();
tComment.Text = row["Comment"].ToString();
tPartOfProject.Text = row["ProjectName"].ToString();
}
}
}
}
catch
{
throw;
}
}
private bool GetServerDetail()
{
try
{
string ServerName = string.Empty;
string UserName = string.Empty;
byte[] Password = null;
string IntegratedSecurity = string.Empty;
//ConnectionString = "";
using (DataStuff sn = new DataStuff())
{
sn.ConnectionString = StoreConnectionString;
DataTable dt = sn.GetServerDetail(cbEnvironment.Text, UserID);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
ServerName = row["ServerName"].ToString();
UserName = row["UserName"].ToString();
Password = (byte[])row["Password"];
IntegratedSecurity = row["IntegratedSecurity"].ToString();
}
}
}
if (IntegratedSecurity == "Y")
{
ConnectionString = "Data Source=" + ServerName + ";Integrated Security=True";
}
else
{
string DecryptedPassword = string.Empty;
using (DataStuff ds = new DataStuff())
{
DecryptedPassword = ds.Ontsyfer(Password);
}
ConnectionString = "Data Source=" + ServerName + ";User ID=" + UserName + ";Password="******"")
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
private void GetServerAliasDetail()
{
try
{
tServerName.Text = "";
tServerRole.Text = "";
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetServerAliasDetail(cbServerName.Text);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
tServerName.Text = row["ServerName"].ToString();
tServerRole.Text = row["ServerRoleDesc"].ToString();
}
}
}
}
catch
{
}
}
private void ObjectUndoCheckOut_Load(object sender, EventArgs e)
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.SingleUser(Environment.UserName, "DBObject");
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
UserName = row["UserName"].ToString();
UserID = Convert.ToInt32(row["UserID"].ToString());
}
}
}
ConnectionString = GetServerConnectionString(AliasName);
LoadObjectStatusDetail();
GetPreviousVersion();
if (CurrentObjectText.Trim() == "")
{
CurrentObjectText = GetObjectText(ConnectionString, DatabaseName, ObjectName);
CurrentObjectText = gs.ChangeCreateToAlter(CurrentObjectText);
}
}
private void LoadObjectStatusDetail()
{
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetObjectStatusDetail(AliasName, ObjectName);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
tObjectStatus.Text = row["ObjectStatusDesc"].ToString();
tLastStatusDate.Text = row["HistoryDate"].ToString();
tResponsiblePerson.Text = row["UserName"].ToString();
tComment.Text = row["Comment"].ToString();
tPartOfProject.Text = row["ProjectName"].ToString();
}
}
else
{
tResponsiblePerson.Text = UserName;
}
}
OriginalStatus = tObjectStatus.Text;
}
catch
{
throw;
}
}
private void cStrictForceCheckOutDev_CheckedChanged(object sender, EventArgs e)
{
string SettingValue = string.Empty;
try
{
using (DataStuff sn = new DataStuff())
{
if (cStrictForceCheckOutDev.Checked == true)
{
SettingValue = "true";
}
else
{
SettingValue = "false";
}
sn.SaveSystemSetting("Key7", SettingValue);
}
}
catch
{
}
}
private void cForceApproverApproval_CheckedChanged(object sender, EventArgs e)
{
string SettingValue = string.Empty;
try
{
using (DataStuff sn = new DataStuff())
{
if (cForceApproverApproval.Checked == true)
{
SettingValue = "true";
}
else
{
SettingValue = "false";
}
sn.SaveSystemSetting("Key9", SettingValue);
}
}
catch
{
}
}
private void LoadProjects()
{
try
{
cmdRestore.Enabled = false;
string IncludeInactive = string.Empty;
IncludeInactive = cActiveOnly.Checked ? "N" : "Y";
cbProject.Items.Clear();
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetProjectBackupSets(IncludeInactive);
if (dt.Rows.Count > 0)
{
cbProject.DataSource = dt;
cbProject.DisplayMember = "ProjectName";
cbProject.ValueMember = "ProjectSetID";
}
}
}
catch
{
throw;
}
}
private string LoadHelpText(string DBName, string ObjName)
{
string ObjectText = string.Empty;
string ConnString = GetServerConnectionString(cbServers.Text, UserID);
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetObjectHelpText(ConnString, DBName, ObjName);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
ObjectText = ObjectText + row[0].ToString();
}
}
return(ObjectText);
}
}
catch
{
return("");
}
}
private bool RestoreObject(string ReleaseToServer, string DatabaseName, string ObjectName, string ObjectText)
{
string RetVal = string.Empty;
using (DataStuff sn = new DataStuff())
{
string ConnectionStr = string.Empty;
ConnectionStr = GetServerConnectionString(ReleaseToServer);
ConnectionStr = ConnectionStr + ";Database=" + DatabaseName;
if (IsNewObject)
{
ObjectText = gs.ChangeAlterToCreate(ObjectText);
}
lStatus.Text = "Deploying object " + DatabaseName + " - " + ObjectName + " to " + ReleaseToServer + "...";
RetVal = sn.CreateObjectS(ConnectionStr, ObjectText);
if (RetVal != "")
{
MessageBox.Show("Failed - " + RetVal, "Modify Procedure", MessageBoxButtons.OK, MessageBoxIcon.Error);
lStatus.Text = "Error deploying object " + DatabaseName + " - " + ObjectName + " to " + ReleaseToServer + "...";
return(false);
}
}
return(true);
}
private string LoadObjectDetail(string ConnectionString, string DBName, string DBOwner, string ObjectName)
{
string DateModified = string.Empty;
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetObjectDetail(ConnectionString, DBName, DBOwner, ObjectName);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
DateModified = row["modify_date"].ToString();
}
}
else
{
DateModified = "";
}
}
return(DateModified);
}
catch
{
return("");
}
}
private void LoadDatabaseFilteredObjects()
{
try
{
tError.Text = "";
cbObjects.Items.Clear();
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetDatabaseObjectsFiltered(ConnectionString, cbDatabaseName.Text, FilterString, ObjectsSelected, false);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbObjects.Items.Add(row["Name"].ToString());
}
}
}
}
catch (Exception ex)
{
tError.Text = ex.Message;
}
}
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 void cUpdateChangeLog_CheckedChanged(object sender, EventArgs e)
{
string SettingValue = string.Empty;
try
{
using (DataStuff sn = new DataStuff())
{
if (cUpdateChangeLog.Checked == true)
{
SettingValue = "true";
}
else
{
SettingValue = "false";
}
sn.SaveSystemSetting("Key11", SettingValue);
}
}
catch
{
}
}
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 void ObjectBackToDev_Load(object sender, EventArgs e)
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.SingleUser(Environment.UserName, "DBObject");
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
UserName = row["UserName"].ToString();
UserID = Convert.ToInt32(row["UserID"].ToString());
}
}
}
if (!IsDevServer())
{
MessageBox.Show("This server is not a development server - Changing the status is not allowed.", "Change Status", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
ConnectionString = GetServerConnectionString(AliasName);
LoadObjectStatusDetail();
}
if (CurrentObjectText.Trim() == "")
{
CurrentObjectText = GetObjectText(ConnectionString, DatabaseName, ObjectName);
CurrentObjectText = gs.ChangeCreateToAlter(CurrentObjectText);
}
}
private bool GetPreviousVersion()
{
try
{
using (DataStuff sn = new DataStuff())
{
tPreviousVersion.Text = sn.GetVersionAtCheckOut(AliasName, ObjectName, DatabaseName);
}
if (tPreviousVersion.Text.Trim() == "")
{
cRestorePrevious.Checked = false;
cRestorePrevious.Enabled = false;
return(false);
}
else
{
cRestorePrevious.Checked = true;
cRestorePrevious.Enabled = true;
return(true);
}
}
catch
{
cRestorePrevious.Checked = false;
cRestorePrevious.Enabled = false;
return(false);
}
}
private void GetServers(int UserID)
{
try
{
cbServerAlias.Items.Clear();
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetServers(UserID);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbServerAlias.Items.Add(row["ServerAliasDesc"].ToString());
}
}
}
}
catch
{
throw;
}
}
private void LoadEnvironments()
{
try
{
cbEnvironment.Items.Clear();
using (DataStuff sn = new DataStuff())
{
sn.ConnectionString = StoreConnectionString;
DataTable dt = sn.GetServerAliases();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbEnvironment.Items.Add(row["ServerAliasDesc"].ToString());
}
}
}
}
catch
{
throw;
}
}
private void GetRequestStatus()
{
cmdRequestApproval.Enabled = false;
tRequestBy.Text = "Not Requested";
tRequestDate.Text = "";
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.ProjectGetRequestStatus(ServerName, ProjectName);
if (dt.Rows.Count > 0)
{
tRequestBy.Text = dt.Rows[0]["UserName"].ToString();
tRequestDate.Text = dt.Rows[0]["RequestDate"].ToString();
}
else
{
cmdRequestApproval.Enabled = true;
}
}
}
catch
{
}
}
private void LoadDatabaseNames()
{
try
{
cbDatabaseName.Items.Clear();
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetSystemDatabases(ConnectionString);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbDatabaseName.Items.Add(row["Name"].ToString());
}
}
}
}
catch
{
throw;
}
}
private void GetRequesterEmail()
{
try
{
DataTable dtEmail;
using (DataStuff sn = new DataStuff())
{
dtEmail = sn.ProjectGetRequesterEmail(ServerName, ProjectName);
if (dtEmail != null)
{
if (dtEmail.Rows.Count > 0)
{
RequesterEmailAddress = dtEmail.Rows[0]["EmailAddress"].ToString();
RequesterName = dtEmail.Rows[0]["UserName"].ToString();
}
}
}
}
catch
{
}
}
private void tsbSave_Click(object sender, EventArgs e)
{
string IntegratedSecurity = "";
if (!DoValidation())
{
return;
}
try
{
if (cIntegratedSecurity.Checked)
{
IntegratedSecurity = "Y";
}
else
{
IntegratedSecurity = "N";
}
using (DataStuff sn = new DataStuff())
{
sn.SaveServer(cbServerName.Text, tUserName.Text, tPassword.Text, IntegratedSecurity, UserID);
MessageBox.Show("Server saved.", "Server Settings", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("There was an error saving the server settings - " + ex.Message, "Server Settings", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void GetApproverEmail()
{
try
{
DataTable dtEmail;
using (DataStuff sn = new DataStuff())
{
dtEmail = sn.ProjectGetApproverEmails();
if (dtEmail != null)
{
if (dtEmail.Rows.Count > 0)
{
foreach (DataRow row in dtEmail.Rows)
{
if (row["QTNumber"].ToString().ToUpper() == Environment.UserName.ToUpper())
{
ApproverName = row["UserName"].ToString();
ApproverEmailAddress = row["EmailAddress"].ToString();
break;
}
}
}
}
}
}
catch
{
}
}
private void LoadObjectHistory()
{
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetObjectHistory(DatabaseName, ObjectName);
if (dt.Rows.Count > 0)
{
dgvHistory.DataSource = dt;
}
else
{
MessageBox.Show("No history was found for object " + ObjectName + ".", "Object History", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
catch
{
throw;
}
}
private string LoadHelpText(string ConnectionString, string DatabaseName, string ObjectName)
{
string ObjectText = string.Empty;
try
{
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetObjectHelpText(ConnectionString, DatabaseName, ObjectName);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
ObjectText = ObjectText + row[0].ToString();
}
}
}
}
catch
{
return("");
}
return(ObjectText);
}
private void LoadProjects()
{
try
{
cbPartOfProject.Items.Clear();
using (DataStuff sn = new DataStuff())
{
DataTable dt = sn.GetProjects();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbPartOfProject.Items.Add(row["ProjectName"].ToString());
}
}
}
}
catch
{
throw;
}
}
private void SaveUser()
{
string NetworkUserName = string.Empty;
if (!IsValid())
{
return;
}
try
{
UserID = 0;
NetworkUserName = tNetworkName.Text;
using (DataStuff sn = new DataStuff())
{
if (sn.SaveNetworkSystemUser(UserID, NetworkUserName, tName.Text, tEmail.Text, "Y"))
{
if (sn.SaveUserRole(cbRole.Text, NetworkUserName))
{
MessageBox.Show("User successfully saved.", "User Maintenance", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
tNetworkName.Focus();
}
}
}
catch
{
MessageBox.Show("There was an error saving the user.", "User Maintenance", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
