public async Task <IEnumerable <UserOutput> > GetUsers(UserQueryInput input)
{
int pageIndex = input.Page - 1;
int Per_Page = input.Per_Page;
string sortBy = input.SortBy;
IQueryable <User> query = dbContext.Users
.Include(q => q.Organazition)
.Include(q => q.Role)
.AsQueryable <User>();
query = query.Where(q => string.IsNullOrEmpty(input.Name) || q.Name.Contains(input.Name));
query = query.OrderBy(sortBy);
var totalCount = query.Count();
var totalPages = (int)Math.Ceiling((double)totalCount / Per_Page);
HttpContext.Response.Headers.Add("X-TotalCount", JsonConvert.SerializeObject(totalCount));
HttpContext.Response.Headers.Add("X-TotalPage", JsonConvert.SerializeObject(totalPages));
query = query.Skip(pageIndex * Per_Page).Take(Per_Page);
List <User> users = await query.ToListAsync();
List <UserOutput> list = mapper.Map <List <UserOutput> >(users);
return(list);
}
public QueryRequestOut <UserItem> GetAll(UserQueryInput input)
{
return(_userRepository.GetAll()
.Where(m => !m.IsDeleted)
.WhereIf(!input.Keywords.IsNullOrWhiteSpace(), m => m.LoginName.Contains(input.Keywords))
.ToOutPut <UserItem>(input));
}
public PagedResultOutput<UserDto> GetUsers(UserQueryInput input)
{
int totalCount;
return new PagedResultOutput<UserDto>
{
TotalCount = userManager.Users.Count(),
Items = userManager.Users.FilterBy(input, out totalCount).OrderByDescending(u => u.CreationTime).PageBy(input).ToList().MapTo<List<UserDto>>()
};
}
public PagedResultOutput <UserDto> GetUsers(UserQueryInput input)
{
int totalCount;
return(new PagedResultOutput <UserDto>
{
TotalCount = userManager.Users.Count(),
Items = userManager.Users.FilterBy(input, out totalCount).OrderByDescending(u => u.CreationTime).PageBy(input).ToList().MapTo <List <UserDto> >()
});
}
public JsonResult GetList(UserQueryInput input)
{
var list = UserService.GetAll(input);
var json = new
{
total = list.total,
rows = list.rows
};
return Json(json, JsonRequestBehavior.AllowGet);
}
public async Task <List <UserItemDto> > GetAllUserItem(UserQueryInput input)
{
var users = await _stateManager.GetOrAddAsync <IReliableDictionary <ItemId, UserItem> >(DictionaryName);
List <UserItemDto> list = new List <UserItemDto>();
using (var tx = _stateManager.CreateTransaction())
{
var enumerator = (await users.CreateEnumerableAsync(tx)).GetAsyncEnumerator();
CancellationToken ct = default(CancellationToken);
while (await enumerator.MoveNextAsync(ct))
{
var currentUser = enumerator.Current.Value;
if (input.CheckCriteria(currentUser))
{
list.Add(_mapper.Map <UserItemDto>(currentUser));
}
}
}
return(list);
}
public JsonResult List(UserQueryInput input)
{
var list = _userService.GetAll(input);
return ToJson(list);
}
public QueryRequestOut<UserDto> GetAll(UserQueryInput input)
{
return UserRepository.Get().ToOutPut<UserDto>(input);
}
//[AntiDuplicateRequest(GlobalLockKey = "User_GetPagedList", Interval = 5, Type = LockType.User)] public async Task <Paged <UserOutput> > GetPagedList([FromQuery] UserQueryInput queryInput) => await _userAppService.GetPaged(queryInput);
public async Task <UserExcelOutput> Export([FromQuery] UserQueryInput queryInput) => await _userAppService.Export(queryInput);
public JsonResult List(UserQueryInput input)
{
var list = _userService.GetAll(input);
return(ToJson(list));
}
public void Test_CheckCreatedCriteria()
{
var inputs = new List <UserItem>();
for (int i = 0; i < 12; i++)
{
var item = new UserItem(null, "test" + i, null, "TestUser" + i, null, null, null, null, null, null, null);
item.SetCreated(new DateTimeOffset(2018, i + 1, 1, 1, 1, 1, TimeSpan.Zero));
inputs.Add(item);
}
var result = new List <UserItem>();
// StartCreated != null && EndCreated != null
var query = new UserQueryInput
{
StartCreated = new DateTimeOffset(2018, 3, 1, 1, 1, 1, TimeSpan.Zero),
EndCreated = new DateTimeOffset(2018, 8, 1, 1, 1, 1, TimeSpan.Zero)
};
result = new List <UserItem>();
foreach (var item in inputs)
{
if (query.CheckCriteria(item))
{
result.Add(item);
}
}
Assert.AreEqual(6, result.Count);
// StartCreated = null
query = new UserQueryInput
{
StartCreated = null,
EndCreated = new DateTimeOffset(2018, 8, 1, 1, 1, 1, TimeSpan.Zero)
};
result = new List <UserItem>();
foreach (var item in inputs)
{
if (query.CheckCriteria(item))
{
result.Add(item);
}
}
Assert.AreEqual(8, result.Count);
// EndCreated = null
result = new List <UserItem>();
query = new UserQueryInput
{
StartCreated = new DateTimeOffset(2018, 8, 1, 1, 1, 1, TimeSpan.Zero),
EndCreated = null
};
foreach (var item in inputs)
{
if (query.CheckCriteria(item))
{
result.Add(item);
}
}
Assert.AreEqual(5, result.Count);
// StartCreated = null and EndCreated = null
query = new UserQueryInput
{
StartCreated = null,
EndCreated = null
};
result = new List <UserItem>();
foreach (var item in inputs)
{
if (query.CheckCriteria(item))
{
result.Add(item);
}
}
Assert.AreEqual(12, result.Count);
}
public QueryRequestOut<UserItem> GetAll(UserQueryInput input)
{
return _userRepository.GetAll()
.Where(m=>!m.IsDeleted)
.WhereIf(!input.Keywords.IsNullOrWhiteSpace(), m => m.LoginName.Contains(input.Keywords))
.ToOutPut<UserItem>(input);
}
