private void CargarSucursales() { MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); string v_Sucursal = RegOut.GetSetting("ConexionSQL", "Sucursal"); if (v_Sucursal != null) { v_Sucursalnum = Convert.ToInt32(DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "Sucursal"))); CargarSucursales(v_Sucursalnum); } }
private void Frm_Login_Shown(object sender, EventArgs e) { txtUser.Focus(); MSRegistro RegOut = new MSRegistro(); SkinForm.LookAndFeel.SetSkinStyle(RegOut.GetSetting("ConexionSQL", "Sking")); }
private void Form1_ConfigureDataConnection(object sender, ConfigureDataConnectionEventArgs e) { MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); string valServer = RegOut.GetSetting("ConexionSQL", "Server"); string valDB = RegOut.GetSetting("ConexionSQL", "DBase"); string valLogin = RegOut.GetSetting("ConexionSQL", "User"); string valPass = RegOut.GetSetting("ConexionSQL", "Password"); if (valServer != string.Empty && valDB != string.Empty && valLogin != string.Empty && valPass != string.Empty) { valServer = DesencriptarTexto.Desencriptar(valServer); valDB = DesencriptarTexto.Desencriptar(valDB); valLogin = DesencriptarTexto.Desencriptar(valLogin); valPass = DesencriptarTexto.Desencriptar(valPass); e.ConnectionParameters = new MsSqlConnectionParameters(valServer, valDB, valLogin, valPass, MsSqlAuthorizationType.SqlServer); } }
private void CargarComboSucursales() { MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); if (v_Sucursal != null) { int v_Sucursalnum = Convert.ToInt32(DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "Sucursal"))); CargarSucursales(v_Sucursalnum); if (v_Caja != null) { int v_Cajanum = Convert.ToInt32(DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "Caja"))); cboCajas.Properties.DataSource = null; CargarCajas(v_Cajanum, v_Sucursalnum); } } else { CargarSucursales(null); } }
private void Frm_Conexiones_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("ConexionSQL", "Server")); valDB = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "DBase")); valLogin = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "User")); valPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting("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(); v_Sucursal = RegOut.GetSetting("ConexionSQL", "Sucursal"); v_Caja = RegOut.GetSetting("ConexionSQL", "Caja"); CargarComboSucursales(); } catch { XtraMessageBox.Show("No se Han Configurado datos Correctos para la conexion a la base de datos Local"); } } } else { txtServer.Text = string.Empty; txtDB.Text = string.Empty; txtLogin.Text = string.Empty; txtPassword.Text = string.Empty; } }
private void Frm_Principal_Load(object sender, EventArgs e) { MSRegistro RegOut = new MSRegistro(); SkinForm.LookAndFeel.SetSkinStyle(RegOut.GetSetting("ConexionSQL", "Sking")); }