/// <summary>
/// Checks the query options.
/// </summary>
/// <param name="mode">The mode.</param>
/// <returns></returns>
private bool CheckQueryOptions(ESnoozeMode mode)
{
return(XmlConfigHelper.Check(m_dictionary, m_xpath + m_xpathQueryOptions, (int)mode));
}
/// <summary>
/// Sets the type of the query.
/// </summary>
/// <param name="mode">The mode.</param>
private void SetQueryType(ESnoozeMode mode)
{
XmlConfigHelper.Set(m_dictionary, m_xpath + m_xpathQueryType, (int)mode);
}
/// <summary>
/// Unsets the query options.
/// </summary>
/// <param name="mode">The mode.</param>
private void UnsetQueryOptions(ESnoozeMode mode)
{
XmlConfigHelper.Unset(m_dictionary, m_xpath + m_xpathQueryOptions, (int)mode);
}
/// <summary>
/// Unsets the type of the query.
/// </summary>
/// <param name="mode">The mode.</param>
private void UnsetQueryType(ESnoozeMode mode)
{
XmlConfigHelper.Unset(m_dictionary, m_xpath + m_xpathQueryType, (int)mode);
}
/// <summary>
/// Sets the query options.
/// </summary>
/// <param name="mode">The mode.</param>
private void SetQueryOptions(ESnoozeMode mode)
{
XmlConfigHelper.Set(m_dictionary, m_xpath + m_xpathQueryOptions, (int)mode);
}
/// <summary>
/// Checks the type of the query.
/// </summary>
/// <param name="mode">The mode.</param>
/// <returns></returns>
private bool CheckQueryType(ESnoozeMode mode)
{
return XmlConfigHelper.Check(m_dictionary, m_xpath + m_xpathQueryType, (int)mode);
}
/// <summary>
/// Sets the snooze mode.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="snoozeMode">The snooze mode.</param>
/// <remarks>Documented by Dev08, 2009-01-13</remarks>
public void SetSnoozeMode(int id, ESnoozeMode? snoozeMode)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "UPDATE \"SnoozeOptions\" SET snooze_mode=" + (snoozeMode.HasValue ? "@value" : "null") + " WHERE id=@id";
cmd.Parameters.Add("@id", id);
if (snoozeMode.HasValue)
cmd.Parameters.Add("@value", snoozeMode.Value.ToString());
MSSQLCEConn.ExecuteNonQuery(cmd);
//Save to Cache
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeMode, id, Cache.DefaultSettingsValidationTime)] = snoozeMode;
}
public void SetSnoozeMode(int id, ESnoozeMode? SnoozeMode)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "UPDATE \"SnoozeOptions\" SET snooze_mode=" + (SnoozeMode.HasValue ? ":value" : "null") + " WHERE id=:id";
cmd.Parameters.Add("id", id);
if (SnoozeMode.HasValue)
cmd.Parameters.Add("value", SnoozeMode.Value.ToString());
PostgreSQLConn.ExecuteNonQuery(cmd, Parent.CurrentUser);
//Save to Cache
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeMode, id, Cache.DefaultSettingsValidationTime)] = SnoozeMode;
}
}
}
