public static int InsertEmployee(Personeelslid pl)
{
using (var FinalDBEntities = new FinalDBEntities())
{
FinalDBEntities.Personeelslids.Add(pl);
if (0 < FinalDBEntities.SaveChanges())
{
return(pl.PersoneelslidID);
}
}
return(0);
}
public static int InsertClient(Klant k)
{
using (var FinalDBEntities = new FinalDBEntities())
{
FinalDBEntities.Klants.Add(k);
if (0 < FinalDBEntities.SaveChanges())
{
return(k.KlantID);
}
}
return(0);
}
public static int InsertSupplier(Leverancier l)
{
using (var FinalDBEntities = new FinalDBEntities())
{
FinalDBEntities.Leveranciers.Add(l);
if (0 < FinalDBEntities.SaveChanges())
{
return(l.LeverancierID);
}
}
return(0);
}
public static int InsertProduct(Product p)
{
using (var FinalDBEntities = new FinalDBEntities())
{
FinalDBEntities.Products.Add(p);
if (0 < FinalDBEntities.SaveChanges())
{
return(p.ProductID);
}
}
return(0);
}
public static int InsertCategory(Categorie c)
{
using (var FinalDBEntities = new FinalDBEntities())
{
FinalDBEntities.Categories.Add(c);
if (0 < FinalDBEntities.SaveChanges())
{
return(c.CategorieID);
}
}
return(0);
}
public static int InsertOrder(Bestelling b)
{
using (var FinalDBEntities = new FinalDBEntities())
{
FinalDBEntities.Bestellings.Add(b);
if (0 < FinalDBEntities.SaveChanges())
{
return(b.BestellingID);
}
}
return(0);
}
public static int DeleteEmployee(Personeelslid EmployeeDelete)
{
using (var FinalDBEntities = new FinalDBEntities())
{
var query = from Personeelslid in FinalDBEntities.Personeelslids
where Personeelslid.PersoneelslidID == EmployeeDelete.PersoneelslidID
select Personeelslid;
Personeelslid personeelslid = query.FirstOrDefault();
FinalDBEntities.Personeelslids.Remove(personeelslid);
return(FinalDBEntities.SaveChanges());
}
}
public static int DeleteSupplier(Leverancier SupplierDelete)
{
using (var FinalDBEntities = new FinalDBEntities())
{
var query = from Leverancier in FinalDBEntities.Leveranciers
where Leverancier.LeverancierID == SupplierDelete.LeverancierID
select Leverancier;
Leverancier leverancier = query.FirstOrDefault();
FinalDBEntities.Leveranciers.Remove(leverancier);
return(FinalDBEntities.SaveChanges());
}
}
public static int DeleteCatergory(Categorie CategoryDelete)
{
using (var FinalDBEntities = new FinalDBEntities())
{
var query = from Categorie in FinalDBEntities.Categories
where Categorie.CategorieID == CategoryDelete.CategorieID
select Categorie;
Categorie categorie = query.FirstOrDefault();
FinalDBEntities.Categories.Remove(categorie);
return(FinalDBEntities.SaveChanges());
}
}
public static int DeleteOrder(Bestelling OrderDelete)
{
using (var FinalDBEntities = new FinalDBEntities())
{
var query = from Bestelling in FinalDBEntities.Bestellings
where Bestelling.BestellingID == OrderDelete.BestellingID
select Bestelling;
Bestelling bestelling = query.FirstOrDefault();
FinalDBEntities.Bestellings.Remove(bestelling);
return(FinalDBEntities.SaveChanges());
}
}
public static int DeleteClient(Klant ClientDelete)
{
using (var FinalDBEntities = new FinalDBEntities())
{
var query = from Klant in FinalDBEntities.Klants
where Klant.KlantID == ClientDelete.KlantID
select Klant;
Klant k = query.FirstOrDefault();
FinalDBEntities.Klants.Remove(k);
return(FinalDBEntities.SaveChanges());
}
}
public static int DeleteProduct(Product ProductDelete)
{
using (var FinalDBEntities = new FinalDBEntities())
{
var query = from Product in FinalDBEntities.Products
where Product.ProductID == ProductDelete.ProductID
select Product;
Product p = query.FirstOrDefault();
FinalDBEntities.Products.Remove(p);
return(FinalDBEntities.SaveChanges());
}
}