Example #1
0
            public SimpleMembershipInitializer()
            {
                System.Data.Entity.Database.SetInitializer<CrisisCheckin>(null);

                try
                {
                    using (var context = new CrisisCheckin())
                    {

                        if (!context.Database.Exists())
                        {
                            // Create the SimpleMembership database without Entity Framework migration schema
                            ((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
                        }
                    }

                    if (!WebSecurity.Initialized)
                    {
                        WebSecurity.InitializeDatabaseConnection("CrisisCheckin", "User", "Id", "UserName", autoCreateTables: true);
                    }
                }
                catch (Exception ex)
                {
                    throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
                }
            }
Example #2
0
 public static void Initialize()
 {
     using (var db = new CrisisCheckin()) {
         if (!db.Database.CompatibleWithModel(false)) {
             Database.SetInitializer<CrisisCheckin>(new MigrateDatabaseToLatestVersion<CrisisCheckin, Models.Migrations.Configuration>());
             db.Database.Initialize(false);
         }
         Models.Migrations.Configuration.SeedIfNotEmpty(db);
     }
 }
        public void SetUp()
        {
            AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory());
            using (var dbContext = new CrisisCheckin())
            {
                dbContext.Database.Delete();

                new MigrateDatabaseToLatestVersion<CrisisCheckin, CrisisCheckinConfiguration>()
                    .InitializeDatabase(dbContext);

                Seed(dbContext);
            }
        }
 static void Seed(CrisisCheckin dbContext)
 {
     dbContext.Clusters.AddOrUpdate(
         c => c.Name,
         new Cluster { Name = "Agriculture Cluster" },
         new Cluster { Name = "Camp Coordination and Management Cluster" },
         new Cluster { Name = "Early Recovery Cluster" },
         new Cluster { Name = "Emergency Shelter Cluster" },
         new Cluster { Name = "Emergency Telecommunications Cluster" },
         new Cluster { Name = "Food Cluster" },
         new Cluster { Name = "Health Cluster" },
         new Cluster { Name = "Logistics Cluster" },
         new Cluster { Name = "Nutrition Cluster" },
         new Cluster { Name = "Protection Cluster" },
         new Cluster { Name = "Water and Sanitation Cluster" }
         );
     dbContext.SaveChanges();
 }
Example #5
0
        public static void InitializeCrisisCheckinAndMembershipData()
        {
            var migrateOnStartup = false;
            if (!bool.TryParse(ConfigurationManager.AppSettings["MigrateDbToLatestOnStartup"], out migrateOnStartup))
            {
                migrateOnStartup = false;
            }

            if (migrateOnStartup)
            {
                Database.SetInitializer<CrisisCheckin>(new MigrateDatabaseToLatestVersion<CrisisCheckin, Models.Migrations.CrisisCheckinConfiguration>());
            }
            else
            {
                Database.SetInitializer<CrisisCheckin>(null);
            }

            //Users are created via membership so never ever do initialization
            Database.SetInitializer<CrisisCheckinMembership>(null);

            using (var db = new CrisisCheckin())
            {
                db.Database.CreateIfNotExists();

                if (migrateOnStartup)
                {
                    var configuration = new CrisisCheckinConfiguration();

                    var migrator = new DbMigrator(configuration);
                    migrator.Update();
                }

                AuthConfig.Register();
                AuthConfig.VerifyRolesAndDefaultAdminAccount();

                using (var mdb = new CrisisCheckinMembership())
                {
                    SeedIfNotEmpty(db, mdb);
                }
            }
        }
 public DataService(CrisisCheckin ctx, CrisisCheckinMembership mctx)
 {
     context = ctx;
     membership_context = mctx;
 }
Example #7
0
 public DataService(CrisisCheckin ctx)
 {
     context = ctx;
 }
 public PersonController(CrisisCheckin dbContext, IWebSecurityWrapper webSecurity)
 {
     DbContext = dbContext;
     WebSecurity = webSecurity;
 }
Example #9
0
        public static void SeedIfNotEmpty(CrisisCheckin context, CrisisCheckinMembership membership_context) // Not overriding DbMigrationsConfiguration<T>.Seed, since it doesn't seem to always get called when it should.
        {
            // We want to call this method even when the database updates aren't necessary. That's
            // because VS 2013 tooling automatically creates the DB when the app starts. Therefore,
            // this code only executes when the clusters table is empty. That's a good proxy for a
            // clean database with no data.
            if (context.Clusters.Any())
                return;

            context.ClusterGroups.AddOrUpdate(g => g.Name, 
                new ClusterGroup { Name = "UN Clusters", Description = "The UN Cluster list." });

            context.SaveChanges();
            var clusterGroup = context.ClusterGroups.First();

            context.Clusters.AddOrUpdate(
                c => c.Name,
                new Cluster { Name = "Agriculture Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Camp Coordination and Management Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Early Recovery Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Emergency Shelter Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Emergency Telecommunications Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Food Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Health Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Logistics Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Nutrition Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Protection Cluster", ClusterGroupId = clusterGroup.Id },
                new Cluster { Name = "Water and Sanitation Cluster", ClusterGroupId = clusterGroup.Id }
                );
            context.SaveChanges();
            var vtype = context.VolunteerTypes.First(vt => vt.Name == VolunteerType.VOLUNTEERTYPE_ONSITE);

            var firstCluster = context.Clusters.FirstOrDefault();

            context.Persons.AddOrUpdate(
                p => p.FirstName,
                new Person
                {
                    FirstName = "Bob",
                    Commitments =
                        new Commitment[] { new Commitment { StartDate = new DateTime(2014, 1, 1), EndDate = new DateTime(2014, 2, 1), Disaster = new Disaster { Name = "Hurricane", IsActive = true }, VolunteerType = vtype, Cluster = firstCluster } }
                });

            // Set up automated test user
            var testUser = membership_context.Users.FirstOrDefault(u => u.UserName == Constants.DefaultTestUserName);
            if (testUser != null)
            {
                if (context.Persons.FirstOrDefault(p => p.UserId == testUser.Id) == null)
                {
                    context.Persons.Add(new Person
                    {
                        UserId = testUser.Id,
                        FirstName = "Test",
                        LastName = "User",
                        Email = "*****@*****.**",
                        Commitments = new Commitment[]
                            {
                                new Commitment
                                {
                                    StartDate = new DateTime(DateTime.Now.Year, 1, 1), EndDate = new DateTime(DateTime.Now.Year, 2, 1),
                                    Disaster = new Disaster { Name = "Test Disaster", IsActive = true },
                                    VolunteerType = vtype, Cluster = firstCluster
                                }
                            },
						OrganizationId = 1,
 
                        Organization = new Organization
                            {
								OrganizationName = "Humanitarian Toolbox",
								OrganizationId = 1,
								Type = OrganizationTypeEnum.NonProfit,
								Location = new Address
								{
									AddressLine1 = "HT AddressLine 1",
									AddressLine2 = "HT Address Line 2",
									AddressLine3 = "HT Address Line 3",
									BuildingName = "HT Building Name",
									City = "HTCity",
									Country = "USA",
									County = "HT County",
									PostalCode = "12345",
									State = "HT State"
								},
								Verified = true
							}

                    });
                }
            }

            context.SaveChanges();

            context.DisasterClusters.Add(new DisasterCluster { DisasterId = 1, ClusterId = 1 });
            context.DisasterClusters.Add(new DisasterCluster { DisasterId = 2, ClusterId = 2 });

            context.SaveChanges();
        }
Example #10
0
        // Not overriding DbMigrationsConfiguration<T>.Seed, since it doesn't seem to always get called when it should.
        public static void SeedIfNotEmpty(CrisisCheckin context, CrisisCheckinMembership membership_context)
        {
            // We want to call this method even when the database updates aren't necessary. That's
            // because VS 2013 tooling automatically creates the DB when the app starts. Therefore,
            // this code only executes when the clusters table is empty. That's a good proxy for a
            // clean database with no data.
            if (context.Clusters.Any())
                return;

            context.Clusters.AddOrUpdate(
                c => c.Name,
                new Cluster { Name = "Agriculture Cluster" },
                new Cluster { Name = "Camp Coordination and Management Cluster" },
                new Cluster { Name = "Early Recovery Cluster" },
                new Cluster { Name = "Emergency Shelter Cluster" },
                new Cluster { Name = "Emergency Telecommunications Cluster" },
                new Cluster { Name = "Food Cluster" },
                new Cluster { Name = "Health Cluster" },
                new Cluster { Name = "Logistics Cluster" },
                new Cluster { Name = "Nutrition Cluster" },
                new Cluster { Name = "Protection Cluster" },
                new Cluster { Name = "Water and Sanitation Cluster" }
                );
            context.SaveChanges();
            var vtype = context.VolunteerTypes.First(vt => vt.Name == VolunteerType.VOLUNTEERTYPE_ONSITE);

            context.Persons.AddOrUpdate(
                p => p.FirstName,
                new Person
                {
                    FirstName = "Bob",
                    Commitments =
                        new Commitment[] { new Commitment { StartDate = new DateTime(2014, 1, 1), EndDate = new DateTime(2014, 2, 1), Disaster = new Disaster { Name = "Hurricane", IsActive = true }, VolunteerType = vtype } }
                });

            // Set up automated test user
            var testUser = membership_context.Users.FirstOrDefault(u => u.UserName == Constants.DefaultTestUserName);
            if (testUser != null)
            {
                if (context.Persons.FirstOrDefault(p => p.UserId == testUser.Id) == null)
                {
                    context.Persons.Add(new Person
                    {
                        UserId = testUser.Id,
                        FirstName = "Test",
                        LastName = "User",
                        Email = "*****@*****.**",
                        Commitments = new Commitment[]
                            {
                                new Commitment
                                {
                                    StartDate = new DateTime(DateTime.Now.Year, 1, 1), EndDate = new DateTime(DateTime.Now.Year, 2, 1),
                                    Disaster = new Disaster { Name = "Test Disaster", IsActive = true },
                                    VolunteerType = vtype
                                }
                            }
                    });
                }
            }

            context.SaveChanges();

            context.DisasterClusters.Add(new DisasterCluster { DisasterId = 1, ClusterId = 1 });
            context.DisasterClusters.Add(new DisasterCluster { DisasterId = 2, ClusterId = 2 });

            context.SaveChanges();
        }