public void TestDeleteUserRole()
{
string failureResult = "";
try
{
// Arrange
var dbContext = DbContextMocker.UserRoleDbContext();
var dbUserContext = DbContextMocker.UserDbContext();
var controller = new UsersRoleRepository(dbUserContext, dbContext);
var request = new DeleteAssignUserRole
{
username = "******",
rolename = "user",
IsDelete = true
};
// Act
var response = controller.DeleteAssignRoleUser(request, null);
dbContext.Dispose();
}
catch (Exception ex)
{
failureResult = ex.Message;
}
// Assert
//Assert.IsType<OkObjectResult>(response);
// var result = Assert.IsType<OkObjectResult>(response);
Assert.Equal("", failureResult);
}
private async Task DeleteSeedUsers(UserManager <IdentityUser> userManager, DeleteAssignUserRole deleteassignUsername)
{
IList <Users> Users = await FindByUserName(deleteassignUsername.username);
if (await userManager.FindByNameAsync(deleteassignUsername.username) != null)
{
var user = new IdentityUser
{
UserName = deleteassignUsername.username,
Email = Users[0].Email
};
var result = await userManager.FindByNameAsync(deleteassignUsername.username);
if (result != null)
{
IdentityResult deletionResult = await userManager.RemoveFromRoleAsync(result, deleteassignUsername.rolename);
IdentityResult deletionUser = await userManager.DeleteAsync(result);
}
}
}
public async Task <IActionResult> DeleteUserRole([FromBody] DeleteAssignUserRole deleteassignUserRole)
{
try
{
_logger.LogInfo("Attempted submission attempted");
if (deleteassignUserRole == null)
{
_logger.LogWarn("Empty request submitted");
return(BadRequest(ModelState));
}
if (!ModelState.IsValid)
{
_logger.LogWarn("User data was incomplete");
return(BadRequest(ModelState));
}
int UID = _UserRoleRepository.DeleteAssignRoleUser(deleteassignUserRole, _userManager);
var UserAudit = await _UserRepository.FindByUserName(deleteassignUserRole.username.ToString());
var User_new = _Mapper.Map <IList <Users> >(UserAudit);
_logger.LogInfo("Role has deleted");
Audit_logs audit = new Audit_logs()
{
uid = User_new[0].id,
action = "Delete User Role",
log = $"{deleteassignUserRole.username} Role has deleted",
datetime = DateTime.Now
};
await _audit_Logs.Create(audit);
return(NoContent());
}
catch (Exception ex)
{
return(InternalError($"{ex.Message}-{ex.InnerException}"));
}
}
public int DeleteAssignRoleUser(DeleteAssignUserRole deleteassignUserRole, UserManager <IdentityUser> userManager)
{
var param = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@username",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = deleteassignUserRole.username.ToString()
},
new SqlParameter()
{
ParameterName = "@rolename",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = deleteassignUserRole.rolename.ToString()
},
new SqlParameter()
{
ParameterName = "@IsDelete",
SqlDbType = System.Data.SqlDbType.Bit,
Direction = System.Data.ParameterDirection.Input,
Value = Convert.ToBoolean(deleteassignUserRole.IsDelete)
},
};
// IQueryable<Users> studentList = _dbRole.User_new.FromSqlRaw("EXEC ProcAddRoletoUser @username, @rolename, @IsDelete", param[0].Value, param[1].Value, param[2].Value).IgnoreQueryFilters();
string SQLQuery = $"EXECUTE ProcAddRoletoUser @username='******', @rolename='{param[1].Value}', @IsDelete={param[2].Value}";
int result = _dbRole.Database.ExecuteSqlRaw(SQLQuery);
if (userManager != null)
{
DeleteSeedUsers(userManager, deleteassignUserRole).Wait();
}
return(result);
}
