internal EfCoreRepositoryBase(
ICoreDbContext contextFactory,
ICachingStrategy <T, TKey> cachingStrategy = null)
: base(cachingStrategy)
{
this.context = contextFactory;
DbSet = context.Set <T>();
}
public UnitOfWork(ICoreDbContext context)
{
this.context = context;
if (this.context != null)
{
this.context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
this.context.ChangeTracker.AutoDetectChangesEnabled = false;
}
}
public UnitOfWork(IDbContextFactory dbContextFactory)
{
context = dbContextFactory.Create();
if (context != null)
{
context.ChangeTracker.AutoDetectChangesEnabled = false;
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
}
private void DeleteUserRoles(
Guid siteId,
Guid userId,
ICoreDbContext dbContext)
{
var query = from x in dbContext.UserRoles
where x.UserId == userId
select x;
dbContext.UserRoles.RemoveRange(query);
}
private void DeleteClaimsByUser(
Guid siteId,
Guid userId,
ICoreDbContext dbContext)
{
var query = from x in dbContext.UserClaims
where (
(siteId == Guid.Empty || x.SiteId == siteId) &&
x.UserId == userId
)
select x;
dbContext.UserClaims.RemoveRange(query);
}
private void DeleteTokensByUser(
Guid siteId,
Guid userId,
ICoreDbContext dbContext)
{
var query = from l in dbContext.UserTokens
where (
l.SiteId == siteId &&
l.UserId == userId
)
select l;
dbContext.UserTokens.RemoveRange(query);
}
public SiteCommands(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
private static async Task EnsureData(
ICoreDbContext 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.FirstOrDefaultAsync <SiteSettings>(
s => s.Id != Guid.Empty && s.IsServerAdminSite == true);
if (site != null)
{
var role = await db.Roles.FirstOrDefaultAsync(
x => x.SiteId == site.Id && x.NormalizedRoleName == "ADMINISTRATORS");
if (role != null)
{
var adminUser = InitialData.BuildInitialAdmin();
adminUser.SiteId = site.Id;
adminUser.Id = Guid.NewGuid();
adminUser.CanAutoLockout = false;
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(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public SiteQueries(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public UserCommands(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public SiteQueries(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public UnitOfWork(ICoreDbContext db)
{
this.db = db;
}
public GeoQueries(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public SystemRepository(ICoreDbContext coreDbContext)
{
_coreDbContext = coreDbContext;
}
public UserCommands(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public UserQueries(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public GeoCommands(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public UserQueries(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public Repository <T> SetContext(ICoreDbContext db)
{
this.db = db;
return(this);
}
public UserRepository(ICoreDbContext coreDbContext)
{
_coreDbContext = coreDbContext;
}
public TestEfCoreRepository(ICoreDbContext dbContext, ICachingStrategy <T, TKey> cachingStrategy = null)
: base(dbContext, cachingStrategy)
{
}
public LoginQueryHandler(ICoreDbContext dbContext, IUserIdentityService identityService, ICoreLogger logger)
{
_dbContext = dbContext;
_identityService = identityService;
_logger = logger;
}
public UnitOfWork(ICoreDbContext context, IServiceProvider provider)
{
this.context = context;
this.provider = provider;
cache = new Dictionary <Type, object>();
}
public GeoQueries(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
public EfCoreRepository(ICoreDbContext contextFactory, ICompoundKeyCachingStrategy <T, TKey, TKey2, TKey3> cachingStrategy = null)
: base(contextFactory, cachingStrategy)
{
}
public SiteCommands(ICoreDbContext dbContext)
{
this.dbContext = dbContext;
}
private static async Task EnsureData(
ICoreDbContext 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.FirstOrDefaultAsync<SiteSettings>(
s => s.Id != Guid.Empty && s.IsServerAdminSite == true);
if (site != null)
{
var role = await db.Roles.FirstOrDefaultAsync(
x => x.SiteId == site.Id && x.NormalizedRoleName == "ADMINISTRATORS");
if(role != null)
{
var adminUser = InitialData.BuildInitialAdmin();
adminUser.SiteId = site.Id;
adminUser.Id = Guid.NewGuid();
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();
}
}
}
}
}
}
