public static void EnsureSeeded(this AppUsersDbContext context)
{
if (!context.UserRoles.Any())
{
var roles = JsonConvert.DeserializeObject <List <IdentityRole> >(File.ReadAllText("seed" + Path.DirectorySeparatorChar + "roles.json"));
List <ApplicationRole> roleList = new List <ApplicationRole>();
foreach (var role in roles)
{
roleList.Add(new ApplicationRole()
{
Name = role.Name
});
}
context.Roles.AddRange(roleList);
int i = context.SaveChanges();
}
if (!context.Users.Any())
{
List <ApplicationUser> appUserList = new List <ApplicationUser>();
var userList = JsonConvert.DeserializeObject <List <ApplicationUser> >(File.ReadAllText("seed" + Path.DirectorySeparatorChar + "users.json"));
foreach (var appUser in userList)
{
string passwordHasher = new PasswordHasher <ApplicationUser>().HashPassword(appUser, appUser.PasswordHash);
appUser.PasswordHash = passwordHasher;
appUserList.Add(appUser);
}
context.Users.AddRange(appUserList);
int j = context.SaveChanges();
}
}
public ActionResult Role()
{
AppUsersDbContext context = new AppUsersDbContext();
var Roles = context.Roles.ToList();
return(View(Roles));
}
public ActionResult UsersWithRoles()
{
AppUsersDbContext context = new AppUsersDbContext();
var usersWithRoles = (from user in context.Users
select new
{
UserId = user.Id,
Username = user.UserName,
Email = user.Email,
RoleNames = (from userRole in user.Roles
join role in context.Roles on userRole.RoleId
equals role.Id
select role.Name).ToList()
}).ToList().Select(p => new UserRoleViewModel()
{
UserId = p.UserId,
Username = p.Username,
Email = p.Email,
Role = string.Join(",", p.RoleNames)
});
ViewBag.Roles = getallRoles();
return(View(usersWithRoles));
}
public Seed()
{
var appUserContext = AppUsersDbContext.Create();
if (appUserContext.AllMigrationsApplied())
{
appUserContext.Database.Migrate();
appUserContext.EnsureSeeded();
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, AppUsersDbContext db)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
//Create Database
db.Database.Migrate();
app.UseAuthentication();
app.UseMvc();
}
public UsersController()
{
this._context = new AppUsersDbContext();
}
