public async Task SeedAsync() { _ctx.Database.EnsureCreated(); // Seed the Main User StoreUser user = await _userManager.FindByEmailAsync("*****@*****.**"); if (user == null) { user = new StoreUser() { LastName = "Panshyn", FirstName = "Roman", Email = "*****@*****.**", UserName = "******" }; var result = await _userManager.CreateAsync(user, "P@ssw0rd!"); if (result != IdentityResult.Success) { throw new InvalidOperationException("Could not create user in Seeding"); } } if (!_ctx.Products.Any()) { // Need to create sample data var filepath = Path.Combine(_hosting.ContentRootPath, "Data/smartphone.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.User = user; order.Items = new List <OrderItem>() { new OrderItem() { Product = products.First(), Quantity = 5, UnitPrice = products.First().Price } }; } _ctx.SaveChanges(); } }
//public IEnumerable<Product> GetProductsByCategory(string category) //{ // return _ctx.Products // .Where(p => p.Category == category) // .ToList(); //} public bool SaveAll() { return(_ctx.SaveChanges() > 0); }