public void Seed()
        {
            if (_context.Departamento.Any() ||
                _context.Venda.Any() ||
                _context.Vendedor.Any())
            {
                return;
            }

            Departamento d1 = new Departamento(1, "Eletrônicos");
            Departamento d2 = new Departamento(2, "Eletrodomésticos");
            Departamento d3 = new Departamento(3, "Movéis");
            Departamento d4 = new Departamento(4, "Fitness");
            Departamento d5 = new Departamento(5, "Utensílios");
            Departamento d6 = new Departamento(6, "Cama/Mesa/Banho");

            Vendedor vd1  = new Vendedor(1, "João", "*****@*****.**", new DateTime(1988, 07, 22), 1000.00, d1);
            Vendedor vd2  = new Vendedor(2, "Camila", "*****@*****.**", new DateTime(1989, 12, 17), 1000.00, d2);
            Vendedor vd3  = new Vendedor(3, "Thais", "*****@*****.**", new DateTime(1990, 10, 23), 1000.00, d3);
            Vendedor vd4  = new Vendedor(4, "Viviane", "*****@*****.**", new DateTime(1996, 09, 19), 1000.00, d4);
            Vendedor vd5  = new Vendedor(5, "Gilberto", "*****@*****.**", new DateTime(1999, 02, 05), 1000.00, d5);
            Vendedor vd6  = new Vendedor(6, "Juliete", "*****@*****.**", new DateTime(2000, 06, 01), 1000.00, d6);
            Vendedor vd7  = new Vendedor(7, "Artur", "*****@*****.**", new DateTime(2000, 07, 21), 1000.00, d2);
            Vendedor vd8  = new Vendedor(8, "Rodolfo", "*****@*****.**", new DateTime(1986, 04, 25), 1000.00, d4);
            Vendedor vd9  = new Vendedor(9, "Caio", "*****@*****.**", new DateTime(1988, 04, 25), 1000.00, d3);
            Vendedor vd10 = new Vendedor(10, "Fiuk", "*****@*****.**", new DateTime(1991, 05, 20), 1000.00, d5);

            Venda v1  = new Venda(1, new DateTime(2021, 03, 17), 1100.50, StatusVenda.Faturado, vd2);
            Venda v2  = new Venda(2, new DateTime(2021, 02, 17), 1200.60, StatusVenda.Faturado, vd1);
            Venda v3  = new Venda(3, new DateTime(2021, 01, 23), 1320.50, StatusVenda.Faturado, vd2);
            Venda v4  = new Venda(4, new DateTime(2021, 02, 01), 100.10, StatusVenda.Faturado, vd6);
            Venda v5  = new Venda(5, new DateTime(2021, 02, 23), 354.50, StatusVenda.Faturado, vd5);
            Venda v6  = new Venda(6, new DateTime(2021, 01, 14), 414.90, StatusVenda.Faturado, vd9);
            Venda v7  = new Venda(7, new DateTime(2021, 02, 07), 2105.50, StatusVenda.Faturado, vd7);
            Venda v8  = new Venda(8, new DateTime(2021, 03, 09), 1100.50, StatusVenda.Faturado, vd8);
            Venda v9  = new Venda(9, new DateTime(2021, 02, 28), 1100.50, StatusVenda.Faturado, vd1);
            Venda v10 = new Venda(10, new DateTime(2021, 02, 03), 1401.70, StatusVenda.Faturado, vd9);
            Venda v11 = new Venda(11, new DateTime(2021, 04, 02), 1100.50, StatusVenda.Faturado, vd7);
            Venda v12 = new Venda(12, new DateTime(2021, 02, 22), 1100.50, StatusVenda.Faturado, vd2);
            Venda v13 = new Venda(13, new DateTime(2021, 03, 10), 1100.50, StatusVenda.Faturado, vd2);
            Venda v14 = new Venda(14, new DateTime(2021, 02, 14), 150.50, StatusVenda.Faturado, vd2);
            Venda v15 = new Venda(15, new DateTime(2021, 03, 07), 1100.50, StatusVenda.Faturado, vd10);
            Venda v16 = new Venda(16, new DateTime(2021, 02, 21), 135.50, StatusVenda.Faturado, vd2);
            Venda v17 = new Venda(17, new DateTime(2021, 02, 16), 1150.50, StatusVenda.Faturado, vd9);
            Venda v18 = new Venda(18, new DateTime(2021, 02, 15), 1500.50, StatusVenda.Faturado, vd2);
            Venda v19 = new Venda(19, new DateTime(2021, 01, 13), 1100.50, StatusVenda.Faturado, vd2);
            Venda v20 = new Venda(20, new DateTime(2021, 01, 08), 1100.50, StatusVenda.Faturado, vd9);
            Venda v21 = new Venda(21, new DateTime(2021, 02, 19), 1100.50, StatusVenda.Faturado, vd3);
            Venda v22 = new Venda(22, new DateTime(2021, 02, 15), 1100.50, StatusVenda.Faturado, vd2);
            Venda v23 = new Venda(23, new DateTime(2021, 04, 26), 1600.50, StatusVenda.Faturado, vd3);
            Venda v24 = new Venda(24, new DateTime(2021, 02, 24), 1700.50, StatusVenda.Faturado, vd4);
            Venda v25 = new Venda(25, new DateTime(2021, 03, 17), 1100.50, StatusVenda.Faturado, vd5);

            _context.Departamento.AddRange(d1, d2, d3, d4, d5, d6);
            _context.Vendedor.AddRange(vd1, vd2, vd3, vd4, vd5, vd6, vd7, vd8, vd9, vd10);
            _context.Venda.AddRange(v1, v2, v3, v4, v5, v6, v7, v8, v9, v10,
                                    v11, v12, v13, v14, v15, v16, v17, v18,
                                    v19, v20, v21, v22, v23, v24, v25);
            _context.SaveChanges();
        }
