private void UpdateCPDWebConfig(string connectionString, string password) { string strWebConfig; // holds just the password string strConnecitonStringPassword = ""; // holds the rest of hte connection string string strConnectionStringNoPassword = ""; // get the connection string and remove the password string[] strParts = connectionString.Split(';'); foreach (string strPart in strParts) { if (strPart.ToLower().IndexOf("password="******";"; } } SecurityHandler objSecurity = new SecurityHandler(); strConnecitonStringPassword = objSecurity.Encrypt(password); // Get the installation diretory // its the first parameter off the command line arguments string strInstallDirectory = ""; try { strInstallDirectory = Environment.GetCommandLineArgs()[1]; } catch (Exception ex) { MessageBox.Show(" This application requires arguements - first arguement is the install directory, message relating to arguements:" + ex.Message + Environment.NewLine + ex.StackTrace); } // string strInstallDirectory = Environment.GetCommandLineArgs()[0]; // Above directory is web directory DirectoryInfo dirSaltApplication = new DirectoryInfo(strInstallDirectory); // Full path and filename to the web.config file. strWebConfig = dirSaltApplication.FullName + "\\Reporting\\CPD\\Web.Config"; Bdw.Application.Salt.Deployment.DatabaseConfiguration.ConfigureWebConfig.WebConfigConnectionString (strWebConfig, "logconnectionstring", strConnectionStringNoPassword.Replace("\"", ""), "connectionstringpassword", strConnecitonStringPassword.Replace("\"", "")); }
private void btnEncrypt_Click(object sender, System.EventArgs e) { try { if (txtUnencrypted.Text.Length > 0) { SecurityHandler objSecurityHandler = new SecurityHandler(); this.txtEncrypted.Text = objSecurityHandler.Encrypt(this.txtUnencrypted.Text); //this.txtEncrypted.Enabled=true; } else { MessageBox.Show("Enter the password to encrypt"); } } catch (Exception ex) { MessageBox.Show("Error Encrypting Text" + Environment.NewLine + ex.Message); } }
/// <summary> /// Updates the installed web.config file with the new connection string. /// </summary> /// <param name="connectionString">connectionString to be placed in web.config</param> /// <param name="password">password in unencrypted form</param> private void UpdateWebConfig(string connectionString, string password) { string strWebConfig; string strEmailRptWebConfig; string strAdminRptWebConfig; // holds just the password string strConnecitonStringPassword = ""; // holds the rest of hte connection string string strConnectionStringNoPassword = ""; // get the connection string and remove the password string[] strParts = connectionString.Split(';'); foreach (string strPart in strParts) { if (strPart.ToLower().IndexOf("password="******";"; } } SecurityHandler objSecurity = new SecurityHandler(); strConnecitonStringPassword = objSecurity.Encrypt(password); // Get the installation diretory // its the first parameter off the command line arguments string strInstallDirectory = Environment.GetCommandLineArgs()[1]; // Above directory is web directory DirectoryInfo dirSaltApplication = new DirectoryInfo(strInstallDirectory); // Full path and filename to the web.config file. strWebConfig = dirSaltApplication.FullName + "\\Web.Config"; // Load Web.Config XmlDocument configXmlDocument = new XmlDocument(); configXmlDocument.Load(strWebConfig); // Loop through all application settings until the correct one is found foreach (XmlNode node in configXmlDocument["configuration"]["appSettings"]) { if (node.Name == "add") { if (node.Attributes.GetNamedItem("key").Value.ToLower() == "rptconnectionstring") { // Change the value of the connection string node.Attributes["value"].Value = strConnectionStringNoPassword.Replace("\"", ""); //form.lblSQLServer.Text = strConnectionStringNoPassword.Replace("\"", ""); } if (node.Attributes.GetNamedItem("key").Value.ToLower() == "rptconnectionstringpassword") { // Change the value of the connection string password node.Attributes["value"].Value = strConnecitonStringPassword.Replace("\"", ""); } } } configXmlDocument.Save(strWebConfig); // Full path and filename to the BuildEmailReport report web.config file strEmailRptWebConfig = dirSaltApplication.FullName + "\\Reporting\\Email\\Web.Config"; // Load Web.Config XmlDocument EmailConfigXmlDocument = new XmlDocument(); EmailConfigXmlDocument.Load(strEmailRptWebConfig); // Loop through all application settings until the correct one is found foreach (XmlNode node in EmailConfigXmlDocument["configuration"]["appSettings"]) { if (node.Name == "add") { if (node.Attributes.GetNamedItem("key").Value.ToLower() == "connectionstring") { // Change the value of the connection string node.Attributes["value"].Value = strConnectionStringNoPassword.Replace("\"", ""); } if (node.Attributes.GetNamedItem("key").Value.ToLower() == "connectionstringpassword") { // Change the value of the connection string password node.Attributes["value"].Value = strConnecitonStringPassword.Replace("\"", ""); } } } EmailConfigXmlDocument.Save(strEmailRptWebConfig); // Full path and filename to the AdministrationReport report web.config file strAdminRptWebConfig = dirSaltApplication.FullName + "\\Reporting\\Admin\\Web.Config"; // Load Admin Web.Config XmlDocument AdminConfigXmlDocument = new XmlDocument(); AdminConfigXmlDocument.Load(strAdminRptWebConfig); // Loop through all application settings until the correct one is found foreach (XmlNode node in AdminConfigXmlDocument["configuration"]["appSettings"]) { if (node.Name == "add") { if (node.Attributes.GetNamedItem("key").Value.ToLower() == "connectionstring") { // Change the value of the connection string node.Attributes["value"].Value = strConnectionStringNoPassword.Replace("\"", ""); } if (node.Attributes.GetNamedItem("key").Value.ToLower() == "connectionstringpassword") { // Change the value of the connection string password node.Attributes["value"].Value = strConnecitonStringPassword.Replace("\"", ""); } } } AdminConfigXmlDocument.Save(strAdminRptWebConfig); }