public static void SeedDatabase(SalesContext context)
{
Random randGenerator = new Random();
var products = new List <Product>();
var customers = new List <Customer>();
var stores = new List <Store>();
var sales = new List <Sale>();
products = SeedProducts(randGenerator);
customers = SeedCustomers(randGenerator);
stores = SeedStores(randGenerator);
sales = SeedSales(randGenerator, products, customers, stores);
context.AddRange(products);
context.AddRange(customers);
context.AddRange(stores);
context.AddRange(sales);
context.SaveChanges();
}
private static void Seed(SalesContext db)
{
Customer customer = new Customer
{
Name = "Gosho",
Email = "*****@*****.**",
CreditCardNumber = "123",
};
Customer customer2 = new Customer
{
Name = "Ivan",
Email = "*****@*****.**",
CreditCardNumber = "567",
};
db.Add(customer2);
db.Add(customer);
Sale sale = new Sale
{
Date = DateTime.Now,
ProductId = 1,
CustomerId = 1,
StoreId = 2,
};
db.AddRange(sale);
Sale sale2 = new Sale
{
Date = DateTime.Now,
ProductId = 2,
CustomerId = 2,
StoreId = 1,
};
db.Add(sale2);
Sale sale3 = new Sale
{
Date = DateTime.Now,
ProductId = 1,
CustomerId = 1,
StoreId = 2,
};
db.Add(sale3);
Product product = new Product
{
Name = "Sirene",
Quantity = 15,
Price = 120,
Description = "Unikalno",
};
product.Sales.Add(sale);
product.Sales.Add(sale2);
Product product2 = new Product
{
Name = "Salam",
Quantity = 5,
Price = 13,
Description = "Vkusno",
};
product2.Sales.Add(sale);
product2.Sales.Add(sale2);
db.Add(product2);
Store store = new Store
{
Name = "Metro"
};
store.Sales.Add(sale3);
db.Add(store);
db.SaveChanges();
}
