public static IEnumerable <string> GetRoles(this ERoles role) { List <string> result = new List <string>(); if (role.HasFlag(ERoles.VIEWER)) { result.Add(nameof(ERoles.VIEWER)); } if (role.HasFlag(ERoles.MODERATOR)) { result.Add(nameof(ERoles.MODERATOR)); } if (role.HasFlag(ERoles.EDITOR)) { result.Add(nameof(ERoles.EDITOR)); } if (role.HasFlag(ERoles.SERVICE)) { result.Add(nameof(ERoles.SERVICE)); } if (role.HasFlag(ERoles.ADMIN)) { result.Add(nameof(ERoles.ADMIN)); } return(result); }
public ActionResult RemoveUser(ERoles roleCode, string userName) { var user = this.userManager.FindByName(userName); this.userManager.RemoveFromRole(user, roleCode); return(this.Ok()); }
//Metodo para COnsultar Roles public DataTable ObtenerRoles(string sNameRol) { DataTable dt = oConn.ejecutarDataTable("UP_WEB_OBTENERROLES", sNameRol); ERoles oeRoles = new ERoles(); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i <= dt.Rows.Count - 1; i++) { oeRoles.Rolid = dt.Rows[i]["Rol_id"].ToString().Trim(); oeRoles.RolName = dt.Rows[i]["Rol_Name"].ToString().Trim(); oeRoles.RolDescription = dt.Rows[i]["Rol_Description"].ToString().Trim(); oeRoles.RolStatus = Convert.ToBoolean(dt.Rows[i]["Rol_Status"].ToString().Trim()); oeRoles.RolCreateBy = dt.Rows[i]["Rol_CreateBy"].ToString().Trim(); oeRoles.RolDateBy = dt.Rows[i]["Rol_DateBy"].ToString().Trim(); oeRoles.RolModiBy = dt.Rows[i]["Rol_DateModiBy"].ToString().Trim(); } } return(dt); } else { return(null); } }
public ActionResult AddUser(ERoles roleCode, string userName) { var user = this.userManager.FindByName(userName); this.userManager.AddToRole(user, roleCode); return(this.Ok()); }
public ERoles[] GetById(int userId) { List <ERoles> roles = new List <ERoles>(); var dbContext = new SQLDbContext(); string SQL = @"SELECT * FROM VW_Usuarios_Perfils WHERE IdUsuario = @IdUsuario"; var parametros = new SqlParameter[] { new SqlParameter("@IdUsuario", userId) }; DataTable dtResult = dbContext.ExecutarConsulta(SQL, parametros); foreach (DataRow dataRow in dtResult.Rows) { int perfilId = Convert.ToInt32(dataRow["IdPerfil"]); ERoles role = EnumHelper.PerfilIdParaPerfil(perfilId); roles.Add(role); } return(roles.ToArray()); }
public EmployeeInfo(Guid id, string firstName, string lastName, string userName, ERoles role) { Id = id; FirstName = firstName; LastName = lastName; UserName = userName; Role = role; }
//Metdo para Actualizacion de Roles public ERoles ActualizaRol(string sRolid, string sRolName, string sRolDescription, bool bRolStatus, string sRolModiBy, string sRolDateModiBy) { Lucky.Data.Common.Application.DRoles odacroles = new Lucky.Data.Common.Application.DRoles(); ERoles oeroles = odacroles.ActulizarRoles(sRolid, sRolName, sRolDescription, bRolStatus, sRolModiBy, sRolDateModiBy); odacroles = null; return(oeroles); }
//---Metodo de Consulta de Roles public DataTable BuscarRoles(string sRolName) { Lucky.Data.Common.Application.DRoles odsroles = new Lucky.Data.Common.Application.DRoles(); ERoles oeroles = new ERoles(); DataTable dtroles = odsroles.ObtenerRoles(sRolName); odsroles = null; return(dtroles); }
//----Metodo para registrar Roles public ERoles RegistrarRoles( string sRol_id, string sRolName, string sRolDescription, bool bRolStatus, string sRolCreateBy, string sRolDateBy, string sRolModiBy, string sRolDateModiBy) { Lucky.Data.Common.Application.DRoles odrroles = new Lucky.Data.Common.Application.DRoles(); ERoles oeroles = odrroles.RegistrarRolesPK(sRol_id, sRolName, sRolDescription, bRolStatus, sRolCreateBy, sRolDateBy, sRolModiBy, sRolDateModiBy); odrroles = null; return(oeroles); }
public ERoles Roles_Update(ERoles item, ref ETransactionResult _transResult) { ERoles itemUpdated = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("UpdateTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_Roles_Update"; sqlCmd.Parameters.AddWithValue("@Id", item.Id); sqlCmd.Parameters.AddWithValue("@DescripcionRol", item.DescripcionRol); using (var reader = sqlCmd.ExecuteReader()) { while (reader.Read()) { itemUpdated = new ERoles(); itemUpdated.Id = (string)reader["Id"]; itemUpdated.DescripcionRol = (string)reader["DescripcionRol"]; } } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 1; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemUpdated); }
public List <ERoles> Roles_GetAll(ref ETransactionResult _transResult) { var list = new List <ERoles>(); _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectAllTranstaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_Roles_SelectAll"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { var item = new ERoles(); item.Id = (string)reader["Id"]; item.DescripcionRol = (string)reader["DescripcionRol"]; list.Add(item); } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(list); }
//Metodo para Actualizar Roles public ERoles ActulizarRoles(string sRol_id, string sRolName, string sRolDescription, bool bRolStatus, string sRolModiBy, string sRolDateModiBy) { DataTable dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZAROL", sRol_id, sRolName, sRolDescription, bRolStatus, sRolModiBy, sRolDateModiBy); ERoles oearoles = new ERoles(); oearoles.Rolid = sRol_id; oearoles.RolName = sRolName; oearoles.RolDescription = sRolDescription; oearoles.RolStatus = bRolStatus; oearoles.RolModiBy = sRolModiBy; oearoles.RolDateModiBy = sRolDateModiBy; return(oearoles); }
public static List <string> GetMenuItemList(ERoles role) { switch (role) { case ERoles.AreaManager: return(MenuItemListForAreaManager); case ERoles.FieldOfficer: return(MenuItemListForFieldOfficer); case ERoles.ZSM_RSM: return(MenuItemListForZSM_RSM); default: return(MenuItemListForFieldOfficer); } }
//Metodo para Registrar Roles public ERoles RegistrarRolesPK(string iRol_id, string sRolName, string sRolDescription, bool bRolStatus, string sRolCreateBy, string sRolDateBy, string sRolModiBy, string sRolDateModiBy) { DataTable dt = oConn.ejecutarDataTable("UP_WEB_RERGISTERROLES", iRol_id, sRolName, sRolDescription, bRolStatus, sRolCreateBy, sRolDateBy, sRolModiBy, sRolDateModiBy); ERoles oerRoles = new ERoles(); oerRoles.Rolid = iRol_id; oerRoles.RolName = sRolName; oerRoles.RolDescription = sRolDescription; oerRoles.RolStatus = Convert.ToBoolean(bRolStatus.ToString().Trim()); oerRoles.RolCreateBy = sRolCreateBy; oerRoles.RolDateBy = sRolDateBy; oerRoles.RolModiBy = sRolModiBy; oerRoles.RolDateModiBy = sRolDateModiBy; return(oerRoles); }
public void Roles_Delete(ERoles item, ref ETransactionResult _transResult) { _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("DeleteTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_Roles_Delete"; sqlCmd.Parameters.AddWithValue("@Id", item.Id); sqlCmd.ExecuteNonQuery(); transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } }
public Role(ERoles description) : this() { Description = description; Id = EnumHelper.PerfilParaPerfilId(description); }
public async Task <UserActionResult> RegisterUserAsync(UserToRegisterDto userToRegister, ERoles role = ERoles.User) { // Checking if user exist if (await CheckUserExistAync(userToRegister.Email)) { string messageFailed = $"User with email '{userToRegister.Email}'"; _logger.LogWarning(messageFailed); return(InitResult(0, null, true, messageFailed)); } // Adding crypto service to generate salt and use hashing using var hmac = new HMACSHA512(); var user = new EUser { FirstName = userToRegister.FirstName, LastName = userToRegister.LastName, Email = userToRegister.Email.ToLower(), PasswordSalt = hmac.Key, PasswordHash = hmac.ComputeHash(Encoding.UTF8.GetBytes(userToRegister.Password)), CreatedUTC = DateTime.UtcNow }; // Create user await _dbcontext.Users.AddAsync(user); await _dbcontext.SaveChangesAsync(); var userRole = new ERole { EUserId = user.id, Role = userToRegister.Email == "admin@localhost" ? ERoles.Administrator : ERoles.User, EUser = user }; // Assign user role await _dbcontext.Roles.AddAsync(userRole); await _dbcontext.SaveChangesAsync(); string messageSeccess = $"User '{userToRegister.Email}' has been registered."; _logger.LogInformation(messageSeccess); return(InitResult(user.id, null, false, messageSeccess)); }
public static EmployeeInfo CreateNew(String firstName, String lastName, string userName, ERoles role) { return new EmployeeInfo(Guid.NewGuid(), firstName, lastName, userName, role); }