public static bool ValiderParametresApp(String pDataBaseName, String pServerName, out string pErreur)
{
System.Configuration.Configuration m_config;
string sChaine = string.Empty;
pErreur = string.Empty;
try
{
String sPath = Assembly.GetExecutingAssembly().Location;
m_config = ConfigurationManager.OpenExeConfiguration(sPath);
m_config.AppSettings.Settings.Remove("BDEnvoiFactureCIEConnectionString");
//constituer la chaine
sChaine = GetSqlConnexionStringBuilder(pDataBaseName, pServerName).ConnectionString;
if (!Utilitaire.EstSqlConnexionStringValide(sChaine, out pErreur))
{
throw new Exception(pErreur);
}
else
{
// Crypter la chain
sChaine = Crypteur.CrypterText(sChaine);
m_config.AppSettings.Settings.Add("BDEnvoiFactureCIEConnectionString", sChaine);
m_config.Save(ConfigurationSaveMode.Modified);
return(true);
}
}
catch
{
return(false);
}
}
public static bool OpenTransation(out SqlCommand CommandEnvoiDeFacture, out SqlTransaction TransactionEnvoiDeFacture, out SqlConnection ConnectionEnvoiDeFacture)
{
try
{
ConnectionEnvoiDeFacture = new SqlConnection(Utilitaire.GetConnectionString());
ConnectionEnvoiDeFacture.Open();
TransactionEnvoiDeFacture =
ConnectionEnvoiDeFacture.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
CommandEnvoiDeFacture = new SqlCommand();
CommandEnvoiDeFacture = ConnectionEnvoiDeFacture.CreateCommand();
CommandEnvoiDeFacture.CommandTimeout = 5 * 60;
CommandEnvoiDeFacture.Transaction = TransactionEnvoiDeFacture;
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
