public static void InitializeDataBase()
{
var dbContext = new AppDbContext();
if (dbContext.Database.Exists())
return;
dbContext.Database.Create();
AddUserRoles(dbContext);
}
private static void SaveDb(string actionName, int userId, string ip)
{
using (var db = new AppDbContext())
{
var activity = new UserActivity
{
User = db.Users.Find(userId),
Time = DateTime.UtcNow,
IpAddress = ip,
Action = actionName
};
db.UserActivities.Add(activity);
db.SaveChanges();
}
}
private static void AddUserRoles(AppDbContext dbContext)
{
var roles = new List<UserRole>
{
new UserRole {Name = "Administrator", Description = "系统管理员，负责用户管理，角色分配，数据备份"},
new UserRole {Name = "Reporter", Description = "报修员，由各班班干部或班主任负责"},
new UserRole {Name = "MaintenanceStaff", Description = "维修人员，由学校总务处派出"},
new UserRole {Name = "Supervisor", Description = "监督者，学校总务处主管领导"}
};
roles.ForEach(r => dbContext.UserRoles.Add(r));
var initialUser = new User
{
UserName = "******",
DisplayName = "Initial User",
Grade = -1,
IsEnabled = true,
Roles = new HashSet<UserRole>(),
PasswordHash = new PasswordHasher().HashPassword("admin")
};
initialUser.Roles.Add(roles[0]);
dbContext.Users.Add(initialUser);
dbContext.SaveChanges();
}