public IHttpActionResult PutDostawa(int id, Dostawa dostawa)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dostawa.id_dostawa)
{
return(BadRequest());
}
db.Entry(dostawa).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DostawaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutAdre(int id, Adre adre)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != adre.id_adres)
{
return(BadRequest());
}
db.Entry(adre).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AdreExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutProdukt(int id, Produkt produkt)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != produkt.id_produkt)
{
return(BadRequest());
}
db.Entry(produkt).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProduktExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutDuck(DuckViewModel duck)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
var ExistingDuck = ctx.Kaczki.Where(I => I.Kaczka_id == duck.DuckId).FirstOrDefault();
if (ExistingDuck != null)
{
ExistingDuck.Rodzaj = duck.DuckType;
ExistingDuck.Cena = duck.DuckPrice;
ExistingDuck.Kraj_id = duck.DuckCountryId;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult PutRecipient(RecipientViewModel recipient)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
var ExistingRecipient = ctx.Odbiorcy.Where(I => I.Odbiorca_id == recipient.RecipientId).FirstOrDefault();
if (ExistingRecipient != null)
{
ExistingRecipient.Odbiorca_id = recipient.RecipientId;
ExistingRecipient.Odbiorca_nazwa = recipient.RecipientName;
ExistingRecipient.Kraj_id = recipient.RecipientCountryId;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult PutInvoice(InvoiceViewModel invoice)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
var ExistingInvoice = ctx.Faktury.Where(I => I.Faktura_id == invoice.InvoiceId).FirstOrDefault();
if (ExistingInvoice != null)
{
//ExistingInvoice.Faktura_id = invoice.InvoiceId;
ExistingInvoice.Dostawca_id = invoice.SupplierId;
ExistingInvoice.Odbiorca_id = invoice.RecipientId;
ExistingInvoice.Kaczka_id = invoice.DuckId;
ExistingInvoice.Pracownik_id = invoice.EmployeeId;
ExistingInvoice.Ilosc = invoice.Quantity;
// ExistingInvoice.Data_wystawienia = invoice.Date;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult PostNewInvoice(InvoiceViewModel invoice)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
ctx.Faktury.Add(new Faktury()
{
Faktura_id = NextInvoiceIndex,
Odbiorca_id = invoice.RecipientId.ToString(),
Dostawca_id = invoice.SupplierId.ToString(),
Kaczka_id = int.Parse(invoice.DuckId.ToString()),
Pracownik_id = int.Parse(invoice.EmployeeId.ToString()),
Ilosc = invoice.Quantity,
Data_wystawienia = DateTime.Now
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PutCountry(CountryViewModel country)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
var ExistingCountry = ctx.Kraje.Where(I => I.Kraj_id == country.CountryId).FirstOrDefault();
if (ExistingCountry != null)
{
ExistingCountry.Kraj_id = country.CountryId;
ExistingCountry.Kraj_nazwa = country.CountryName;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult PutEmployee(EmployeeViewModel employee)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
var ExistingEmployee = ctx.Pracownicy.Where(I => I.Pracownik_id == employee.EmployeeId).FirstOrDefault();
if (ExistingEmployee != null)
{
ExistingEmployee.Imie = employee.EmployeeName;
ExistingEmployee.Nazwisko = employee.EmployeeSurname;
ExistingEmployee.Pensja = employee.EmployeeSalary;
ExistingEmployee.Plec = employee.Gender;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult PutRecipient(SupplierViewModel supplier)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
var ExistingSupplier = ctx.Dostawcy.Where(I => I.Dostawca_id == supplier.SupplierId).FirstOrDefault();
if (ExistingSupplier != null)
{
ExistingSupplier.Dostawca_id = supplier.SupplierId;
ExistingSupplier.Dostawca_nazwa = supplier.SupplierName;
ExistingSupplier.Kraj_id = supplier.SupplierCountryId;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult DeleteCountryById(string id)
{
using (var ctx = new SklepEntities())
{
var country = ctx.Kraje.Where(I => I.Kraj_id == id).FirstOrDefault();
ctx.Entry(country).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult DeleteInvoiceById(int id)
{
if (id < 0)
{
return(BadRequest("Invalid id"));
}
using (var ctx = new SklepEntities())
{
var Invoice = ctx.Faktury.Where(I => I.Faktura_id == id).FirstOrDefault();
ctx.Entry(Invoice).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult DeleteRecipientById(string id)
{
using (var ctx = new SklepEntities())
{
if (ctx.Faktury.Include("Odbiorca_id").Any(K => K.Odbiorca_id == id))
{
return(BadRequest("Id exists"));
}
{
var recipient = ctx.Odbiorcy.Where(I => I.Odbiorca_id == id).FirstOrDefault();
ctx.Entry(recipient).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
}
return(Ok());
}
public IHttpActionResult DeleteSupplierById(string id)
{
using (var ctx = new SklepEntities())
{
if (ctx.Faktury.Include("Dostawca").Any(K => K.Dostawca_id == id))
{
return(BadRequest("Id exists"));
}
{
var supplier = ctx.Dostawcy.Where(I => I.Dostawca_id == id).FirstOrDefault();
ctx.Entry(supplier).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
}
return(Ok());
}
public IHttpActionResult PostNewCountry(CountryViewModel country)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
ctx.Kraje.Add(new Kraje()
{
Kraj_id = country.CountryId,
Kraj_nazwa = country.CountryName,
}); ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewRecipient(RecipientViewModel recipient)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
ctx.Odbiorcy.Add(new Odbiorcy()
{
Odbiorca_id = recipient.RecipientId,
Odbiorca_nazwa = recipient.RecipientName,
Kraj_id = recipient.RecipientCountryId
}); ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewSupplier(SupplierViewModel supplier)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
ctx.Dostawcy.Add(new Dostawcy()
{
Dostawca_id = supplier.SupplierId,
Dostawca_nazwa = supplier.SupplierName,
Kraj_id = supplier.SupplierCountryId
}); ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewDuck(DuckViewModel duck)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
ctx.Kaczki.Add(new Kaczki()
{
Kaczka_id = NextDuckIndex,
Rodzaj = duck.DuckType,
Cena = duck.DuckPrice,
Kraj_id = duck.DuckCountryId
}); ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewEmployee(EmployeeViewModel employee)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SklepEntities())
{
ctx.Pracownicy.Add(new Pracownicy()
{
Pracownik_id = NextEmployeeIndex,
Imie = employee.EmployeeName,
Nazwisko = employee.EmployeeSurname,
Pensja = employee.EmployeeSalary,
Plec = employee.Gender
}); ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult DeleteEmployeeById(int id)
{
if (id < 0)
{
return(BadRequest("Invalid id"));
}
using (var ctx = new SklepEntities())
{
if (ctx.Faktury.Include("Pracownik_id").Any(K => K.Pracownik_id == id))
{
return(BadRequest("Id exists"));
}
else
{
var Employee = ctx.Pracownicy.Where(I => I.Pracownik_id == id).FirstOrDefault();
ctx.Entry(Employee).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
}
return(Ok());
}
public IHttpActionResult DeleteDuckById(int id)
{
if (id < 0)
{
return(BadRequest("Invalid id"));
}
using (var ctx = new SklepEntities())
{
if (ctx.Faktury.Include("Kaczka_id").Any(K => K.Kaczka_id == id))
{
return(BadRequest("Id exists"));
}
else
{
var duck = ctx.Kaczki.Where(I => I.Kaczka_id == id).FirstOrDefault();
ctx.Entry(duck).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
}
return(Ok());
}
public void Save()
{
context.SaveChanges();
}
