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