public SiteQueries(CoreDbContext dbContext) { this.dbContext = dbContext; }
public GeoQueries(CoreDbContext dbContext) { this.dbContext = dbContext; }
public UserQueries(CoreDbContext dbContext) { this.dbContext = dbContext; }
public UserCommands(CoreDbContext dbContext) { this.dbContext = dbContext; }
public SiteCommands(CoreDbContext dbContext) { this.dbContext = dbContext; }
public SiteCommands(CoreDbContext dbContext) { this.dbContext = dbContext; }
public UserQueries(CoreDbContext dbContext) { this.dbContext = dbContext; }
public GeoCommands(CoreDbContext dbContext) { this.dbContext = dbContext; }
private static async Task EnsureData( CoreDbContext db ) { int rowsAffected = 0; int count = await db.Countries.CountAsync<GeoCountry>(); if(count == 0) { foreach(GeoCountry c in InitialData.BuildCountryList()) { db.Countries.Add(c); } rowsAffected = await db.SaveChangesAsync(); } count = await db.States.CountAsync<GeoZone>(); if (count == 0) { foreach (GeoZone c in InitialData.BuildStateList()) { db.States.Add(c); } rowsAffected = await db.SaveChangesAsync(); } count = await db.Sites.CountAsync<SiteSettings>(); SiteSettings newSite = null; if (count == 0) { // create first site newSite = InitialData.BuildInitialSite(); db.Sites.Add(newSite); rowsAffected = await db.SaveChangesAsync(); } // ensure roles count = await db.Roles.CountAsync<SiteRole>(); if (count == 0) { var site = newSite; if(site == null) { site = await db.Sites.SingleOrDefaultAsync<SiteSettings>( s => s.Id != Guid.Empty && s.IsServerAdminSite == true); } if(site != null) { var adminRole = InitialData.BuildAdminRole(); adminRole.SiteId = site.Id; db.Roles.Add(adminRole); var roleAdminRole = InitialData.BuildRoleAdminRole(); roleAdminRole.SiteId = site.Id; db.Roles.Add(roleAdminRole); var contentAdminRole = InitialData.BuildContentAdminsRole(); contentAdminRole.SiteId = site.Id; db.Roles.Add(contentAdminRole); var authenticatedUserRole = InitialData.BuildAuthenticatedRole(); authenticatedUserRole.SiteId = site.Id; db.Roles.Add(authenticatedUserRole); rowsAffected = await db.SaveChangesAsync(); } } // ensure admin user count = await db.Users.CountAsync<SiteUser>(); if (count == 0) { SiteSettings site = await db.Sites.SingleOrDefaultAsync<SiteSettings>( s => s.Id != Guid.Empty && s.IsServerAdminSite == true); if (site != null) { var role = await db.Roles.SingleOrDefaultAsync( x => x.SiteId == site.Id && x.NormalizedRoleName == "Administrators".ToUpperInvariant()); if(role != null) { var adminUser = InitialData.BuildInitialAdmin(); adminUser.SiteId = site.Id; db.Users.Add(adminUser); rowsAffected = await db.SaveChangesAsync(); if(rowsAffected > 0 && adminUser.Id != Guid.Empty) { var ur = new UserRole(); ur.RoleId = role.Id; ur.UserId = adminUser.Id; db.UserRoles.Add(ur); await db.SaveChangesAsync(); role = await db.Roles.SingleOrDefaultAsync( x => x.SiteId == site.Id && x.NormalizedRoleName == "Authenticated Users".ToUpperInvariant()); if(role != null) { ur = new UserRole(); ur.RoleId = role.Id; ur.UserId = adminUser.Id; db.UserRoles.Add(ur); await db.SaveChangesAsync(); } } } } } }
public GeoCommands(CoreDbContext dbContext) { this.dbContext = dbContext; }
public SiteQueries(CoreDbContext dbContext) { this.dbContext = dbContext; }