internal static void DeleteOldEvents(DateTime now)
{
using (var context = new DataHandler())
{
context.ExecuteCommand(String.Format("DELETE FROM [Messaging.Events] WHERE [When] < '{0}'", now.AddMonths(-2).ToString("yyyy-MM-dd HH:mm:ss")));
}
}
internal static void DeleteAllMessages()
{
using (var context = new DataHandler())
{
context.ExecuteCommand("DELETE FROM [Messaging.Messages]");
}
}
internal static void DeleteAllEvents()
{
using (var context = new DataHandler())
{
context.ExecuteCommand("DELETE FROM [Messaging.Events]");
}
}
internal static void Reset()
{
using (var context = new DataHandler())
{
context.ExecuteCommand("DELETE FROM [Messaging.LastProcessTime]");
}
}
public static void DeleteAllSubscriptions()
{
using (var context = new DataHandler())
{
context.ExecuteCommand("DELETE FROM [Messaging.Subscriptions]");
}
}
public static void DeleteAllSubscriptions()
{
using (var context = new DataHandler())
{
context.ExecuteCommand("DELETE FROM [Messaging.Subscriptions]");
}
}
internal static void DeleteOldEvents(DateTime now)
{
using (var context = new DataHandler())
{
context.ExecuteCommand(String.Format("DELETE FROM [Messaging.Events] WHERE [When] < '{0}'", now.AddMonths(-2).ToString("yyyy-MM-dd HH:mm:ss")));
}
}
internal static void Reset()
{
using (var context = new DataHandler())
{
context.ExecuteCommand("DELETE FROM [Messaging.LastProcessTime]");
}
}
