public DalFile FindById(Guid id) { using (var context = new FileStorageDbContext()) { return(context.Files.FirstOrDefault(f => f.Id == id).ToDalFile()); } }
public IEnumerable <DalRole> FindAll() { using (var context = new FileStorageDbContext()) { return(context.Roles.AsEnumerable().Select(elem => elem.ToDalRole()).ToList());; } }
public void Save(DalUser user) { using (var context = new FileStorageDbContext()) { context.Users.Add(user.ToOrmUser()); context.SaveChanges(); } }
public IEnumerable <DalFile> FindByAccurNameAndOwnerId(string fileName, Guid ownerId) { using (var context = new FileStorageDbContext()) { return(context.Files.AsEnumerable() .Where(item => item.Name.Equals(fileName) && item.OwnerId == ownerId) .Select(item => item.ToDalFile()).ToList()); } }
public IEnumerable <DalFile> FindPublicByName(string fileName) { using (var context = new FileStorageDbContext()) { return(context.Files.AsEnumerable() .Where(elem => elem.ToDalFile().IsPublic&& elem.Name.Contains(fileName)) .Select(elem => elem.ToDalFile()).ToList()); } }
public IEnumerable <DalFile> FindPublic() { using (var context = new FileStorageDbContext()) { return(context.Files.AsEnumerable() .Where(elem => elem.ToDalFile().IsPublic) .Select(elem => elem.ToDalFile()).ToList()); } }
public IEnumerable <DalFile> FindByOwnerId(Guid ownerId) { using (var context = new FileStorageDbContext()) { return(context.Files.AsEnumerable() .Where(elem => elem.ToDalFile().OwnerId == ownerId) .Select(elem => elem.ToDalFile()).ToList()); } }
private void ConfigureDependencies(FileStorageDbContext dbContext) { // Create and initialize inner kernel for test suite initialization this.InitializationKernel = new StandardKernel(new NinjectFileStorageModule()); this.InitializationKernel.Unbind <FileStorageDbContext>(); this.InitializationKernel.Bind <FileStorageDbContext>().ToConstant(dbContext); // Create shared kernel to be used by each individual test case this.Kernel = new StandardKernel(new NinjectFileStorageModule()); }
public IEnumerable <DalUser> FindAll() { IEnumerable <DalUser> users; using (var context = new FileStorageDbContext()) { users = context.Users.AsEnumerable().Select(elem => elem.ToDalUser()).ToList(); } return(users); }
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 IEnumerable <DalUser> FindByRole(string roleName) { IEnumerable <DalUser> users; using (var context = new FileStorageDbContext()) { users = context.Users.AsEnumerable() .Where(elem => elem.Role.Name.Equals(roleName)) .Select(elem => elem.ToDalUser()).ToList(); } return(users); }
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(); } } }
private void InitializeDatabase() { var options = new DbContextOptionsBuilder <FileStorageDbContext>() .UseSqlServer(ApplicationSettings.Storage.DataStoreConnectionString) .Options; using (var dbContext = new FileStorageDbContext(options)) { dbContext.Database.EnsureDeleted(); dbContext.Database.EnsureCreated(); dbContext.SaveChanges(); ConfigureDependencies(dbContext); IUploadSessionRepository uploadSessionRepository = this.InitializationKernel.Get <IUploadSessionRepository>(); DatabaseSeeder.Seed(uploadSessionRepository); } }