public UserEntity(User User)
{
this.Id = User.Id;
this.Username = User.Username;
this.Password = User.Password;
ROLES Roles = ROLES.USER;
if (User.Admin != null)
{
Roles = Roles | ROLES.ADMIN;
}
if (User.Student != null)
{
Roles |= ROLES.STUDENT;
}
if (User.Lecturer != null)
{
Roles |= ROLES.LECTURER;
}
if (User.HrEmployee != null)
{
Roles |= ROLES.HrEmployee;
}
this.Roles = Roles.ToString().Replace(" ", "").Split(",").ToList();
}
public ROLES ModificationQuery(int?SN)
{
ROLES row = null;
using (DbCommand cmd = Db.CreateConnection().CreateCommand())
{
string sql = @"
SELECT SN,NAME,MODE,CDATE,CUSER,MDATE,MUSER
FROM ROLES
WHERE SN=@SN
";
Db.AddInParameter(cmd, "SN", DbType.Int32, SN);
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
using (IDataReader reader = Db.ExecuteReader(cmd))
{
while (reader.Read())
{
row = new ROLES
{
SN = reader["SN"] as Int32? ?? null,
NAME = reader["NAME"] as string,
MODE = reader["MODE"] as string,
CDATE = reader["CDATE"] as DateTime?,
CUSER = reader["CUSER"] as string,
MDATE = reader["MDATE"] as DateTime?,
MUSER = reader["MUSER"] as string
};
}
}
}
return(row);
}
public ActionResult EditarRol(ROLES _role)
{
if (string.IsNullOrEmpty(_role.Descripcion))
{
ModelState.AddModelError("Role Description", "Role Description must be entered");
log.Warn("Se debe ingresar una descripicion para el rol");
}
//EntityState state = database.Entry(_role).State;
Usuarios user = database.Usuarios.Where(r => r.Usuario == User.Identity.Name).FirstOrDefault();
if (ModelState.IsValid)
{
database.Entry(_role).State = EntityState.Modified;
_role.Modificado = DateTime.Now;
database.SaveChanges();
log.InfoFormat("Se modifico correctamente el rol {0}", _role.Nombre);
return(RedirectToAction("ListaRoles", new RouteValueDictionary(new { id = _role.Rol_Id })));
}
// USERS combo
ViewBag.UserId = new SelectList(database.Usuarios.Where(r => r.Inactivo == false || r.Inactivo == null), "User_Id", "Usuario");
// Rights combo
ViewBag.permisoId = new SelectList(database.Permisos.OrderBy(a => a.Permiso_Id), "Permiso_Id", "Descripcion");
ViewBag.List_boolNullYesNo = this.List_boolNullYesNo();
return(View(_role));
}
public PlayerLogic(int id, string name) {
this.name = name;
this.id = id;
this.hand = new List<bool>();
this.role = ROLES.Liberal;
this.playerState = PLAYERSTATES.Idle;
this.isDead = false;
}
/// <summary>
/// Create a new ROLES object.
/// </summary>
/// <param name="id">Initial value of ID.</param>
/// <param name="rOLENAME">Initial value of ROLENAME.</param>
public static ROLES CreateROLES(int id, string rOLENAME)
{
ROLES rOLES = new ROLES();
rOLES.ID = id;
rOLES.ROLENAME = rOLENAME;
return(rOLES);
}
public ActionResult DeleteConfirmed(int id)
{
ROLES rOLES = db.ROLES.Find(id);
db.ROLES.Remove(rOLES);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void OnActionExecuting(ActionExecutingContext FilterContext)
{
if (FilterContext.HttpContext.Request.Path.Value.StartsWith("/api/Users/Login"))
{
return;
}
var Token = FilterContext.HttpContext.Request.Cookies["JWT"];
var JWTEntity = JWTHandler.Decode(Token);
if (JWTEntity != null)
{
FilterContext.HttpContext.User = new MyPrincipal(JWTEntity.UserEntity);
string Path = FilterContext.HttpContext.Request.Path.HasValue
? FilterContext.HttpContext.Request.Path.Value
: "";
string Method = FilterContext.HttpContext.Request.Method;
string[] temp = Path.Split('/');
for (int i = 0; i < temp.Length; i++)
{
Guid id;
bool isGuid = Guid.TryParse(temp[i], out id);
if (isGuid)
{
temp[i] = "*";
}
}
Path = string.Join("/", temp);
ClassSurvey1Context Context = new ClassSurvey1Context();
Console.WriteLine("Filter " + Path + " " + Method);
Operation Operation = Context.Operations
.FirstOrDefault(o => o.Link.Equals(Path) && o.Method.Equals(Method));
if (Operation == null)
{
return;
}
Console.WriteLine(Operation.Link);
string role = string.Join(",", JWTEntity.UserEntity.Roles);
ROLES roles = (ROLES)Enum.Parse(typeof(ROLES), role);
Console.WriteLine(roles);
var operationRole = (ROLES)Enum.Parse(typeof(ROLES), Operation.Role.ToString());
if (Operation != null && operationRole != ROLES.NONE)
{
if ((operationRole & roles) == 0)
{
throw new ForbiddenException("Bạn không có quyền truy cập");
}
}
return;
}
if (FilterContext.HttpContext.Request.Path.Value.StartsWith("api"))
{
throw new ForbiddenException("Cookie không hợp lệ");
}
throw new ForbiddenException("Login First");
}
public static void Main(string[] args)
{
var host = BuildWebHost(args);
SeedDatabaseWithRoles(host, ROLES.Roles());
SeedDatabaseWithAdmin(host);
host.Run();
}
private RolViewModel Convertir(ROLES roles)
{
return(new RolViewModel
{
idRol = roles.idRol,
nombreRol = roles.nombreRol,
descripcionRol = roles.descripcionRol
});
}
public void CARGARVALORESINICIALES()
{
List <ROLES> listRol = ROLES.ROLESObtenerTodos("SI");
cboRollBuscar.DataSource = listRol;
cboRollBuscar.DataTextField = "NOMBRE";
cboRollBuscar.DataValueField = "ID_ROLL";
cboRollBuscar.DataBind();
}
public ActionResult Edit([Bind(Include = "ID_ROL,ROL,DESCRIPCION")] ROLES rOLES)
{
if (ModelState.IsValid)
{
db.Entry(rOLES).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rOLES));
}
public bool IsInRole(ROLES role)
{
var roles = Roles.GetRolesForUser(UserName);
foreach (var r in roles)
{
if (r.Equals(role.ToString()))
return true;
}
return false;
}
public ActionResult Create([Bind(Include = "ID_ROL,ROL,DESCRIPCION")] ROLES rOLES)
{
if (ModelState.IsValid)
{
db.ROLES.Add(rOLES);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rOLES));
}
public ActionResult Edit([Bind(Include = "ID_ROL,ID_PERFIL,DESCRIPCION")] ROLES rOLES)
{
if (ModelState.IsValid)
{
db.Entry(rOLES).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_PERFIL = new SelectList(db.PERFILES, "ID_PERFIL", "DESCRIPCION", rOLES.ID_PERFIL);
return(View(rOLES));
}
public ActionResult Create([Bind(Include = "rol_code,rol_name")] ROLES rOLES)
{
if (ModelState.IsValid)
{
db.ROLES.Add(rOLES);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rOLES));
}
public ActionResult Create([Bind(Include = "ID,NOMBRE,DETALLLE")] ROLES rOLES)
{
if (ModelState.IsValid)
{
rOLES.ID = db.ROLES.Max(x => x.ID) + 1;
db.ROLES.Add(rOLES);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rOLES));
}
public PartialViewResult AddPermission2RoleReturnPartialView(int id, int permisoId)
{
ROLES role = database.ROLES.Find(id);
Permisos _permiso = database.Permisos.Find(permisoId);
if (!role.Permisos.Contains(_permiso))
{
role.Permisos.Add(_permiso);
database.SaveChanges();
}
return(PartialView("_ListaPermisos", role));
}
public PartialViewResult DeletePermissionFromRoleReturnPartialView(int id, int permisoId)
{
ROLES _role = database.ROLES.Find(id);
Permisos _permiso = database.Permisos.Find(permisoId);
if (_role.Permisos.Contains(_permiso))
{
_role.Permisos.Remove(_permiso);
database.SaveChanges();
}
return(PartialView("_ListaPermisos", _role));
}
public void RoleInsert(RoleRequest role)
{
ROLES RoleInsert = new ROLES()
{
NAME = role.roleName,
INSERTDATE = DateTime.Now,
STATUS = 1
};
_context.ROLES.Add(RoleInsert);
_context.SaveChanges();
}
public PartialViewResult DeleteRoleFromPermissionReturnPartialView(int id, int permisoId)
{
ROLES role = database.ROLES.Find(id);
Permisos permission = database.Permisos.Find(permisoId);
if (role.Permisos.Contains(permission))
{
role.Permisos.Remove(permission);
database.SaveChanges();
}
return(PartialView("_ListaRoles4Permisos", permission));
}
public PartialViewResult DeletePermissionFromRoleReturnPartialView(int id, int permissionId)
{
ROLES _role = database.ROLES.Find(id);
PERMISSIONS _permission = database.PERMISSIONS.Find(permissionId);
if (_role.PERMISSIONS.Contains(_permission))
{
_role.PERMISSIONS.Remove(_permission);
database.SaveChanges();
}
return(PartialView("_ListPermissions", _role));
}
public ActionResult DeleteUserRole(int id, int userId)
{
ROLES role = database.ROLES.Find(id);
USERS user = database.USERS.Find(userId);
if (role.USERS.Contains(user))
{
role.USERS.Remove(user);
database.SaveChanges();
}
return(RedirectToAction("Details", "USER", new { id = userId }));
}
public PartialViewResult AddRole2ReportReturnPartialView(int id, int reportId)
{
ROLES role = database.ROLES.Find(id);
REPORTS _report = database.REPORTS.Find(reportId);
if (!role.REPORTS.Contains(_report))
{
role.REPORTS.Add(_report);
database.SaveChanges();
}
return(PartialView("_ListRolesTable4Report", _report));
}
public PartialViewResult AddUser2RoleReturnPartialView(int id, int userId)
{
ROLES role = database.ROLES.Find(id);
USERS user = database.USERS.Find(userId);
if (!role.USERS.Contains(user))
{
role.USERS.Add(user);
database.SaveChanges();
}
return(PartialView("_ListUsersTable4Role", role));
}
public PartialViewResult AddRole2PermissionReturnPartialView(int permissionId, int roleId)
{
ROLES role = database.ROLES.Find(roleId);
PERMISSIONS _permission = database.PERMISSIONS.Find(permissionId);
if (!role.PERMISSIONS.Contains(_permission))
{
role.PERMISSIONS.Add(_permission);
database.SaveChanges();
}
return(PartialView("_ListRolesTable4Permission", _permission));
}
public PartialViewResult DeleteRoleFromPermissionReturnPartialView(int id, int permissionId)
{
ROLES role = database.ROLES.Find(id);
PERMISSIONS permission = database.PERMISSIONS.Find(permissionId);
if (role.PERMISSIONS.Contains(permission))
{
role.PERMISSIONS.Remove(permission);
database.SaveChanges();
}
return(PartialView("_ListRolesTable4Permission", permission));
}
public PartialViewResult AddUser2RoleReturnPartialView(int id, int userId)
{
ROLES role = database.ROLES.Find(id);
Usuarios user = database.Usuarios.Find(userId);
if (!role.Usuarios.Contains(user))
{
role.Usuarios.Add(user);
database.SaveChanges();
}
return(PartialView("_ListaUsuarios4Roles", role));
}
public PartialViewResult AddRole2PermissionReturnPartialView(int permisoId, int roleId)
{
ROLES role = database.ROLES.Find(roleId);
Permisos _permiso = database.Permisos.Find(permisoId);
if (!role.Permisos.Contains(_permiso))
{
role.Permisos.Add(_permiso);
database.SaveChanges();
}
return(PartialView("_ListaRoles4Permisos", _permiso));
}
public void TestDeleteGeneric()
{
ROLES roles = new ROLES();
using (UnidadDeTrabajo<ROLES> Unidad = new UnidadDeTrabajo<ROLES>(new BDContext()))
{
roles = Unidad.genericDAL.Get(2);
Unidad.genericDAL.Remove(roles);
Assert.AreEqual(true, Unidad.Complete());
}
}
public PartialViewResult AddPermission2RoleReturnPartialView(int id, int permissionId)
{
ROLES role = database.ROLES.Find(id);
PERMISSIONS _permission = database.PERMISSIONS.Find(permissionId);
if (!role.PERMISSIONS.Contains(_permission))
{
role.PERMISSIONS.Add(_permission);
database.SaveChanges();
}
return(PartialView("_ListPermissions", role));
}
public ActionResult Create([Bind(Include = "ID_ROL,ID_PERFIL,DESCRIPCION")] ROLES rOLES)
{
if (ModelState.IsValid)
{
db.ROLES.Add(rOLES);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_PERFIL = new SelectList(db.PERFILES, "ID_PERFIL", "DESCRIPCION", rOLES.ID_PERFIL);
return(View(rOLES));
}
public PartialViewResult DeleteRoleFromReportReturnPartialView(int id, int reportId)
{
ROLES role = database.ROLES.Find(id);
REPORTS report = database.REPORTS.Find(reportId);
if (role.REPORTS.Contains(report))
{
role.REPORTS.Remove(report);
database.SaveChanges();
}
return(PartialView("_ListRolesTable4Report", report));
}
