//[Obsolete]
public IActionResult GetAllUsers()
{
var users = (
from user in _db.Users
join userRole in _db.UserRoles
on user.Id equals userRole.UserId
join role in _db.Roles
on userRole.RoleId equals role.Id
where user.Deleted == false
select new BaseUser
{
FirstName = user.FirstName,
MiddleName = user.MiddleName,
LastName = user.LastName,
DisplayName = user.DisplayName,
UserName = user.UserName,
Email = user.Email,
PhoneNumber = user.PhoneNumber,
Location = new Address
{
Country = user.Location.Country,
City = user.Location.City,
Region = user.Location.Region,
Street = user.Location.Street,
Building = user.Location.Building,
Floor = user.Location.Floor
},
CreatedAt = user.CreatedAt,
UpdatedAt = user.UpdatedAt,
Deleted = user.Deleted,
role = role.Name,
}
).ToList();
// Clean data
var result = _dataCleaner.cleanAllUsersListBasedOnRoles(users);
if (result.Count() == 0 || result == null)
{
return(BadRequest(new JsonResult("No users to show")));
}
else
{
return(Ok(result));
}
}