/////////////////////////////////////////////////////// public void ResetCache() { CDonneeNotificationResetCacheDatabaseRegistre data = new CDonneeNotificationResetCacheDatabaseRegistre(IdSession); CEnvoyeurNotification.EnvoieNotifications(new CDonneeNotificationResetCacheDatabaseRegistre[] { data }); ResetCacheStatic(); }
/////////////////////////////////////////////////////// public CResultAErreur SetValeur(string strCle, string strValeur) { CResultAErreur result = CResultAErreur.True; try { lock (typeof(CDatabaseRegistre)) { string strRequete = "select " + c_champValeur + " from " + c_nomTable + " where " + c_champCle + "=" + Connexion.GetStringForRequete(strCle); result = Connexion.ExecuteScalar(strRequete); if (!result || result.Data == null) { string strInsert = "insert into " + c_nomTable + "(" + c_champCle + "," + c_champValeur + ") " + "values(" + Connexion.GetStringForRequete(strCle) + "," + Connexion.GetStringForRequete(strValeur) + ")"; return(Connexion.RunStatement(strInsert)); } else { string strUpdate = "Update " + c_nomTable + " set " + c_champValeur + "=" + Connexion.GetStringForRequete(strValeur) + " where " + c_champCle + "=" + Connexion.GetStringForRequete(strCle); return(Connexion.RunStatement(strUpdate)); } } } catch (Exception e) { result.EmpileErreur(new CErreurException(e)); } finally { if (result) { CDonneeNotificationResetCacheDatabaseRegistre data = new CDonneeNotificationResetCacheDatabaseRegistre(IdSession); CEnvoyeurNotification.EnvoieNotifications(new CDonneeNotificationResetCacheDatabaseRegistre[] { data }); } ResetCacheStatic(); } return(result); }