private void FillArchives() { List<CodeITDL.User> UsersFromEntity = new List<CodeITDL.User>(); List<CodeITDL.File> FilesFromEntity = new List<CodeITDL.File>(); try { using (CodeITDL.CodeITDbContext ctx = new CodeITDL.CodeITDbContext(Context.UserId)) { UsersFromEntity = ctx.Users.ToList(); FilesFromEntity = ctx.Files.ToList(); } if (FilesFromEntity.Count > 0) { DateTime limit = DateTime.Now.AddDays(6).Date; List<CodeITDL.File> uploadedFiles = new List<CodeITDL.File>(); bool isCloud = CodeITLicence.Licence.StorageType == CodeITLicence.StorageType.Cloud ? true : false; if (Context.getCurrentUser.RoleId != (int)Role.Administrator) { uploadedFiles = FilesFromEntity.Where(x => x.UserId == Context.UserId && x.OriginalFileDate <= limit && x.IsCloudFileSystem == isCloud).OrderByDescending(x => x.CreatedOn).ToList(); } else { uploadedFiles = FilesFromEntity.Where(x => x.OriginalFileDate <= limit && x.IsCloudFileSystem == isCloud && UsersFromEntity.Where(y => y.CustomerId == Context.CustomerId).Select(y => y.Id).Contains(x.UserId)).OrderByDescending(x => x.CreatedOn).ToList(); } List<CodeITDL.User> users = UsersFromEntity.Where(x => x.CustomerId == Context.CustomerId).ToList(); if (uploadedFiles != null && uploadedFiles.Count > 0) { for (int i = 0; i < uploadedFiles.Count; i++) { FileFromDB file = new FileFromDB(uploadedFiles[i], i); file.UserName = (file.UserId == Context.UserId ? (Context.getCurrentUser.FirstName + " " + Context.getCurrentUser.LastName) : UsersFromEntity.Where(u => u.Id == file.UserId).Select(u => (u.FirstName + " " + u.LastName)).FirstOrDefault()); files.Add(file); } } } } catch (Exception ex) { _logger.Error(ex.Message); } }
private void FillArchivesFromSearch() { List<CodeITDL.User> UsersFromEntity = new List<CodeITDL.User>(); List<CodeITDL.File> FilesFromEntity = new List<CodeITDL.File>(); try { ((frmUserMainScreen)this.ParentForm).performResize(); Cursor.Current = Cursors.WaitCursor; List<int> users = new List<int>(); files = new List<FileFromDB>(); using (CodeITDL.CodeITDbContext ctx = new CodeITDL.CodeITDbContext(Context.UserId)) { UsersFromEntity = ctx.Users.ToList(); FilesFromEntity = ctx.Files.ToList(); } bool isCloud = CodeITLicence.Licence.StorageType == CodeITLicence.StorageType.Cloud ? true : false; if (Context.getCurrentUser.RoleId != (int)Role.Administrator) users.Add(Context.UserId); else { users = UsersFromEntity.Where(x => x.CustomerId == Context.CustomerId && (x.Id == (int)cbName.SelectedValue || (int)cbName.SelectedValue == -1)).Select(x => x.Id).ToList(); } List<CodeITDL.File> tmpList = new List<CodeITDL.File>(); DateTime to = dtpTo.Value.Date.AddHours(23).AddMinutes(59); if (cbSearchBy.SelectedIndex == 0) { tmpList = FilesFromEntity.Where(x => x.OriginalFileDate >= dtpFrom.Value.Date && x.OriginalFileDate <= to && x.IsCloudFileSystem == isCloud && users.Contains(x.UserId)).OrderBy(x => x.NewFileName).ThenBy(x=>x.CreatedOn.Date).ToList(); } else { tmpList = FilesFromEntity.Where(x => x.CreatedOn >= dtpFrom.Value.Date && x.CreatedOn <= to && x.IsCloudFileSystem == isCloud && users.Contains(x.UserId)).OrderBy(x => x.NewFileName).ThenBy(x => x.CreatedOn.Date).ToList(); } if (tmpList != null && tmpList.Count > 0) { for (int i = 0; i < tmpList.Count; i++) { FileFromDB fileDb = new FileFromDB(tmpList[i], i); fileDb.UserName = (fileDb.UserId == Context.UserId ? (Context.getCurrentUser.FirstName + " " + Context.getCurrentUser.LastName) : UsersFromEntity.Where(u => u.Id == fileDb.UserId).Select(u => (u.FirstName + " " + u.LastName)).FirstOrDefault()); files.Add(fileDb); } } } catch (Exception ex) { } }
private void CheckForVideos(List<IDeviceObject> _files, User _uploadUser) { string lastFilename = ""; string newfilename = ""; try { if (_files != null && _files.Count > 0) { GoProVideos = new List<FileFromDB>(); for (int i = 0; i < _files.Count; i++) { var item = _files[i]; VideoInfo info = VideoInfo.GetVideoInfo(item.Id); FileFromDB file = new FileFromDB(); FileInfo fileInfo = new FileInfo(item.Id); file.OriginalFileDate = ((Device)_goproDevice).getFileCreationDate(item.Id); file.OriginalFileName = item.Name; file.OriginalFileLocation = item.Name; file.NewFileName = GetFilenameFormat(file.OriginalFileDate, file.OriginalFileName); fileNames.Add(file.NewFileName); file.CreatedOn = DateTime.Now; file.isFromCard = true; file.UserName = item.Name; if (info != null) { file.Duration = (int)info.Duration; file.Resolution = info.Resolution; } GoProVideos.Add(file); } ucUserVideos.lvItemsContainer.ContextMenu.Visibility = System.Windows.Visibility.Hidden; ucUserVideos.lvItemsContainer.ContextMenu.IsOpen = false; ucUserVideos.IsUpload = true; ucUserVideos.lvItemsContainer.ItemsSource = GoProVideos; if (ucUserVideos.itemContainer != null) { ucUserVideos.itemContainer.Width = pnlMain.Width - 21 > 0 ? pnlMain.Width - 21 : pnlMain.Width; } ucUserVideos.ContextMenuClick -= uv_ContextMenuClick; ucUserVideos.ContextMenuClick += uv_ContextMenuClick; } } catch (Exception) { } }