Beispiel #1
0
        public void Update(int userId, int triggerTypeId, string triggerValue, byte trgActivity)
        {
            AcTrigger trg = new AcTrigger
            {
                TrgUsrId    = userId,
                TrgTrtId    = triggerTypeId,
                TrgValue    = triggerValue,
                TrgActivity = trgActivity
            };

            _context.AcTrigger.Update(trg);
            _context.SaveChanges();
        }
Beispiel #2
0
        public UserTrigger getUserByTriggerType(string value, string type)
        {
            UserTrigger userTrigger = (
                from trgt in _context.AcTriggerType
                join trg in _context.AcTrigger on new { Key1 = trgt.TrtId, Key2 = value } equals new { Key1 = trg.TrgTrtId, Key2 = trg.TrgValue } into AcTrigger
                from q in AcTrigger.DefaultIfEmpty() join us in _context.AcUser on q.TrgUsrId equals us.UsrId into AcUser
                from l in AcUser.DefaultIfEmpty()
                where trgt.TrtName == type
                select new UserTrigger
            {
                TrgtId = trgt.TrtId,
                UsrId = q.TrgUsrId,
                TrgActivity = q.TrgActivity,
                UsrActivity = l.UsrActivity
            }
                ).SingleOrDefault();

            return(userTrigger);
        }