protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85));
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
// any guid
const string ADMIN_ID = "a18be9c0-aa65-4af8-bd17-00bd9344e575";
// any guid, but nothing is against to use the same one
const string ROLE_ID = ADMIN_ID;
modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole
{
Id = ROLE_ID,
Name = "Administrador",
NormalizedName = "ADMINISTRADOR"
});
var hasher = new PasswordHasher <Usuario>();
modelBuilder.Entity <Usuario>().HasData(new Usuario
{
Id = ADMIN_ID,
Nome = "Admin",
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = hasher.HashPassword(null, "12345678"),
SecurityStamp = hasher.GetHashCode().ToString()
});
modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string>
{
RoleId = ROLE_ID,
UserId = ADMIN_ID
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <Cidade>().HasData(new Cidade
{
Id = 1,
Nome = "Barra Bonita",
Estado = "SP"
}, new Cidade
{
Id = 2,
Nome = "Igaraçu do Tietê",
Estado = "SP"
}, new Cidade
{
Id = 3,
Nome = "Bauru",
Estado = "SP"
}, new Cidade
{
Id = 4,
Nome = "Macatuba",
Estado = "SP"
}, new Cidade
{
Id = 5,
Nome = "Pederneiras",
Estado = "SP"
}, new Cidade
{
Id = 6,
Nome = "Lençois Paulista",
Estado = "SP"
});
modelBuilder.Entity <TipoObra>().HasData(new TipoObra
{
Id = 1,
Nome = "Fotografia"
}, new TipoObra
{
Id = 2,
Nome = "Artes Plásticas"
}, new TipoObra
{
Id = 3,
Nome = "Escultura"
}, new TipoObra
{
Id = 4,
Nome = "Pintura"
}, new TipoObra
{
Id = 5,
Nome = "Modelagem 3D"
});
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85));
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
// any guid
const string ADMIN_ID = "a18be9c0-aa65-4af8-bd17-00bd9344e575";
// any guid, but nothing is against to use the same one
const string ROLE_ID = ADMIN_ID;
modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole
{
Id = ROLE_ID,
Name = "Administrador",
NormalizedName = "ADMINISTRADOR"
},
new IdentityRole
{
Id = Guid.NewGuid().ToString(),
Name = "Artista",
NormalizedName = "ARTISTA"
});
var hasher = new PasswordHasher <Usuario>();
modelBuilder.Entity <Usuario>().HasData(new Usuario
{
Id = ADMIN_ID,
Nome = "Admin",
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = hasher.HashPassword(null, "123456"),
SecurityStamp = hasher.GetHashCode().ToString()
});
modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string>
{
RoleId = ROLE_ID,
UserId = ADMIN_ID
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85));
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
// any guid
const string ADMIN_ID = "a18be9c0-aa65-4af8-bd17-00bd9344e575";
// any guid, but nothing is against to use the same one
const string ROLE_ID = ADMIN_ID;
modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole
{
Id = ROLE_ID,
Name = "Administrador",
NormalizedName = "ADMINISTRADOR"
},
new IdentityRole
{
Id = Guid.NewGuid().ToString(),
Name = "Visitante",
NormalizedName = "VISITANTE"
});
var hasher = new PasswordHasher <Usuario>();
modelBuilder.Entity <Usuario>().HasData(new Usuario
{
Id = ADMIN_ID,
Nome = "Admin",
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = hasher.HashPassword(null, "123456"),
SecurityStamp = hasher.GetHashCode().ToString(),
DataNascimento = Convert.ToDateTime("08/04/2002"),
Apelido = "Admin"
});
modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string>
{
RoleId = ROLE_ID,
UserId = ADMIN_ID
});
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
//para que definir um tamanho maximo de caracter, para que o banco aguente...
//controla as informações do usuários, esses campos vem do Identity.EntityFrameworkCore...
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85));
modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85));
//identityRole seria o perfil
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85));
modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
//muitos pra muitos
modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
//somente se tiver o migration funcionando...
//any guid(Um alfa numerico)
//chave do usuario
const string ADMIN_ID = "al8be9c0-aa65-4af8-bd17-00bd9344e575";
//any guid, but nothing is against to use the same one
const string ROLE_ID = ADMIN_ID;
//startando os dados do perfil do admin
modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole
{
Id = ROLE_ID,
Name = "Administrador",
NormalizedName = "ADMINISTRADOR"
},
/*Novo usuario*/
new IdentityRole
{
Id = Guid.NewGuid().ToString(),
Name = "Artista",
NormalizedName = "ARTISTA"
});
//startando um usuario se não não vai ter como logar
//hasher possui os componentes para criar criptografia
var hasher = new PasswordHasher <Usuario>();
modelBuilder.Entity <Usuario>().HasData(new Usuario
{
Id = ADMIN_ID,
Nome = "Admin",
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = hasher.HashPassword(null, "123456"),
SecurityStamp = hasher.GetHashCode().ToString()
});
modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string>
{
RoleId = ROLE_ID,
UserId = ADMIN_ID
});
modelBuilder.Entity <Cidade>().HasData(new Cidade
{
Id = 1,
Nome = "Barra Bonita",
Estado = "SP"
}, new Cidade
{
Id = 2,
Nome = "Igaraçu do Tietê",
Estado = "SP"
}, new Cidade
{
Id = 3,
Nome = "Bauru",
Estado = "SP"
}, new Cidade
{
Id = 4,
Nome = "Macatuba",
Estado = "SP"
}, new Cidade
{
Id = 5,
Nome = "Pederneiras",
Estado = "SP"
}, new Cidade
{
Id = 6,
Nome = "Lençois Paulista",
Estado = "SP"
});
modelBuilder.Entity <TipoObra>().HasData(new TipoObra
{
Id = 1,
Nome = "Fotografia"
}, new TipoObra
{
Id = 2,
Nome = "Artes Plásticas"
}, new TipoObra
{
Id = 3,
Nome = "Escultura"
}, new TipoObra
{
Id = 4,
Nome = "Pintura"
}, new TipoObra
{
Id = 5,
Nome = "Modelagem 3D"
});
}
protected override void OnModelCreating(ModelBuilder builder)
{
base.OnModelCreating(builder);
builder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85));
builder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85));
builder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85));
builder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85));
builder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85));
builder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
builder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85));
builder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
builder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
builder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
builder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
builder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
builder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85));
builder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
builder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85));
builder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85));
builder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
// IDS dos perfis
string ROLE_ADMIN_ID = Guid.NewGuid().ToString();
string ROLE_CLIENTE_ID = Guid.NewGuid().ToString();
// IDS dos usuarios
string ADMIN_ID = Guid.NewGuid().ToString();
string CLIENTE_ID = Guid.NewGuid().ToString();
// Permiti cadastrar um perfil
builder.Entity <IdentityRole>().HasData(
new IdentityRole
{
Id = ROLE_ADMIN_ID, // Chave primaria
Name = "Administrador",
NormalizedName = "ADMINISTRADOR" // Regra - fica tudo em maiusculo
},
new IdentityRole
{
Id = ROLE_CLIENTE_ID, // Chave primaria
Name = "Cliente",
NormalizedName = "CLIENTE" // Regra - fica tudo em maiusculo
}
);
// Criptografia da senha
var hash1 = new PasswordHasher <Usuario>();
var hash2 = new PasswordHasher <Usuario>();
builder.Entity <Usuario>().HasData(
new Usuario
{
Id = ADMIN_ID,
Nome = "Admin",
Apelido = "Admin",
DataNascimento = DateTime.Now, // Retorna data e hora na hora criada
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = hash1.HashPassword(null, "ateliemoonchild123456789"), // Nulo e senha que vai ser criptografada
SecurityStamp = hash1.GetHashCode().ToString() // Necessario para discriptografa
},
new Usuario
{
Id = CLIENTE_ID,
Nome = "Alexandre Tavano Cardoso",
Apelido = "Tavano",
DataNascimento = Convert.ToDateTime("05/08/2002"),
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
PasswordHash = hash2.HashPassword(null, "UserProgramador123"), // Nulo e senha que vai ser criptografada
SecurityStamp = hash2.GetHashCode().ToString() // Necessario para discriptografa
}
);
// Determina qual user é de qual categoria
builder.Entity <IdentityUserRole <string> >().HasData(
new IdentityUserRole <string>
{
RoleId = ROLE_ADMIN_ID,
UserId = ADMIN_ID
},
new IdentityUserRole <string>
{
RoleId = ROLE_CLIENTE_ID,
UserId = CLIENTE_ID
}
);
}
