public IActionResult Index(FilterModel filter) { if (filter.MinDate == DateTime.MinValue) { if (filter.Month != 0 && filter.Year != 0) { filter.MinDate = new DateTime(filter.Year, filter.Month, 1); } } if (filter.MaxDate == DateTime.MinValue) { if (filter.Month != 0 && filter.Year != 0) { filter.MaxDate = new DateTime(filter.Year, filter.Month, 1).AddMonths(1).AddDays(-1); } } if (filter.MinDate == DateTime.MinValue) { filter.MinDate = DateTime.Now.AddDays(-30); } if (filter.MaxDate == DateTime.MinValue) { filter.MaxDate = DateTime.Now; } var spends = _spendService.GetAll(GetUserId(), filter); ViewBag.filter = filter; ViewBag.total = (double)spends.Sum(x => x.Value) / 100; ViewData["categoriesSummary"] = spends.GroupBy(x => x.CategoryId) .Select(c => new CategoryViewModel() { Category = c.First().Category.Description, Total = (double)c.Sum(s => s.Value) / 100, Id = c.First().Category.Id }).OrderBy(o => o.Category).ToList(); return(View(spends)); }
public ActionResult <IList <Spend> > Get([FromQuery] FilterModel filter) { return(_spendService.GetAll(GetUserId(), filter)); }