public IHttpActionResult InsertZam(int id, Zamowienie zam1) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (SMAPIEntities entities = new SMAPIEntities()) { var numerKlienta = entities.Faktura.Where(p => p.FakturaID == id).FirstOrDefault(); zam1.KlientID = numerKlienta.KlientID; zam1.FakturaID = id; var poRabacieTemp = zam1.Cena * (100 - zam1.rabat); zam1.PoRabacie = poRabacieTemp / 100; var suma = (zam1.PoRabacie * zam1.ilosc); zam1.Razem = suma; entities.Zamowienie.Add(zam1); entities.SaveChanges(); } return(Ok()); }
// PUT: odata/Faktura(5) public IHttpActionResult Put([FromODataUri] int key, Delta <Faktura> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Faktura faktura = db.Faktura.Find(key); if (faktura == null) { return(NotFound()); } patch.Put(faktura); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!FakturaExists(key)) { return(NotFound()); } else { throw; } } return(Updated(faktura)); }
public IHttpActionResult InsertFakt(Faktura faktura1) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (SMAPIEntities entities = new SMAPIEntities()) { entities.Configuration.ProxyCreationEnabled = false; var ostatni = entities.Faktura.Max(p => p.FakturaID); faktura1.NrFaktury = ostatni + 1 + "/2020"; faktura1.Klient.numerKlienta = "QWE" + (ostatni + 1).ToString(); entities.Faktura.Add(faktura1); entities.SaveChanges(); } return(Ok(faktura1)); }