/// <summary>
/// Auther: Pankaj W.
/// Date :17-08-15
/// Reason : get lates max 5 screen shots based on id
/// </summary>
/// <param name="deviceId"></param>
/// <returns> list Tbl_ScreenshotDetails</returns>
public List <Models.Tbl_ScreenshotDetails> GetScreensByDeviceId(string deviceId, string fromDate, string toDate)
{
entity = new MonitoringSystemEntities();
DateTime dtTime = System.DateTime.Now;
//subtract 2 minutes from current time to check screnn shots from last 2 minutes for device
dtTime = dtTime.AddMinutes(-2);
try
{
if (string.IsNullOrEmpty(fromDate) || string.IsNullOrEmpty(toDate))
{
var v = (from t in entity.Tbl_Devices
join t1 in entity.Tbl_ScreenshotDetails on t.DeviceId equals t1.Fk_DeviceId
where t.DeviceId == deviceId //&& t1.CreatedDate >= dtTime
select t1).OrderByDescending(p => p.CreatedDate).Take(15);
return(v.ToList());
}
else
{
DateTime fromDatedate = Convert.ToDateTime(fromDate);
DateTime toDatedate = Convert.ToDateTime(toDate);
var v = (from t in entity.Tbl_Devices
join t1 in entity.Tbl_ScreenshotDetails on t.DeviceId equals t1.Fk_DeviceId
where t.DeviceId == deviceId && t1.CreatedDate >= fromDatedate && t1.CreatedDate <= toDatedate
select t1).OrderByDescending(p => p.CreatedDate);
return(v.ToList());
}
}
catch (Exception)
{
throw;
}
}
public void SaveImageToDb(string deviceId, string imageBas64)
{
int length = !string.IsNullOrEmpty(imageBas64) ? imageBas64.Length : 0;
entity = new MonitoringSystemEntities();
ETestApp.Models.Tbl_ScreenshotDetails screenObj = new ETestApp.Models.Tbl_ScreenshotDetails();
screenObj.CreatedDate = System.DateTime.Now;
if (length > 20000)
{
screenObj.Screenshot1 = imageBas64.Substring(0, 20000);
}
if (length < 20000)
{
screenObj.Screenshot1 = imageBas64.Substring(0, length);
}
if (length < 40000 && length > 20000)
{
screenObj.Screenshot2 = imageBas64.Substring(20000, (length - 20000));
}
if (length > 40000)
{
screenObj.Screenshot2 = imageBas64.Substring(20000, 20000);
}
if (length > 40000 && length < 60000)
{
screenObj.Screenshot3 = imageBas64.Substring(40000, (length - 40000));
}
if (length > 60000)
{
screenObj.Screenshot3 = imageBas64.Substring(40000, 20000);
}
if (length > 60000 && length < 80000)
{
screenObj.Screenshot4 = imageBas64.Substring(60000, (length - 60000));
}
if (length > 80000)
{
screenObj.Screenshot4 = imageBas64.Substring(60000, 20000);
}
if (length > 100000)
{
screenObj.Screenshot5 = imageBas64.Substring(80000, (length - 80000));
}
screenObj.Fk_DeviceId = deviceId;
screenObj.IsDeleted = false;
entity.Tbl_ScreenshotDetails.Add(screenObj);
entity.SaveChanges();
}
/// <summary>
/// Reason To get all devices
/// </summary>
/// <returns></returns>
public List <Models.Tbl_Devices> GetAllDevices()
{
entity = new MonitoringSystemEntities();
try
{
var v = (entity.Tbl_Devices.Where(p => p.IsDeleted == false)).Distinct();
return(v.ToList());
}
catch (Exception)
{
throw;
}
}
public void SaveImage(string deviceId, string imageBas64)
{
entity = new MonitoringSystemEntities();
Tbl_ScreenshotDetails screenObj = new Tbl_ScreenshotDetails();
screenObj.CreatedDate = System.DateTime.Now;
screenObj.Screenshot1 = imageBas64;
screenObj.Fk_DeviceId = deviceId;
screenObj.IsDeleted = false;
entity.Tbl_ScreenshotDetails.Add(screenObj);
entity.SaveChanges();
}
public Boolean setScreenshotInterval(string deviceId, int interval)
{
entity = new MonitoringSystemEntities();
try
{
var v = (entity.Tbl_Devices.Where(p => p.DeviceId == deviceId && p.IsDeleted == false)).FirstOrDefault();
if (v == null)
{
return(false);
}
v.ScreenshotInterval = interval;
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public void SaveDeviceIfNotExists(DevicesDetails devObj)
{
try
{
entity = new MonitoringSystemEntities();
var v = entity.Tbl_Devices.Where(p => p.DeviceId.Equals(devObj.deviceId)).FirstOrDefault();
if (v != null)
{
return;
}
entity.Tbl_Devices.Add(PrepareDeviceDataModel(devObj));
entity.SaveChanges();
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Auther : Pankaj W.
/// Date Get all online devices which are having screen shot in last 2 minutes
/// </summary>
/// <returns></returns>
public List <Models.Tbl_Devices> GetAllOnlineDevices()
{
entity = new MonitoringSystemEntities();
DateTime dtTime = System.DateTime.Now;
int val = 312222;
dtTime = dtTime.AddMinutes(-val);
try
{
var v = (from t in entity.Tbl_Devices
join t1 in entity.Tbl_ScreenshotDetails on t.DeviceId equals t1.Fk_DeviceId
where t1.CreatedDate >= dtTime
select t).Distinct();
return(v.ToList());
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Auther: Pankaj W.
/// Date :17-08-15
/// Reason : get lates max 5 screen shots based on id
/// </summary>
/// <param name="deviceId"></param>
/// <returns> list Tbl_ScreenshotDetails</returns>
public List <ETestApp.Models.Tbl_ScreenshotDetails> GetScreensByDeviceId(string deviceId)
{
entity = new MonitoringSystemEntities();
DateTime dtTime = System.DateTime.Now;
//subtract 2 minutes from current time to check screnn shots from last 2 minutes for device
dtTime = dtTime.AddMinutes(-2);
try
{
var v = (from t in entity.Tbl_Devices
join t1 in entity.Tbl_ScreenshotDetails on t.DeviceId equals t1.Fk_DeviceId
where t.DeviceId == deviceId //&& t1.CreatedDate >= dtTime
select t1).OrderByDescending(p => p.CreatedDate).Take(15);
return(v.ToList());
}
catch (Exception)
{
throw;
}
}
public void UpdateImageObj(ScreenshotDetails scrnObj)
{
try
{
entity = new MonitoringSystemEntities();
var screenObj = entity.Tbl_ScreenshotDetails.Where(p => p.Fk_DeviceId.Equals(scrnObj.fk_DeviceId) && p.Id == scrnObj.id && p.IsDeleted == false).FirstOrDefault();
if (screenObj == null)
{
return;
}
screenObj.Screenshot4 = scrnObj.screenshot4;
screenObj.Screenshot5 = scrnObj.screenshot5;
entity.SaveChanges();
}
catch (Exception)
{
throw;
}
}
public void UpdateDeviceIfNotExists(DevicesDetails devObj)
{
try
{
entity = new MonitoringSystemEntities();
var dev = entity.Tbl_Devices.Where(p => p.DeviceId.Equals(devObj.deviceId) && p.IsDeleted == false).FirstOrDefault();
if (dev == null)
{
return;
}
dev.DeviceIp = devObj.deviceId;
dev.ScreenshotInterval = devObj.screenshotInterval;
entity.SaveChanges();
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Reason To get Interval
/// </summary>
/// <param name="deviceId"></param>
/// <returns></returns>
public int GetInterval(string deviceId)
{
try
{
entity = new MonitoringSystemEntities();
var v = entity.Tbl_Devices.Where(p => p.DeviceId == deviceId && p.IsDeleted == false).FirstOrDefault();
if (v == null)
{
return(5);//default interval
}
else
{
return(v.ScreenshotInterval != null?Convert.ToInt32(v.ScreenshotInterval) : 5);
}
}
catch (Exception)
{
throw;
}
}
public Int64 SaveImageObj(ScreenshotDetails scrnObj)
{
try
{
entity = new MonitoringSystemEntities();
Tbl_ScreenshotDetails screenObj = new Tbl_ScreenshotDetails();
screenObj.CreatedDate = System.DateTime.Now;
screenObj.Screenshot1 = scrnObj.screenshot1;
screenObj.Screenshot2 = scrnObj.screenshot2;
screenObj.Screenshot3 = scrnObj.screenshot3;
screenObj.Screenshot4 = scrnObj.screenshot4;
screenObj.Screenshot5 = scrnObj.screenshot5;
screenObj.Fk_DeviceId = scrnObj.fk_DeviceId;
screenObj.IsDeleted = scrnObj.isDeleted;
entity.Tbl_ScreenshotDetails.Add((screenObj));
entity.SaveChanges();
return(screenObj.Id);
}
catch (Exception)
{
throw;
}
}
