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