예제 #2
0
        public void Seed()
        {
            if (_context.Department.Any() ||
                _context.Seller.Any() ||
                _context.SalesRecord.Any())
            {
                return; //DB has been seeded
            }

            Department d1 = new Department("Computers");
            Department d2 = new Department("Electronics");
            Department d3 = new Department("Fashion");
            Department d4 = new Department("Books");

            Seller s1 = new Seller("Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
            Seller s2 = new Seller("Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
            Seller s3 = new Seller("Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
            Seller s4 = new Seller("Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
            Seller s5 = new Seller("Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
            Seller s6 = new Seller("Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);

            SalesRecord r1  = new SalesRecord(new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
            SalesRecord r2  = new SalesRecord(new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
            SalesRecord r3  = new SalesRecord(new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
            SalesRecord r4  = new SalesRecord(new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
            SalesRecord r5  = new SalesRecord(new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
            SalesRecord r6  = new SalesRecord(new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
            SalesRecord r7  = new SalesRecord(new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
            SalesRecord r8  = new SalesRecord(new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
            SalesRecord r9  = new SalesRecord(new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
            SalesRecord r10 = new SalesRecord(new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
            SalesRecord r11 = new SalesRecord(new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
            SalesRecord r12 = new SalesRecord(new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
            SalesRecord r13 = new SalesRecord(new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
            SalesRecord r14 = new SalesRecord(new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
            SalesRecord r15 = new SalesRecord(new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
            SalesRecord r16 = new SalesRecord(new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
            SalesRecord r17 = new SalesRecord(new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
            SalesRecord r18 = new SalesRecord(new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
            SalesRecord r19 = new SalesRecord(new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
            SalesRecord r20 = new SalesRecord(new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
            SalesRecord r21 = new SalesRecord(new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
            SalesRecord r22 = new SalesRecord(new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
            SalesRecord r23 = new SalesRecord(new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
            SalesRecord r24 = new SalesRecord(new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
            SalesRecord r25 = new SalesRecord(new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
            SalesRecord r26 = new SalesRecord(new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
            SalesRecord r27 = new SalesRecord(new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
            SalesRecord r28 = new SalesRecord(new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
            SalesRecord r29 = new SalesRecord(new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
            SalesRecord r30 = new SalesRecord(new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);

            _context.Department.AddRange(d1, d2, d3, d4);

            _context.Seller.AddRange(s1, s2, s3, s4, s5, s6);

            _context.SalesRecord.AddRange(
                r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
                r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
                r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
                );

            _context.SaveChanges();
        }