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", "ServerL"));
ValDBase = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBaseL"));
ValUser = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "UserL"));
ValPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "PasswordL"));
StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", ValServer, ValDBase, ValUser, ValPass);
return(StrConexion);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
static public string LeerConexionRC(string ServerC, string DBaseC, string UserC, string PasswordC)
{
try
{
string StrConexion;
string ValServerC = string.Empty;
string ValDBaseC = string.Empty;
string ValUserC = string.Empty;
string ValPassC = string.Empty;
if (ServerC != null && DBaseC != null && UserC != null && PasswordC != null)
{
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
ValServerC = DesencriptarTexto.Desencriptar(ServerC);
ValDBaseC = DesencriptarTexto.Desencriptar(DBaseC);
ValUserC = DesencriptarTexto.Desencriptar(UserC);
ValPassC = DesencriptarTexto.Desencriptar(PasswordC);
}
StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", ValServerC, ValDBaseC, ValUserC, ValPassC);
return(StrConexion);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public string LeerConexionR()
{
try
{
string StrConexion;
string ValServerR;
string ValDBaseR;
string ValUserR;
string ValPassR;
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
ValServerR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "ServerR"));
ValDBaseR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBaseR"));
ValUserR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "UserR"));
ValPassR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "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);
}
}
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);
}
}
static public string LeerConexionC()
{
string StrConexion = string.Empty;
string valServer = string.Empty;
string valDB = string.Empty;
string valLogin = string.Empty;
string valPass = string.Empty;
string ProyectName = string.Empty;
try
{
StrConexion = string.Empty;
valServer = ConfigurationManager.AppSettings["ServerName"].ToString();
valDB = ConfigurationManager.AppSettings["DataBase"].ToString();
valLogin = ConfigurationManager.AppSettings["UserName"].ToString();
valPass = ConfigurationManager.AppSettings["Password"].ToString();
ProyectName = ConfigurationManager.AppSettings["ProyectName"].ToString();
StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", valServer, valDB, valLogin, valPass);
//SqlConnection conn = new SqlConnection(StrConexion);
//conn.Open();
return(StrConexion);
}
catch
{
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
valServer = RegOut.GetSetting("ConexionSQL", "ServerC");
valDB = RegOut.GetSetting("ConexionSQL", "DBaseC");
valLogin = RegOut.GetSetting("ConexionSQL", "UserC");
valPass = RegOut.GetSetting("ConexionSQL", "PasswordC");
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);
}
else
{
valServer = string.Empty;
valDB = string.Empty;
valLogin = string.Empty;
valPass = string.Empty;
ProyectName = string.Empty;
throw new Exception("Faltan datos de Conexion");
}
StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", valServer, valDB, valLogin, valPass);
return(StrConexion);
}
}
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(string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", ValServer, ValDBase, ValUser, ValPass));
conn.Open();
return(true);
}
catch
{
return(false);
}
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
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 void ConnectionStrings(string csName)
{
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
string valServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "ServerL"));
string valDB = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "DBaseL"));
string valLogin = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "UserL"));
string valPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "PasswordL"));
String cadenaNueva = string.Format(@"XpoProvider=MSSqlServer;data source={0};user id={1}; password={2};initial catalog={3};Persist Security Info=true", valServer, valLogin, valPass, valDB);
// Get the application configuration file.
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
int connStrCnt = ConfigurationManager.ConnectionStrings.Count;
ConnectionStringSettings csSettings = new ConnectionStringSettings(csName, cadenaNueva);
ConnectionStringsSection csSection = config.ConnectionStrings;
config.ConnectionStrings.ConnectionStrings.Remove(csName);
config.Save(ConfigurationSaveMode.Modified);
csSection.ConnectionStrings.Add(csSettings);
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("ConnectionStrings");
}
