public DeviceStatusCache GetDeviceStatusHistoryLastValue(string ip) { DeviceStatusHistoryLastValue lastValue = Entities.DeviceStatusHistoryLastValues.FirstOrDefault(x => x.IPAddress == ip); DeviceStatu deviceStatu = Entities.DeviceStatus.FirstOrDefault(x => x.StatusId == lastValue.StatusId); DeviceStatusCache statusCache = new DeviceStatusCache(deviceStatu.StatusId, deviceStatu.Status, deviceStatu.Description, (StatusColor)deviceStatu.StatusColor, ip); return(statusCache); }
public bool AddNewDeviceStatusLastRecord(string ip, int statusId) { DeviceStatusHistoryLastValue lastValue = Entities.DeviceStatusHistoryLastValues.FirstOrDefault(x => x.IPAddress == ip); lastValue.StatusId = statusId; lastValue.Date = DateTime.Now; if (Entities.SaveChanges() > 0) { return(true); } return(false); }