//public Order GetOrderById(int id) //{ // return _ctx.Orders // .Include(o => o.Items) // .ThenInclude(i => i.Product) // .Where(o => o.Id == id) // .FirstOrDefault(); //} public bool SaveAll() { return(_ctx.SaveChanges() > 0); }
public async Task SeedAsync() //public void Seed() { _ctx.Database.EnsureCreated(); StoreUser user = await _userManager.FindByEmailAsync("*****@*****.**"); if (user == null) { user = new StoreUser() { FirstName = "Salim", LastName = "Miah", Email = "*****@*****.**", UserName = "******" }; var result = await _userManager.CreateAsync(user, "P@ssw0rd!"); if (result != IdentityResult.Success) { throw new InvalidOperationException("Could not create new user in seeder"); } } if (!_ctx.Products.Any()) { //Need to create sample data var filepath = Path.Combine(_hosting.ContentRootPath, "Data/art.json"); var json = File.ReadAllText(filepath); var products = JsonConvert.DeserializeObject <IEnumerable <Product> >(json); _ctx.Products.AddRange(products); var order = _ctx.Orders.Where(o => o.Id == 1).FirstOrDefault(); //if(order == null) //{ // order = new Order(); // order.Items = new List<OrderItem>() // { // new OrderItem // { // Product =products.First(), // Quantity = 5, // UnitPrice = products.FirstOrDefault().Price // } // }; // _ctx.Add(order); //} if (order != null) { order.User = user; order.Items = new List <OrderItem>() { new OrderItem() { Product = products.First(), Quantity = 5, UnitPrice = products.First().Price } }; } _ctx.SaveChanges(); } }