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);
}
