public void seed() { if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any()) { return; } Department d1 = new Department(1, "Computers"); Department d2 = new Department(2, "Eletronics"); Department d3 = new Department(3, "Tools"); Department d4 = new Department(4, "Ebooks"); Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 5), 1000.00, d1); Seller s2 = new Seller(2, "Cris Nogueira", "*****@*****.**", new DateTime(1960, 3, 29), 1100.00, d2); Seller s3 = new Seller(3, "Cicero Silva", "*****@*****.**", new DateTime(1989, 7, 12), 1200.00, d3); Seller s4 = new Seller(4, "Josi Santos", "*****@*****.**", new DateTime(2000, 9, 6), 1300.00, d1); Seller s5 = new Seller(5, "Danilo Barbosa", "*****@*****.**", new DateTime(1996, 11, 24), 1400.00, d2); Seller s6 = new Seller(6, "Dimas Diogenes", "*****@*****.**", new DateTime(1991, 1, 17), 1500.00, d3); SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1); SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5); SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4); SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1); SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3); SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1); SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2); SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4); SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6); SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6); SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2); SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3); SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4); SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5); SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1); SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4); SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1); SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3); SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5); SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6); SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2); SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4); SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2); SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5); SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3); SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4); SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1); SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3); SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5); SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2); _context.AddRange(d1, d2, d3, d4); _context.AddRange(s1, s2, s3, s4, s5, s6); _context.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(); }
public void Seed() { if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any()) { return; } Department d1 = new Department(1, "Computers"); Department d2 = new Department(2, "Eletronics"); Department d3 = new Department(3, "Fashion"); Department d4 = new Department(4, "Books"); Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000, d1); Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500, d2); Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200, d1); Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 13), 3000, d4); Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000, d3); Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000, d2); SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1); SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5); SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4); SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1); SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3); SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1); SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2); SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4); SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6); SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6); SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2); SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3); SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4); SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5); SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1); SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4); SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1); SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3); SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5); SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6); SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2); SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4); SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2); SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5); SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3); SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4); SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1); SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3); SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5); SalesRecord r30 = new SalesRecord(30, 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.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(); }
/*Operação responsável por popular a base de dados:*/ public void Seed() { /*Testando: se já existe algum dado na base de dados, a operação será interrompida:*/ //OBS: A operação any do linq testa se existe algum registro na tabela indicada: if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any()) { //Apenas dar um return para cortar a execução do método: return; } /*Instanciamos para depois mandar para a base de dados:*/ Department d1 = new Department(1, "Computers"); Department d2 = new Department(2, "Eletronics"); Department d3 = new Department(3, "Fashion"); Department d4 = new Department(4, "Books"); Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 12), 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, SaleStatus.Billed, s1); SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5); SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4); SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1); SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3); SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1); SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2); SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4); SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6); SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6); SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2); SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3); SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4); SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5); SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1); SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4); SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1); SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3); SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5); SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6); SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2); SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4); SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2); SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5); SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3); SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4); SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1); SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3); SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5); SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2); //Adicionando esses objetos no banco de dados: //obs: o AddRange permite adicionar vários objetos de uma só vez: _context.Department.AddRange(d1, d2, d3, d4); _context.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 ); /*SaveChanges salva as alterações e confirma no banco de dados*/ _context.SaveChanges(); }
public void Seed() { if (_dbContext.Department.Any() || _dbContext.Seller.Any() || _dbContext.SaleRecord.Any()) { return; } Department[] departments = { new Department(1, "Computer"), new Department(2, "Eletronics"), new Department(3, "Fashion"), new Department(4, "Books") }; Seller[] sellers = { new Seller(1, "Guilherme Rocha", "*****@*****.**", departments[0], new DateTime(2001, 10, 02), 1200.00), new Seller(2, "Mario Games", "*****@*****.**", departments[1], new DateTime(1978, 05, 15), 3000.00), new Seller(3, "Jorge Amado", "*****@*****.**", departments[3], new DateTime(2002, 08, 24), 2500.00), new Seller(4, "Paulo Maluco", "*****@*****.**", departments[2], new DateTime(1999, 03, 07), 4500.00), }; SaleRecord[] saleRecords = { new SaleRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.BILLED, sellers[0]), new SaleRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.BILLED, sellers[0]), new SaleRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.CANCELED, sellers[0]), new SaleRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.BILLED, sellers[0]), new SaleRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.BILLED, sellers[0]), new SaleRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.BILLED, sellers[1]), new SaleRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.BILLED, sellers[1]), new SaleRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.BILLED, sellers[1]), new SaleRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.PENDING, sellers[1]), new SaleRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.BILLED, sellers[1]), new SaleRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.BILLED, sellers[2]), new SaleRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.PENDING, sellers[2]), new SaleRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.BILLED, sellers[2]), new SaleRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.BILLED, sellers[2]), new SaleRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.BILLED, sellers[0]), new SaleRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.BILLED, sellers[0]), new SaleRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.BILLED, sellers[2]), new SaleRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.BILLED, sellers[1]), new SaleRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.BILLED, sellers[2]), new SaleRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.BILLED, sellers[3]), new SaleRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.BILLED, sellers[3]), new SaleRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.BILLED, sellers[3]), new SaleRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.CANCELED, sellers[2]), new SaleRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.BILLED, sellers[1]), new SaleRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.BILLED, sellers[1]), new SaleRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.BILLED, sellers[2]), new SaleRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.PENDING, sellers[3]), new SaleRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.BILLED, sellers[2]), new SaleRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.BILLED, sellers[0]), new SaleRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.BILLED, sellers[1]), }; _dbContext.AddRange(departments); _dbContext.AddRange(sellers); _dbContext.AddRange(saleRecords); _dbContext.SaveChanges(); }