public PageResponse <AutomobilDto> Execute(PretragaAutomobila request)
{
var query = Context.Automobili.AsQueryable();
if (request.Keyword != null)
{
query = query.Where(g => g.Naziv
.ToLower()
.Contains(request.Keyword.ToLower()));
}
query = query.Include(m => m.Marka)
.ThenInclude(mo => mo.Modeli)
.Include(t => t.Tip)
.Include(k => k.Kategorija)
.Include(s => s.Slike)
.Include(kor => kor.Korisnik)
.Include(g => g.Gorivo)
.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage);
var totalRecords = query.Count();
var pagesCount = (int)Math.Ceiling((double)totalRecords / request.PerPage);
var response = new PageResponse <AutomobilDto>
{
CurrentPage = request.PageNumber,
TotalCount = totalRecords,
PagesCount = pagesCount,
Data = query.Select(a => new AutomobilDto
{
Id = a.Id,
Godiste = a.Godiste,
MarkaAutomobila = a.Marka.MarkaAutomobila,
Kategorija = a.Kategorija.Naziv,
Naziv = a.Naziv,
Opis = a.Opis,
Price = a.Price,
Tip = a.Tip.Type,
Vlasnik = a.Vlasnik,
VrstaGoriva = a.Gorivo.Naziv,
Model = a.Model.Model,
DateCreated = a.DateCreated,
DateModified = a.DateModified,
Slike = a.Slike.Select(s => new SlikeDto {
Id = s.Id,
Path = s.Putanja
}).ToList()
})
};
return(response);
}
// GET: Cars
public ActionResult Index(PretragaAutomobila search)
{
var cars = _getCarsCommand.Execute(search);
return(View(cars));
}
