public void ListUserTest()
{
QueryCommandBase queryParam = new QueryCommandBase();
var list = _queryService.ListUser(queryParam);
Assert.IsTrue(list.Count > 0);
}
public void ListPersonalInformationTest()
{
QueryCommandBase queryParam = new QueryCommandBase();
var list = _queryService.ListPersonalInformation(queryParam);
Assert.IsTrue(list.Count > 0);
}
public List <UserQueryModel> ListUser(QueryCommandBase queryParam)
{
var users = _context.Users;
if (string.IsNullOrEmpty(queryParam.SearchText))
{
return(users.Paginate(t => t.PersonId, queryParam.Pagination)
.ToList <UserQueryModel>());
}
else
{
string searchTextToLower = queryParam.SearchText.ToLower();
return(users.Where(t =>
t.UserNumber.ToLower().Contains(searchTextToLower)
)
.Paginate(t => t.PersonId, queryParam.Pagination)
.ToList <UserQueryModel>());
}
}
public List <PersonalInformationQueryModel> ListPersonalInformation(QueryCommandBase queryParam)
{
var personalInfos = _context.PersonalInformations.Where(t =>
(t.PersonId_User.StatusId != null)
);
if (string.IsNullOrEmpty(queryParam.SearchText))
{
return(personalInfos.Paginate(t => t.PersonId, queryParam.Pagination)
.ToList().AsQueryable()
.ToList <PersonalInformationQueryModel>());
}
{
string searchTextLower = queryParam.SearchText.ToLower();
return(personalInfos.Where(t =>
t.PersonId_User.UserNumber.ToLower().Contains(searchTextLower)
)
.Paginate(t => t.PersonId, queryParam.Pagination)
.ToList <PersonalInformationQueryModel>());
}
}
public List <UserQueryModel> ListUser(QueryCommandBase queryParam)
{
return(_query.ListUser(queryParam));
}
public List <PersonalInformationQueryModel> ListPersonalInformation(QueryCommandBase queryParam)
{
return(_query.ListPersonalInformation(queryParam));
}
public List <UserQueryModel> ListUser(QueryCommandBase queryParam)
{
return(_modelManagementQueryServices.ListUser(queryParam));
}
public List <PersonalInformationQueryModel> ListPersonalInformation(QueryCommandBase queryParam)
{
return(_modelManagementQueryServices.ListPersonalInformation(queryParam));
}
