Esempio n. 1
0
 public ProjectStore(IMapper mapper, WavesDbContext context, ITransactionService transactionService, IProjectSearchQueryBuilder queryBuilder)
 {
     _mapper             = mapper;
     _context            = context;
     _transactionService = transactionService;
     _queryBuilder       = queryBuilder;
 }
 public void Dispose()
 {
     using (var context = new WavesDbContext(DbOptions))
     {
         context.Database.EnsureDeleted();
     }
 }
        private IProjectStore _GetProjectStore(WavesDbContext context)
        {
            IProjectSearchQueryBuilder builder            = new ProjectSearchQueryBuilder(context);
            ITransactionService        transactionService = new TransactionService(context);

            return(new ProjectStore(iMapper, context, transactionService, builder));
        }
 public ProjectFixture() : base()
 {
     using (WavesDbContext context = new WavesDbContext(DbOptions))
     {
         _AddTestData(context);
     }
 }
Esempio n. 5
0
 public AppUserAuthorizationService(IAuthTokenFactory tokenFactory, UserManager <AppUser> userManager,
                                    WavesDbContext context, IRolePolicyService policyService, SignInManager <AppUser> signInManager) : base(tokenFactory)
 {
     _context       = context;
     _userManager   = userManager;
     _policyService = policyService;
     _signInManager = signInManager;
 }
 public DatabaseFixture() : base()
 {
     using (var context = new WavesDbContext(DbOptions))
     {
         context.Database.EnsureDeleted();
         context.Database.Migrate();
     }
 }
 public void Dispose()
 {
     using (var context = new WavesDbContext(DbOptions))
     {
         context.Projects.RemoveRange(context.Projects);
         context.AppUsers.RemoveRange(context.AppUsers);
         context.AppRoles.RemoveRange(context.AppRoles);
         context.SaveChanges();
     }
 }
        public async Task Should_Return_Projects_Count_According_To_Filter_Parameters(
            ProjectSearchParametersModel parameters, Int32 expectedCount)
        {
            using (WavesDbContext context = new WavesDbContext(_fixture.DbOptions))
            {
                IProjectStore store = _GetProjectStore(context);
                ItemListModel <ProjectDTO> result = await store.GetAsync(parameters);

                Assert.Equal(expectedCount, result.TotalCount);
            }
        }
