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