public void Seed() { if (context.Departamento.Any() || context.Vendedor.Any() || context.RegistroVendas.Any()) { return; } Departamento d1 = new Departamento(1, "Computadores"); Departamento d2 = new Departamento(2, "Eletronicos"); Departamento d3 = new Departamento(3, "Financeiro"); Departamento d4 = new Departamento(4, "Livros"); Vendedor v1 = new Vendedor(1, "Josefino", "*****@*****.**", new DateTime(1996, 5, 3), 2600.0, d1); Vendedor v2 = new Vendedor(2, "Godofredo", "*****@*****.**", new DateTime(1986, 7, 2), 4500.0, d3); Vendedor v3 = new Vendedor(3, "Thomas Turbando", "*****@*****.**", new DateTime(2000, 6, 10), 1000.0, d2); Vendedor v4 = new Vendedor(4, "Kukah Beludo", "*****@*****.**", new DateTime(1998, 10, 15), 3000.0, d4); Vendedor v5 = new Vendedor(5, "Jaison Mendes", "*****@*****.**", new DateTime(1975, 6, 18), 5000.0, d3); Vendedor v6 = new Vendedor(6, "Jacinto Leite", "*****@*****.**", new DateTime(1990, 5, 9), 2800.0, d1); RegistroVendas r1 = new RegistroVendas(1, new DateTime(2005, 5, 9), 8000.0, StatusVenda.Pago, v1); RegistroVendas r2 = new RegistroVendas(2, new DateTime(2009, 10, 5), 25000.0, StatusVenda.Pendente, v2); RegistroVendas r3 = new RegistroVendas(3, new DateTime(2005, 8, 20), 3650.0, StatusVenda.Cancelado, v3); RegistroVendas r4 = new RegistroVendas(4, new DateTime(2005, 10, 10), 88000.0, StatusVenda.Pago, v4); RegistroVendas r5 = new RegistroVendas(5, new DateTime(2005, 12, 15), 97800.0, StatusVenda.Pendente, v5); RegistroVendas r6 = new RegistroVendas(6, new DateTime(2005, 5, 7), 76800, StatusVenda.Cancelado, v6); context.Departamento.AddRange(d1, d2, d3, d4); context.Vendedor.AddRange(v1, v2, v3, v4, v5, v6); context.RegistroVendas.AddRange(r1, r2, r3, r4, r5, r6); context.SaveChanges(); }
public void Seed() { if (_context.Department.Any() || _context.Vendedor.Any() || _context.Venda.Any()) { return; // O Banco de dados ja foi populado!!! } Department d1 = new Department(1, "Computadores"); Department d2 = new Department(2, "Eletronicos"); Department d3 = new Department(3, "Livros"); Department d4 = new Department(4, "Smartphones"); Vendedor v1 = new Vendedor(1, "Luis", "*****@*****.**", new DateTime(1998, 1, 10), 1000.0, d1); Vendedor v2 = new Vendedor(2, "Carlos", "*****@*****.**", new DateTime(1992, 8, 12), 1200.0, d2); Vendedor v3 = new Vendedor(3, "Carla", "*****@*****.**", new DateTime(1993, 4, 5), 2000.0, d3); Vendedor v4 = new Vendedor(4, "Ana", "*****@*****.**", new DateTime(1994, 6, 16), 2400.0, d4); Vendedor v5 = new Vendedor(5, "Leticia", "*****@*****.**", new DateTime(1988, 8, 8), 3000.0, d2); Vendedor v6 = new Vendedor(6, "Mauro", "*****@*****.**", new DateTime(1995, 7, 11), 3500.0, d1); Venda vnd1 = new Venda(1, new DateTime(2018, 09, 25), 11000.0, StatusVenda.Finalizado, v1); Venda vnd2 = new Venda(2, new DateTime(2018, 09, 4), 7000.0, StatusVenda.Finalizado, v5); Venda vnd3 = new Venda(3, new DateTime(2018, 09, 13), 4000.0, StatusVenda.Cancelado, v4); Venda vnd4 = new Venda(4, new DateTime(2018, 09, 1), 8000.0, StatusVenda.Finalizado, v1); Venda vnd5 = new Venda(5, new DateTime(2018, 09, 21), 3000.0, StatusVenda.Finalizado, v3); Venda vnd6 = new Venda(6, new DateTime(2018, 09, 15), 2000.0, StatusVenda.Finalizado, v1); Venda vnd7 = new Venda(7, new DateTime(2018, 09, 28), 13000.0, StatusVenda.Finalizado, v2); Venda vnd8 = new Venda(8, new DateTime(2018, 09, 11), 4000.0, StatusVenda.Finalizado, v4); Venda vnd9 = new Venda(9, new DateTime(2018, 09, 14), 11000.0, StatusVenda.Pendente, v6); Venda vnd10 = new Venda(10, new DateTime(2018, 09, 7), 9000.0, StatusVenda.Finalizado, v6); Venda vnd11 = new Venda(11, new DateTime(2018, 09, 13), 6000.0, StatusVenda.Finalizado, v2); Venda vnd12 = new Venda(12, new DateTime(2018, 09, 25), 7000.0, StatusVenda.Pendente, v3); Venda vnd13 = new Venda(13, new DateTime(2018, 09, 29), 10000.0, StatusVenda.Finalizado, v4); Venda vnd14 = new Venda(14, new DateTime(2018, 09, 4), 3000.0, StatusVenda.Finalizado, v5); Venda vnd15 = new Venda(15, new DateTime(2018, 09, 12), 4000.0, StatusVenda.Finalizado, v1); Venda vnd16 = new Venda(16, new DateTime(2018, 10, 5), 2000.0, StatusVenda.Finalizado, v4); Venda vnd17 = new Venda(17, new DateTime(2018, 10, 1), 12000.0, StatusVenda.Finalizado, v1); Venda vnd18 = new Venda(18, new DateTime(2018, 10, 24), 6000.0, StatusVenda.Finalizado, v3); Venda vnd19 = new Venda(19, new DateTime(2018, 10, 22), 8000.0, StatusVenda.Finalizado, v5); Venda vnd20 = new Venda(20, new DateTime(2018, 10, 15), 8000.0, StatusVenda.Finalizado, v6); Venda vnd21 = new Venda(21, new DateTime(2018, 10, 17), 9000.0, StatusVenda.Finalizado, v2); Venda vnd22 = new Venda(22, new DateTime(2018, 10, 24), 4000.0, StatusVenda.Finalizado, v4); Venda vnd23 = new Venda(23, new DateTime(2018, 10, 19), 11000.0, StatusVenda.Cancelado, v2); Venda vnd24 = new Venda(24, new DateTime(2018, 10, 12), 8000.0, StatusVenda.Finalizado, v5); Venda vnd25 = new Venda(25, new DateTime(2018, 10, 31), 7000.0, StatusVenda.Finalizado, v3); Venda vnd26 = new Venda(26, new DateTime(2018, 10, 6), 5000.0, StatusVenda.Finalizado, v4); Venda vnd27 = new Venda(27, new DateTime(2018, 10, 13), 9000.0, StatusVenda.Pendente, v1); Venda vnd28 = new Venda(28, new DateTime(2018, 10, 7), 4000.0, StatusVenda.Finalizado, v3); Venda vnd29 = new Venda(29, new DateTime(2018, 10, 23), 12000.0, StatusVenda.Finalizado, v5); Venda vnd30 = new Venda(30, new DateTime(2018, 10, 12), 5000.0, StatusVenda.Finalizado, v2); _context.Department.AddRange(d1, d2, d3, d4); _context.Vendedor.AddRange(v1, v2, v3, v4, v5, v6); _context.Venda.AddRange(vnd1, vnd2, vnd3, vnd4, vnd5, vnd6, vnd7, vnd8, vnd9, vnd10, vnd11, vnd12, vnd11, vnd14, vnd15, vnd16, vnd17, vnd18, vnd19, vnd20, vnd21, vnd22, vnd23, vnd24, vnd25, vnd26, vnd27, vnd28, vnd29, vnd30); _context.SaveChanges(); }
public void Seed() { if (_context.Departament.Any() || _context.Seller.Any() || _context.SalesRecord.Any()) { return; // DB ja foi populado } Departament d1 = new Departament(1, "Computers"); Departament d2 = new Departament(2, "Electronics"); Departament d3 = new Departament(3, "Fashion"); Departament d4 = new Departament(4, "Books"); Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1); Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2); Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1); Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4); Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3); Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2); SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SalesStatus.Billed, s1); SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SalesStatus.Billed, s5); SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SalesStatus.Canceled, s4); SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SalesStatus.Billed, s1); SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SalesStatus.Billed, s3); SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SalesStatus.Billed, s1); SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SalesStatus.Billed, s2); SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SalesStatus.Billed, s4); SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SalesStatus.Pending, s6); SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SalesStatus.Billed, s6); SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SalesStatus.Billed, s2); SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SalesStatus.Pending, s3); SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SalesStatus.Billed, s4); SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SalesStatus.Billed, s5); SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SalesStatus.Billed, s1); SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SalesStatus.Billed, s4); SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SalesStatus.Billed, s1); SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SalesStatus.Billed, s3); SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SalesStatus.Billed, s5); SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SalesStatus.Billed, s6); SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SalesStatus.Billed, s2); SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SalesStatus.Billed, s4); SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SalesStatus.Canceled, s2); SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SalesStatus.Billed, s5); SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SalesStatus.Billed, s3); SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SalesStatus.Billed, s4); SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SalesStatus.Pending, s1); SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SalesStatus.Billed, s3); SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SalesStatus.Billed, s5); SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SalesStatus.Billed, s2); _context.Departament.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(); }