static void Main(string[] args)
{
ShoppingEFDBContext _context = new ShoppingEFDBContext();
//Product product1 = new Product();
//product1.ProductName = "HP Laptop";
//product1.ProductCost = 45000;
//_context.Products.Add(product1);
//_context.SaveChanges();
var id = Guid.Parse("CCA121A9-72C4-4E38-9480-F5DA75D6BEF1");
Order order = _context.Orders.Find(id);
LineItem item = new LineItem();
item.order = order;
item.product.ID = new Guid("AB28D600-875B-4A35-9CAD-61315182682C");
item.Quantity = 2;
order.Lineitems.Add(item);
_context.SaveChanges();
//var lineid = Guid.Parse("6C38E66B-1D64-457E-8C68-9340BE179950");
//var lineitem = _context.Items.Find(lineid);
//lineitem.product.ID = new Guid("AB28D600-875B-4A35-9CAD-61315182682C");
//_context.SaveChanges();
//var id = Guid.Parse("CCA121A9-72C4-4E38-9480-F5DA75D6BEF1");
//Order order = _context.Orders.Find(id);
// Add(_context);
// Update(_context, order);
// Display(order);
// ReverseDisplay(_context);
}
private static void ReverseDisplay(ShoppingEFDBContext _context)
{
var lineid = Guid.Parse("6C38E66B-1D64-457E-8C68-9340BE179950");
var lineitem = _context.Items.Find(lineid);
Console.WriteLine(lineitem.ID);
// Console.WriteLine(lineitem.ProductName);
Console.WriteLine(lineitem.Quantity);
Console.WriteLine(lineitem.order.ID);
// Console.WriteLine(lineitem.order.CustomerName);
Console.WriteLine(lineitem.order.Date);
}
private static void Update(ShoppingEFDBContext _context, Order query)
{
//LineItem item = new LineItem();
//item.order = query;
//item.ProductName = "Biscuit";
//item.Quantity = 2;
//item.UnitPrice = 10;
//query.Lineitems.Add(item);
//_context.SaveChanges();
var id = Guid.Parse("6C38E66B-1D64-457E-8C68-9340BE179950");
var lineItem = query.Lineitems.First();
// lineItem.ProductName = "Pen";
_context.SaveChanges();
}
private static void Add(ShoppingEFDBContext _context)
{
Order order1 = new Order();
// order1.CustomerName = "Akash";
order1.Date = "20-07-2019";
LineItem item = new LineItem();
// item.order = query;
// item.ProductName = "Biscuit";
item.Quantity = 2;
// item.UnitPrice = 10;
order1.Add(item);
_context.Orders.Add(order1);
_context.SaveChanges();
}