private static StoreSetting Get(SqlConnection cn, string settingName, bool recursionProtected = false)
{
StoreSetting result = null;
if (settingName == null)
{
return(null);
}
using (var cmd = new SqlCommand("SELECT * FROM StoreSetting WHERE StoreSettingName LIKE @StoreSettingName", cn))
{
BuildSqlParameter(cmd, "@StoreSettingName", SqlDbType.Text, settingName);
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildStoreSetting(rdr);
}
}
}
if ((result == null) && !recursionProtected)
{
Insert(cn, settingName, null);
result = Get(cn, settingName, true);
}
return(result);
}
public static void Refresh(StoreSetting setting)
{
if (setting != null)
{
Refresh(setting, Get(setting.Name));
}
}
public static void Set(string settingName, DateTime?dateTimeValue)
{
SqlConnection cn = GetConnection();
StoreSetting currentValue = Get(cn, settingName);
if (currentValue != null)
{
if (dateTimeValue != null)
{
// Update
Update(cn, currentValue.Id, dateTimeValue.Value);
}
else
{
// Delete
Delete(cn, currentValue.Id);
}
}
else
{
if (dateTimeValue != null)
{
// Insert
Insert(cn, settingName, dateTimeValue.Value);
}
}
FinishedWithConnection(cn);
}
public static StoreSetting Get(string settingName)
{
SqlConnection cn = GetConnection();
StoreSetting result = Get(cn, settingName);
FinishedWithConnection(cn);
return(result);
}
public static void Refresh(StoreSetting setting, StoreSetting tempSetting)
{
if ((setting == null) || (tempSetting == null))
{
return;
}
setting.Name = tempSetting.Name;
setting.StringValue = tempSetting.StringValue;
setting.IntValue = tempSetting.IntValue;
setting.FloatValue = tempSetting.FloatValue;
setting.DateTimeValue = tempSetting.DateTimeValue;
}
