public IEnumerable <Advertisement> GetDisabled(Range range)
{
return(Context.Advertisements.Where(adv => adv.Status == Status.Disabled).Skip(range.From).Take(range.To - range.From));
}
public IEnumerable <Advertisement> Search(SearchAdvertisementsRequest request, Range range)
{
foreach (Detail rd in request.Details)
{
if (rd.StringValue == null)
{
Debug.WriteLine("HIBA!"); rd.StringValue = "";
}
}
//Szűrés
var result = Context.Advertisements.Include(ad => ad.Details).Where(adv =>
//A meta adattagok alapján válogatunk
request.Details.All(
rd => (rd.StringValue == "" && rd.NumberValue == 0) ||
adv.Details.Any(
d => ((d.StringValue == rd.StringValue || rd.StringValue == "") &&
d.NumberValue == rd.NumberValue) &&
d.MetaId == rd.MetaId)) &&
//A fix adattagok alapján válogatunk
(adv.Status != Status.Deleted && adv.Status != Status.Hidden && adv.Status != Status.Disabled) &&
adv.Title.Contains(request.Title) &&
(adv.Category.Id == request.CategoryId || request.CategoryId == 0) &&
adv.Price >= request.MinPrice && adv.Price <= request.MaxPrice &&
adv.UploadDate >= request.MinDate && adv.UploadDate <= request.MaxDate);
//Rendezés
if (request.Order == Order.Ascending)
{
result = result.OrderByDescending(adv => adv.Status).ThenBy(getOrderFunc(request.OrderBy));
}
else
{
result = result.OrderByDescending(adv => adv.Status).ThenByDescending(getOrderFunc(request.OrderBy));
}
//Pagelés
result = result.Skip(range.From).Take(range.To - range.From);
return(result);
}
public IEnumerable <Advertisement> Get(Range range)
{
return(Context.Advertisements.Where(adv => adv.Status != Status.Deleted && adv.Status != Status.Hidden && adv.Status != Status.Disabled).OrderByDescending(adv => adv.Status).Skip(range.From).Take(range.To - range.From));
}
