private void btnProtegeCNX_Click(object sender, EventArgs e) { if (txtCadenaConexion.TextLength > 0) { CLS.Utilities objCnx = new CLS.Utilities(); objCnx.ProtectConnectionString(); } /* * try * { * //Se abre el app.config para recuperar la seccion ConnectionStrings * Configuration MiAppConfig = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath); * //Se recupera la seccion ConnectionStrings * ConnectionStringsSection MiSeccion = (ConnectionStringsSection)(MiAppConfig.GetSection("connectionStrings")); * //Se protege la seccion, caso contrario se desprotege * if (MiSeccion.SectionInformation.IsProtected) * MiSeccion.SectionInformation.UnprotectSection(); * else * MiSeccion.SectionInformation.ProtectSection("DataProtectionConfigurationProvider"); * //Se guarda los cambios * MiAppConfig.Save(); * if (MiSeccion.SectionInformation.IsProtected) * MessageBox.Show("Cadena de Conexion Protegida"); * else * MessageBox.Show("No esta protegida"); * * }catch (Exception ex){ * MessageBox.Show(ex.Message); * } */ }
private void btnSave_Click(object sender, EventArgs e) { CLS.Connection cnxValidate = new CLS.Connection(); CLS.Utilities objConx = new CLS.Utilities(); string newString = null; newString = objConx.SetConnectionStringComplete(txtServer.Text, uint.Parse(txtPort.Text), txtBD.Text, txtUser.Text, txtPass.Text); if (chkVerify.Checked) { if (cnxValidate.ValidarConexion(newString)) { MessageBox.Show("Conexión exitosa", "ConnectionSettings", MessageBoxButtons.OK, MessageBoxIcon.Information); if (newString != null) { objConx.SaveConnectionString(newString); objConx.ProtectConnectionString(); DBM.CLS.QUERY Query_ = new DBM.CLS.QUERY(); Query_.GetColumnWidth("pedido", "listo"); if (Query_.GetColumnWidth("pedido", "listo")["COLUMN_TYPE"].ToString().Trim() == "tinyint(1)") { DBM.CLS.Transaccion Trans = new DBM.CLS.Transaccion(); string query = ""; query = "ALTER TABLE `pedido` CHANGE `listo` `listo` TINYINT(2) NULL DEFAULT NULL;"; if (Trans.CreateTransaction(query)) { MessageBox.Show("El campo LISTO ahora tiene un ancho de 2 ", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } else { MessageBox.Show("No se pudo establecer la conexión con el servidor." + saltoLinea + "Para guardar los datos sin comprobar la conexión desactive la casilla de verificación", "ConnectionSettings", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { if (newString != null) { objConx.SaveConnectionString(newString); objConx.ProtectConnectionString(); } } }