public static void SetSqlSettingValue(string strName, string strValue, SQLDataAccess db)
{
SetSqlSettingValueFromDB(strName, strValue, db);
// Add into cahce
string strCacheName = CacheNames.GetCommonSettingsCacheObjectName(strName);
CacheManager.Insert(strCacheName, strValue);
}
public static bool RemoveSqlSetting(string strKey)
{
SQLDataAccess.ExecuteNonQuery("DELETE FROM [Settings].[Settings] WHERE [Name]=@Name", CommandType.Text, new SqlParameter("@Name", strKey));
// Clear cache object
string strCacheName = CacheNames.GetCommonSettingsCacheObjectName(strKey);
CacheManager.Remove(strCacheName);
return(true);
}
/// <summary>
/// Save settings into DB
/// </summary>
/// <param name="strName"></param>
/// <param name="strValue"></param>
/// <remarks></remarks>
public static bool SetSqlSettingValue(string strName, string strValue)
{
bool boolReult = SetSqlSettingValueFromDB(strName, strValue);
// Add into cahce
string strCacheName = CacheNames.GetCommonSettingsCacheObjectName(strName);
CacheManager.Insert(strCacheName, strValue);
return(boolReult);
}
/// <summary>
/// Read settings from DB.
/// On Err: Function will return Nothing
/// </summary>
/// <param name="strName"></param>
/// <returns></returns>
/// <remarks></remarks>
public static string GetSqlSettingValue(string strName)
{
string strRes;
string strCacheName = CacheNames.GetCommonSettingsCacheObjectName(strName);
if (CacheManager.Contains(strCacheName))
{
strRes = CacheManager.Get <string>(strCacheName);
}
else
{
strRes = GetSqlSettingValueFromDB(strName);
if (strRes != null)
{
CacheManager.Insert(strCacheName, strRes);
}
}
return(strRes);
}