Exemple #1
0
        /// <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();
        }