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(); }
static void Main() { //Problem - 03 SalesContext dbContext = new SalesContext(); //Random random = new Random(); //IWriter consoleWriter = new ConsoleWriter(); //ICollection<ISeeder> seeders = new List<ISeeder>(); //seeders.Add(new ProductSeeder(dbContext, random, consoleWriter)); //seeders.Add(new StoreSeeder(dbContext, consoleWriter)); //foreach (var seeder in seeders) //{ // seeder.Seed(); //} //Problem - 05 Sale sale = new Sale() { CustomerId = 1, ProductId = 1, StoreId = 1 }; dbContext.Sales.Add(sale); dbContext.SaveChanges(); Sale[] sales = dbContext.Sales.ToArray(); foreach (Sale saleInfo in sales) { Console.WriteLine($"Sale ({saleInfo.SaleId} {saleInfo.Date})"); } }
//Add methods public static string AddCustomer(SalesContext context) { Console.WriteLine("Customer name:"); string name = Console.ReadLine(); Console.WriteLine("Customer email:"); string email = Console.ReadLine(); Console.WriteLine("Customer credit card number"); string creditCardNumber = Console.ReadLine(); var customer = new Customer() { Name = name, Email = email, CreditCardNumber = creditCardNumber }; context.Customers.Add(customer); context.SaveChanges(); return($"Added customer {name}"); }
public static string UpdateStore(SalesContext context, string name) { int storeId = FindStoreId(context, name); if (storeId == -1) { return("There is no store with that name"); } var store = context .Stores .Where(s => s.StoreId == storeId) .FirstOrDefault(); Console.WriteLine("New name:"); string newName = Console.ReadLine(); store.Name = newName; context.SaveChanges(); return($"Store: {name} With new name {newName}"); }
private static void Seed(SalesContext context) { var stores = new[] { new Store { Name = "Kaufland" }, new Store { Name = "Lidl" }, new Store { Name = "Homemax" } }; context.Stores.AddRange(stores); context.SaveChanges(); var customers = new[] { new Customer { Name = "Stoian", Email = "*****@*****.**", CreditCardNumber = "6546754674234" }, new Customer { Name = "Petyr", Email = "*****@*****.**" } }; context.Customers.AddRange(customers); context.SaveChanges(); var products = new[] { new Product { Name = "Bread", Quantity = 0.500m, Price = 0.90m, Description = "White bread" }, new Product { Name = "Steak", Quantity = 0.900m, Price = 6.80m, Description = "Pork steak" }, new Product { Name = "Crowbar", Quantity = 4.900m, Price = 12.50m, Description = "Crowbar for the garden" }, new Product { Name = "Cake", Quantity = 1.000m, Price = 8.20m, Description = "Cake for a birthday" }, new Product { Name = "Screwdriver", Quantity = 0.300m, Price = 9.99m, Description = "Screwdriver for small appliances" } }; context.Products.AddRange(products); context.SaveChanges(); var sales = new[] { new Sale { Date = DateTime.Now, Customer = customers[0], Product = products[1], Store = stores[0] }, new Sale { Date = DateTime.Today.AddDays(-2), Customer = customers[0], Product = products[3], Store = stores[1] }, new Sale { Date = DateTime.Today.AddDays(-6), Customer = customers[1], Product = products[2], Store = stores[2] }, new Sale { Date = DateTime.Now, Customer = customers[1], Product = products[4], Store = stores[2] }, new Sale { Date = DateTime.Now.AddDays(-3), Customer = customers[0], Product = products[0], Store = stores[0] }, new Sale { Date = DateTime.Now, Customer = customers[1], Product = products[1], Store = stores[1] }, }; context.Sales.AddRange(sales); context.SaveChanges(); }
public static string AddSale(SalesContext context) { //Date Console.WriteLine("Add date?"); char dorno = char.Parse(Console.ReadLine()); DateTime?date = new DateTime(); if (char.ToLower(dorno) == 'y') { date = DateTime.Parse(Console.ReadLine()); } else { date = null; } //ProductId Console.WriteLine("Product Name: "); string productName = Console.ReadLine(); int productId = FindProductId(context, productName); if (productId == -1) { Console.WriteLine("Need to add the product before we continue"); Console.WriteLine(AddProduct(context)); productId = FindProductId(context, productName); } //customerId Console.WriteLine("Customer by name:"); string customerName = Console.ReadLine(); int customerId = FindCustomerId(context, customerName); if (customerId == -1) { Console.WriteLine("You have to add new Customer:"); Console.WriteLine(AddCustomer(context)); customerId = FindCustomerId(context, customerName); } //StoreId Console.WriteLine("Store name:"); string storeName = Console.ReadLine(); int storeId = FindStoreId(context, storeName); if (storeId == -1) { Console.WriteLine("You have to create new store!"); Console.WriteLine(AddStore(context)); storeId = FindStoreId(context, storeName); } if (date == null) { Sale sale = new Sale() { ProductId = productId, CustomerId = customerId, StoreId = storeId }; context.Sales.Add(sale); } else { Sale sale = new Sale() { Date = (DateTime)date, ProductId = productId, CustomerId = customerId, StoreId = storeId }; context.Sales.Add(sale); } context.SaveChanges(); return("Added new Sale"); }
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(); }
private static void Seed(SalesContext context) { Product[] products = new[] { new Product { Name = "Chips", Quantity = 30, Price = 1.20M, Description = "Delicious baked chips", }, new Product { Name = "Water", Quantity = 110, Price = 1.00M, Description = "Purest mountain water", } }; context.Products.AddRange(products); Customer[] customers = new[] { new Customer { Name = "Ivan", CreditCardNumber = "1111 1111 1111 1111" }, new Customer { Name = "Mariya", CreditCardNumber = "0000 1111 1111 1111" } }; context.Customers.AddRange(customers); Store store = new Store { Name = "MegaShop" }; context.Stores.Add(store); Sale[] sales = new Sale[] { new Sale { Date = new DateTime(2019, 11, 6), Product = products[0], Customer = customers[1], Store = store, }, new Sale { Date = new DateTime(2019, 11, 6), Product = products[0], Customer = customers[0], Store = store, }, new Sale { Date = new DateTime(2019, 11, 6), Product = products[1], Customer = customers[0], Store = store, } }; context.Sales.AddRange(sales); context.SaveChanges(); }