public Startup(IHostingEnvironment env) { using (var client = new InventoryContext()) { client.Database.EnsureCreated(); } using (var client = new UserContext()) { client.Database.EnsureCreated(); } using (var client = new PurchaseOrderContext()) { client.Database.EnsureCreated(); } }
public ReportingController(PurchaseOrderContext context) { _context = context; }
private static async Task Seed(PurchaseOrderContext context) { if (await context.PurchaseOrders.AnyAsync()) { return; } var date = DateTime.UtcNow.Date; var finalDate = date.AddDays(30); context.Products.Add(new Product("Sapato", 10.0m)); context.Products.Add(new Product("Boné", 15.0m)); context.Products.Add(new Product("Chinelo", 18.0m)); context.Products.Add(new Product("Calça", 25.0m)); context.Products.Add(new Product("Tenis", 35.0m)); await context.SaveChangesAsync(); var productRandom = new Random(); var productAmountRandom = new Random(); for (var day = date.Date; day.Date <= finalDate.Date; day = day.AddDays(1)) { var order = new PurchaseOrder() { Date = day, Customer = new Customer($"Customer {day}") }; var productId = productRandom.Next(1, 5); var quant = productAmountRandom.Next(1, 4); order.ProductOrders.Add(new PurchaseOrderProduct() { Quantity = quant, Product = context.Products.First(w => w.Id == productId), UnitValue = context.Products.First(w => w.Id == productId).Value }); productId = productRandom.Next(1, 5); quant = productAmountRandom.Next(1, 4); order.ProductOrders.Add(new PurchaseOrderProduct() { Quantity = quant, Product = context.Products.First(w => w.Id == productId), UnitValue = context.Products.First(w => w.Id == productId).Value }); productId = productRandom.Next(1, 5); quant = productAmountRandom.Next(1, 4); order.ProductOrders.Add(new PurchaseOrderProduct() { Quantity = quant, Product = context.Products.First(w => w.Id == productId), UnitValue = context.Products.First(w => w.Id == productId).Value }); productId = productRandom.Next(1, 5); quant = productAmountRandom.Next(1, 4); order.ProductOrders.Add(new PurchaseOrderProduct() { Quantity = quant, Product = context.Products.First(w => w.Id == productId), UnitValue = context.Products.First(w => w.Id == productId).Value }); order.TotalValue = order.ProductOrders.Sum(s => s.UnitValue * s.Quantity); context.PurchaseOrders.Add(order); } await context.SaveChangesAsync(); }
public ProductsController(PurchaseOrderContext context) { _context = context; }
public MigrationHostedService(PurchaseOrderContext purchaseOrderContext) { _purchaseOrderContext = purchaseOrderContext; }
public PurchaseOrderRepository(DbContext context) : base(context) { _dbContext = (_dbContext ?? (PurchaseOrderContext)context); }
public PurchaseOrderShippingsController(PurchaseOrderContext context) { _context = context; }
public VendorsController(PurchaseOrderContext context) { _context = context; }
public UserService(IOptions <AppSettings> appSettings, PurchaseOrderContext context) { _appSettings = appSettings.Value; _context = context; }
public PurchaseOrderController(PurchaseOrderContext context, PurchaseOrderContextnew contextnew) { _context = context; _contextnew = contextnew; }
public SupplierController(PurchaseOrderContext context) { _context = context; }
public ClientsController(PurchaseOrderContext context) { _context = context; }