/// <summary>
/// Removes a specified config.
/// </summary>
/// <param name="configChange">The config change object.</param>
/// <returns>
/// How many changes have been processed by this method.
/// </returns>
/// <exception cref="System.Exception">Trying to delete a config that does not exist in RiME Config.</exception>
public static int RemoveConfig(ConfigChangeModel configChange)
{
RiMEConfigModel rimeConfig = RiMEConfigDAL.GetConfig((int)configChange.ConfigObjectType, configChange.Key.ToString());
if (rimeConfig != null)
{
return(RiMEConfigDAL.RemoveConfig(configChange));
}
else
{
throw new Exception("Trying to delete a config that does not exist in RiME Config. \r\nThis Config Info:\r\n{0}".FormatWith(configChange.ToSerializedXmlString()));
}
}
/// <summary>
/// Updates a specified config.
/// </summary>
/// <param name="configChange">The config change object.</param>
/// <returns>How many changes have been processed by this method.</returns>
/// <exception cref="System.Exception">Trying to update a config that does not exist in RiME Config.</exception>
public static int UpdateConfig(ConfigChangeModel configChange)
{
RiMEConfigModel rimeConfig = RiMEConfigDAL.GetConfig((int)configChange.ConfigObjectType, configChange.Key.ToString());
if (rimeConfig != null)
{
string oldValue = rimeConfig.Value;
return(RiMEConfigDAL.UpdateConfig(configChange, RiMEConfigBLL.GetNewValueToStoreInDB(oldValue, configChange.NewConfig)));
}
else
{
throw new Exception("Trying to update a config that does not exist in RiME Config. \r\nThis Config Info:\r\n{0}".FormatWith(configChange.ToSerializedXmlString()));
}
}
/// <summary>
/// Gets a list of config objects that are all in the specified type.
/// </summary>
/// <param name="configObjectType">A integer value represents the type of the config object.</param>
/// <returns>A list of config objects.</returns>
public static List <RiMEConfigModel> GetConfig(int configObjectType)
{
List <RiMEConfigModel> result = new List <RiMEConfigModel>();
string sql = "SELECT iConfigObjectType, vcKey, nvcValue, dtUpdatedTime FROM RiMEConfig.dbo.Config WHERE iConfigObjectType = @configObjectType";
DataTable dt = SqlServerHelper.Query(sql, new SqlParameter("configObjectType", configObjectType));
for (int i = 0; i < dt.Rows.Count; i++)
{
RiMEConfigModel model = new RiMEConfigModel()
{
ConfigObjectType = dt.Rows[i][0].ToInt(), Key = dt.Rows[i][1].ToString(), Value = dt.Rows[i][2].ToString(), UpdatedTime = dt.Rows[i][3].ToDateTime()
};
result.Add(model);
}
return(result);
}
/// <summary>
/// Gets a config by its key and configObjectType.
/// </summary>
/// <param name="configObjectType">The integer value that represents the type of the config object.</param>
/// <param name="key">The key.</param>
/// <returns>The config object</returns>
public static RiMEConfigModel GetConfig(int configObjectType, string key)
{
string sql = "SELECT iConfigObjectType, vcKey, nvcValue, dtUpdatedTime FROM RiMEConfig.dbo.Config WHERE iConfigObjectType = @configObjectType AND vcKey = @key";
DataTable dt = SqlServerHelper.Query(sql, new SqlParameter("configObjectType", configObjectType), new SqlParameter("key", key));
if (dt.Rows.Count > 0)
{
RiMEConfigModel model = new RiMEConfigModel()
{
ConfigObjectType = dt.Rows[0][0].ToInt(), Key = dt.Rows[0][1].ToString(), Value = dt.Rows[0][2].ToString(), UpdatedTime = dt.Rows[0][3].ToDateTime()
};
return(model);
}
else
{
return(null);
}
}
