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); } } }