Esempio n. 1
0
        static void Main(string[] args)
        {
            //var product = new Product(1, "Notebook", 20_000);
            //var customer = new Customer(1, "Ivan");
            //var order = new Order(1, DateTimeOffset.UtcNow, 0.12m, customer);
            //order.OrderLines.Add(new OrderLine(order, 2, product));

            using var context = new OnlineStoreContext();

            context.Database.EnsureCreated();

            var product  = new Product("Notebook", 20_000);
            var customer = new Customer("Ivan");
            var order    = new Order(DateTimeOffset.UtcNow, 0.12m, customer);

            order.OrderLines.Add(new OrderLine(order, 2, product));
            context.Orders.Add(order);
            context.SaveChanges();

            var lastOrder = context.Orders.OrderBy(order => order.OrderDate).Last();

            Console.WriteLine($"The laster order id is {lastOrder.Id}");
            var firstOrder = context.Orders.First(order => order.Id == 1);

            Console.WriteLine($"The first order date is {firstOrder.OrderDate}");
            var customerOrders = context.Orders.Where(order => order.Customer.Id == 1).ToList();

            Console.WriteLine($"Count of orders of customer with id 1{customerOrders.Count}");
            var customers = context.Customers.ToList();

            Console.WriteLine($"The customers count: {customers.Count}");
        }
Esempio n. 2
0
        static void Main(string[] args)
        {
            var city               = new City("Москва");
            var positionSender     = new Position("Директор");
            var positionReceiver   = new Position("Зам.Ректора");
            var addressSender      = new Address(city, "Москва, ул. Б.Пироговская, д.21");
            var addressReceiver    = new Address(city, "Москва, ул. Косыгина, д.30");
            var document           = new Document("Книга", "Война и Мир т.1 ", 666);
            var contractorSender   = new Contractor("Иванов Иван Иванович", addressSender, positionSender);
            var contractorReceiver = new Contractor("Петров Петр Петрович", addressReceiver, positionReceiver);
            var documentStatus     = new DocumentStatus(contractorSender, contractorReceiver, document, "Доставлено", DateTimeOffset.UtcNow);

            using var context = new OnlineStoreContext();
            context.Database.Migrate();

            context.DocumentStatuss.Add(documentStatus);
            context.SaveChanges();
            Console.WriteLine("Completed");
        }