Ejemplo n.º 1
0
 private void btnGuardarConexion_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
 {
     if (txtServer.Text != "" && txtDB.Text != "" && txtLogin.Text != "" && txtPassword.Text != "")
     {
         {
             SqlConnection conn = new SqlConnection("Data Source=" + txtServer.Text + ";Initial Catalog=" + txtDB.Text + ";Persist Security Info=True;User ID=" + txtLogin.Text + ";Password="******"AvoTrace", "ConexionSQL", "Server", EncriptarTexto.Encriptar(txtServer.Text));
                 RegIn.SaveSetting("AvoTrace", "ConexionSQL", "DBase", EncriptarTexto.Encriptar(txtDB.Text));
                 RegIn.SaveSetting("AvoTrace", "ConexionSQL", "User", EncriptarTexto.Encriptar(txtLogin.Text));
                 RegIn.SaveSetting("AvoTrace", "ConexionSQL", "Password", EncriptarTexto.Encriptar(txtPassword.Text));
                 RegIn.SaveSetting("AvoTrace", "ConexionSQL", "Sucursal", EncriptarTexto.Encriptar(Convert.ToString(cmbSucursal.SelectedValue)));
                 RegIn.SaveSetting("AvoTrace", "ConexionSQL", "Estacion", EncriptarTexto.Encriptar(Convert.ToString(cbEstacion.SelectedValue)));
                 MessageBox.Show("Se Grabaron los Datos Del Servidor Principal Con Exito");
                 this.Close();
             }
             catch (Exception ex)
             {
                 MessageBox.Show("Error Descripcion: " + ex);
             }
         }
     }
     else
     {
         MessageBox.Show("Faltan Datos para la Conexion Principal");
     }
 }
Ejemplo n.º 2
0
 private void Cargar_Cajas()
 {
     MSRegistro RegOut = new MSRegistro();
     Crypto DesencriptarTexto = new Crypto();
     int valSucursal = Convert.ToInt32(cmbSucursal.SelectedValue.ToString());
     Estaciones estacion = new Estaciones();
     cbEstacion.DataSource = estacion.ListarEstacionesLogin(valSucursal);
     cbEstacion.ValueMember = "EstacionesId";
     cbEstacion.DisplayMember = "EstacionesNombre";
 }
Ejemplo n.º 3
0
        private void FrmConexion_Load(object sender, EventArgs e)
        {
            CargarIconos();
            MSRegistro RegOut = new MSRegistro();
            Crypto DesencriptarTexto = new Crypto();
            string valServer, valDB, valLogin, valPass;

            try
            {
                valServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting("AvoTrace", "ConexionSQL", "Server"));
                valDB = DesencriptarTexto.Desencriptar(RegOut.GetSetting("AvoTrace", "ConexionSQL", "DBase"));
                valLogin = DesencriptarTexto.Desencriptar(RegOut.GetSetting("AvoTrace", "ConexionSQL", "User"));
                valPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting("AvoTrace", "ConexionSQL", "Password"));
            }
            catch
            {
                valServer = string.Empty;
                valDB = string.Empty;
                valLogin = string.Empty;
                valPass = string.Empty;
            }
            if (valServer != null && valDB != null && valLogin != null & valPass != null)
            {
                txtServer.Text = valServer;
                txtDB.Text = valDB;
                txtLogin.Text = valLogin;
                txtPassword.Text = valPass;
                using (SqlConnection conn = new SqlConnection(String.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", txtServer.Text, txtDB.Text, txtLogin.Text, txtPassword.Text)))
                {
                    try
                    {
                        conn.Open();
                        Cargar_Sucursales();
                        cmbSucursal.SelectedValue = DesencriptarTexto.Desencriptar(RegOut.GetSetting("AvoTrace", "ConexionSQL", "Sucursal"));
                        Cargar_Cajas();
                        cbEstacion.SelectedValue = DesencriptarTexto.Desencriptar(RegOut.GetSetting("AvoTrace", "ConexionSQL", "Estacion"));
                    }
                    catch
                    {
                        MessageBox.Show("No se Han Configurado datos Correctos para la conexion a la base de datos");
                    }
                }
            }
            else
            {
                txtServer.Text = string.Empty;
                txtDB.Text = string.Empty;
                txtLogin.Text = string.Empty;
                txtPassword.Text = string.Empty;
            }
        }
Ejemplo n.º 4
0
        private void btnProbarConexion_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (txtServer.Text != "" && txtDB.Text != "" && txtLogin.Text != "" && txtPassword.Text != "")
            {
                using (SqlConnection conn = new SqlConnection(String.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", txtServer.Text, txtDB.Text, txtLogin.Text, txtPassword.Text)))
                {
                    try
                    {
                        conn.Open();
                        MessageBox.Show("Conexion Exitosa DB Principal");
                        MSRegistro RegIn = new MSRegistro();
                        Crypto EncriptarTexto = new Crypto();
                        RegIn.SaveSetting("AvoTrace", "ConexionSQL", "Server", EncriptarTexto.Encriptar(txtServer.Text));
                        RegIn.SaveSetting("AvoTrace", "ConexionSQL", "DBase", EncriptarTexto.Encriptar(txtDB.Text));
                        RegIn.SaveSetting("AvoTrace", "ConexionSQL", "User", EncriptarTexto.Encriptar(txtLogin.Text));
                        RegIn.SaveSetting("AvoTrace", "ConexionSQL", "Password", EncriptarTexto.Encriptar(txtPassword.Text));
                        Cargar_Sucursales();
                        Cargar_Cajas();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("No se pudo Conectar con la Base de Datos Principal: " + ex);
                    }
                }

            }
        }