public async Task <IActionResult> PutAcObject([FromRoute] int id, [FromBody] AcObject acObject) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != acObject.ObjId) { return(BadRequest()); } _context.Entry(acObject).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AcObjectExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void UpdateDisplayName() { switch (AcObject.GetType().Name) { case nameof(CarObject): DisplayName = "Car: " + AcObject.DisplayName; break; case nameof(CarSkinObject): DisplayName = "Skin: " + AcObject.DisplayName; break; case nameof(TrackObject): case nameof(TrackExtraLayoutObject): case nameof(TrackObjectBase): DisplayName = "Track: " + AcObject.Name; break; case nameof(WeatherObject): DisplayName = "Weather: " + AcObject.DisplayName; break; default: DisplayName = AcObject.DisplayName; break; } }
public async Task <IActionResult> PostAcObject([FromBody] AcObject acObject) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.AcObject.Add(acObject); await _context.SaveChangesAsync(); return(CreatedAtAction("GetAcObject", new { id = acObject.ObjId }, acObject)); }
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 static void GetValidationList(this AcObject source) { Console.WriteLine(source.Id); }
//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); }