private static int _updateParameterBusiness(string userName, string parameterName, string parameterValue) { int result = 0; try { string connectionString = SAFConfiguration.readConnectionStringBusiness(); using (IDbConnection dbConnection = new SqlConnection(connectionString)) { dbConnection.Open(); using (IDbCommand dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "SetConfigurationParameter"; dbCommand.Parameters.Add(new SqlParameter("@UserName", userName)); dbCommand.Parameters.Add(new SqlParameter("@ParameterName", parameterName)); dbCommand.Parameters.Add(new SqlParameter("@ParameterValue", parameterValue)); result = (int)dbCommand.ExecuteScalar(); } } } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Configuration.SAFConfiguration::_updateParameterBusiness failed. Err:" + ex.Message, ex); } SAFConfiguration._CheckCache(0); return(result); }
private static string _readParameterBusiness(string parameterFullName, int cacheSecs) { string result; try { SAFConfigurationParametersMap cacheData = SAFConfiguration._CheckCache(cacheSecs); if (cacheData == null || !cacheData.ContainsKey(parameterFullName)) { result = null; } else { result = cacheData[parameterFullName].value; } } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.WARNING, "SAFBUSINESS", new string[] { "http://sfexpand.SAFBusinessConfig.SAFConfiguration.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), "failed::[" + parameterFullName + "]", ex.ToString() }); result = null; } return(result); }
private static string _readParameterBusiness(string parameterFullName, int cacheSecs) { SAFConfigurationParametersMap sAFConfigurationParametersMap = SAFConfiguration._CheckCache(cacheSecs); if (sAFConfigurationParametersMap == null) { return(null); } string result; try { result = sAFConfigurationParametersMap[parameterFullName].value; } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Configuration.SAFConfiguration::readParameterBusinessChangeable error getting parameter[" + parameterFullName + "]. Err:" + ex.Message, ex); result = null; } return(result); }
public static SAFConfigurationParametersMap readParameters(int cacheSecs) { return(SAFConfiguration._CheckCache(cacheSecs)); }
public static SAFConfigurationParametersMap readParameters() { return(SAFConfiguration._CheckCache(0)); }