public override List <Model.NabavkaStavke> Get(NabavkaStavkeSearchRequest search) { List <Model.NabavkaStavke> lista = new List <Model.NabavkaStavke>(); var nabavkaStavke = _db.NabavkaStavke.AsQueryable(); if (!string.IsNullOrWhiteSpace(search.NabavkaId.ToString())) { nabavkaStavke = nabavkaStavke.Where(w => w.NabavkaId == search.NabavkaId); } foreach (var item in nabavkaStavke) { lista.Add(new Model.NabavkaStavke { NabavkaId = item.NabavkaId, RobaId = item.RobaId, Cijena = item.Cijena, Roba = _db.Roba.Where(w => w.RobaId == item.RobaId).Select(w => w.Naziv).FirstOrDefault(), Sifra = _db.Roba.Where(w => w.RobaId == item.RobaId).Select(w => w.Sifra).FirstOrDefault(), Dostavljeno = item.Kolicina, Stanje = _db.Roba.Where(w => w.RobaId == item.RobaId).Select(w => w.Stanje).FirstOrDefault() }); } return(lista); }
private async void FrmNabavkaDetalji_Load(object sender, EventArgs e) { PripremiDgv(); NabavkaStavkeSearchRequest req = new NabavkaStavkeSearchRequest { NabavkaId = _id }; var result = await _detalji.Get <List <Model.NabavkaStavke> >(req); dgvDetalji.AutoGenerateColumns = false; dgvDetalji.DataSource = result; }