private static void SeedStore(SalesContext db) { db.Stores.Add(new Store() { Name = "Magazina na bay ganio" }); db.Stores.Add(new Store() { Name = "24h e-mag" }); db.SaveChanges(); }
private static void SeedDatabase() { using (var context = new SalesContext()) { SeedProducts(context); SeedCustomers(context); SeedStore(context); context.SaveChanges(); SeedSales(context); context.SaveChanges(); } }
private static void SeedCustomer(SalesContext db) { db.Customers.Add(new Customer() { Name = "Ivancheto", Email = "*****@*****.**", CreditCardNumber = "423142873181331" }); db.Customers.Add(new Customer() { Name = "Todor", Email = "*****@*****.**", CreditCardNumber = "121401393190310" }); db.SaveChanges(); }
public static void Main(string[] args) { using (var db = new SalesContext()) { var store = new Store { Name = "Magazin" }; db.Stores.Add(store); db.SaveChanges(); } }
public static void Seeder(SalesContext context) { Store store = new Store(); store.Name = "Kaufland"; context.Stores.Add(store); Product product = new Product(); product.Name = "Krastavica"; product.Price = 7.50m; product.Quantity = 10; Product product2 = new Product(); product2.Name = "Domat"; product2.Price = 8.50m; product2.Quantity = 1; Product product3 = new Product(); product3.Name = "Zele"; product3.Price = 2.50m; product3.Quantity = 2; context.Products.Add(product); context.Products.Add(product2); context.Products.Add(product3); Customer customer = new Customer(); customer.Name = "Gosho"; customer.Email = "Email"; context.Customers.Add(customer); Sale sale = new Sale(); sale.CustomerId = 0; sale.ProductId = 1; sale.StoreId = 2; //sale.Customer = customer; //sale.Product = product3; //sale.Store = store; context.Sales.Add(sale); context.SaveChanges(); }
public static void Main(string[] args) { using (var db = new SalesContext()) { var productsToAdd = GetProductsToSeed(); db.Products.AddRange(productsToAdd); var storesToAdd = GetStoresToSeed(); db.Stores.AddRange(storesToAdd); db.SaveChanges(); } }
public static void Main(string[] args) { var context = new SalesContext(); context.Database.Migrate(); //var product = new Product() //{ // Name = "Koza", // Quantity = 10, // Price = 100, // Description = "Shtastlivi balkanski kozi", //}; //var customer = new Customer() //{ // Name = "Svetlin", // Email = "*****@*****.**", // CreditCardNumber = "2648997200", //}; //var store = new Store() //{ // Name = "Gipo.OOD", //}; var sale = new Sale() { Product = new Product() { Name = "Rimsko Pravo", Quantity = 1, Price = 25, Description = "Uchebnik po Rimsko pravo", }, Customer = new Customer() { Name = "Donika", Email = "*****@*****.**", CreditCardNumber = "2543547200", }, StoreId = 1, }; //context.Sales.Add(sale); context.SaveChanges(); }
static void Main(string[] args) { var context = new SalesContext(); var random = new Random(); var writer = new ConsoleWriter(); var seeders = new List <ISeeder>(); seeders.Add(new ProductSeeder(context, random, writer)); seeders.Add(new StoreSeeder(context, writer)); foreach (var seeder in seeders) { seeder.Seed(); } }
public static string AddStore(SalesContext context) { Console.WriteLine("Store name:"); string name = Console.ReadLine(); Store store = new Store() { Name = name }; context.Stores.Add(store); context.SaveChanges(); return("Added store with name: " + name); }
private static void SeedProduct(SalesContext db) { db.Prodcuts.Add(new Product() { Name = "Kola", Quantity = 5, Price = 1.2M }); db.Prodcuts.Add(new Product() { Name = "Vafla borec", Quantity = 10, Price = 0.5M }); db.Prodcuts.Add(new Product() { Name = "Qica ot chafka", Quantity = 30, Price = 5.0M }); db.SaveChanges(); }
static ServiceProvider Main(string[] args) { SalesContext salesContext = new SalesContext(); using (salesContext) { //.. } ServiceCollection services = new ServiceCollection(); // services.AddSingleton(); ServiceProvider sp = services.BuildServiceProvider(); return(sp); }
public static void Main() { using (var db = new SalesContext()) { try { db.Database.Migrate(); Console.WriteLine("Database successfully created/updated!"); //SeedDB(db); } catch (Exception e) { Console.WriteLine(e.Message); } } }
public static string ReadStore(SalesContext context, string name) { var store = context .Stores .Select(s => new { Name = s.Name }) .Where(s => s.Name == name) .FirstOrDefault(); if (store == null) { return("There is no such store in the database"); } else { return($"Store with name: {store.Name}"); } }
public static string DeleteSale(SalesContext context, int id) { var sale = context .Sales .Where(s => s.SaleId == id) .FirstOrDefault(); if (sale == null) { return("No sale with Id: " + id); } context.Sales.Remove(sale); context.SaveChanges(); return($"Sale with id: {id} removed successfully"); }
private static void Seed(SalesContext db) { var products = new[] { new Product("Apples", 7.4, 2.40m), new Product("Pears", 6.0, 3.10m), new Product("Grapes", 250, 1.95m), new Product("Kiwi", 0.8, 3.5m), }; db.Products.AddRange(products); var customers = new[] { new Customer("Iva", "*****@*****.**", "545056485015120"), new Customer("Gergana", "*****@*****.**", "545056485015120"), new Customer("Rositsa", "*****@*****.**", "545056485015120"), new Customer("Valya", "*****@*****.**", "545056485015120"), }; db.Customers.AddRange(customers); var stores = new[] { new Store("CBA"), new Store("Piccadilly"), new Store("Kaufland"), new Store("Metro"), }; db.Stores.AddRange(stores); var sales = new[] { new Sale(products[0], customers[0], stores[0]), new Sale(products[1], customers[1], stores[1]), new Sale(products[2], customers[2], stores[2]), new Sale(products[3], customers[3], stores[3]), }; db.Sales.AddRange(sales); db.SaveChanges(); }
private static int FindCustomerId(SalesContext context, string name) { int result = -1; var customer = context .Customers .Select(c => new { Id = c.CustomerId, Name = c.Name }) .Where(c => c.Name == name) .FirstOrDefault(); if (customer != null) { result = customer.Id; } return(result); }
public static string DeleteStore(SalesContext context, string name) { int storeId = FindStoreId(context, name); if (storeId == -1) { return("No store with name " + name); } var store = context .Stores .Where(s => s.StoreId == storeId) .First(); context.Stores.Remove(store); context.SaveChanges(); return($"Store {name} removed successfully"); }
public static void Main(string[] args) { using (SalesContext context = new SalesContext()) { // context.Database.EnsureCreated(); int[] arr = new int[] { 1, 2, 3, 4, 4, 2, 1 }; int lastElement = arr.Length - 1; bool isTelescopic = true; for (int i = 0; i <= arr.Length / 2; i++) { if (arr[i] != arr[lastElement - i]) { isTelescopic = false; break; } } Console.WriteLine(isTelescopic); } }
//Delete methods public static string DeleteCustomer(SalesContext context, string name) { int customerId = FindCustomerId(context, name); if (customerId == -1) { return("No customer with name: " + name); } var customer = context .Customers .Where(c => c.CustomerId == customerId) .First(); context.Customers.Remove(customer); context.SaveChanges(); return($"Customer {name} removed successfully"); }
//Read methods public static string ReadCustomer(SalesContext context, string name) { var customer = context .Customers .Select(c => new { CustomerId = c.CustomerId, Name = c.Name, Email = c.Email, CreditCardNumber = c.CreditCardNumber }) .FirstOrDefault(c => c.Name == name); if (customer == null) { return("There is no customer with that name"); } return($"Customer: {customer.Name} with email: {customer.Email} amd credit card number: {customer.CreditCardNumber}"); }
public static string AddProduct(SalesContext context) { //name Console.WriteLine("Product name:"); string productName = Console.ReadLine(); //quantiti Console.WriteLine("Product Quantiti"); double quantity = double.Parse(Console.ReadLine()); //price Console.WriteLine("Price:"); decimal price = decimal.Parse(Console.ReadLine()); //description Console.WriteLine("Description?"); Console.WriteLine("y/n"); char yorn = char.Parse(Console.ReadLine()); string description = string.Empty; if (char.ToLower(yorn) == 'y') { Console.WriteLine("Add description here:"); description = Console.ReadLine(); } var product = new Product() { Name = productName, Quantity = quantity, Price = price, Description = description }; context.Products.Add(product); context.SaveChanges(); return($"Added product {productName} with quantity {quantity} and cost {price}"); }
private static int FindStoreId(SalesContext context, string name) { int result = -1; var store = context .Stores .Select(s => new { Id = s.StoreId, Name = s.Name }) .Where(s => s.Name == name) .FirstOrDefault(); if (store != null) { result = store.Id; } return(result); }
public static string ReadProduct(SalesContext context, string name) { var product = context .Products .Select(p => new { Name = p.Name, Quantity = p.Quantity, Price = p.Price, Description = p.Description }) .Where(p => p.Name == name) .FirstOrDefault(); if (product == null) { return("There is no such product in the database"); } return($"Product {product.Name} with price {product.Price} and quantity {product.Quantity} Description: {product.Description}"); }
private static void SeedSale(SalesContext db) { db.Sales.Add(new Sale() { ProductId = 1, CustomerId = 1, StoreId = 1 }); db.Sales.Add(new Sale() { ProductId = 1, CustomerId = 1, StoreId = 2 }); db.Sales.Add(new Sale() { ProductId = 2, CustomerId = 2, StoreId = 1 }); db.Sales.Add(new Sale() { ProductId = 3, CustomerId = 2, StoreId = 1 }); db.SaveChanges(); }
private static int FindProductId(SalesContext context, string name) { int result = -1; var productId = context .Products .Select(p => new { Id = p.ProductId, Name = p.Name }) .Where(p => p.Name == name) .FirstOrDefault(); if (productId != null) { result = productId.Id; } return(result); }
static void Main(string[] args) { var rand = new Random(); var context = new SalesContext(); //context.Database.EnsureDeleted(); //context.Database.EnsureCreated(); for (int i = 50; i < 60; i++) { var sale = new Sale { Product = new Product() { Name = "Sharo" + i, Quantity = 5, Price = 20, }, Customer = new Customer() { Name = "Pesho" + i, Email = "*****@*****.**" + i, CreditCardNumber = new String(Convert.ToChar(rand.Next(0, 10).ToString()), 10) }, Store = new Store() { Name = "Billa" + i } }; context.Sales.Add(sale); } context.SaveChanges(); }
private static void Seed(SalesContext context) { var customers = new[] { new Customer("Ivan", "*****@*****.**", "2685H8NSQLX"), new Customer("Petyr", "*****@*****.**", "829HOTYP89"), new Customer("Maria", "*****@*****.**", "HETAB6QW816") }; context.Customers.AddRange(customers); var products = new[] { new Product("Apple", 12.476, 1.60m), new Product("Orange", 17.267, 2.70m), new Product("Banana", 10.682, 1.80m, "Bananas are fairly nutritious, and contain high amounts of fiber and antioxidants.") }; context.Products.AddRange(products); var stores = new[] { new Store("Mandarin"), new Store("Fresh"), new Store("Plodchetata") }; context.Stores.AddRange(stores); var sales = new[] { new Sale(DateTime.Parse("10.10.2017"), products[0].ProductId, customers[2].CustomerId, stores[1].StoreId), new Sale(products[1].ProductId, customers[0].CustomerId, stores[2].StoreId), new Sale(DateTime.Parse("09.04.2017"), products[2].ProductId, customers[1].CustomerId, stores[0].StoreId) }; context.Sales.AddRange(sales); context.SaveChanges(); }
public static string ReadSale(SalesContext context, string name) { var sale = context .Sales .Select(s => new { SaleDate = s.Date, SaledProduct = s.Product.Name, SaledToCustomer = s.Customer.Name, StoreName = s.Store.Name }) .Where(s => s.SaledProduct == name) .FirstOrDefault(); if (sale == null) { return("There is no such store in the database"); } return($" Selled product: {sale.SaledProduct} on date {sale.SaleDate}" + $"In Store: {sale.StoreName} to customer {sale.SaledToCustomer}"); }
public static string DeleteProduct(SalesContext context, string name) { int productId = FindProductId(context, name); if (productId == -1) { return($"No product with name {name}"); } var product = context .Products .Where(p => p.ProductId == productId) .First(); context .Products.Remove(product); context .SaveChanges(); return("Successfully removed product: " + name); }
private static void Seed(SalesContext context) { Customer customer = new Customer { Name = "Stoqn Dimitrov", CreditCardNumber = "11aa-2211", Email = "*****@*****.**" }; context.Customers.Add(customer); Product product = new Product { Name = "Table", Price = 124.99m, Description = "Great wooden table", Quantity = 2 }; context.Products.Add(product); Store store = new Store { Name = "IKEA" }; context.Stores.Add(store); Sale sale = new Sale { Product = product, Store = store, Customer = customer }; context.Sales.Add(sale); context.SaveChanges(); }