protected override void Seed(CrisisCheckin context) { // Populate resource types context.ResourceTypes.AddOrUpdate(x => x.ResourceTypeId, new ResourceType { ResourceTypeId = 1, TypeName = "Food" }, new ResourceType { ResourceTypeId = 2, TypeName = "Water" }, new ResourceType { ResourceTypeId = 3, TypeName = "Medical" }, new ResourceType { ResourceTypeId = 4, TypeName = "Shelter" }, new ResourceType { ResourceTypeId = 5, TypeName = "Heavy Machines" }, new ResourceType { ResourceTypeId = 6, TypeName = "Hazard" }, new ResourceType { ResourceTypeId = 7, TypeName = "Pamphlets Delivered" }, new ResourceType { ResourceTypeId = 8, TypeName = "Medical Services" }); }
public void Get_person() { var db = new CrisisCheckin(); var controller = new EntitiesController(db); Assert.AreEqual(_person.PhoneNumber, controller.Persons().OrderByDescending(p => p.Id).First().PhoneNumber); }
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()); Database.SetInitializer <CrisisCheckin>(new Initializer()); using (var context = new CrisisCheckin()) { context.Database.Delete(); context.Database.Initialize(true); } }
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); } }
public void SetUp() { AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory()); Database.SetInitializer <CrisisCheckin>(new MyInitializer()); using (var context = new CrisisCheckin()) { if (!context.Database.Exists()) { ((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); } context.Database.Initialize(true); } }
public static void SeedIfNotEmpty(CrisisCheckin context) // Not overriding DbMigrationsConfiguration<T>.Seed, since it doesn't seem to always get called when it should. { context.Clusters.Add(new Cluster { Name = "Agriculture Cluster" }); context.Clusters.Add(new Cluster { Name = "Camp Coordination and Management Cluster" }); context.Clusters.Add(new Cluster { Name = "Early Recovery Cluster" }); context.Clusters.Add(new Cluster { Name = "Emergency Shelter Cluster" }); context.Clusters.Add(new Cluster { Name = "Emergency Telecommunications Cluster" }); context.Clusters.Add(new Cluster { Name = "Food Cluster" }); context.Clusters.Add(new Cluster { Name = "Health Cluster" }); context.Clusters.Add(new Cluster { Name = "Logistics Cluster" }); context.Clusters.Add(new Cluster { Name = "Nutrition Cluster" }); context.Clusters.Add(new Cluster { Name = "Protection Cluster" }); context.Clusters.Add(new Cluster { Name = "Water and Sanitation Cluster" }); context.Persons.Add(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 } } } }); context.SaveChanges(); }
static void Seed(CrisisCheckin dbContext) { dbContext.ClusterGroups.AddOrUpdate( g => g.Name, new ClusterGroup { Name = "UN Clusters", Description = "Some description here" }); dbContext.Clusters.AddOrUpdate( c => c.Name, new Cluster { Name = "Agriculture Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Camp Coordination and Management Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Early Recovery Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Emergency Shelter Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Emergency Telecommunications Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Food Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Health Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Logistics Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Nutrition Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Protection Cluster", ClusterGroupId = 1 }, new Cluster { Name = "Water and Sanitation Cluster", ClusterGroupId = 1 } ); dbContext.SaveChanges(); }
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 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(); } } 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); } }
public DataService(CrisisCheckin ctx, CrisisCheckinMembership mctx) { context = ctx; membership_context = mctx; }
public DataService(CrisisCheckin ctx) { context = ctx; }
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.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(); }
public PersonController(CrisisCheckin dbContext, IWebSecurityWrapper webSecurity) { DbContext = dbContext; WebSecurity = webSecurity; }
public EntitiesController(CrisisCheckin ctx, IWebSecurityWrapper webSecurity) { _contextProvider = new CrisisCheckinContextProvider(ctx); _webSecurity = webSecurity; }
public EntitiesController(CrisisCheckin db) { _contextProvider = new CrisisCheckinContextProvider(db); }