private static void Delete() { Show(); Console.WriteLine("Enter the ID of the product you want to delete"); int Delete_Id = Convert.ToInt32(Console.ReadLine()); using (var context = new ETradeContext()) { var entity = context.Entry(new Product { Id = Delete_Id }); entity.State = EntityState.Deleted; context.SaveChanges(); } Show(); Console.WriteLine("Product is deleted"); }
private static void Add() { Console.WriteLine("Enter Product Name"); var Add_ProductName = Console.ReadLine(); Console.WriteLine("Enter Stock Amount"); var Add_StockAmount = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Unit Price"); var Add_UnitPrice = Convert.ToInt32(Console.ReadLine()); using (var context = new ETradeContext()) { var entity = context.Entry(new Product { ProductName = Add_ProductName, StockAmount = Add_StockAmount, UnitPrice = Add_UnitPrice }); entity.State = EntityState.Added; context.SaveChanges(); } }