private void OnTimedEvent(object source, ElapsedEventArgs e)
{
// check all registered permissions...
DateTime?temp;
foreach (SQLTriggerEvent trigger in triggerList)
{
if ((temp = getSQLTriggerTime(trigger.name)) != trigger.timestamp)
{
trigger.timestamp = temp;
SQLTriggerEvent evnt = new SQLTriggerEvent();
evnt.name = trigger.name;
evnt.timestamp = temp;
context.Post(new SendOrPostCallback(delegate(object state)
{
SQLTriggerHandler handler = sqlTriggerEvent;
if (handler != null)
{
handler(this, evnt);
}
}), null);
}
}
}
/// <summary>
/// Register an event to watch for
/// </summary>
/// <param name="name">Event Name</param>
public void registerSQLTrigger(string name)
{
if (!UpdateSession.IsConnected)
{
UpdateSession.OptimisticLockingReadBehavior = OptimisticLockingReadBehavior.Ignore;
UpdateSession.LockingOption = LockingOption.None;
UpdateSession.Connect();
}
XpoSQLTriggerInfo trigger;
trigger = UpdateSession.FindObject <XpoSQLTriggerInfo>(CriteriaOperator.Parse("[triggerName] = '" + name + "'"));
if (trigger != null)
{
SQLTriggerEvent obj = new SQLTriggerEvent();
obj.name = trigger.triggerName;
obj.timestamp = trigger.timestamp;
triggerList.Add(obj);
}
}
private void OnTimedEvent(object source, ElapsedEventArgs e)
{
// check all registered permissions...
DateTime? temp;
foreach (SQLTriggerEvent trigger in triggerList)
{
if ((temp = getSQLTriggerTime(trigger.name)) != trigger.timestamp)
{
trigger.timestamp = temp;
SQLTriggerEvent evnt = new SQLTriggerEvent();
evnt.name = trigger.name;
evnt.timestamp = temp;
context.Post(new SendOrPostCallback(delegate(object state)
{
SQLTriggerHandler handler = sqlTriggerEvent;
if (handler != null)
{
handler(this, evnt);
}
}), null);
}
}
}
/// <summary>
/// Register an event to watch for
/// </summary>
/// <param name="name">Event Name</param>
public void registerSQLTrigger(string name)
{
if (!UpdateSession.IsConnected)
{
UpdateSession.OptimisticLockingReadBehavior = OptimisticLockingReadBehavior.Ignore;
UpdateSession.LockingOption = LockingOption.None;
UpdateSession.Connect();
}
XpoSQLTriggerInfo trigger;
trigger = UpdateSession.FindObject<XpoSQLTriggerInfo>(CriteriaOperator.Parse("[triggerName] = '" + name + "'"));
if (trigger != null)
{
SQLTriggerEvent obj = new SQLTriggerEvent();
obj.name = trigger.triggerName;
obj.timestamp = trigger.timestamp;
triggerList.Add(obj);
}
}