protected override void Up(MigrationBuilder migrationBuilder)
{
var optionsBuilder = new DbContextOptionsBuilder <SiriusContext>();
string connectionString = "Host=127.0.0.1;Port=5432;Database=siriusdb;Username=siriususer;Password=Uncle340571578;Integrated Security=false;";
var options = optionsBuilder
.UseNpgsql(connectionString)
.Options;
using (var context = new SiriusContext(options))
{
Role adminRole = new Role {
Id = DefaultValues.Roles.Admin.Id, Name = "Администратор"
};
Role viewerRole = new Role {
Id = DefaultValues.Roles.Viewer.Id, Name = "Просмотр"
};
context.Roles.AddRange(new Role[] { adminRole, viewerRole });
/*
* User admin = context.Users.Where(user => user.FirstName == "Администратор").FirstOrDefault();
* if (admin != null)
* {
* admin.Role = adminRole;
* admin.RoleId = adminRole.Id;
* context.Users.Update(admin);
* }*/
context.SaveChanges();
}
}
protected override void Up(MigrationBuilder migrationBuilder)
{
var optionsBuilder = new DbContextOptionsBuilder <SiriusContext>();
string connectionString = "Host=127.0.0.1;Port=5432;Database=siriusdb;Username=siriususer;Password=Uncle340571578;Integrated Security=false;";
var options = optionsBuilder
.UseNpgsql(connectionString)
.Options;
using (var context = new SiriusContext(options))
{
Role viewerRole = context.Roles.Where(role => role.Id == DefaultValues.Roles.Viewer.Id).FirstOrDefault();
var startDate = DateConverter.ConvertToRTS(DateTime.UtcNow.ToLocalTime());
byte[] passwordHash, passwordSalt;
PasswordHash.CreatePasswordHash("user2019", out passwordHash, out passwordSalt);
var user = new User {
FirstName = "Пользователь",
LastName = "",
Username = "******",
Id = Guid.NewGuid(),
Role = viewerRole,
StartDate = startDate,
IsConfirmed = true,
PasswordHash = passwordHash,
PasswordSalt = passwordSalt
};
context.Users.Add(user);
context.SaveChanges();
}
}
protected override void Up(MigrationBuilder migrationBuilder)
{
var optionsBuilder = new DbContextOptionsBuilder <SiriusContext>();
string connectionString = "Host=127.0.0.1;Port=5432;Database=siriusdb;Username=siriususer;Password=Uncle340571578;Integrated Security=false;";
var options = optionsBuilder
.UseNpgsql(connectionString)
.Options;
using (var context = new SiriusContext(options))
{
Role adminRole = context.Roles.Where(role => role.Id == DefaultValues.Roles.Admin.Id).FirstOrDefault();
//User admin = context.Users.Where(user => user.FirstName == "Администратор").FirstOrDefault();
var users = context.Users.ToArray();
foreach (var user in users)
{
user.Role = adminRole;
context.Users.Update(user);
}
context.SaveChanges();
}
}