private static void Show() { using (var context = new ETradeContext()) { foreach (var item in context.products) { Console.WriteLine("Product Id = {0}, Product Name = {1} , Product Stock Amount = {2} , Product Unit Price = {3}", item.Id, item.ProductName, item.StockAmount, item.UnitPrice); } } }
private static void Update() { Show(); Console.WriteLine("Enter the ID of the product you want to update"); int Update_Id = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter a number to update\n1=Product Name\n2=Stock Amount\n3=UnitPrice"); int choice = Convert.ToInt32(Console.ReadLine()); using (var context = new ETradeContext()) { switch (choice) { case 1: { Console.WriteLine("Enter new product name"); var New_ProductName = Console.ReadLine(); Product product = context.products.Find(Update_Id); product.ProductName = New_ProductName; context.SaveChanges(); break; } case 2: { Console.WriteLine("Enter new stock amount"); var New_StockAmount = Convert.ToInt32(Console.ReadLine()); Product product = context.products.Find(Update_Id); product.StockAmount = New_StockAmount; context.SaveChanges(); break; } case 3: { Console.WriteLine("Enter new unit price"); var New_UnitPrice = Convert.ToInt32(Console.ReadLine()); Product product = context.products.Find(Update_Id); product.UnitPrice = New_UnitPrice; context.SaveChanges(); break; } default: Console.WriteLine("Incorrect entry"); break; } } Show(); }
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(); } }