public void Update(int id, NarudzbeInsertRequest request) { //Model.Database.Narudzba nova = new Model.Database.Narudzba(); Model.Database.Narudzba nova = _context.Narudzba.Where(x => x.NarudzbaId == id).Include(x => x.Klijent).Include(y => y.Korisnik).Include(p => p.Skladiste) .SingleOrDefault(); nova.BrojNarudzbe = request.BrojNarudzbe; nova.Datum = request.Datum; if (request.IznosBezPdv > 0) { nova.IznosBezPdv = request.IznosBezPdv; } if (request.IznosSaPdv > 0) { nova.IznosSaPdv = request.IznosSaPdv; } nova.Otkazano = request.Otkazano; nova.Status = request.Status; nova.KorisnikId = request.KorisnikId; nova.KlijentId = request.KlijentId; nova.SkladisteId = request.SkladisteId; _context.Narudzba.Attach(nova); _context.Narudzba.Update(nova); _context.SaveChanges(); }
public void InsertNarudzba(Model.Database.Narudzba narudzba, List <Model.Database.StavkaNarudzbe> stavke) { int id = naruzbaRepository.InsertAndReturnEntityId(narudzba); stavke.ForEach(x => x.NarudzbaId = id); stavkeNaruzbaRepository.InsertRange(stavke); }
public void Insert(NarudzbeInsertRequest request) { Model.Database.Narudzba nova = new Model.Database.Narudzba(); nova.BrojNarudzbe = request.BrojNarudzbe; nova.Datum = request.Datum; if (request.IznosBezPdv > 0) { nova.IznosBezPdv = request.IznosBezPdv; } if (request.IznosSaPdv > 0) { nova.IznosSaPdv = request.IznosSaPdv; } nova.Otkazano = request.Otkazano; nova.Status = request.Status; nova.KorisnikId = request.KorisnikId; nova.KlijentId = request.KlijentId; nova.SkladisteId = request.SkladisteId; _context.Narudzba.Add(nova); _context.SaveChanges(); foreach (var item in request.stavke) { Model.Database.NarudzbaStavke stavka = new Model.Database.NarudzbaStavke(); stavka.NarudzbaId = nova.NarudzbaId; stavka.Popust = item.Popust; stavka.Kolicina = item.Kolicina; stavka.Cijena = item.Cijena; stavka.ArtikalId = item.ArtikalId; _context.NarudzbaStavke.Add(stavka); _context.SaveChanges(); } }