public List <ObjectsWithLogData> getObjectsLastOpened() { List <FilterEventLogDto> lastOpened = (from evl in _context.AcEventLog join evs in _context.AcEventStatus on evl.EvlEvsId equals evs.EvsId join obj1 in _context.AcObject on evl.EvlObjId equals obj1.ObjId into AcObject from obj in AcObject.DefaultIfEmpty() join usr1 in _context.AcUser on evl.EvlUsrId equals usr1.UsrId into AcUser from usr in AcUser.DefaultIfEmpty() join trt in _context.AcTriggerType on evl.EvlTrtId equals trt.TrtId where evl.EvlObjId != null && (from log2 in _context.AcEventLog where log2.EvlObjId == evl.EvlObjId && log2.EvlEvsId == 10 orderby log2.EvlDate descending select log2.EvlId ).First().Equals(evl.EvlId) select new FilterEventLogDto { EventLogId = evl.EvlId, Date = evl.EvlDate, TriggerValue = evl.EvlTrgValue, UserName = usr.UsrName, UserSurname = usr.UsrSurname, TriggerName = trt.TrtName, ObjectName = obj.ObjName, EventStatusName = evs.EvsName, ObjectId = evl.EvlObjId }).ToList(); List <ObjectsWithLogData> lstt = (from obj in _context.AcObject join lst in lastOpened on obj.ObjId equals lst.ObjectId into lstl from v in lstl.DefaultIfEmpty() select new ObjectsWithLogData { ObjId = obj.ObjId, ObjName = obj.ObjName, ObjOpen = obj.ObjOpen, ObjAuto = obj.ObjAuto, ObjActivity = obj.ObjActivity, ObjGps = obj.ObjGps, ObjAction = obj.ObjAction, ObjObtTypeId = obj.ObjObtTypeId, Date = v.Date, TriggerValue = v.TriggerValue, UserName = v.UserName, UserSurname = v.UserSurname, TriggerName = v.TriggerName, EventStatusName = v.EventStatusName }).ToList(); return(lstt); }
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); }
//public List<ObjectsWithLogData> getObjects() //{ //List<ObjectsWithLogData> Allobjects = ( // from evl in _context.AcEventLog // join evs in _context.AcEventStatus on evl.EvlEvsId equals evs.EvsId // join obj1 in _context.AcObject on evl.EvlObjId equals obj1.ObjId into AcObject // from obj in AcObject.DefaultIfEmpty() // join usr1 in _context.AcUser on evl.EvlUsrId equals usr1.UsrId into AcUser // from usr in AcUser.DefaultIfEmpty() // join trt in _context.AcTriggerType on evl.EvlTrtId equals trt.TrtId // where req.ObjId == evl.evlObjId // select new ObjectsWithLogData // { // EventLogId = evl.EvlId, // Date = evl.EvlDate, // TriggerValue = evl.EvlTrgValue, // UserName = usr.UsrName, // UserSurname = usr.UsrSurname, // TriggerName = trt.TrtName, // ObjectName = obj.ObjName, // EventStatusName = evs.EvsName // } //).OrderByDescending(x => x.Date).ToList(); //return Allobjects; //} public List <FilterEventLogDto> getEventLogs(int?id) { List <FilterEventLogDto> eventLogs = ( from evl in _context.AcEventLog join evs in _context.AcEventStatus on evl.EvlEvsId equals evs.EvsId join obj1 in _context.AcObject on evl.EvlObjId equals obj1.ObjId into AcObject from obj in AcObject.DefaultIfEmpty() join usr1 in _context.AcUser on evl.EvlUsrId equals usr1.UsrId into AcUser from usr in AcUser.DefaultIfEmpty() join trt in _context.AcTriggerType on evl.EvlTrtId equals trt.TrtId where id == null || evl.EvlUsrId == id select new FilterEventLogDto { EventLogId = evl.EvlId, Date = evl.EvlDate, TriggerValue = evl.EvlTrgValue, UserName = usr.UsrName, UserSurname = usr.UsrSurname, TriggerName = trt.TrtName, ObjectName = obj.ObjName, EventStatusName = evs.EvsName } ).OrderByDescending(x => x.Date).ToList(); return(eventLogs); }