private void AddCategoryForUser(DBL.Models.User user, DBController db, ExtraCategory extraCategory)
{
if (user.ExtraCategories.Contains(extraCategory))
{
user.ExtraCategories.Remove(extraCategory);
db.Update <DBL.Models.User>(user);
}
else
{
user.ExtraCategories.Add(extraCategory);
db.Update <DBL.Models.User>(user);
}
}
private void queryAddExtraCategory(ref IQueryable <Book> query, ExtraCategory extraCategory)
{
DateTime dateFrom, dateTo, dateNow = DateTime.Now;
;
switch (extraCategory)
{
case ExtraCategory.Nowosci:
dateFrom = dateNow.AddDays(-14);
query = query.Where(book => book.DateAdded > dateFrom);
break;
case ExtraCategory.Zapowiedzi:
dateFrom = dateNow;
dateTo = dateNow.AddDays(14);
query = query.Where(book => book.DateRelease > dateFrom && book.DateRelease <= dateTo);
break;
case ExtraCategory.SuperOkazje:
query = query.Where(book => book.Opportunity);
break;
}
}
public IEnumerable <Book> createQuery(ExtraCategory extraCategory, int category, string filtrValue)
{
var query = _db.Books.AsQueryable();
query = query.Where(book => !book.IsDeleted);
filtrValue = filtrValue.ToLower();
if (extraCategory != ExtraCategory.None)
{
this.queryAddExtraCategory(ref query, extraCategory);
}
if (filtrValue != string.Empty)
{
this.queryAddFiltrValue(ref query, filtrValue);
}
if (category > 0)
{
query = query.Where(book => category == book.Category.Id);
}
query = query.OrderBy(book => book.Title);
return(query.ToList());
}
public IEnumerable <Book> Get(int category = 0, ExtraCategory extraCategory = 0, string filtrValue = "")
{
var books = _bookSevice.createQuery(extraCategory, category, filtrValue);
return(books);
}
