// GET: Credits public IActionResult Index(CreditFilter filter) { if (filter == null) { filter = new CreditFilter(); } var indexVM = new CreditIndexViewModel { User = _userManager.FindByIdAsync(User.FindFirstValue(ClaimTypes.NameIdentifier)).Result, CreditPurchases = _creditPurchaseManager.GetCreditPurchases(filter), Filter = filter }; return(View(indexVM)); }
public DataSet <CreditPurchase> GetCreditPurchases(CreditFilter filter) { var datasSet = new DataSet <CreditPurchase>(); if (filter == null) { return(GetCreditPurchases()); } else { var qryBase = _context.CreditPurchases; var qry = qryBase.Select(x => x); if (_user != null) { //Enkel CreditPurchase ophalen die van ons zijn tenzij we admin rol hebben if (_userManager.IsInRoleAsync(_user, UserRoleType.RestaurantOwner.ToString()).Result || _userManager.IsInRoleAsync(_user, UserRoleType.Customer.ToString()).Result) { qry = from t in qry where t.UserID == _user.Id select t; } } if (filter.From.HasValue) { qry = from t in qry where t.CreatedOn.Date >= filter.From.Value.Date select t; } if (filter.To.HasValue) { qry = from t in qry where t.CreatedOn.Date <= filter.To.Value.Date select t; } if (filter.Status.HasValue) { qry = from t in qry where t.Status == filter.Status.Value select t; } if (!String.IsNullOrWhiteSpace(filter.UserID)) { qry = from t in qry where t.UserID.ToLower().Contains(filter.UserID.ToLower()) select t; } if (filter.PurchaseID.HasValue) { qry = from t in qry where t.ID == filter.PurchaseID.Value select t; } qry = from t in qry orderby t.CreatedOn descending select t; datasSet.Data = qry.ToList(); return(datasSet); } }