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; } }