public bool IsPatrolAvailable(Guid patrolOriginalId) { try { if (dbContext == null) { dbContext = new TFMEntities(); } var incident = dbContext.TFMIncidents.Where(x => x.CurrentStatusId != 4 && x.PatrolId == patrolOriginalId).FirstOrDefault(); if (incident != null) { return(false); } var duty = dbContext.iPatrolDuties.Where(x => x.PatrolId == patrolOriginalId && x.FinishTime == null).FirstOrDefault(); if (duty != null) { return(false); } return(true); } catch (Exception ex) { Utility.WriteLog(ex); return(true); } }
public TFMMediaDTO GetTaskMedia(long taskId) { try { dbContext = new TFMEntities(); TFMMediaDTO dto = new TFMMediaDTO(); var task = dbContext.iPatrolDuties.Where(x => x.Id == taskId).FirstOrDefault(); if (task == null) { return(null); } var taskUser = dbContext.iPatrolDutiesUsers.Where(x => x.DutyId == taskId).FirstOrDefault(); if (taskUser != null && dbContext.iPatrolFilesSubmittedByUsers.Any(x => x.StaffId == taskUser.StaffId)) { var files = dbContext.iPatrolFilesSubmittedByUsers.Where(x => x.StaffId == taskUser.StaffId).ToList(); foreach (var item in files) { } } return(dto); } catch (Exception ex) { Utility.WriteLog(ex); return(null); } }
public Transporter GetPatrolById(Guid PatrolId) { try { dbContext = new TFMEntities(); var patrol = dbContext.Transporters.Where(x => x.ID == PatrolId).FirstOrDefault(); return(patrol); } catch (Exception ex) { return(null); } }
public List <string> GetTaskImagesURLs(long taskId) { Utility.WriteLog("Invokation Started"); List <string> urls = new List <string>(); try { string Environment = ConfigurationManager.AppSettings["Environment"]; Utility.WriteLog(Environment); if (Environment != "Production") { string imagesURL = baseURL + @"12345/Images"; Utility.WriteLog(imagesURL); if (Directory.Exists(imagesURL)) { string[] dirImages = Directory.GetFiles(imagesURL); if (dirImages != null && dirImages.Length > 0) { foreach (var imageURL in dirImages) { Image img = Image.FromFile(imageURL); if (img != null) { using (MemoryStream m = new MemoryStream()) { img.Save(m, img.RawFormat); byte[] imageBytes = m.ToArray(); if (imageBytes != null && imageBytes.Length > 0) { string b64String = Convert.ToBase64String(imageBytes); Utility.WriteLog(b64String); urls.Add(b64String); } } } } return(urls); } } } } catch (Exception ex) { Utility.WriteLog(ex); } try { Utility.WriteLog("Production Environment"); dbContext = new TFMEntities(); Utility.WriteLog(taskId.ToString()); iPatrolDuty task = new iPatrolDuty(); task = dbContext.iPatrolDuties.Where(x => x.Id == taskId).FirstOrDefault(); if (task == null) { Utility.WriteLog("Task Is Null"); return(null); } var nexttask = dbContext.iPatrolDuties.Where(t => t.Id > task.Id).OrderBy(t => t.Id).FirstOrDefault(); Utility.WriteLog("Task Is Not Null"); var taskUser = dbContext.iPatrolDutiesUsers.Where(x => x.DutyId == taskId).FirstOrDefault(); if (taskUser != null && dbContext.iPatrolFilesSubmittedByUsers.Any(x => x.StaffId == taskUser.StaffId)) { var files = dbContext.iPatrolFilesSubmittedByUsers.Where(x => x.StaffId == taskUser.StaffId).ToList(); foreach (var fileObj in files) { string imagesURL = baseURL + fileObj.FileId.ToString() + @"/Images"; Utility.WriteLog("Base URL Is: " + imagesURL); if (Directory.Exists(imagesURL)) { string[] dirImages = Directory.GetFiles(imagesURL); if (dirImages != null && dirImages.Length > 0) { foreach (var imageURL in dirImages) { Utility.WriteLog(imageURL); Image img = Image.FromFile(imageURL); if (img != null) { DateTime fileDate = default(DateTime); DateTime nextTaskDate = DateTime.Now; try { fileDate = File.GetCreationTime(imageURL); if (nexttask != null) { nextTaskDate = nexttask.Date.HasValue ? nexttask.Date.Value : DateTime.Now; } } catch { } if (fileDate >= task.Date && fileDate <= nextTaskDate) { using (MemoryStream m = new MemoryStream()) { img.Save(m, img.RawFormat); byte[] imageBytes = m.ToArray(); if (imageBytes != null && imageBytes.Length > 0) { string b64String = Convert.ToBase64String(imageBytes); Utility.WriteLog(b64String); urls.Add(b64String); } } } } else { Utility.WriteLog("Image Could not be created!"); } } } else { Utility.WriteLog("Directory Is Empty!"); } } } } else { Utility.WriteLog("Task User Is NULL"); } return(urls); } catch (Exception ex) { Utility.WriteLog(ex); return(null); } }
public List <string> GetTaskVideosURLs(long taskId) { List <string> urls = new List <string>(); try { string Environment = ConfigurationManager.AppSettings["Environment"]; if (Environment != "Production") { string imagesURL = baseURL + @"12345/Video"; if (Directory.Exists(imagesURL)) { string[] dirImages = Directory.GetFiles(imagesURL); if (dirImages != null && dirImages.Length > 0) { foreach (var imageURL in dirImages) { byte[] videoArray = File.ReadAllBytes(imageURL); if (videoArray != null && videoArray.Length > 0) { string b64String = Convert.ToBase64String(videoArray); Utility.WriteLog(b64String); urls.Add(b64String); } } return(urls); } } } } catch (Exception ex) { Utility.WriteLog(ex); } try { dbContext = new TFMEntities(); var task = dbContext.iPatrolDuties.Where(x => x.Id == taskId).FirstOrDefault(); if (task == null) { return(null); } var nexttask = dbContext.iPatrolDuties.Where(t => t.Id > task.Id).OrderBy(t => t.Id).FirstOrDefault(); var taskUser = dbContext.iPatrolDutiesUsers.Where(x => x.DutyId == taskId).FirstOrDefault(); if (taskUser != null && dbContext.iPatrolFilesSubmittedByUsers.Any(x => x.StaffId == taskUser.StaffId)) { var files = dbContext.iPatrolFilesSubmittedByUsers.Where(x => x.StaffId == taskUser.StaffId).ToList(); foreach (var fileObj in files) { string imagesURL = baseURL + fileObj.FileId.ToString() + @"/Video"; if (Directory.Exists(imagesURL)) { string[] dirImages = Directory.GetFiles(imagesURL); if (dirImages != null && dirImages.Length > 0) { foreach (var imageURL in dirImages) { DateTime fileDate = default(DateTime); DateTime nextTaskDate = DateTime.Now; try { fileDate = File.GetCreationTime(imageURL); if (nexttask != null) { nextTaskDate = nexttask.Date.HasValue ? nexttask.Date.Value : DateTime.Now; } } catch { } if (fileDate >= task.Date && fileDate <= nextTaskDate) { byte[] videoArray = File.ReadAllBytes(imageURL); if (videoArray != null && videoArray.Length > 0) { string b64String = Convert.ToBase64String(videoArray); Utility.WriteLog(b64String); urls.Add(b64String); } } } } } } } return(urls); } catch (Exception ex) { Utility.WriteLog(ex); return(null); } }