/// <summary>
/// Returns connection string
/// /// </summary>
/// <returns>Connection string</returns>
private string GetConnString()
{
// We need to return here the connection string
// First let's check in the cache
// that will avoid us to rebuild it
string connString = Global.GetConnStringNavSettings();
if (connString != null)
{
// We have something in the cache
// great, no need to continue
// we will thie string and that's it.
return(connString);
}
// We don't have the connection string in the cache
// we need to build it
// There are two parts that need to be added
// Database information (from Web.config file)
// and pooling information (from Web.config file)
connString = Util.BuildSQLConnectionString(EncDec.DecryptPassword(ConfigurationManager.ConnectionStrings["NavisionSettingsConnectionString"].ConnectionString),
ConfigurationManager.AppSettings["NavisionSettingsConnectionMaxPoolSize"],
ConfigurationManager.AppSettings["NavisionSettingsConnectionMinPoolSize"]);
// Save connection string in the cache...for next time
Global.SetConnStringNavSettings(connString);
return(connString);
}
/// <summary>
/// Retourne la chaine de connexion
/// à la base de données
/// </summary>
/// <returns>Chaine de connexion</returns>
private string GetConnString()
{
// On recherche la chaine de connexion
// dans le cache
string connString = Global.GetConnStrinEncrFo();
if (connString != null)
{
// La chaine de connexion est en cache
return(connString);
}
// On construit la chaine de connexion
connString = Util.BuildSQLConnectionString(EncDec.DecryptPassword(ConfigurationManager.ConnectionStrings["EncryptedFODataConnectionString"].ConnectionString),
ConfigurationManager.AppSettings["EncryptedDataConnectionMaxPoolSize"],
ConfigurationManager.AppSettings["EncryptedDataConnectionMinPoolSize"]);
// On sauvegarde la chaine de connexion
Global.SetConnStringEncrFo(connString);
return(connString);
}
/// <summary>
/// Retourne la chaine de connexion
/// à la base de données
/// </summary>
/// <returns>Chaine de connexion</returns>
private string GetConnString()
{
// On recherche la chaine de connexion
// dans le cache
string connString = Global.GetConnStringRejectedCCLog();
if (connString != null)
{
// La chaine de connexion est en cache
return(connString);
}
// On construit la chaine de connexion
connString = Util.BuildSQLConnectionString(EncDec.DecryptPassword(ConfigurationManager.ConnectionStrings["CreditCardLogConnectionString"].ConnectionString),
ConfigurationManager.AppSettings["CreditCardLogConnectionMaxPoolSize"],
ConfigurationManager.AppSettings["CreditCardLogConnectionMinPoolSize"]);
// On sauvegarde la chaine de connexion
// en cache pour réutilisation ultérieure
Global.SetConnStringRejectedCCLog(connString);
return(connString);
}
/// <summary>
/// Connexion à l'AD
/// avec le compte générique
/// </summary>
private void Connect()
{
SetAnonymous(true);
Connect(ConfigurationManager.AppSettings["LDAPUserName"],
EncDec.DecryptPassword(ConfigurationManager.AppSettings["LDAPPassword"]));
}
