public string LeerConexionL()
{
try
{
string StrConexion;
string ValServer;
string ValDBase;
string ValUser;
string ValPass;
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
ValServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Server"));
ValDBase = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBase"));
ValUser = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "User"));
ValPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Password"));
StrConexion = "Data Source=" + ValServer + ";Initial Catalog=" + ValDBase + ";Persist Security Info=True;User ID=" + ValUser + ";Password=" + ValPass;
return(StrConexion);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
static public string LeerConexionR(string ServerR, string DBaseR, string UserR, string PasswordR)
{
try
{
string StrConexion;
string ValServerR = string.Empty;
string ValDBaseR = string.Empty;
string ValUserR = string.Empty;
string ValPassR = string.Empty;
if (ServerR != null && DBaseR != null && UserR != null && PasswordR != null)
{
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
ValServerR = DesencriptarTexto.Desencriptar(ServerR);
ValDBaseR = DesencriptarTexto.Desencriptar(DBaseR);
ValUserR = DesencriptarTexto.Desencriptar(UserR);
ValPassR = DesencriptarTexto.Desencriptar(PasswordR);
}
StrConexion = "Data Source=" + ValServerR + ";Initial Catalog=" + ValDBaseR + ";Persist Security Info=True;User ID=" + ValUserR + ";Password=" + ValPassR;
return(StrConexion);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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="******"ConexionSQL", "Server", EncriptarTexto.Encriptar(txtServer.Text));
RegIn.SaveSetting("ConexionSQL", "DBase", EncriptarTexto.Encriptar(txtDB.Text));
RegIn.SaveSetting("ConexionSQL", "User", EncriptarTexto.Encriptar(txtLogin.Text));
RegIn.SaveSetting("ConexionSQL", "Password", EncriptarTexto.Encriptar(txtPassword.Text));
XtraMessageBox.Show("Se Grabaron los Datos Del Servidor Principal Con Exito");
this.Close();
}
catch (Exception ex)
{
XtraMessageBox.Show("Error Descripcion: " + ex);
}
}
}
else
{
XtraMessageBox.Show("Faltan Datos para la Conexion Principal");
}
}
static public string LeerConexion()
{
string StrConexion;
string valServer;
string valDB;
string valLogin;
string valPass;
try
{
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
valServer = RegOut.GetSetting("ConexionSQL", "Server");
valDB = RegOut.GetSetting("ConexionSQL", "DBase");
valLogin = RegOut.GetSetting("ConexionSQL", "User");
valPass = RegOut.GetSetting("ConexionSQL", "Password");
if (valServer != string.Empty && valLogin != string.Empty && valLogin != string.Empty && valPass != string.Empty)
{
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"));
}
else
{
throw new Exception("Faltan datos para la Conexión");
}
}
catch
{
valServer = string.Empty;
valDB = string.Empty;
valLogin = string.Empty;
valPass = string.Empty;
}
if (valServer != string.Empty && valLogin != string.Empty && valLogin != string.Empty && valPass != string.Empty)
{
StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", valServer, valDB, valLogin, valPass);
return(StrConexion);
}
else
{
throw new Exception("Faltan datos para la Conexión");
}
}
public Boolean ValidaConexion()
{
try
{
string ValServer;
string ValDBase;
string ValUser;
string ValPass;
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
try
{
ValServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Server"));
ValDBase = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBase"));
ValUser = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "User"));
ValPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Password"));
}
catch
{
ValServer = string.Empty;
ValDBase = string.Empty;
ValUser = string.Empty;
ValPass = string.Empty;
}
if (ValServer != string.Empty && ValDBase != string.Empty && ValUser != string.Empty && ValPass != string.Empty)
{
try
{
SqlConnection conn = new SqlConnection("Data Source=" + ValServer + ";Initial Catalog=" + ValDBase + ";Persist Security Info=True;User ID=" + ValUser + ";Password=" + ValPass);
conn.Open();
return(true);
}
catch
{
return(false);
}
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
private void btnAcceso_Click(object sender, EventArgs e)
{
if (btnAcceso.Text == "Acceso")
{
if (txtUser.Text != string.Empty && txtPass.Text != string.Empty)
{
SEG_Login sLogin = new SEG_Login()
{
c_codigo_usu = txtUser.Text, v_passwo_usu = txtPass.Text
};
sLogin.MtdSeleccionarUsuarioLogin();
if (sLogin.Exito)
{
if (sLogin.Datos.Rows.Count > 0)
{
vIdUsuario = sLogin.Datos.Rows[0]["c_codigo_usu"].ToString();
vIdActivo = Convert.ToInt32(sLogin.Datos.Rows[0]["c_activo_usu"].ToString());
Frm_Etiquetas_Empleados frmP = new Frm_Etiquetas_Empleados();
MSRegistro RegIn = new MSRegistro();
if (vIdActivo == 1)
{
frmP.c_codigo_usu = txtUser.Text;
frmP.Show();
this.Hide();
}
else
{
XtraMessageBox.Show("Este usuario esta inactivo en el sistema");
}
}
else
{
XtraMessageBox.Show("Usuario o Contraseña Incorrectos o El Usuario Esta Inactivo");
}
}
else
{
XtraMessageBox.Show(sLogin.Mensaje);
}
}
else
{
XtraMessageBox.Show("Faltan Datos por Capturar Usuario y/o Password");
}
}
}
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();
}
catch
{
XtraMessageBox.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();
XtraMessageBox.Show("Conexion Exitosa DB Principal");
MSRegistro RegIn = new MSRegistro();
Crypto EncriptarTexto = new Crypto();
RegIn.SaveSetting("ConexionSQL", "Server", EncriptarTexto.Encriptar(txtServer.Text));
RegIn.SaveSetting("ConexionSQL", "DBase", EncriptarTexto.Encriptar(txtDB.Text));
RegIn.SaveSetting("ConexionSQL", "User", EncriptarTexto.Encriptar(txtLogin.Text));
RegIn.SaveSetting("ConexionSQL", "Password", EncriptarTexto.Encriptar(txtPassword.Text));
}
catch (Exception ex)
{
XtraMessageBox.Show("No se pudo Conectar con la Base de Datos Principal: " + ex);
}
}
}
}
private void Frm_Login_Load(object sender, EventArgs e)
{
txtUser.Focus();
MSRegistro RegOut = new MSRegistro();
//SkinForm.LookAndFeel.SetSkinStyle(RegOut.GetSetting("ConexionSQL", "Sking"));
}
