public Product DeleteProducts(int productID) { Product dbentry = context.Products.FirstOrDefault(x => x.ProductID == productID); if (dbentry != null) { context.Products.Remove(dbentry); context.SaveChanges(); } return(dbentry); }
public static void EnsurePopulated(IApplicationBuilder app) { ApplicationDataBaseContext context = app.ApplicationServices .GetRequiredService <ApplicationDataBaseContext>(); if (!context.Products.Any()) { context.Products.AddRange( new Product { Name = "Kayak", Price = 32.23M, Description = "A boat fot one person.", Category = "Water sport." }, new Product { Name = "Boxing glowes", Price = 23.42M, Description = "Glowes from natural skin.", Category = "Boxing." }, new Product { Name = "Lifejucket", Price = 21.32M, Description = "Protective and fashionable.", Category = "Water sport." }, new Product { Name = "Soccet ball", Price = 10.21M, Description = "FIFA=approved size and weight.", Category = "Football." } ); context.SaveChanges(); } }
public void DeleteOrder(int productId) { context.Orders.RemoveRange(Orders.Where(x => x.Lines.OrderBy(y => y.Product.ProductID == productId).Count() != 0)); context.SaveChanges(); }