コード例 #1
0
        internal static bool SeedDatabase(DbContextOptions <StoreSystemDbContext> options)
        {
            using (var seedContext = new StoreSystemDbContext(options))
            {
                seedContext.Addresses.AddRange(
                    new Address
                {
                    Name = "valid address 1"
                },
                    new Address
                {
                    Name = "valid address 2"
                }
                    );

                var entityTracked = seedContext.SaveChanges();
                return(entityTracked > 0 ? true : false);
            }
        }
コード例 #2
0
        internal static bool SeedDatabase(DbContextOptions <StoreSystemDbContext> options)
        {
            using (var seedContext = new StoreSystemDbContext(options))
            {
                seedContext.Addresses.AddRange(
                    new Address
                {
                    Name = "valid address 1"
                },
                    new Address
                {
                    Name = "valid address 2"
                }
                    );

                seedContext.Cities.AddRange(
                    new City
                {
                    Name = "valid city 1"
                },
                    new City
                {
                    Name = "valid city 2"
                }
                    );

                seedContext.Countries.AddRange(
                    new Country
                {
                    Name = "valid country 1"
                },
                    new Country
                {
                    Name = "valid country 2"
                }
                    );

                seedContext.Clients.AddRange(
                    new Client
                {
                    Name      = "valid client 1",
                    AddressID = 1,
                    CityID    = 1,
                    CountryID = 1,
                    UIN       = "123456789",
                },
                    new Client
                {
                    Name      = "valid client 2",
                    AddressID = 2,
                    CityID    = 3,
                    CountryID = 2,
                    UIN       = "987654321",
                }
                    );

                seedContext.Suppliers.AddRange(
                    new Supplier
                {
                    Name      = "valid client 1",
                    AddressID = 1,
                    CityID    = 1,
                    CountryID = 1,
                    UIN       = "123456789",
                },
                    new Supplier
                {
                    Name      = "valid client 2",
                    AddressID = 2,
                    CityID    = 2,
                    CountryID = 2,
                    UIN       = "987654321",
                }
                    );

                seedContext.Products.AddRange(
                    new Product
                {
                    Name        = "valid product 1",
                    Measure     = "v1",
                    Quantity    = 1,
                    BuyPrice    = 1,
                    RetailPrice = 1
                },
                    new Product
                {
                    Name        = "valid product 2",
                    Measure     = "v2",
                    Quantity    = 2,
                    BuyPrice    = 2,
                    RetailPrice = 2
                },
                    new Product
                {
                    Name        = "valid product 3",
                    Measure     = "v3",
                    Quantity    = 3,
                    BuyPrice    = 3,
                    RetailPrice = 3
                }
                    );

                seedContext.Warehouses.AddRange(
                    new Warehouse
                {
                    Name      = "valid warehouse 1",
                    AddressID = 1,
                    CityID    = 1,
                    CountryID = 1,
                },
                    new Warehouse
                {
                    Name      = "valid warehouse 2",
                    AddressID = 2,
                    CityID    = 2,
                    CountryID = 2,
                }
                    );

                seedContext.Sales.Add(
                    new Sale
                {
                    ClientID        = 1,
                    AddressID       = 1,
                    CityID          = 1,
                    CountryID       = 1,
                    OfferID         = 1,
                    ProductDiscount = 0.1m,
                    DeadlineDate    = new DateTime(2019, 1, 1),
                    DeliveryDate    = new DateTime(1, 1, 1),
                    OrderDate       = new DateTime(2019, 1, 1),
                    ProductsInSale  = new List <ProductSale>
                    {
                        new ProductSale {
                            ProductID = 1, Quantity = 1
                        },
                        new ProductSale {
                            ProductID = 2, Quantity = 1
                        }
                    }
                }
                    );

                seedContext.Sales.Add(
                    new Sale
                {
                    ClientID        = 1,
                    AddressID       = 1,
                    CityID          = 1,
                    CountryID       = 1,
                    OfferID         = 1,
                    ProductDiscount = 0.1m,
                    DeadlineDate    = new DateTime(2019, 2, 2),
                    DeliveryDate    = new DateTime(2019, 2, 2),
                    OrderDate       = new DateTime(2019, 2, 2),
                    ProductsInSale  = new List <ProductSale>
                    {
                        new ProductSale {
                            ProductID = 3, Quantity = 1
                        },
                    }
                }
                    );

                seedContext.Sales.Add(
                    new Sale
                {
                    ClientID        = 2,
                    AddressID       = 2,
                    CityID          = 2,
                    CountryID       = 2,
                    OfferID         = 2,
                    ProductDiscount = 0.1m,
                    DeadlineDate    = new DateTime(2019, 3, 3),
                    DeliveryDate    = new DateTime(2019, 3, 3),
                    OrderDate       = new DateTime(2019, 3, 3),
                }
                    );
                seedContext.Sales.Add(
                    new Sale
                {
                    ClientID        = 2,
                    AddressID       = 2,
                    CityID          = 2,
                    CountryID       = 2,
                    OfferID         = 2,
                    ProductDiscount = 0.1m,
                    DeadlineDate    = new DateTime(2019, 4, 4),
                    DeliveryDate    = new DateTime(2019, 4, 4),
                    OrderDate       = new DateTime(2019, 4, 4),
                    ProductsInSale  = new List <ProductSale>
                    {
                        new ProductSale {
                            ProductID = 1, Quantity = 1
                        },
                        new ProductSale {
                            ProductID = 3, Quantity = 1
                        }
                    }
                }
                    );


                seedContext.Offers.AddRange(
                    new Offer
                {
                    ClientID        = 1,
                    AddressID       = 1,
                    CityID          = 1,
                    CountryID       = 1,
                    ProductDiscount = 0.1m,
                    ExpiredDate     = new DateTime(2019, 1, 1),
                    DeliveryDate    = new DateTime(2019, 1, 1),
                    OfferDate       = new DateTime(2019, 1, 1),
                    ProductsInOffer = new List <ProductOffer>
                    {
                        new ProductOffer {
                            ProductID = 1, Quantity = 1
                        },
                    }
                },
                    new Offer
                {
                    ClientID        = 2,
                    AddressID       = 2,
                    CityID          = 2,
                    CountryID       = 2,
                    ProductDiscount = 0.2m,
                    ExpiredDate     = new DateTime(2019, 2, 2),
                    DeliveryDate    = new DateTime(2019, 2, 2),
                    OfferDate       = new DateTime(2019, 2, 2),
                    ProductsInOffer = new List <ProductOffer>
                    {
                        new ProductOffer {
                            ProductID = 2, Quantity = 1
                        }
                    }
                }
                    );

                seedContext.Purchases.AddRange(
                    new Purchase
                {
                    SupplierID         = 1,
                    WarehouseID        = 1,
                    DeadlineDate       = new DateTime(2019, 1, 1),
                    DeliveryDate       = new DateTime(2019, 1, 1),
                    PurchaseDate       = new DateTime(2019, 1, 1),
                    ProductsТоPurchase = new List <ProductPurchase>
                    {
                        new ProductPurchase {
                            ProductID = 1, ProductPrice = 1, ProductQty = 1
                        },
                        new ProductPurchase {
                            ProductID = 2, ProductPrice = 2, ProductQty = 2
                        }
                    }
                }
                    );



                var entityTracked = seedContext.SaveChanges();
                return(entityTracked > 0 ? true : false);
            }
        }