public RaffleEvent GetById(int id) { if (!cache.TryGetValue($"{CacheKeys.RaffleEventById}{id}", out RaffleEvent cacheEntry)) { cacheEntry = repository.GetById(id); var cacheEntryOptions = new MemoryCacheEntryOptions() .SetSlidingExpiration(TimeSpan.FromHours(1)); cache.Set($"{CacheKeys.RaffleEventById}{id}", cacheEntry, cacheEntryOptions); } return(cacheEntry); }
public async Task <IActionResult> Index(string sortBy, string searchFilter, string categoryFilter) { var raffleEvent = raffleEventRepository.GetById(1); if (raffleEvent.CloseDate.HasValue && raffleEvent.CloseDate.Value < DateTime.UtcNow) { return(View("IndexRaffleClosed")); } RaffleOrder order = null; if (HttpContext.Request.Cookies.ContainsKey(CookieKeys.RaffleOrderId)) { int.TryParse(HttpContext.Request.Cookies[CookieKeys.RaffleOrderId], out int orderId); if (!(await mediator.Send(new RaffleOrderExistsQuery { OrderId = orderId }))) { logger.LogInformation("No Order Found"); orderId = await mediator.Send(new StartRaffleOrderQuery()); HttpContext.Response.Cookies.Append( CookieKeys.RaffleOrderId, orderId.ToString(), new CookieOptions { Secure = true, SameSite = SameSiteMode.Strict, Expires = new DateTimeOffset(DateTime.Now.AddDays(7)) }); logger.LogInformation($"New Order Created (OrderId: {orderId})"); } order = await mediator.Send(new GetRaffleOrderQuery { OrderId = orderId }); } else { logger.LogInformation("No Order Cookie Found"); var orderId = await mediator.Send(new StartRaffleOrderQuery()); HttpContext.Response.Cookies.Append( CookieKeys.RaffleOrderId, orderId.ToString(), new CookieOptions { Secure = true, SameSite = SameSiteMode.Strict, Expires = new DateTimeOffset(DateTime.Now.AddDays(7)) }); logger.LogInformation($"New Order Created (OrderId: {orderId})"); order = await mediator.Send(new GetRaffleOrderQuery { OrderId = orderId }); } if (HttpContext.Request.Query["emoji"] == "on") { ViewData["emoji"] = "on"; } if (HttpContext.Request.Query["menu"] == "on") { ViewData["graph"] = "on"; } ViewData["itemNumberSortParam"] = sortBy == "itemNumber" ? "itemNumber_desc" : "itemNumber"; ViewData["titleSortParam"] = sortBy == "title" ? "title_desc" : "title"; ViewData["categorySortParam"] = sortBy == "category" ? "category_desc" : "category"; ViewData["pointsSortParam"] = sortBy == "points" ? "points_desc" : "points"; ViewData["currentFilter"] = searchFilter; ViewData["categoryFilter"] = categoryFilter; var raffleItems = raffleItemRepository.GetAll() .Select(x => new RaffleItemModel { Id = x.Id, ItemNumber = x.ItemNumber, Title = x.Title, Description = x.Description, Category = x.Category, Sponsor = x.Sponsor, Cost = x.Cost, Value = x.ItemValue, ForOver21 = x.ForOver21, LocalPickupOnly = x.LocalPickupOnly, IsAvailable = x.IsAvailable, NumberOfDraws = x.NumberOfDraws, TotalTicketsEntered = x.TotalTicketsEntered, Pictures = x.ImageUrls }).ToList(); foreach (var line in order.Lines) { raffleItems.First(x => x.Id == line.RaffleItemId).Amount = line.Count; } if (!string.IsNullOrEmpty(searchFilter)) { raffleItems = raffleItems.Where(x => x.Title.Contains(searchFilter, StringComparison.OrdinalIgnoreCase) || x.Description.Contains(searchFilter, StringComparison.OrdinalIgnoreCase) || x.Category.Contains(searchFilter, StringComparison.OrdinalIgnoreCase)) .ToList(); } if (!string.IsNullOrEmpty(categoryFilter)) { raffleItems = raffleItems.Where(x => x.Category.Equals(categoryFilter, StringComparison.OrdinalIgnoreCase)) .ToList(); } switch (sortBy) { case "title_desc": raffleItems = raffleItems.OrderByDescending(x => x.Title).ToList(); break; case "title": raffleItems = raffleItems.OrderBy(x => x.Title).ToList(); break; case "category": raffleItems = raffleItems.OrderBy(x => x.Category).ToList(); break; case "category_desc": raffleItems = raffleItems.OrderByDescending(x => x.Category).ToList(); break; case "itemNumber": raffleItems = raffleItems.OrderBy(x => x.ItemNumber).ToList(); break; case "itemNumber_desc": raffleItems = raffleItems.OrderByDescending(x => x.ItemNumber).ToList(); break; case "points": raffleItems = raffleItems.OrderBy(x => x.Cost).ToList(); break; case "points_desc": raffleItems = raffleItems.OrderByDescending(x => x.Cost).ToList(); break; default: raffleItems = raffleItems.OrderBy(x => x.ItemNumber).ToList(); break; } var model = new RaffleOrderViewModel { StartDate = raffleEvent.StartDate, CloseDate = raffleEvent.CloseDate.Value.ToUniversalTime(), Categories = raffleItemRepository.GetUsedCategories().OrderBy(x => x).ToList(), RaffleItems = raffleItems }; return(View(model)); }