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); }