private static void SaveNewUsers()
{
var users = new List <User>
{
new User {
Name = "admin",
Password = "******",
Firstname = "Bidkar",
Lastname = "Aragón Cárdenas",
Email = "*****@*****.**",
Gender = gender.MAN,
RoleId = 1
},
new User {
Name = "guest",
Password = "******",
Firstname = "Jordan",
Lastname = "Bojorquez",
Email = "*****@*****.**",
Gender = gender.MAN,
RoleId = 2
},
new User {
Name = "operator",
Password = "******",
Firstname = "Alejandra",
Lastname = "Garcia",
Email = "*****@*****.**",
Gender = gender.WOMAN,
RoleId = 3
}
};
using (var db = new MatutinoDbContext())
{
try
{
db.Users.AddRange(users);
db.SaveChanges();
System.Console.WriteLine("Los usuarios han sido registrados correctamente.");
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
}
private static void PrintUserWithRoles()
{
using (var db = new MatutinoDbContext())
{
try
{
var users = db.Users.Include(u => u.Role).ToList();
foreach (var user in users)
{
System.Console.WriteLine($"Id:{user.Id}, Name:{user.Name}, Fullname:{user.Firstname} {user.Lastname}, Rolename:{user.Role.Name}");
}
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
}
private static void PrintRolesWithPermissions()
{
using (var db = new MatutinoDbContext())
{
var roles = db.Roles
.Include(r => r.Permissions)
.ThenInclude(h => h.Permission)
.ToList();
foreach (var role in roles)
{
var permissions = role.Permissions.ToList();
var perms = new List <string>();
foreach (var perm in permissions)
{
perms.Add(perm.Permission.Name);
}
System.Console.WriteLine($"{role.Name} has [{string.Join(',',perms.ToArray())}] permissions");
}
}
}
private static void PrintUsersWithPermissions()
{
using (var db = new MatutinoDbContext())
{
var users = db.Users
.Include(u => u.Role)
.ThenInclude(r => r.Permissions)
.ThenInclude(h => h.Permission)
.ToList();
foreach (var user in users)
{
var rolesPermissions = user.Role.Permissions;
var permissions = new List <string>();
foreach (var rp in rolesPermissions)
{
permissions.Add(rp.Permission.Name);
}
System.Console.WriteLine($"Id:{user.Id}, Name:{user.Name}, Fullname:{user.FullName}, Role:{user.Role.Name}, Permission:{string.Join(", ", permissions)}");
}
}
}
private static void setRolesAndPermissions()
{
using (var db = new MatutinoDbContext())
{
try
{
System.Console.WriteLine("Conectando a la base de datos...");
db.Database.EnsureCreated();
// var roleAdmin = new Role
// {
// Name = "Administrator",
// Description = "Role with all rights",
// Level = 1
// };
// var loginPermission = new Permission
// {
// Name = "Login",
// Description = "Users with it, can login"
// };
// db.Roles.Add(roleAdmin);
// db.Permissions.Add(loginPermission);
// db.SaveChanges();
var roles = new List <Role>
{
new Role {
Name = "Guest",
Description = "Role with only read rights",
Level = 2
},
new Role {
Name = "Operator",
Description = "Role with limit rights",
Level = 3
}
};
var permissions = new List <Permission>
{
new Permission {
Name = "Edit",
Description = "User can edit information"
},
new Permission {
Name = "Delete",
Description = "User can delete information"
},
new Permission {
Name = "View",
Description = "User can view information"
}
};
// db.Roles.AddRange(roles);
// db.Permissions.AddRange(permissions);
// db.SaveChanges();
var misRoles = db.Roles.ToList();
foreach (var role in misRoles)
{
System.Console.WriteLine($"Role: {role.Name}, Description: {role.Description}");
}
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
}
