public IEnumerable <AspNetUserLogin> GetAll()
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.AspNetUserLogins.ToList());
}
}
public Tag Get(int userId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.Tags.Find(userId));
}
}
public FileSystemTag Get(int userId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(null);
}
}
public IEnumerable <FileSystem> GetAll()
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.FileSystems.ToList());
}
}
public IEnumerable <SharedAccess> GetAll()
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.SharedAccesses.ToList());
}
}
public AspNetUserLogin Get(int userId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.AspNetUserLogins.Find(userId));
}
}
public SharedAccess Get(int userId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.SharedAccesses.Find(userId));
}
}
public IEnumerable <FileSystemTag> GetAll()
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(null);
}
}
public Tag Get(string name)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.Tags.Where(x => x.Name == name).FirstOrDefault());
}
}
public IEnumerable <FileSystem> GetAll(string userId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.FileSystems.Where(x => x.UserId == userId)
.Include(x => x.Tags)
.ToList());
}
}
public FileSystem Get(int fileSystemId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
return(dbContext.FileSystems.Where(x => x.Id == fileSystemId)
.Include(x => x.Tags)
.ToList().FirstOrDefault());
}
}
public void DeleteFileSystem(int fileSystemId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var fileSystem = dbContext.FileSystems.Where(x => x.Id == fileSystemId).FirstOrDefault();
dbContext.Entry(fileSystem).State = EntityState.Deleted;
dbContext.SaveChanges();
}
}
public async Task AddTagAsync(int fileSystem, int tag)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var filesystems = dbContext.FileSystems.Where(x => x.Id == fileSystem).FirstOrDefault();
var tags = dbContext.Tags.Where(x => x.Id == tag).FirstOrDefault();
filesystems.Tags.Add(tags);
await dbContext.SaveChangesAsync();
}
}
public List <FileDeleteModel> SearchFileSystemForDelete(int fileSystemId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var param = new SqlParameter("@Id", fileSystemId);
List <FileDeleteModel> fileSystem = dbContext.Database.SqlQuery <FileDeleteModel>("prFileSystemDelete @Id", param).ToList();
return(fileSystem);
}
}
public int InsertObject(FileSystem file)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
dbContext.FileSystems.Add(file);
dbContext.SaveChanges();
return(file.Id);
}
}
public int InsertObject(Tag tag)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
dbContext.Tags.Add(tag);
dbContext.SaveChanges();
return(tag.Id);
}
}
public void FileSystemAddThumbnailLink(int fileSystemId, string link)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var fileSystem = dbContext.FileSystems.Where(x => x.Id == fileSystemId).FirstOrDefault();
if (fileSystem != null)
{
fileSystem.BlobThumbnail = link;
dbContext.SaveChanges();
}
}
}
public void RenameFileSystem(int fileSystemId, string name)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var fileSystem = dbContext.FileSystems.Where(x => x.Id == fileSystemId).FirstOrDefault();
if (fileSystem != null)
{
fileSystem.Name = name;
fileSystem.UploadDate = DateTime.Now;
dbContext.SaveChanges();
}
}
}
public bool Get(string userId, int?parentId, string name)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var file = dbContext.FileSystems.Where(x => x.UserId == userId && x.ParentId == parentId && x.Name == name)
.Include(x => x.Tags)
.ToList().FirstOrDefault();
if (file == null)
{
return(true);
}
else
{
return(false);
}
}
}
public void ChangeFileSystemParentId(int fileSystemId, int?fileSystemParentId, string userId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var fileSystem = dbContext.FileSystems.Where(x => x.UserId == userId && x.Id == fileSystemId).FirstOrDefault();
if (fileSystem != null)
{
if (fileSystem.Id != fileSystemParentId)
{
fileSystem.ParentId = fileSystemParentId;
fileSystem.UploadDate = DateTime.Now;
dbContext.SaveChanges();
}
}
}
}
public bool UniqueName(string name, int?fileSystemParentId, string userId)
{
using (var dbContext = new MediaPortalDbContext(_connectionString))
{
var fileSystem = dbContext.FileSystems
.Where(x => x.UserId == userId && x.ParentId == fileSystemParentId && x.Name == name)
.FirstOrDefault();
if (fileSystem == null)
{
return(true);
}
else
{
return(false);
}
}
}
