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