private static void seedUsersTable(StudentPaperServiceContext context)
{
List <Professor> professors = new List <Professor>();
List <Subject> subjects = new List <Subject>();
List <ProfessorSubject> professorSubjects = new List <ProfessorSubject>();
List <Student> students = new List <Student>();
List <SeminarPaper> seminarPapers = new List <SeminarPaper>();
seedData(out professors, out subjects, out professorSubjects, out students, out seminarPapers);
Admin admin = new Admin()
{
Id = "11", AccessFailedCount = 0, ConcurrencyStamp = "b58d0834-4428-4b8b-8585-54f91a26ba71", Email = null, EmailConfirmed = false, LockoutEnabled = true, LockoutEnd = null, NormalizedEmail = null, NormalizedUserName = "******", PasswordHash = "AQAAAAEAACcQAAAAEHBL8bFd9GJAYlw8zQiyUsq4Qg+7/1XOo3XBQwUwx50VIlJcoqi8GgrMwGF5DzHFiw==", PhoneNumber = null, PhoneNumberConfirmed = false, SecurityStamp = "ac1d41a1-6a1b-43d5-83d0-1eb64223e354", TwoFactorEnabled = false, UserName = "******"
};
context.Users.Add(admin);
context.SaveChanges();
context.Users.AddRange(professors);
context.SaveChanges();
context.Users.AddRange(students);
context.SaveChanges();
context.Subjects.AddRange(subjects);
context.SaveChanges();
context.ProfessorSubjects.AddRange(professorSubjects);
context.SaveChanges();
context.SeminarPapers.AddRange(seminarPapers);
context.SaveChanges();
}
private static void seedUserRolesTable(StudentPaperServiceContext context)
{
context.UserRoles.AddRange(
new IdentityUserRole <string>()
{
UserId = "11", RoleId = "1"
},
new IdentityUserRole <string>()
{
UserId = "21", RoleId = "2"
},
new IdentityUserRole <string>()
{
UserId = "22", RoleId = "2"
},
new IdentityUserRole <string>()
{
UserId = "23", RoleId = "2"
},
new IdentityUserRole <string>()
{
UserId = "24", RoleId = "2"
},
new IdentityUserRole <string>()
{
UserId = "25", RoleId = "2"
},
new IdentityUserRole <string>()
{
UserId = "31", RoleId = "3"
},
new IdentityUserRole <string>()
{
UserId = "32", RoleId = "3"
},
new IdentityUserRole <string>()
{
UserId = "33", RoleId = "3"
},
new IdentityUserRole <string>()
{
UserId = "34", RoleId = "3"
},
new IdentityUserRole <string>()
{
UserId = "35", RoleId = "3"
},
new IdentityUserRole <string>()
{
UserId = "36", RoleId = "3"
}
);
context.SaveChanges();
}
public static bool AllMigrationsApplied(this StudentPaperServiceContext context)
{
var applied = context.GetService <IHistoryRepository>()
.GetAppliedMigrations()
.Select(m => m.MigrationId);
var total = context.GetService <IMigrationsAssembly>()
.Migrations
.Select(m => m.Key);
return(!total.Except(applied).Any());
}
public static StudentPaperServiceContext EnsureDatabaseSeeded(this StudentPaperServiceContext context)
{
if (!context.Roles.Any())
{
seedRolesTable(context);
}
if (!context.Users.Any())
{
seedUsersTable(context);
}
if (!context.UserRoles.Any())
{
seedUserRolesTable(context);
}
return(context);
}
private static void seedRolesTable(StudentPaperServiceContext context)
{
context.Roles.AddRange(
new IdentityRole()
{
Id = "1", Name = "admin"
},
new IdentityRole()
{
Id = "2", Name = "profesor"
},
new IdentityRole()
{
Id = "3", Name = "student"
}
);
context.SaveChanges();
}
