コード例 #1
0
ファイル: DamaContextSeed.cs プロジェクト: joaodotnet/adama
        public static async Task SeedAsync(DamaContext catalogContext,
                                           ILoggerFactory loggerFactory, int?retry = 0, bool isDevelopment = false)
        {
            var log = loggerFactory.CreateLogger <DamaContextSeed>();

            if (isDevelopment)
            {
                if (!catalogContext.Categories.Any())
                {
                    var cat1 = await catalogContext.Categories.AddAsync(new Category("Acessórios", "acessorios", 1));

                    var cat2 = await catalogContext.Categories.AddAsync(new Category("Papelaria", "papelaria", 2));

                    var cat3 = await catalogContext.Categories.AddAsync(new Category("Decoração", "decoracao", 3));

                    await catalogContext.SaveChangesAsync();

                    var type1 = new CatalogType("Canecas", "http://localhost:5500/images/producttypes/canecas-20.jpg");
                    type1.AddCategory(new CatalogTypeCategory(cat1.Entity.Id));
                    await catalogContext.CatalogTypes.AddAsync(type1);

                    var type2 = new CatalogType("Cadernos", "http://localhost:5500/images/producttypes/cadernos-11.jpg");
                    type2.AddCategory(new CatalogTypeCategory(cat2.Entity.Id));
                    await catalogContext.CatalogTypes.AddAsync(type2);

                    var type3 = new CatalogType("Imãs", "http://localhost:5500/images/producttypes/imas-38.jpg");
                    type3.AddCategory(new CatalogTypeCategory(cat3.Entity.Id));
                    await catalogContext.CatalogTypes.AddAsync(type3);

                    await catalogContext.SaveChangesAsync();

                    var illustrationType = new IllustrationType("Ferias", "Ferias");
                    await catalogContext.IllustrationTypes.AddAsync(illustrationType);

                    await catalogContext.SaveChangesAsync();

                    var illustration = new CatalogIllustration("DAMA_FERIAS", "Dama Férias", illustrationType.Id);
                    await catalogContext.CatalogIllustrations.AddAsync(illustration);

                    await catalogContext.SaveChangesAsync();

                    var item1 = new CatalogItem("Carteira de Mulher", "carteira-de-mulher", 18.99m, "http://localhost:5500/images/products/dama-de-ferias-(2)-75.jpg", true, true, true, true, illustration.Id, type1.Id);
                    item1.AddCategory(cat1.Entity.Id);
                    await catalogContext.CatalogItems.AddAsync(item1);

                    var item2 = new CatalogItem("Caderno Educadora", "caderno-educadora", 9.99m, "http://localhost:5500/images/products/cadernos-(1)-208.jpg", true, true, true, true, illustration.Id, type2.Id);
                    item2.AddCategory(cat2.Entity.Id);
                    await catalogContext.CatalogItems.AddAsync(item2);

                    var item3 = new CatalogItem("Ima Auxiliar", "ima-auxiliar", 5.99m, "http://localhost:5500/images/products/iman-auxiliar-264.jpg", true, true, true, true, illustration.Id, type3.Id);
                    item3.AddCategory(cat3.Entity.Id);
                    await catalogContext.CatalogItems.AddAsync(item3);

                    await catalogContext.SaveChangesAsync();

                    log.LogInformation("Seed data create successuful");
                }
            }
            // if(!catalogContext.ShippingPriceWeights.Any())
            // {
            //     catalogContext.ShippingPriceWeights.AddRange(
            //         new ShippingPriceWeight
            //         {
            //             MinWeight = 0,
            //             MaxWeight = 20,
            //             Price = 0.53M
            //         },
            //         new ShippingPriceWeight
            //         {
            //             MinWeight = 20,
            //             MaxWeight = 50,
            //             Price = 0.70M,
            //         },
            //         new ShippingPriceWeight
            //         {
            //             MinWeight = 50,
            //             MaxWeight = 100,
            //             Price = 0.85M,
            //         },
            //         new ShippingPriceWeight
            //         {
            //             MinWeight = 100,
            //             MaxWeight = 500,
            //             Price = 1.50M,
            //         },
            //         new ShippingPriceWeight
            //         {
            //             MinWeight = 500,
            //             MaxWeight = 2000,
            //             Price = 3.5M
            //         });
            //     await catalogContext.SaveChangesAsync();
            // }
            // if (!catalogContext.ShopConfigs.Any(x => x.Type == ShopConfigType.SEO))
            // {
            //     catalogContext.ShopConfigs.AddRange(
            //         new ShopConfig
            //         {
            //             Type = ShopConfigType.SEO,
            //             IsActive = true,
            //             Name = "Meta Description",
            //             Value = "Bem-vindo à Dama no Jornal®. A Loja Online que oferece os Presentes Personalizados mais Criativos. Vem conhecer os nossos Produtos e Personaliza!"
            //         },
            //         new ShopConfig
            //         {
            //             Type = ShopConfigType.SEO,
            //             IsActive = true,
            //             Name = "Title",
            //             Value = "Dama no Jornal - Loja Online"
            //         });
            //     await catalogContext.SaveChangesAsync();
            // }

            // if(catalogContext.CatalogItems.All(x => string.IsNullOrEmpty(x.Slug)))
            // {
            //     //Fix Duplicates catalog Names
            //     var duplicates = await catalogContext.CatalogItems
            //         .GroupBy(x => x.Name)
            //         .Where(g => g.Count() > 1)
            //         .ToListAsync();
            //     foreach (var item in duplicates)
            //     {
            //         for (int i = 0; i < item.Count(); i++)
            //         {
            //             item.ElementAt(i).UpdateName($"{item.ElementAt(i).Name}-{i + 1}");
            //         }

            //     }

            //     await catalogContext.SaveChangesAsync();

            //     //Update Slug
            //     await catalogContext.CatalogItems.ForEachAsync(c => c.UpdateSlug(Utils.URLFriendly(c.Name)));

            //     await catalogContext.SaveChangesAsync();
            // }

            // if(catalogContext.Categories.All(x => string.IsNullOrEmpty(x.Slug)))
            // {
            //     await catalogContext.Categories.ForEachAsync(x => x.Slug = Utils.URLFriendly(x.Name));
            //     await catalogContext.SaveChangesAsync();
            // }

            // if(catalogContext.CatalogTypes.All(x => string.IsNullOrEmpty(x.Slug)))
            // {
            //     var bolsas = await catalogContext.CatalogTypes.Where(x => x.Name == "Bolsa de Telemóvel").ToListAsync();
            //     if (bolsas?.Count > 1)
            //     {
            //         foreach (var item in bolsas)
            //         {
            //             item.Name = item.Code == "BTL_M" ? "Bolsa de Telemóvel Mulher" : "Bolsa de Telemóvel Homem";
            //         }
            //         await catalogContext.SaveChangesAsync();
            //     }
            //     await catalogContext.CatalogTypes.ForEachAsync(x => x.Slug = Utils.URLFriendly(x.Name));
            //     await catalogContext.SaveChangesAsync();
            // }

            //if (!catalogContext.CatalogPrices.Any())
            //{
            //    var products = await catalogContext.CatalogItems
            //        .Include(x => x.CatalogType)
            //        .ToListAsync();
            //    foreach (var item in products)
            //    {
            //        catalogContext.CatalogPrices.Add(new CatalogPrice
            //        {
            //            CatalogItemId = item.Id,
            //            Price = item.Price ?? item.CatalogType.Price,
            //            Active = true,
            //        });
            //    }
            //    await catalogContext.SaveChangesAsync();
            //}
            //int retryForAvailability = retry.Value;
            //try
            //{
            ////TODO: Only run this if using a real database
            // context.Database.Migrate();

            //    if (!catalogContext.CatalogBrands.Any())
            //    {
            //        catalogContext.CatalogBrands.AddRange(
            //            GetPreconfiguredCatalogBrands());

            //        await catalogContext.SaveChangesAsync();
            //    }

            //    if (!catalogContext.CatalogTypes.Any())
            //    {
            //        catalogContext.CatalogTypes.AddRange(
            //            GetPreconfiguredCatalogTypes());

            //        await catalogContext.SaveChangesAsync();
            //    }

            //    if (!catalogContext.CatalogItems.Any())
            //    {
            //        catalogContext.CatalogItems.AddRange(
            //            GetPreconfiguredItems());

            //        await catalogContext.SaveChangesAsync();
            //    }
            //}
            //catch (Exception ex)
            //{
            //    if (retryForAvailability < 10)
            //    {
            //        retryForAvailability++;
            //        var log = loggerFactory.CreateLogger<DamaContextSeed>();
            //        log.LogError(ex.Message);
            //        await SeedAsync(catalogContext, loggerFactory, retryForAvailability);
            //    }
            //}
        }