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 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 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 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 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 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 GetAllInvoice()
{
IList <InvoiceViewModel> Invoices = null;
using (var ctx = new SklepEntities())
{
Invoices = ctx.Faktury.Include("Faktura_id").Select(I => new InvoiceViewModel()
{
InvoiceId = I.Faktura_id,
RecipientId = I.Odbiorca_id,
SupplierId = I.Dostawca_id,
Quantity = I.Ilosc,
EmployeeId = I.Pracownik_id,
DuckId = I.Kaczka_id,
Recipient = new RecipientViewModel()
{
RecipientId = I.Odbiorca_id,
RecipientName = I.Odbiorcy.Odbiorca_nazwa
},
Supplier = new SupplierViewModel()
{
SupplierId = I.Dostawca_id,
SupplierName = I.Dostawcy.Dostawca_nazwa
},
Duck = new DuckViewModel()
{
DuckId = I.Kaczka_id,
DuckType = I.Kaczki.Rodzaj,
DuckPrice = I.Kaczki.Cena
},
Employee = new EmployeeViewModel()
{
EmployeeId = I.Pracownik_id,
EmployeeName = I.Pracownicy.Imie,
EmployeeSurname = I.Pracownicy.Nazwisko
}
}).ToList();
}
if (Invoices.Count == 0)
{
return(NotFound());
}
NextInvoiceIndex = Invoices.Last().InvoiceId + 1;
return(Ok(Invoices));
}
public IHttpActionResult GetCountryById(string id)
{
IList <CountryViewModel> Countries = null;
using (var ctx = new SklepEntities())
{
Countries = ctx.Kraje.Include("Kraje_id").Where(E => E.Kraj_id == id).Select(I => new CountryViewModel()
{
CountryId = I.Kraj_id,
CountryName = I.Kraj_nazwa
}).ToList();
}
return(Ok(Countries));
}
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 GetUser()
{
IList <UserLoginViewModel> Users = null;
using (var ctx = new SklepEntities())
{
Users = ctx.Uzytkownicy.Include("Uzytkownik_id").Select(I => new UserLoginViewModel()
{
UserName = I.Uzytkownik_nazwa,
UserPassword = I.Uzytkownik_haslo,
UserRole = I.Rola,
}).ToList();
}
return(Ok(Users));
}
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 GetRecipientById(string id)
{
IList <RecipientViewModel> Recipients = null;
using (var ctx = new SklepEntities())
{
Recipients = ctx.Odbiorcy.Include("Odbiorca_id").Where(E => E.Odbiorca_id == id).Select(I => new RecipientViewModel()
{
RecipientId = I.Odbiorca_id,
RecipientName = I.Odbiorca_nazwa,
RecipientCountryId = I.Kraj_id
}).ToList();
}
return(Ok(Recipients));
}
public IHttpActionResult GetSupplierById(string id)
{
IList <SupplierViewModel> Suppliers = null;
using (var ctx = new SklepEntities())
{
Suppliers = ctx.Dostawcy.Include("Dostawca_id").Where(E => E.Dostawca_id == id).Select(I => new SupplierViewModel()
{
SupplierId = I.Dostawca_id,
SupplierName = I.Dostawca_nazwa,
SupplierCountryId = I.Kraj_id
}).ToList();
}
return(Ok(Suppliers));
}
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 GetDuckById(int id)
{
IList <DuckViewModel> Ducks = null;
using (var ctx = new SklepEntities())
{
Ducks = ctx.Kaczki.Include("Kaczka_id").Where(E => E.Kaczka_id == id).Select(I => new DuckViewModel()
{
DuckId = I.Kaczka_id,
DuckType = I.Rodzaj,
DuckPrice = I.Cena,
DuckCountryId = I.Kraj_id
}).ToList();
}
return(Ok(Ducks));
}
public IHttpActionResult GetAllDucks()
{
IList <DuckViewModel> Ducks = null;
using (var ctx = new SklepEntities())
{
Ducks = ctx.Kaczki.Include("Kaczka_id").Select(I => new DuckViewModel()
{
DuckId = I.Kaczka_id,
DuckType = I.Rodzaj,
DuckPrice = I.Cena,
DuckCountryId = I.Kraj_id
}).ToList();
}
NextDuckIndex = Ducks.Last().DuckId + 1;
return(Ok(Ducks));
}
public IHttpActionResult GetEmployeeById(int id)
{
IList <EmployeeViewModel> Employees = null;
using (var ctx = new SklepEntities())
{
Employees = ctx.Pracownicy.Include("Pracownik_id").Where(E => E.Pracownik_id == id).Select(I => new EmployeeViewModel()
{
EmployeeId = I.Pracownik_id,
EmployeeName = I.Imie,
EmployeeSurname = I.Nazwisko,
EmployeeSalary = I.Pensja,
Gender = I.Plec
}).ToList();
}
return(Ok(Employees));
}
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 GetAllEmployees()
{
IList <EmployeeViewModel> Employees = null;
using (var ctx = new SklepEntities())
{
Employees = ctx.Pracownicy.Include("Pracownik_id").Select(I => new EmployeeViewModel()
{
EmployeeId = I.Pracownik_id,
EmployeeName = I.Imie,
EmployeeSurname = I.Nazwisko,
EmployeeSalary = I.Pensja,
Gender = I.Plec
}).ToList();
}
NextEmployeeIndex = Employees.Last().EmployeeId + 1;
return(Ok(Employees));
}
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 IHttpActionResult GetInvoiceById(int id)
{
IList <InvoiceViewModel> Invoices = null;
using (var ctx = new SklepEntities())
{
Invoices = ctx.Faktury.Include("Faktura_id").Where(I => I.Faktura_id == id).Select(I => new InvoiceViewModel()
{
InvoiceId = I.Faktura_id,
RecipientId = I.Odbiorca_id,
SupplierId = I.Dostawca_id,
Quantity = I.Ilosc,
EmployeeId = I.Pracownik_id,
DuckId = I.Kaczka_id,
}).ToList();
}
if (Invoices.Count == 0)
{
return(NotFound());
}
return(Ok(Invoices));
}
