public async Task <PagedResults <Pica> > GetPiceAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var pice = await _dbContext.Pice.ToArrayAsync();
if (pice == null)
{
return(null);
}
var piceMap = _mapper.Map <IEnumerable <Entities.Pica>, IEnumerable <Models.Pica> >(pice);
var pagedPice = piceMap.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <Pica>
{
Items = pagedPice,
TotalSize = piceMap.Count()
});
}
public async Task <PagedResults <EkstraDodaci> > GetEkstraDodaciAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var query = from ekstraDodaciDbo in _dbContext.EkstraDodaci
join dodaciDbo in _dbContext.Dodaci on ekstraDodaciDbo.DodatakID equals dodaciDbo.DodatakID
join detaljiNDbo in _dbContext.DetaljiNarudzbenice on ekstraDodaciDbo.DetaljiNarudzbeniceID equals detaljiNDbo.DetaljiNarudzbeniceID
select new { ekstraDodaci = ekstraDodaciDbo, dodaci = dodaciDbo, DetaljiNarudzbenice = detaljiNDbo };
var rezultati = await query.ToArrayAsync();
if (rezultati == null)
{
return(null);
}
List <Entities.EkstraDodaci> ekstraDodaciList = new List <Entities.EkstraDodaci>();
foreach (var prom in rezultati)
{
ekstraDodaciList.Add(prom.ekstraDodaci);
}
var ekstraDMapp = _mapper.Map <IEnumerable <Entities.EkstraDodaci>, IEnumerable <Models.EkstraDodaci> >(ekstraDodaciList);
var padgeEkstraDodac = ekstraDMapp.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <EkstraDodaci>
{
Items = ekstraDMapp,
TotalSize = ekstraDMapp.Count()
});
}
public async Task <PagedResults <Dodatak> > GetDodaciAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var dodaci = await _dbContext.Dodaci.ToArrayAsync();
if (dodaci == null)
{
return(null);
}
var dodaciMap = _mapper.Map <IEnumerable <Entities.Dodatak>, IEnumerable <Models.Dodatak> >(dodaci);
var pagedDodaci = dodaciMap.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <Dodatak>
{
Items = pagedDodaci,
TotalSize = dodaciMap.Count()
});
}
public async Task <PagedResults <Vozilo> > GetVoziloAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var vozilo = await _dbContext.Vozila.ToArrayAsync();
if (vozilo == null)
{
return(null);
}
var mapVozilo = _mapper.Map <IEnumerable <Entities.Vozilo>, IEnumerable <Models.Vozilo> >(vozilo);
var pagedVozilo = mapVozilo.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <Vozilo>
{
Items = pagedVozilo,
TotalSize = mapVozilo.Count()
});
}
public async Task <ActionResult <IEnumerable <Dodatak> > > GetDodaciAsync(CancellationToken ct, [FromQuery] PaginigOptions paginigOptions)
{
if (!ModelState.IsValid)
{
return(BadRequest(new ApiError(ModelState)));
}
paginigOptions.Offset = paginigOptions.Offset ?? 0;
paginigOptions.Limit = paginigOptions.Limit ?? 25;
var collection = await _dodatakService.GetDodaciAsync(ct, paginigOptions);
if (collection == null)
{
return(NotFound());
}
var collectionLink = Link.ToCollection(nameof(GetDodaciAsync));
var resources = new PagedCollection <Models.Dodatak>
{
Self = collectionLink,
Value = collection.Items.ToArray(),
Size = collection.TotalSize,
Offset = paginigOptions.Offset.Value,
Limit = paginigOptions.Limit.Value
};
return(Ok(resources));
}
public async Task <PagedResults <Zaposlen> > GetZaposleneAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var zaposleni = await _dbContext.Zaposleni.ToArrayAsync();
if (zaposleni == null)
{
return(null);
}
var zaposleniMap = _mapper.Map <IEnumerable <Entities.Zaposleni>, IEnumerable <Models.Zaposlen> >(zaposleni);
var pagedZaposleni = zaposleniMap.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <Zaposlen>
{
Items = pagedZaposleni,
TotalSize = zaposleniMap.Count()
});
}
public async Task <PagedResults <Models.Narudzbenica> > GetNarudzbeniceAsync(CancellationToken ct, PaginigOptions paginigOptions, NarudzbenicaOptions narudzbenicaOptions)
{
var query = queryForm(null, narudzbenicaOptions.imeZaposleng, narudzbenicaOptions.prezimeZaposlenog, narudzbenicaOptions.statusDostave, narudzbenicaOptions.datumPrijema);
var narudzbenice = await query.ToArrayAsync();
if (narudzbenice == null)
{
return(null);
}
List <Entities.Narudzbenica> narudzbenicesList = new List <Entities.Narudzbenica>();
foreach (var prom in narudzbenice)
{
narudzbenicesList.Add(prom.Narudzbenica);
}
var narudzbenicaMap = _mapper.Map <IEnumerable <Entities.Narudzbenica>, IEnumerable <Models.Narudzbenica> >(narudzbenicesList);
var narudzbenicaPagin = narudzbenicaMap.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <Models.Narudzbenica>
{
Items = narudzbenicaPagin,
TotalSize = narudzbenicaMap.Count()
});
}
public async Task <PagedResults <TipVozila> > GetTipVozilaAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var tipVozila = await _dbContext.TipVozila.ToArrayAsync();
if (tipVozila == null)
{
return(null);
}
var mapTipVozila = _mapper.Map <IEnumerable <Entities.TipVozila>, IEnumerable <Models.TipVozila> >(tipVozila);
var pagedTipVozila = mapTipVozila.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <TipVozila>
{
Items = pagedTipVozila,
TotalSize = mapTipVozila.Count()
});
}
public async Task <PagedResults <Adresa> > GetAdreseAsync(CancellationToken ct, PaginigOptions paginigOptions, string grad)
{
var query = queryVariant(grad);
var adrese = await query.ToArrayAsync();
if (adrese == null)
{
return(null);
}
var mapAdress = _mapper.Map <IEnumerable <Entities.Adresa>, IEnumerable <Models.Adresa> >(adrese);
var pagedAdress = mapAdress.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <Adresa>
{
Items = pagedAdress,
TotalSize = mapAdress.Count()
});
}
public async Task <PagedResults <Kupac> > GetKupaceAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var query = from kupacDb in _dbContext.Kupci
join adresaDb in _dbContext.Adrese on kupacDb.AdresaID equals adresaDb.AdresaID
select new { Kupac = kupacDb, Adresa = adresaDb };
var kupci = await query.ToArrayAsync();
if (kupci == null)
{
return(null);
}
List <Entities.Kupac> kupacList = new List <Entities.Kupac>();
foreach (var prom in kupci)
{
kupacList.Add(prom.Kupac);
}
var kupacMap = _mapper.Map <IEnumerable <Entities.Kupac>, IEnumerable <Models.Kupac> >(kupacList);
var padgeKupac = kupacMap.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <Kupac>
{
Items = kupacMap,
TotalSize = kupacMap.Count()
});
}
public async Task <PagedResults <StatusDostave> > GetStatusDostaveAsync(CancellationToken ct, PaginigOptions paginigOptions)
{
var statusDostave = await _dbContext.StatusDostave.ToArrayAsync();
if (statusDostave == null)
{
return(null);
}
var statusMap = _mapper.Map <IEnumerable <Entities.StatusDostave>, IEnumerable <Models.StatusDostave> >(statusDostave);
var statusPadge = statusMap.Skip(paginigOptions.Offset.Value).Take(paginigOptions.Limit.Value);
return(new PagedResults <StatusDostave>
{
Items = statusPadge,
TotalSize = statusMap.Count()
});
}
