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());
}
public Faktura Get(string nazwa)
{
using (SMAPIEntities entities = new SMAPIEntities())
{
entities.Configuration.ProxyCreationEnabled = false;
return(entities.Faktura.Include("Klient").FirstOrDefault(e => e.Klient.nazwaKlienta == nazwa));
}
}
public Faktura Get(int id)
{
using (SMAPIEntities entities = new SMAPIEntities())
{
entities.Configuration.ProxyCreationEnabled = false;
return(entities.Faktura.Include("Klient").FirstOrDefault(e => e.FakturaID == id));
}
}
public IEnumerable <Faktura> Get()
{
using (SMAPIEntities entities = new SMAPIEntities())
{
entities.Configuration.ProxyCreationEnabled = false;
return(entities.Faktura.Include("Klient").ToList());
}
}
public IEnumerable <Zamowienie> Get()
{
using (SMAPIEntities entities = new SMAPIEntities())
{
entities.Configuration.ProxyCreationEnabled = false;
return(entities.Zamowienie.Include("Towar").ToList());
}
}
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));
}