public void Save(DalUser user)
{
using (var context = new FileStorageDbContext())
{
context.Users.Add(user.ToOrmUser());
context.SaveChanges();
}
}
public void Delete(Guid id)
{
using (var context = new FileStorageDbContext())
{
var user = context.Users.FirstOrDefault(u => u.Id == id);
if (user == null) return;
context.Users.Remove(user);
context.SaveChanges();
}
}
public void Delete(Guid id)
{
using (var context = new FileStorageDbContext())
{
var file = context.Files.FirstOrDefault(f => f.Id == id);
if (file == null) return;
context.Files.Remove(file);
context.SaveChanges();
}
}
public void Save(IEnumerable<DalRole> roles)
{
using (var context = new FileStorageDbContext())
{
foreach (var dalRole in roles)
{
context.Roles.Add(new OrmRole() {Id = dalRole.Id, Name = dalRole.Name});
}
context.SaveChanges();
}
}
public void DeleteByOwnerId(Guid ownerId)
{
using (var context = new FileStorageDbContext())
{
var files = context.Files
.Where(elem => elem.OwnerId == ownerId)
.Select(elem => elem);
foreach (var file in files.Where(file => file != null))
{
context.Files.Remove(file);
context.SaveChanges();
}
}
}
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();
}
}
