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