public ActionResult <FilteringList <Owner> > Get([FromQuery] Filter filter) { try { if (filter.CurrentPage == 0 && filter.InfoPrPage == 0) { var list = _ownerService.GetOwners(null); var newList = new List <Owner>(); foreach (var owner in list.List) { newList.Add(new Owner() { id = owner.id, firstName = owner.firstName, lastName = owner.lastName, address = owner.address, petHistory = owner.petHistory }); } var newFilteredList = new FilteringList <Owner>(); newFilteredList.List = newList; newFilteredList.Count = list.Count; return(Ok(newFilteredList)); } var fl = _ownerService.GetOwners(filter); return(Ok(fl)); } catch (Exception e) { return(StatusCode(500, e.Message)); } }
public FilteringList <Pet> ReadPets(Filter filter) { var filteredList = new FilteringList <Pet>(); if (filter != null && filter.CurrentPage > 0 && filter.InfoPrPage > 0) { filteredList.List = _context.Pets .Skip((filter.CurrentPage - 1) * filter.InfoPrPage) .Take(filter.InfoPrPage) .OrderBy(o => o.id) .Include(p => p.ownersHistory) .ThenInclude(po => po.Owner) .ToList(); return(filteredList); } filteredList.List = _context.Pets .Include(p => p.ownersHistory) .ThenInclude(po => po.Owner); filteredList.Count = filteredList.List.Count(); return(filteredList); }
protected void SetFilter(string columnName, string[] valuesFilter) { string expression = string.Empty; List <string> prmtr = new List <string>(); for (int iCheckedItem = 0; iCheckedItem < valuesFilter.Count(); iCheckedItem++) { if (iCheckedItem == 0) { expression = $"{columnName} = @{iCheckedItem}"; } else { expression = expression + $" Or {columnName} = @{iCheckedItem}"; } prmtr.Add($"{valuesFilter[iCheckedItem]}"); } FilteringList = new ObservableCollection <TList>(FilteringList.Where(expression, prmtr.ToArray())); }
public ActionResult <FilteringList <Pet> > Get([FromQuery] Filter filter) { try { if (filter.CurrentPage == 0 && filter.InfoPrPage == 0) { var list = _petService.GetPets(null); var newList = new List <Pet>(); foreach (var pet in list.List) { newList.Add(new Pet() { id = pet.id, name = pet.name, type = pet.type, birthDate = pet.birthDate, soldDate = pet.soldDate, color = pet.color, price = pet.price, ownersHistory = pet.ownersHistory }); } var newFilteredList = new FilteringList <Pet>(); newFilteredList.List = newList; newFilteredList.Count = list.Count; return(Ok(newFilteredList)); } var fl = _petService.GetPets(filter); return(Ok(fl)); } catch (Exception e) { return(StatusCode(500, e.Message)); } }