62 lines
2.2 KiB
C#
62 lines
2.2 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using DTS.Common.Storage;
|
|
|
|
|
|
namespace DTS.Common.Settings
|
|
{
|
|
/// <inheritdoc />
|
|
/// <summary>
|
|
/// user specific setting, this allows users to have specific settings for columns, tables, etc in the future
|
|
/// </summary>
|
|
public class UserSetting : Setting
|
|
{
|
|
public UserSetting(string id, string defaultValue, string user)
|
|
: base(id, PropertyTypes.User, defaultValue, user)
|
|
{
|
|
|
|
}
|
|
protected override void GetPropertyValue(string defaultValue)
|
|
{
|
|
try
|
|
{
|
|
using (var cmd = DbOperations.GetSQLCommand(true))
|
|
{
|
|
try
|
|
{
|
|
cmd.CommandType = CommandType.StoredProcedure;
|
|
cmd.CommandText = DbOperationsEnum.StoredProcedure.sp_SettingsGet.ToString();
|
|
cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.NVarChar) { Value = UserId });
|
|
cmd.Parameters.Add(new SqlParameter("@PropertyId", SqlDbType.NVarChar) { Value = PropertyId });
|
|
|
|
using (var ds = DbOperations.Connection.QueryDataSet(cmd))
|
|
{
|
|
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
_propertyValue =
|
|
Convert.ToString(
|
|
ds.Tables[0].Rows[0][
|
|
DbOperations.Settings.UserFields.PropertyValue.ToString()]);
|
|
}
|
|
else
|
|
{
|
|
_propertyValue = defaultValue;
|
|
StoreInDB();
|
|
}
|
|
}
|
|
}
|
|
finally
|
|
{
|
|
cmd.Connection.Dispose();
|
|
}
|
|
}
|
|
}
|
|
catch (Exception) //TODO: handle exception properly
|
|
{
|
|
_propertyValue = defaultValue;
|
|
}
|
|
}
|
|
}
|
|
}
|