Entity Framework ORM
The FileManager control allows you to manage file system items that use the Entity Framework ORM to link to a database. You can use the Remote File System Provider to connect to the file system on the client side. To process the control's HTTP requests on the server, create your own file system provider, which implements the IFileSystemItemLoader and IFileSystemItemEditor interfaces.
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
@(Html.DevExtreme().FileManager()
.CurrentPath("Documents/Reports")
.FileSystemProvider(provider => provider.Remote()
.Url(Url.RouteUrl("FileManagerDBProviderApi")))
.Permissions(permissions => permissions
.Create(true)
.Copy(true)
.Move(true)
.Delete(true)
.Rename(true))
.ItemView(itemView => {
itemView.Details(details => {
details.Columns(columns => {
columns.Add().DataField("thumbnail");
columns.Add().DataField("name");
columns.Add().DataField("dateModified").Caption("Modified");
columns.Add().DataField("created").Caption("Created").DataType(GridColumnDataType.Date);
columns.Add().DataField("modifiedBy").Caption("Modified By").VisibleIndex(2);
});
});
})
.AllowedFileExtensions(new string[0])
.Height(550))
using DevExtreme.NETCore.Demos.Models.FileManagement;
using Microsoft.AspNetCore.Mvc;
namespace DevExtreme.NETCore.Demos.Controllers {
public class FileManagerController : Controller {
public IActionResult BindingToEF() {
return View();
}
}
}
using DevExtreme.AspNet.Mvc.FileManagement;
using DevExtreme.NETCore.Demos.Models.FileManagement;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.AspNetCore.Mvc;
using System;
namespace DevExtreme.NETCore.Demos.Controllers {
public class FileManagerDbProviderApiController : Controller {
public FileManagerDbProviderApiController(DbFileProvider dbFileProvider) {
DBFileProvider = dbFileProvider ?? throw new ArgumentNullException(nameof(dbFileProvider));
}
DbFileProvider DBFileProvider { get; }
[Route("api/file-manager-db", Name = "FileManagerDBProviderApi")]
public IActionResult Process(FileSystemCommand command, string arguments) {
var config = new FileSystemConfiguration {
Request = Request,
FileSystemProvider = DBFileProvider,
AllowCopy = true,
AllowCreate = true,
AllowMove = true,
AllowDelete = true,
AllowRename = true,
AllowedFileExtensions = new string[0]
};
var processor = new FileSystemCommandProcessor(config);
var result = processor.Execute(command, arguments);
return Ok(result.GetClientCommandResult());
}
}
}
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using DevExtreme.AspNet.Mvc.FileManagement;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Caching.Memory;
namespace DevExtreme.NETCore.Demos.Models.FileManagement {
public class DbFileProvider : IFileSystemItemLoader, IFileSystemItemEditor {
const int GuestPersonId = 1;
public DbFileProvider(FileManagementDbContext fileManagementDbContext, IHttpContextAccessor contextAccessor, IMemoryCache memoryCache) {
FileManagementDbContext = new InMemoryFileManagementDataContext(fileManagementDbContext, contextAccessor, memoryCache);
}
InMemoryFileManagementDataContext FileManagementDbContext { get; }
public IEnumerable<FileSystemItem> GetItems(FileSystemLoadItemOptions options) {
int parentId = ParseKey(options.Directory.Key);
var fileItems = GetDirectoryContents(parentId);
var hasSubDirectoriesInfo = GetHasSubDirectoriesInfo(fileItems);
var clientItemList = new List<FileSystemItem>();
foreach(var item in fileItems) {
var clientItem = new FileSystemItem {
Key = item.Id.ToString(),
Name = item.Name,
IsDirectory = item.IsDirectory,
DateModified = item.Modified
};
if(item.IsDirectory) {
clientItem.HasSubDirectories = hasSubDirectoriesInfo.ContainsKey(item.Id) && hasSubDirectoriesInfo[item.Id];
}
clientItem.CustomFields["modifiedBy"] = item.ModifiedBy.FullName;
clientItem.CustomFields["created"] = item.Created;
clientItemList.Add(clientItem);
}
return clientItemList;
}
public void CreateDirectory(FileSystemCreateDirectoryOptions options) {
var parentDirectory = options.ParentDirectory;
if(!IsFileItemExists(parentDirectory))
ThrowItemNotFoundException(parentDirectory);
var directory = new FileItem {
Name = options.DirectoryName,
Modified = DateTime.Now,
Created = DateTime.Now,
IsDirectory = true,
ParentId = ParseKey(parentDirectory.Key),
ModifiedById = GuestPersonId
};
FileManagementDbContext.FileItems.Add(directory);
FileManagementDbContext.SaveChanges();
}
public void RenameItem(FileSystemRenameItemOptions options) {
var item = options.Item;
if(!IsFileItemExists(item))
ThrowItemNotFoundException(item);
var fileItem = GetFileItem(item);
fileItem.Name = options.ItemNewName;
fileItem.ModifiedById = GuestPersonId;
fileItem.Modified = DateTime.Now;
FileManagementDbContext.SaveChanges();
}
public void MoveItem(FileSystemMoveItemOptions options) {
var item = options.Item;
var destinationDirectory = options.DestinationDirectory;
if(!IsFileItemExists(item))
ThrowItemNotFoundException(item);
if(!IsFileItemExists(destinationDirectory))
ThrowItemNotFoundException(destinationDirectory);
if(!AllowCopyOrMove(item, destinationDirectory))
ThrowNoAccessException();
var fileItem = GetFileItem(item);
fileItem.ParentId = ParseKey(destinationDirectory.Key);
fileItem.Modified = DateTime.Now;
fileItem.ModifiedById = GuestPersonId;
FileManagementDbContext.SaveChanges();
}
public void CopyItem(FileSystemCopyItemOptions options) {
var item = options.Item;
var destinationDirectory = options.DestinationDirectory;
if(!IsFileItemExists(item))
ThrowItemNotFoundException(item);
if(!IsFileItemExists(destinationDirectory))
ThrowItemNotFoundException(destinationDirectory);
if(!AllowCopyOrMove(item, destinationDirectory))
ThrowNoAccessException();
var sourceFileItem = GetFileItem(item);
var copyFileItem = CreateCopy(sourceFileItem);
copyFileItem.ParentId = ParseKey(destinationDirectory.Key);
copyFileItem.Name = GenerateCopiedFileItemName(copyFileItem.ParentId, copyFileItem.Name, copyFileItem.IsDirectory);
FileManagementDbContext.FileItems.Add(copyFileItem);
if(copyFileItem.IsDirectory)
CopyDirectoryContentRecursive(sourceFileItem, copyFileItem);
FileManagementDbContext.SaveChanges();
}
void CopyDirectoryContentRecursive(FileItem sourcePathInfo, FileItem destinationPathInfo) {
foreach(var fileItem in GetDirectoryContents(sourcePathInfo.Id)) {
var copyItem = CreateCopy(fileItem);
copyItem.Parent = destinationPathInfo;
FileManagementDbContext.FileItems.Add(copyItem);
if(fileItem.IsDirectory)
CopyDirectoryContentRecursive(fileItem, copyItem);
}
}
public void DeleteItem(FileSystemDeleteItemOptions options) {
var item = options.Item;
if(!IsFileItemExists(item))
ThrowItemNotFoundException(item);
var fileItem = GetFileItem(item);
FileManagementDbContext.FileItems.Remove(fileItem);
if(fileItem.IsDirectory)
RemoveDirectoryContentRecursive(fileItem.Id);
FileManagementDbContext.SaveChanges();
}
void RemoveDirectoryContentRecursive(int parenDirectoryKey) {
var itemsToRemove = FileManagementDbContext
.FileItems
.Where(item => item.ParentId == parenDirectoryKey)
.Select(item => new FileItem {
Id = item.Id,
IsDirectory = item.IsDirectory
});
foreach(var item in itemsToRemove) {
FileManagementDbContext.FileItems.Remove(item);
}
foreach(var item in itemsToRemove) {
if(!item.IsDirectory) continue;
RemoveDirectoryContentRecursive(item.Id);
}
}
IEnumerable<FileItem> GetDirectoryContents(int parentKey) {
return FileManagementDbContext.FileItems
.OrderByDescending(item => item.IsDirectory)
.ThenBy(item => item.Name)
.Where(items => items.ParentId == parentKey);
}
IDictionary<int, bool> GetHasSubDirectoriesInfo(IEnumerable<FileItem> fileItems) {
var keys = fileItems.Select(i => i.Id).ToArray();
return FileManagementDbContext.FileItems
.Where(item => item.IsDirectory)
.GroupBy(i => i.ParentId)
.Where(i => keys.Contains(i.Key))
.ToDictionary(group => group.Key, group => group.Any());
}
FileItem GetFileItem(FileSystemItemInfo item) {
var itemId = ParseKey(item.Key);
return FileManagementDbContext.FileItems.FirstOrDefault(i => i.Id == itemId);
}
bool IsFileItemExists(FileSystemItemInfo itemInfo) {
var pathKeys = itemInfo.PathKeys.Select(key => ParseKey(key)).ToArray();
var foundEntries = FileManagementDbContext.FileItems
.Where(item => pathKeys.Contains(item.Id))
.Select(item => new { item.Id, item.ParentId, item.Name, item.IsDirectory });
var pathNames = itemInfo.Path.Split(new[] { Path.DirectorySeparatorChar }, StringSplitOptions.RemoveEmptyEntries);
var isDirectoryExists = true;
for(var i = 0; i < pathKeys.Length && isDirectoryExists; i++) {
var entry = foundEntries.FirstOrDefault(e => e.Id == pathKeys[i]);
isDirectoryExists = entry != null && entry.Name == pathNames[i] &&
(i == 0 && entry.ParentId == 0 || entry.ParentId == pathKeys[i - 1]);
if(isDirectoryExists && i < pathKeys.Length - 1)
isDirectoryExists = entry.IsDirectory;
}
return isDirectoryExists;
}
static bool AllowCopyOrMove(FileSystemItemInfo item, FileSystemItemInfo destinationDirectory) {
if(destinationDirectory.PathKeys.Length < item.PathKeys.Length)
return true;
var isValid = false;
for(var i = 0; i < destinationDirectory.PathKeys.Length && !isValid; i++) {
isValid = destinationDirectory.PathKeys[i] != item.PathKeys[i];
}
return isValid;
}
static FileItem CreateCopy(FileItem fileItem) {
return new FileItem {
Name = fileItem.Name,
Created = DateTime.Now,
Modified = DateTime.Now,
IsDirectory = fileItem.IsDirectory,
ModifiedById = GuestPersonId
};
}
static int ParseKey(string key) {
return string.IsNullOrEmpty(key) ? 0 : int.Parse(key);
}
string GenerateCopiedFileItemName(int parentDirKey, string copiedFileItemName, bool isDirectory) {
var dirNames = GetDirectoryContents(parentDirKey)
.Where(i => i.IsDirectory == isDirectory)
.Select(i => i.Name);
string newName;
var fileExtension = isDirectory ? "" : "." + Path.GetExtension(copiedFileItemName);
var copyNamePrefix =
isDirectory ? copiedFileItemName : Path.GetFileNameWithoutExtension(copiedFileItemName);
var index = -1;
do {
var pathPostfix = index < 1 ? string.Empty : $" {index}{fileExtension}";
newName = $"{copyNamePrefix} {(index < 0 ? "" : "copy")}{pathPostfix}";
index++;
} while(dirNames.Contains(newName));
return newName;
}
void ThrowItemNotFoundException(FileSystemItemInfo item) {
var itemType = item.IsDirectory ? "Directory" : "File";
var errorCode = item.IsDirectory ? FileSystemErrorCode.DirectoryNotFound : FileSystemErrorCode.FileNotFound;
string message = $"{itemType} '{item.Path}' not found.";
throw new FileSystemException(errorCode, message);
}
void ThrowNoAccessException() {
string message = "Access denied. The operation cannot be completed.";
throw new FileSystemException(FileSystemErrorCode.NoAccess, message);
}
}
}