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();
}
}
public void ConfigureAuth(IAppBuilder app)
{
// Configure the db context, user manager and signin manager to use a single instance per request
app.CreatePerOwinContext(SiriusContext.Create);
app.CreatePerOwinContext <SiriusUserManager>(SiriusUserManager.Create);
app.CreatePerOwinContext <SiriusSignInManager>(SiriusSignInManager.Create);
app.CreatePerOwinContext <SiriusRoleManager>(SiriusRoleManager.Create);
Database.SetInitializer <SiriusContext>(new MigrateDatabaseToLatestVersion <SiriusContext, Sirius.Data.Migrations.Configuration>());
SiriusContext context = new SiriusContext();
context.Database.Initialize(false);
// Enable the application to use a cookie to store information for the signed in user
// and to use a cookie to temporarily store information about a user logging in with a third party login provider
// Configure the sign in cookie
app.UseCookieAuthentication(new CookieAuthenticationOptions
{
AuthenticationType = "ApplicationCookie",
LoginPath = new PathString("/user/login"),
ExpireTimeSpan = TimeSpan.FromHours(3)
});
app.UseExternalSignInCookie(DefaultAuthenticationTypes.ExternalCookie);
// Enables the application to temporarily store user information when they are verifying the second factor in the two-factor authentication process.
app.UseTwoFactorSignInCookie(DefaultAuthenticationTypes.TwoFactorCookie, TimeSpan.FromMinutes(5));
// Enables the application to remember the second login verification factor such as phone or email.
// Once you check this option, your second step of verification during the login process will be remembered on the device where you logged in from.
// This is similar to the RememberMe option when you log in.
app.UseTwoFactorRememberBrowserCookie(DefaultAuthenticationTypes.TwoFactorRememberBrowserCookie);
}
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();
}
}
public RegisterRepository(SiriusContext _siriusContext) : base(_siriusContext)
{
}
public BaseRepository(SiriusContext context)
{
dbContext = context;
_dbset = context.Set <T>();
}
public SiriusContext Init()
{
return(dbContext ?? (dbContext = new SiriusContext()));
}
public UserRepository(SiriusContext context) : base(context)
{
}
public ItemRepository(SiriusContext _siriusContext) : base(_siriusContext)
{
}
public RoleRepository(SiriusContext _siriusContext) : base(_siriusContext)
{
}
public InvoiceRepository(SiriusContext _siriusContext) : base(_siriusContext)
{
}
public SettingRepository(SiriusContext context) : base(context)
{
}