Esempio n. 9
0
        public static void EnsureDatabaseInitialized(IServiceScope serviceScope)
        {
            WavesDbContext context       = serviceScope.ServiceProvider.GetRequiredService <WavesDbContext>();
            Boolean        isFirstLaunch = !(context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists();

            context.Database.Migrate();
            if (isFirstLaunch)
            {
                AddTestData(context);
            }
            context.Dispose();
        }
        private void _AddProjects(WavesDbContext context)
        {
            context.Database.ExecuteSqlCommand(@"                
SET IDENTITY_INSERT Projects ON;
INSERT INTO Projects (Id, UserId, Name, IsDeleted, CreatedOn, ModifiedOn) VALUES (1, 1, 'Test', 'false', GETDATE(), GETDATE());
INSERT INTO Projects (Id, UserId, Name, IsDeleted, CreatedOn, ModifiedOn) VALUES (2, 1, 'OneMoreTest', 'true', GETDATE(), GETDATE());
INSERT INTO Projects (Id, UserId, Name, IsDeleted, CreatedOn, ModifiedOn) VALUES (3, 1, 'new project', 'true', GETDATE(), GETDATE());
INSERT INTO Projects (Id, UserId, Name, IsDeleted, CreatedOn, ModifiedOn) VALUES (4, 1, '123', 'false', GETDATE(), GETDATE());
INSERT INTO Projects (Id, UserId, Name, IsDeleted, CreatedOn, ModifiedOn) VALUES (5, 1, 'waves', 'false', GETDATE(), GETDATE());
INSERT INTO Projects (Id, UserId, Name, IsDeleted, CreatedOn, ModifiedOn) VALUES (6, 2, 'difration', 'false', GETDATE(), GETDATE());
INSERT INTO Projects (Id, UserId, Name, IsDeleted, CreatedOn, ModifiedOn) VALUES (7, 2, 'Marinara', 'false', GETDATE(), GETDATE());
SET IDENTITY_INSERT Projects OFF;");
        }
        private void _AddUsers(WavesDbContext context)
        {
            context.Database.ExecuteSqlCommand(@"                
SET IDENTITY_INSERT AppRoles ON;
INSERT INTO AppRoles (Id, IsActive, Name) VALUES (1, 'true', 'Test');
INSERT INTO AppRoles (Id, IsActive, Name) VALUES (2, 'true', 'OneMoreTest');
SET IDENTITY_INSERT AppRoles OFF;");


            context.Database.ExecuteSqlCommand(@"                
SET IDENTITY_INSERT AspNetUsers ON;
INSERT INTO AspNetUsers (Id, Email, RoleId, CreatedOn, ModifiedOn, EmailConfirmed, PhoneNumberConfirmed, TwoFactorEnabled, LockoutEnabled, AccessFailedCount, IsActive) 
VALUES (1, '*****@*****.**', 1, GETDATE(), GETDATE(), 'false', 'false', 'false', 'false', '5', 'true');
INSERT INTO AspNetUsers (Id, Email, RoleId, CreatedOn, ModifiedOn, EmailConfirmed, PhoneNumberConfirmed, TwoFactorEnabled, LockoutEnabled, AccessFailedCount, IsActive)
VALUES (2, '*****@*****.**', 2, GETDATE(), GETDATE(), 'false', 'false', 'false', 'false', '5', 'true');
SET IDENTITY_INSERT AspNetUsers OFF;");
        }
Esempio n. 12
0
        public static void AddIdentityData(WavesDbContext context)
        {
            context.Database.ExecuteSqlCommand($@"
                    SET IDENTITY_INSERT appfeatures ON;
                    INSERT INTO appfeatures (Id, Name, Description) VALUES (1, 'FullAccess', 'Full Access');
                    SET IDENTITY_INSERT appfeatures OFF;");

            context.Database.ExecuteSqlCommand($@"
                    SET IDENTITY_INSERT approles ON;
                    INSERT INTO approles (Id, Name, isActive) VALUES (1, 'SuperAdmin', 'true');
                    SET IDENTITY_INSERT approles OFF;");

            context.Database.ExecuteSqlCommand($@"
                    SET IDENTITY_INSERT approlefeatures ON;
                    INSERT INTO approlefeatures (Id, CreatedOn, ModifiedOn, AppRoleId, AppFeatureId) VALUES (1, GETDATE(), GETDATE(), 1,  1);
                    SET IDENTITY_INSERT approlefeatures OFF;");

            // password for superuser: 123456
            context.Database.ExecuteSqlCommand($@"
                    SET IDENTITY_INSERT aspnetusers ON;
                    INSERT INTO aspnetusers (Id, CreatedOn, ModifiedOn, UserName, NormalizedUserName, Email, NormalizedEmail, EmailConfirmed, PasswordHash, PhoneNumber, PhoneNumberConfirmed, TwoFactorEnabled, LockoutEnabled, AccessFailedCount, FirstName, LastName, IsActive, RoleId) VALUES 
                    (1, GETDATE(), GETDATE(), '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**', 'true', 'AQAAAAEAACcQAAAAEIUEA9TSyuVATZj+snuxTMC4ZKk/jIcgJwa1M/aY/SBH1b9W4Nn7qMwLBTebRBvboA==', '123456789', 'true', 'false', 'false', '0', 'Super', 'User', 'true', '1');
                    SET IDENTITY_INSERT aspnetusers OFF;");
        }
 public UserStore(IMapper mapper, WavesDbContext context, UserManager <AppUser> userManager)
 {
     _mapper      = mapper;
     _context     = context;
     _userManager = userManager;
 }
 private void _AddTestData(WavesDbContext context)
 {
     _AddUsers(context);
     _AddProjects(context);
 }
 public TransactionService(WavesDbContext context)
 {
     _context = context;
 }
Esempio n. 16
0
 public ProjectSearchQueryBuilder(WavesDbContext context)
 {
     _context = context;
 }
 public RolePolicyService(WavesDbContext context)
 {
     _context = context;
 }
Esempio n. 18
0
 public static void AddTestData(WavesDbContext context)
 {
     AddIdentityData(context);
 }