public async Task <HttpResponseMessage> Post([FromBody] SearchOptionsBase searchOptionsBase)
{
using (var repository = new Repository())
{
IQueryable <DeckModel> dbResult = repository.Context.Decks.Include(x => x.Creator).AsNoTracking();
if (!string.IsNullOrWhiteSpace(searchOptionsBase.Search))
{
dbResult =
dbResult.Where(
it =>
it.Name.Contains(searchOptionsBase.Search) ||
it.Creator.Name.Contains(searchOptionsBase.Search));
}
var totalCount = dbResult.Count();
// default order by
if (string.IsNullOrWhiteSpace(searchOptionsBase.OrderBy))
{
searchOptionsBase.OrderBy = "Name";
}
var orderByType = QueryHelper.GetPropertyType <DeckModel>(searchOptionsBase.OrderBy);
if (orderByType != null)
{
if (orderByType == typeof(string))
{
var orderByExpression = QueryHelper.GetPropertyExpression <DeckModel, string>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
if (orderByType == typeof(int))
{
var orderByExpression = QueryHelper.GetPropertyExpression <DeckModel, int>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
if (orderByType == typeof(DateTime))
{
var orderByExpression = QueryHelper.GetPropertyExpression <DeckModel, DateTime>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
}
searchOptionsBase.PageSize = Math.Min(50, searchOptionsBase.PageSize);
var query =
await
dbResult.Skip((searchOptionsBase.PageNumber - 1) *searchOptionsBase.PageSize)
.Take(searchOptionsBase.PageSize)
.ToListAsync();
var result = new ResultList <Deck>(query.Select(x => x.FromDal()).ToList())
{
TotalItems = totalCount,
SearchOptions = searchOptionsBase
};
return(Request.CreateResponse(result));
}
}
public async Task <HttpResponseMessage> Post([FromBody] SearchOptionsBase searchOptionsBase)
{
var dbResult = GameRepository.Instance.GetGames().AsQueryable();
if (!string.IsNullOrWhiteSpace(searchOptionsBase.Search))
{
dbResult = dbResult.Where(it => it.Name.Contains(searchOptionsBase.Search));
}
var totalCount = dbResult.Count();
// default order by
if (string.IsNullOrWhiteSpace(searchOptionsBase.OrderBy))
{
searchOptionsBase.OrderBy = "Name";
}
var orderByType = QueryHelper.GetPropertyType <Game>(searchOptionsBase.OrderBy);
if (orderByType != null)
{
if (orderByType == typeof(string))
{
var orderByExpression = QueryHelper.GetPropertyExpression <Game, string>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
if (orderByType == typeof(int))
{
var orderByExpression = QueryHelper.GetPropertyExpression <Game, int>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
if (orderByType == typeof(DateTime))
{
var orderByExpression = QueryHelper.GetPropertyExpression <Game, DateTime>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
}
searchOptionsBase.PageSize = Math.Min(50, searchOptionsBase.PageSize);
var query = dbResult.Skip((searchOptionsBase.PageNumber - 1) * searchOptionsBase.PageSize).Take(searchOptionsBase.PageSize);
var result = new ResultList <Game>(query.ToList())
{
TotalItems = totalCount, SearchOptions = searchOptionsBase
};
return(Request.CreateResponse(result));
}
