public async Task <ListResponseModel <TModel> > GetListPostCategoryAsync <TModel>(
ListPostCategoryRequestModel requestModel, ParsingConfig parsingConfig = null)
{
#region Validation
var userInfo = contextProvider.BusinessContext.PrincipalInfo;
var validationData = new ValidationData(resultLocalizer);
// validation logic here
if (!validationData.IsValid)
{
throw validationData.BuildException();
}
#endregion
IQueryable <PostCategoryEntity> query = dbContext.PostCategory.AsNoTracking();
IQueryable <ListPostCategoryJoinModel> joinedQuery;
#region Filter
if (requestModel.Ids?.Any() == true)
{
query = query.ByIds(requestModel.Ids);
}
string lang = requestModel.Lang;
string region = requestModel.Region;
if (string.IsNullOrEmpty(lang))
{
lang = CultureInfo.CurrentUICulture.TwoLetterISOLanguageName;
}
var locQuery = dbContext.PostCategoryLocalization.ByCulture(lang, region);
joinedQuery = from pc in query
from pcl in locQuery.Where(o => o.EntityId == pc.Id).Take(1).DefaultIfEmpty()
select new ListPostCategoryJoinModel
{
CreatedTime = pc.CreatedTime,
Description = pcl.Description,
Id = pc.Id,
Lang = pcl.Lang,
Region = pcl.Region,
Title = pcl.Title
};
if (!string.IsNullOrWhiteSpace(requestModel.SearchTerm))
{
joinedQuery = joinedQuery.BySearchTerm(requestModel.SearchTerm);
}
#endregion
var orgQuery = joinedQuery;
#region Sorting
var sortByArr = requestModel.GetSortByArr();
if (!sortByArr.IsNullOrEmpty())
{
foreach (var field in sortByArr)
{
var asc = field[0] == QueryConsts.SortAscPrefix;
var fieldName = field.Remove(0, 1);
switch (fieldName)
{
case ListPostCategoryRequestModel.SortByTitle:
{
if (asc)
{
joinedQuery = joinedQuery.SequentialOrderBy(o => o.Title);
}
else
{
joinedQuery = joinedQuery.SequentialOrderByDesc(o => o.Title);
}
}
break;
default:
throw AppValidationException.From(resultLocalizer, ResultCode.InvalidPagingRequest);
}
}
}
#endregion
if (requestModel.Page > 0)
{
joinedQuery = joinedQuery.Limit(requestModel.Page, requestModel.PageLimit);
}
#region Projection
var projectionArr = requestModel.GetFieldsArr().Select(o => ListPostCategoryRequestModel.Projections[o]).ToArray();
var projectionStr = string.Join(',', projectionArr);
var projectedQuery = joinedQuery.Select <TModel>(
parsingConfig ?? DynamicLinqConsts.DefaultParsingConfig,
$"new {typeof(TModel).FullName}({projectionStr})");
#endregion
var responseModels = await projectedQuery.ToArrayAsync();
var response = new ListResponseModel <TModel>
{
List = responseModels,
};
if (requestModel.CountTotal)
{
response.TotalCount = await orgQuery.CountAsync();
}
return(response);
}
public async Task <IActionResult> GetListPostCategory([FromQuery] ListPostCategoryRequestModel model)
{
var data = await _postCategoryService.GetListPostCategoryAsync <ListPostCategoryModel>(model);
return(Success(data));
}
