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);
}
