public async Task <bool> IsDatabaseSetUpAsync(string strDefaultConnection) { var optionsBuilder = new DbContextOptionsBuilder <BlazorBlogsContext>(); optionsBuilder.UseSqlServer(strDefaultConnection); try { using (var context = new BlazorBlogsContext(optionsBuilder.Options)) { // If we can get Version Number database is set up var VersionNumber = await context.Settings // Use AsNoTracking to disable EF change tracking .AsNoTracking() .Where(x => x.SettingName.ToLower() == "versionnumber") .FirstOrDefaultAsync(); if (VersionNumber == null) { return(false); } else { return(true); } } } catch { return(false); } }
public async Task <bool> AdminExistsAsync(string strDefaultConnection) { var optionsBuilder = new DbContextOptionsBuilder <BlazorBlogsContext>(); optionsBuilder.UseSqlServer(strDefaultConnection); using (var context = new BlazorBlogsContext(optionsBuilder.Options)) { // Get Admin Role var AdminRoleList = await context.AspNetRoles // Use AsNoTracking to disable EF change tracking .AsNoTracking() .Where(x => x.Name.ToLower() == "Administrators") .ToListAsync(); if (AdminRoleList.Count == 0) { return(false); } var AdminRole = AdminRoleList.FirstOrDefault(); // Get number of users in that role var UsersInAdminRole = await context.AspNetUserRoles // Use AsNoTracking to disable EF change tracking .AsNoTracking() .Where(x => x.RoleId == AdminRole.Id) .CountAsync(); return(UsersInAdminRole > 0); } }
public BlogsService(BlazorBlogsContext context) { _context = context; }
public GeneralSettingsService(BlazorBlogsContext context) { _context = context; }
public BlogsService(BlazorBlogsContext context, IWebHostEnvironment environment) { _context = context; _environment = environment; }
public EmailService(BlazorBlogsContext context, GeneralSettingsService generalSettingsService) { _context = context; _generalSettingsService = generalSettingsService; }
public EmailSender(BlazorBlogsContext context, EmailService EmailService, GeneralSettingsService generalSettingsService) { _context = context; _EmailService = EmailService; _GeneralSettingsService = generalSettingsService; }