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()); } }