public async Task <HttpResponseMessage> Post([FromBody] CardSearchOptions searchOptionsBase)
{
var token = TokenExtracton.GetTokenFromCookie(HttpContext.Current.Request);
using (var repository = new Repository(token))
{
IQueryable <CardModel> dbResult = repository.Context.Cards.Include(x => x.RuleSet).Include(x => x.Serie).Include(x => x.Faction).Include(x => x.Status).Include(x => x.Type).Include(x => x.Creator).Include(x => x.LastModifiedBy).AsNoTracking();
if (searchOptionsBase.Cost != null)
{
dbResult = dbResult.Where(x => x.Cost.ToLower() == searchOptionsBase.Cost.ToLower());
}
if (searchOptionsBase.CardType != null)
{
dbResult = dbResult.Where(x => x.Type.Guid == searchOptionsBase.CardType.Guid);
}
if (searchOptionsBase.Faction != null)
{
dbResult = dbResult.Where(x => x.Faction.Guid == searchOptionsBase.Faction.Guid);
}
if (searchOptionsBase.Serie != null)
{
dbResult = dbResult.Where(x => x.Serie.Guid == searchOptionsBase.Serie.Guid);
}
if (searchOptionsBase.RuleSet != null)
{
dbResult = dbResult.Where(x => x.RuleSet.Guid == searchOptionsBase.RuleSet.Guid);
}
if (searchOptionsBase.Status != null)
{
dbResult = dbResult.Where(x => x.Status.Guid == searchOptionsBase.Status.Guid);
}
if (searchOptionsBase.Loyalty != null)
{
dbResult = dbResult.Where(x => x.Loyalty == searchOptionsBase.Loyalty.Value);
}
if (!string.IsNullOrWhiteSpace(searchOptionsBase.Search))
{
dbResult = dbResult.Where(
it => it.Name.Contains(searchOptionsBase.Search) ||
it.Creator.Name.Contains(searchOptionsBase.Search) ||
it.SubType.Contains(searchOptionsBase.Search) ||
it.RuleText.Contains(searchOptionsBase.Search)
);
}
var totalCount = dbResult.Count();
// default order by
if (string.IsNullOrWhiteSpace(searchOptionsBase.OrderBy))
{
searchOptionsBase.OrderBy = "Name";
}
var orderByType = QueryHelper.GetPropertyType <CardModel>(searchOptionsBase.OrderBy);
if (orderByType != null)
{
if (orderByType == typeof(string))
{
var orderByExpression = QueryHelper.GetPropertyExpression <CardModel, string>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
if (orderByType == typeof(int))
{
var orderByExpression = QueryHelper.GetPropertyExpression <CardModel, int>(searchOptionsBase.OrderBy);
dbResult = searchOptionsBase.ReverseOrder ? dbResult.OrderByDescending(orderByExpression) : dbResult.OrderBy(orderByExpression);
}
if (orderByType == typeof(DateTime))
{
var orderByExpression = QueryHelper.GetPropertyExpression <CardModel, 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 <Card>(query.Select(x => x.FromDal()).ToList())
{
TotalItems = totalCount, SearchOptions = searchOptionsBase
};
return(Request.CreateResponse(result));
}
}