public void Delete(DalFile entity)
{
if (entity == null)
{
return;
}
Delete(entity.Id);
}
public void AddFile(DalBook book, DalFile file)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
if (dbBook != null)
{
context.Files.Add(file.ToOrmFile());
}
}
public static ServiceFile ToServiceFile(this DalFile file)
{
return(new ServiceFile
{
ID = file.ID,
BookID = file.BookID,
Path = file.Path,
Format = file.Format,
});
}
public static Files ToOrmFile(this DalFile file)
{
return(new Files
{
FileID = file.ID,
BookID = file.BookID,
Path = file.Path,
Format = file.Format,
});
}
public void Create(DalFile entity)
{
var ormFile = entity?.ToOrmFile();
if (ormFile == null)
{
return;
}
Context.Set <File>()?.Add(ormFile);
}
public void Save(DalFile file)
{
using (var context = new FileStorageDbContext())
{
var oldFile = context.Files.Where(f => f.Name.Equals(file.Name) && f.Path.Equals(file.Path)).Select(f => f);
file.Id = oldFile.Count() != 0 ? oldFile.First().Id : Guid.NewGuid();
context.Files.RemoveRange(oldFile);
context.Files.Add(file.ToOrmFile());
context.SaveChanges();
}
}
public DalFile Create(DalFile entity)
{
if (ReferenceEquals(entity, null))
{
var error = new ArgumentNullException(nameof(entity), "parametr can't be null");
logger.Error(error, error.Message);
throw error;
}
var file = context.Set <Files>().Add(entity.ToOrmFile());
return(file.ToDalFile());
}
public void DeleteFile(DalFile file)
{
var dbFile = context.Files.FirstOrDefault(e => e.FileID == file.ID);
if (dbFile != null)
{
if (File.Exists(dbFile.Path))
{
File.Delete(dbFile.Path);
}
context.Files.Remove(dbFile);
}
}
public static FileEntity ToFileEntity(this DalFile dalFile)
{
return(new FileEntity()
{
Id = dalFile.Id,
IsPublic = dalFile.IsPublic,
Name = dalFile.Name,
OwnerId = dalFile.OwnerId,
Path = dalFile.Path,
Size = dalFile.Size,
UploadDate = dalFile.UploadDate
});
}
public static OrmFile ToOrmFile(this DalFile dalFile)
{
return(new OrmFile()
{
Id = dalFile.Id,
IsPublic = dalFile.IsPublic,
Name = dalFile.Name,
OwnerId = dalFile.OwnerId,
Path = dalFile.Path,
Size = dalFile.Size,
UploadDate = dalFile.UploadDate
});
}
public void CreateFile(int userId, string fileName, int fileExtensionId, int size, byte[] data)
{
var dalFile = new DalFile()
{
UserId = userId, Name = fileName, ExtensionId = fileExtensionId, Size = size, Data = data
};
UnitOfWork.FileRepository.Create(dalFile);
UnitOfWork.Commit();
var fileFromDb = UnitOfWork.FileRepository.GetAll().FirstOrDefault(file => file.Name == dalFile.Name);
Assert.AreEqual(fileFromDb?.Name, fileName);
}
public static File ToOrmFile(this DalFile dalFile)
{
return(new File()
{
Id = dalFile.Id,
IsPublic = dalFile.IsPublic,
Name = dalFile.Name,
Description = dalFile.Description,
Content = dalFile.Content,
Type = dalFile.Type,
Date = dalFile.Date,
User_Id = dalFile.UserId
});
}
public static BllFile ToBllFile(this DalFile dalFile)
{
return(new BllFile()
{
Id = dalFile.Id,
IsPublic = dalFile.IsPublic,
Name = dalFile.Name,
Content = dalFile.Content,
Type = dalFile.Type,
Description = dalFile.Description,
Date = dalFile.Date,
UserId = dalFile.UserId,
User = dalFile.User.ToBllUser()
});
}
/// <summary>
/// Convert Dal File entity to Bll entity
/// </summary>
/// <param name="file">dal entity</param>
/// <returns>bll entity</returns>
public static DtoFile ToDtoFile(this DalFile file)
{
if (ReferenceEquals(file, null))
{
return(null);
}
return(new DtoFile
{
ID = file.ID,
Data = file.Data,
DateTime = file.DateTime,
FolderID = file.FolderID,
Title = file.Title,
FileTypes = new HashSet <DtoFileType>(file.FileTypes.Select(item => item.ToDtoFileType()))
});
}
/// <summary>
/// Mapping <see cref="DalFile"/> entity to <see cref="BllFile"/> entity.
/// </summary>
public static BllFile ToBllFile(this DalFile fileEntity)
{
return(new BllFile()
{
Id = fileEntity.Id,
UserId = fileEntity.UserId,
Name = fileEntity.Name,
ExtensionId = fileEntity.ExtensionId,
Size = fileEntity.Size,
Data = fileEntity.Data,
UploadDate = fileEntity.UploadDate,
IsProfileImage = fileEntity.IsProfileImage,
Banned = fileEntity.Banned,
IsFolder = fileEntity.IsFolder,
ParentFileFolderId = fileEntity.ParentFileFolderId
});
}
/// <summary>
/// Convert Dal File entity to Orm entity
/// </summary>
/// <param name="file">dal entity</param>
/// <returns>orm entity</returns>
public static Files ToOrmFile(this DalFile file)
{
if (ReferenceEquals(file, null))
{
return(null);
}
return(new Files
{
id = file.ID,
content = file.Data,
dateTime = file.DateTime,
name = file.Title,
folderId = file.FolderID,
Folder = null,
FileTypes = new HashSet <FileTypes>(file.FileTypes.Select(item => item.ToOrmFileType()))
});
}
public void Delete(DalFile entity)
{
if (ReferenceEquals(entity, null))
{
var error = new ArgumentNullException(nameof(entity), "parametr can't be null");
logger.Error(error, error.Message);
throw error;
}
var possibleUser = context.Set <Files>().Single(user => user.id == entity.ID);
if (ReferenceEquals(possibleUser, null))
{
var error = new ArgumentNullException(nameof(possibleUser), "didn't find equally File In database");
logger.Error(error, error.Message);
throw error;
}
context.Set <Files>().Remove(possibleUser);
}
public void Update(DalFile entity)
{
if (entity == null)
{
return;
}
var ormFile = Context.Set <File>()?.Find(entity.Id);
if (ormFile == null)
{
return;
}
ormFile.Name = entity.Name;
ormFile.Data = entity.Data;
ormFile.Banned = entity.Banned;
ormFile.Size = entity.Size;
ormFile.IsProfileImage = entity.IsProfileImage;
ormFile.ExtensionId = entity.ExtensionId;
ormFile.IsFolder = entity.IsFolder;
ormFile.ParentFileFolderId = entity.ParentFileFolderId;
}
public void Update(DalFile entity)
{
if (ReferenceEquals(entity, null))
{
var error = new ArgumentNullException(nameof(entity), "parametr can't be null");
logger.Error(error, error.Message);
throw error;
}
var file = context.Set <Files>().Find(entity.ID);
var e = entity.ToOrmFile();
file.Folder = e.Folder;
file.dateTime = e.dateTime;
file.folderId = e.folderId;
file.name = e.name;
file.content = e.content;
file.FileTypes = e.FileTypes;
context.Entry(file).State = EntityState.Modified;
}
