Beispiel #1
0
        //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);
        }
Beispiel #2
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();
            }
        }