/// <summary> /// Register new event /// </summary> /// <param name="name">Event Name</param> public static void register(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) { trigger = new XpoSQLTriggerInfo(UpdateSession); trigger.triggerName = name; trigger.timestamp = (DateTime)UpdateSession.Evaluate(typeof(XPObjectType), new FunctionOperator(FunctionOperatorType.Now), null); trigger.Save(); } else { trigger.Reload(); } }
/// <summary> /// Register new event /// </summary> /// <param name="name">Event Name</param> public static void register(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) { trigger = new XpoSQLTriggerInfo(UpdateSession); trigger.triggerName = name; trigger.timestamp = (DateTime)UpdateSession.Evaluate(typeof(XPObjectType), new FunctionOperator(FunctionOperatorType.Now), null); trigger.Save(); } else trigger.Reload(); }