public void UpdateStatus(DeviceDto _deviceDto, int nPort) { try { //amit 14112016 if (Storage.IsLogEnable == "1") { string Message = "Camera Status Service UpdateStatus():DeviceID" + _deviceDto.DeviceId + "--Port:" + nPort; InsertBrokerOperationLog.AddProcessLog(Message); } var nvrCamera = _deviceDto as NvrCameraDto; bool camStatus = IsDeviceAlive(nvrCamera.CameraIp, nPort); if (camStatus != null) { using (var ctx = new CentralDBEntities()) { var nDeviceEntry = ctx.tblCameraStatus.FirstOrDefault(x => x.DeviceID == nvrCamera.DeviceId); if (nDeviceEntry != null)//Entry exist { nDeviceEntry.Status = camStatus; ctx.SaveChanges(); } else { int camID = Int32.Parse(_deviceDto.DeviceId.ToString()); var cameraStatus = new AMS.Broker.DataStore.tblCameraStatus { Status = camStatus, DeviceID = camID }; ctx.tblCameraStatus.Add(cameraStatus); ctx.SaveChanges(); } } }// //TestFile(nvrCamera); } catch (Exception ex) { //amit 14112016 if (Storage.IsLogEnable == "1") { string Message = "CameraStatusService UpdateStatus() Exception" + ex.Message; InsertBrokerOperationLog.AddProcessLog(Message); } _logger.Info("CameraStatusService UpdateStatus() Exception" + ex.Message); } }
public void UpdateCameraStatusold() { try { using (var context = new CentralDBEntities()) { // _logger.Info(""); _logger.Info("CameraStatus: GetNVRCameraCollection"); var resultsCollection = context.Device; var result2 = resultsCollection.Select(x => x).ToArray(); // var result = resultsCollection.Select(DeviceDto,resultsCollection).ToArray(); var result = result2.Select(Mapper.Map <DeviceDto>).ToArray(); foreach (var deviceDto in result) { if (deviceDto is NvrCameraDto) { try { //create rtsp url var nvrCamera = deviceDto as NvrCameraDto; if (nvrCamera.CameraIp != null && nvrCamera.CameraIp != "") { int nPort = 554; if (nvrCamera.CameraPort != null || nvrCamera.CameraPort != "") { nPort = int.Parse(nvrCamera.CameraPort); } //string camUrl = "rtsp://*****:*****@" + nvrCamera.CameraIp + ":554/Streaming/Channels/2"; //check status of camera bool camStatus = IsDeviceAlive(nvrCamera.CameraIp, nPort); //check the entry in tblCameraStatus /*if (nvrCamera.DeviceId == 331) * { * * }*/ if (camStatus != null) { using (var ctx = new CentralDBEntities()) { var nDeviceEntry = ctx.tblCameraStatus.FirstOrDefault(x => x.DeviceID == nvrCamera.DeviceId); if (nDeviceEntry != null)//Entry exist { nDeviceEntry.Status = camStatus; ctx.SaveChanges(); } else { int camID = Int32.Parse(deviceDto.DeviceId.ToString()); var cameraStatus = new AMS.Broker.DataStore.tblCameraStatus { Status = camStatus, DeviceID = camID }; ctx.tblCameraStatus.Add(cameraStatus); ctx.SaveChanges(); } } } } } catch (Exception ex) { _logger.Info("CameraStatusService UpdateCameraStatusold() Exception" + ex.Message); string Message = "CameraStatusService UpdateCameraStatusold() Exception" + ex.Message; InsertBrokerOperationLog.AddProcessLog(Message); } /*var camCollection = context.tblCameraStatus.Where(x => x.DeviceID == deviceDto.DeviceId); * * var results = camCollection.Select(x => x).ToArray(); * * var resultCam = results.Select(Mapper.Map<tblCameraStatusDto>).ToArray(); * * int camID = Int32.Parse(deviceDto.DeviceId.ToString()); * * if (resultCam.Count() == 0) * { * //insert * var cameraStatus = new tblCameraStatus * { * Status = camStatus, * DeviceID = camID * }; * context.tblCameraStatus.Add(cameraStatus); * context.SaveChanges(); * } * else * { * //update * AMS.Broker.DataStore.tblCameraStatus camsta = (from x in context.tblCameraStatus where x.DeviceID == camID select x).First(); * camsta.Status = camStatus; * context.SaveChanges(); * } */ //update into db } } } } catch (Exception ex) { _logger.Info("CameraStatusService UpdateCameraStatusold() Exception" + ex.Message); string Message = "CameraStatusService UpdateCameraStatusold() Exception1" + ex.Message; InsertBrokerOperationLog.AddProcessLog(Message); } }