public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
//DB has been seeded
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");
_context.Department.AddRange(d1, d2, d3, d4);
_context.SaveChanges();
Seller s1 = new Seller(1, "Jubileu da silva", "*****@*****.**", new DateTime(1990, 1, 10), 1500.0, d1);
Seller s2 = new Seller(2, "Catarina Brito", "*****@*****.**", new DateTime(1989, 6, 24), 1700.0, d3);
Seller s3 = new Seller(3, "Gumercindo Alves", "*****@*****.**", new DateTime(1985, 3, 17), 1450.0, d2);
Seller s4 = new Seller(4, "Maria Odete", "*****@*****.**", new DateTime(1982, 10, 03), 1800.0, d4);
Seller s5 = new Seller(5, "Amarildo Costa", "*****@*****.**", new DateTime(1984, 12, 21), 1600.0, d2);
Seller s6 = new Seller(6, "Jurema Aparecida", "*****@*****.**", new DateTime(1987, 2, 11), 1550.0, d1);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SaveChanges();
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 05, 13), 185.00, 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.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();
}
// quando meu SeedingService for criado automaticamente ele vai receber uma instancia do context tambem
public void Seed() // esse método/SERVIÇO é responsável por popular a base de dados!!!!
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; //É UMA VERIFICAÇÃO PRA VERIFICAR SE O BANCO DE DADOS JÁ FOI POPULADO, SE SIM NAO FAZER NADA
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
//criando os vendedores
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1); // departamento d1, tá havendo uma associação entre objetos
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 ao banco de dados usando o Entity Framework
_context.Department.AddRange(d1, d2, d3, d4); //AddRange permite adicionar varios de uma vez
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6); //adicionando os 6 vendedores
_context.SalesRecord.AddRange( // adicionando as 30 vendas
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
);
//salvar as alterações
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // db ja foi populado
}
Department d1 = new Department(0, "Computers");
Department d2 = new Department(0, "Eletronics");
Department d3 = new Department(0, "Fashion");
Department d4 = new Department(0, "Books");
Seller s1 = new Seller(0, "Bob Brown", "*****@*****.**", new DateTime(1980, 4, 21), 1000.0, d1);
Seller s2 = new Seller(0, "Maria", "*****@*****.**", new DateTime(1979, 4, 21), 3000.0, d2);
Seller s3 = new Seller(0, "Paulo", "*****@*****.**", new DateTime(1980, 4, 21), 1600.0, d1);
Seller s4 = new Seller(0, "Pedro", "*****@*****.**", new DateTime(1980, 4, 21), 1000.0, d4);
Seller s5 = new Seller(0, "Bia", "*****@*****.**", new DateTime(1980, 4, 21), 2000.0, d3);
Seller s6 = new Seller(0, "Laura", "*****@*****.**", new DateTime(1980, 4, 21), 8000.0, d2);
SalesRecord r1 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s4);
SalesRecord r3 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s2);
SalesRecord r4 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s5);
SalesRecord r7 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s6);
SalesRecord r8 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s6);
SalesRecord r9 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r10 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(0, new DateTime(2018, 08, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r12 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s2);
SalesRecord r13 = new SalesRecord(0, new DateTime(2018, 07, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r14 = new SalesRecord(0, new DateTime(2018, 06, 25), 11000.0, SaleStatus.Billed, s3);
SalesRecord r15 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s4);
SalesRecord r16 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r17 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r19 = new SalesRecord(0, new DateTime(2018, 10, 25), 11000.0, SaleStatus.Pending, s1);
SalesRecord r20 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r21 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r22 = new SalesRecord(0, new DateTime(2018, 11, 25), 11000.0, SaleStatus.Billed, s2);
SalesRecord r23 = new SalesRecord(0, new DateTime(2018, 09, 20), 11000.0, SaleStatus.Pending, s1);
SalesRecord r24 = new SalesRecord(0, new DateTime(2018, 09, 26), 11000.0, SaleStatus.Billed, s2);
SalesRecord r25 = new SalesRecord(0, new DateTime(2018, 09, 21), 11000.0, SaleStatus.Billed, s1);
SalesRecord r26 = new SalesRecord(0, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r27 = new SalesRecord(0, new DateTime(2018, 09, 24), 11000.0, SaleStatus.Billed, s3);
SalesRecord r28 = new SalesRecord(0, new DateTime(2018, 09, 26), 11000.0, SaleStatus.Billed, s1);
SalesRecord r29 = new SalesRecord(0, new DateTime(2018, 09, 22), 11000.0, SaleStatus.Billed, s4);
SalesRecord r30 = new SalesRecord(0, new DateTime(2018, 09, 23), 11000.0, SaleStatus.Billed, s1);
_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();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Vendedor.Any() ||
_context.Vendas.Any())
{
return; // DB has been seeded
}
Department d1 = new Department(1, "Moda");
Department d2 = new Department(2, "Cosméticos");
Department d3 = new Department(3, "Outros");
Vendedor v1 = new Vendedor(1, "João Silva", "*****@*****.**", new DateTime(1998, 04, 21), 1000.0, d3);
Vendedor v2 = new Vendedor(2, "Maria Castro", "*****@*****.**", new DateTime(1991, 12, 08), 1200.0, d1);
Vendedor v3 = new Vendedor(3, "Ana Ferreira", "*****@*****.**", new DateTime(1985, 05, 19), 1300.0, d2);
Vendedor v4 = new Vendedor(4, "Lucia Gomes", "*****@*****.**", new DateTime(1991, 02, 17), 1200.0, d2);
Vendedor v5 = new Vendedor(5, "Antonio Gonçalves", "*****@*****.**", new DateTime(1988, 06, 23), 1500.0, d3);
Vendedor v6 = new Vendedor(6, "Julia Rufino", "*****@*****.**", new DateTime(1996, 02, 08), 1350.0, d1);
Vendas r1 = new Vendas(1, new DateTime(2018, 09, 25), 11000.0, StatusVenda.Faturado, v1);
Vendas r2 = new Vendas(2, new DateTime(2018, 09, 4), 7000.0, StatusVenda.Faturado, v5);
Vendas r3 = new Vendas(3, new DateTime(2018, 09, 13), 4000.0, StatusVenda.Cancelado, v4);
Vendas r4 = new Vendas(4, new DateTime(2018, 09, 1), 8000.0, StatusVenda.Faturado, v1);
Vendas r5 = new Vendas(5, new DateTime(2018, 09, 21), 3000.0, StatusVenda.Faturado, v3);
Vendas r6 = new Vendas(6, new DateTime(2018, 09, 15), 2000.0, StatusVenda.Faturado, v1);
Vendas r7 = new Vendas(7, new DateTime(2018, 09, 28), 13000.0, StatusVenda.Faturado, v2);
Vendas r8 = new Vendas(8, new DateTime(2018, 09, 11), 4000.0, StatusVenda.Faturado, v4);
Vendas r9 = new Vendas(9, new DateTime(2018, 09, 14), 11000.0, StatusVenda.Pendente, v6);
Vendas r10 = new Vendas(10, new DateTime(2018, 09, 7), 9000.0, StatusVenda.Faturado, v6);
Vendas r11 = new Vendas(11, new DateTime(2018, 09, 13), 6000.0, StatusVenda.Faturado, v2);
Vendas r12 = new Vendas(12, new DateTime(2018, 09, 25), 7000.0, StatusVenda.Pendente, v3);
Vendas r13 = new Vendas(13, new DateTime(2018, 09, 29), 10000.0, StatusVenda.Faturado, v4);
Vendas r14 = new Vendas(14, new DateTime(2018, 09, 4), 3000.0, StatusVenda.Faturado, v5);
Vendas r15 = new Vendas(15, new DateTime(2018, 09, 12), 4000.0, StatusVenda.Faturado, v1);
Vendas r16 = new Vendas(16, new DateTime(2018, 10, 5), 2000.0, StatusVenda.Faturado, v4);
Vendas r17 = new Vendas(17, new DateTime(2018, 10, 1), 12000.0, StatusVenda.Faturado, v1);
Vendas r18 = new Vendas(18, new DateTime(2018, 10, 24), 6000.0, StatusVenda.Faturado, v3);
Vendas r19 = new Vendas(19, new DateTime(2018, 10, 22), 8000.0, StatusVenda.Faturado, v5);
Vendas r20 = new Vendas(20, new DateTime(2018, 10, 15), 8000.0, StatusVenda.Faturado, v6);
Vendas r21 = new Vendas(21, new DateTime(2018, 10, 17), 9000.0, StatusVenda.Faturado, v2);
Vendas r22 = new Vendas(22, new DateTime(2018, 10, 24), 4000.0, StatusVenda.Faturado, v4);
Vendas r23 = new Vendas(23, new DateTime(2018, 10, 19), 11000.0, StatusVenda.Cancelado, v2);
Vendas r24 = new Vendas(24, new DateTime(2018, 10, 12), 8000.0, StatusVenda.Faturado, v5);
Vendas r25 = new Vendas(25, new DateTime(2018, 10, 31), 7000.0, StatusVenda.Faturado, v3);
Vendas r26 = new Vendas(26, new DateTime(2018, 10, 6), 5000.0, StatusVenda.Faturado, v4);
Vendas r27 = new Vendas(27, new DateTime(2018, 10, 13), 9000.0, StatusVenda.Pendente, v1);
Vendas r28 = new Vendas(28, new DateTime(2018, 10, 7), 4000.0, StatusVenda.Faturado, v3);
Vendas r29 = new Vendas(29, new DateTime(2018, 10, 23), 12000.0, StatusVenda.Faturado, v5);
Vendas r30 = new Vendas(30, new DateTime(2018, 10, 12), 5000.0, StatusVenda.Faturado, v2);
_context.Department.AddRange(d1, d2, d3);
_context.Vendedor.AddRange(v1, v2, v3, v4, v5, v6);
_context.Vendas.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();
}
// Método responsavel por popular o banco de dados
public void Seed()
{
// Verifica se há dados no banco
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecords.Any())
{
return;
}
// Criando os departamentos
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
// Criando os vendedores
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);
// Criando os registros de venda
SalesRecords r1 = new SalesRecords(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecords r2 = new SalesRecords(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecords r3 = new SalesRecords(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecords r4 = new SalesRecords(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecords r5 = new SalesRecords(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecords r6 = new SalesRecords(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecords r7 = new SalesRecords(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecords r8 = new SalesRecords(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecords r9 = new SalesRecords(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecords r10 = new SalesRecords(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecords r11 = new SalesRecords(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecords r12 = new SalesRecords(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecords r13 = new SalesRecords(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecords r14 = new SalesRecords(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecords r15 = new SalesRecords(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecords r16 = new SalesRecords(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecords r17 = new SalesRecords(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecords r18 = new SalesRecords(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecords r19 = new SalesRecords(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecords r20 = new SalesRecords(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecords r21 = new SalesRecords(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecords r22 = new SalesRecords(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecords r23 = new SalesRecords(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecords r24 = new SalesRecords(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecords r25 = new SalesRecords(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecords r26 = new SalesRecords(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecords r27 = new SalesRecords(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecords r28 = new SalesRecords(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecords r29 = new SalesRecords(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecords r30 = new SalesRecords(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
// O método AddRange permite adicionar mais de um objeto
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecords.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);
// Salva e confirma as alterações
_context.SaveChanges();
}
public void Seed() //essa operação vai ser responsavel po popular nossa base de dados.
{
//**ONDE VOU CHAMAR O SEED? na classe Statup no método Configure
//SE já existe algum dado na minha base de banco de dados, então interrompa a operação.
//a operação Any vai testar se existe algum registro na tabela department, Seller ou SalesRecord
//então se existir vou dar um return para quebrar a execução do meu método.
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;
}
//Como estou usando o Code First, ou seja, eu crio os objetos e depois eu crio a base da dados
//então vou fazer a instanciação dos objetos e mandar salvar esses objetos no banco de dados
Department d1 = new Department(1, "Computers"); //esse é nosso 1o objeto do tipo Department
Department d2 = new Department(2, "Electronics");
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.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);
//Vamos adicionar os objetos no banco de dados:
_context.Department.AddRange(d1, d2, d3, d4); //primeiro o department. AddRange adiciona vários objetos de uma só vez.
_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
);
//Para efetivar essas alterações, devemos chamar:
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.Sellers.Any() || _context.SalesRecords.Any())
{
return;
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "José", "*****@*****.**", new DateTime(1998, 4, 20), 1000.0, d1);
Seller s2 = new Seller(1, "Eduardo", "*****@*****.**", new DateTime(2001, 1, 12), 3000.0, d2);
Seller s3 = new Seller(1, "João", "*****@*****.**", new DateTime(1997, 7, 27), 1700.0, d3);
Seller s4 = new Seller(1, "Lucas", "*****@*****.**", new DateTime(1990, 1, 10), 2000.0, d4);
Seller s5 = new Seller(1, "Carlos", "*****@*****.**", new DateTime(1980, 2, 5), 2500.0, d1);
Seller s6 = new Seller(1, "Mário", "*****@*****.**", new DateTime(1999, 6, 13), 4000.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);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Sellers.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecords.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.Departamento.Any() ||
_context.Vendedor.Any() ||
_context.RegistroDeVendas.Any())
{
return;
}
Departamento d1 = new Departamento(1, "Computers");
Departamento d2 = new Departamento(2, "Electronics");
Departamento d3 = new Departamento(3, "Fashion");
Departamento d4 = new Departamento(4, "Books");
Vendedor s1 = new Vendedor(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Vendedor s2 = new Vendedor(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Vendedor s3 = new Vendedor(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Vendedor s4 = new Vendedor(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Vendedor s5 = new Vendedor(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Vendedor s6 = new Vendedor(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
RegistroDeVendas r1 = new RegistroDeVendas(1, new DateTime(2018, 09, 25), 11000.0, StatusDaVenda.Faturado, s1);
RegistroDeVendas r2 = new RegistroDeVendas(2, new DateTime(2018, 09, 4), 7000.0, StatusDaVenda.Faturado, s5);
RegistroDeVendas r3 = new RegistroDeVendas(3, new DateTime(2018, 09, 13), 4000.0, StatusDaVenda.Cancelado, s4);
RegistroDeVendas r4 = new RegistroDeVendas(4, new DateTime(2018, 09, 1), 8000.0, StatusDaVenda.Faturado, s1);
RegistroDeVendas r5 = new RegistroDeVendas(5, new DateTime(2018, 09, 21), 3000.0, StatusDaVenda.Faturado, s3);
RegistroDeVendas r6 = new RegistroDeVendas(6, new DateTime(2018, 09, 15), 2000.0, StatusDaVenda.Faturado, s1);
RegistroDeVendas r7 = new RegistroDeVendas(7, new DateTime(2018, 09, 28), 13000.0, StatusDaVenda.Faturado, s2);
RegistroDeVendas r8 = new RegistroDeVendas(8, new DateTime(2018, 09, 11), 4000.0, StatusDaVenda.Faturado, s4);
RegistroDeVendas r9 = new RegistroDeVendas(9, new DateTime(2018, 09, 14), 11000.0, StatusDaVenda.Pendente, s6);
RegistroDeVendas r10 = new RegistroDeVendas(10, new DateTime(2018, 09, 7), 9000.0, StatusDaVenda.Faturado, s6);
RegistroDeVendas r11 = new RegistroDeVendas(11, new DateTime(2018, 09, 13), 6000.0, StatusDaVenda.Faturado, s2);
RegistroDeVendas r12 = new RegistroDeVendas(12, new DateTime(2018, 09, 25), 7000.0, StatusDaVenda.Pendente, s3);
RegistroDeVendas r13 = new RegistroDeVendas(13, new DateTime(2018, 09, 29), 10000.0, StatusDaVenda.Faturado, s4);
RegistroDeVendas r14 = new RegistroDeVendas(14, new DateTime(2018, 09, 4), 3000.0, StatusDaVenda.Faturado, s5);
RegistroDeVendas r15 = new RegistroDeVendas(15, new DateTime(2018, 09, 12), 4000.0, StatusDaVenda.Faturado, s1);
RegistroDeVendas r16 = new RegistroDeVendas(16, new DateTime(2018, 10, 5), 2000.0, StatusDaVenda.Faturado, s4);
RegistroDeVendas r17 = new RegistroDeVendas(17, new DateTime(2018, 10, 1), 12000.0, StatusDaVenda.Faturado, s1);
RegistroDeVendas r18 = new RegistroDeVendas(18, new DateTime(2018, 10, 24), 6000.0, StatusDaVenda.Faturado, s3);
RegistroDeVendas r19 = new RegistroDeVendas(19, new DateTime(2018, 10, 22), 8000.0, StatusDaVenda.Faturado, s5);
RegistroDeVendas r20 = new RegistroDeVendas(20, new DateTime(2018, 10, 15), 8000.0, StatusDaVenda.Faturado, s6);
RegistroDeVendas r21 = new RegistroDeVendas(21, new DateTime(2018, 10, 17), 9000.0, StatusDaVenda.Faturado, s2);
RegistroDeVendas r22 = new RegistroDeVendas(22, new DateTime(2018, 10, 24), 4000.0, StatusDaVenda.Faturado, s4);
RegistroDeVendas r23 = new RegistroDeVendas(23, new DateTime(2018, 10, 19), 11000.0, StatusDaVenda.Cancelado, s2);
RegistroDeVendas r24 = new RegistroDeVendas(24, new DateTime(2018, 10, 12), 8000.0, StatusDaVenda.Faturado, s5);
RegistroDeVendas r25 = new RegistroDeVendas(25, new DateTime(2018, 10, 31), 7000.0, StatusDaVenda.Faturado, s3);
RegistroDeVendas r26 = new RegistroDeVendas(26, new DateTime(2018, 10, 6), 5000.0, StatusDaVenda.Faturado, s4);
RegistroDeVendas r27 = new RegistroDeVendas(27, new DateTime(2018, 10, 13), 9000.0, StatusDaVenda.Pendente, s1);
RegistroDeVendas r28 = new RegistroDeVendas(28, new DateTime(2018, 10, 7), 4000.0, StatusDaVenda.Faturado, s3);
RegistroDeVendas r29 = new RegistroDeVendas(29, new DateTime(2018, 10, 23), 12000.0, StatusDaVenda.Faturado, s5);
RegistroDeVendas r30 = new RegistroDeVendas(30, new DateTime(2018, 10, 12), 5000.0, StatusDaVenda.Faturado, s2);
_context.Departamento.AddRange(d1, d2, d3, d4);
_context.Vendedor.AddRange(s1, s2, s3, s4, s5, s6);
_context.RegistroDeVendas.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; // DB has been seeded
}
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 Brow", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Gree", "*****@*****.**", new DateTime(1979, 12, 22), 2000.00, d2);
Seller s3 = new Seller(3, "Marcelo Boyka", "*****@*****.**", new DateTime(1974, 12, 22), 2000.00, d3);
Seller s4 = new Seller(4, "Chester Bennington", "*****@*****.**", new DateTime(2000, 12, 22), 2000.00, d4);
Seller s5 = new Seller(5, "Corey Tyler", "*****@*****.**", new DateTime(1999, 12, 22), 2000.00, d2);
Seller s6 = new Seller(6, "Emy Lee", "*****@*****.**", new DateTime(1939, 12, 22), 2000.00, d3);
Seller s7 = new Seller(7, "Alex smalovisk", "*****@*****.**", new DateTime(1929, 12, 22), 2000.00, d1);
Seller s8 = new Seller(8, "Pietrik Hamazin Vladumankastri", "*****@*****.**", new DateTime(1814, 12, 22), 2000.00, d4);
SalesRecord r1 = new SalesRecord(1, new DateTime(2016, 12, 8), 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.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6, s7, s8);
_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, r29, r30);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // DB has been seeded
}
Department computers = new Department(1, "Computers");
Department electronics = new Department(2, "Electronics");
Department fashion = new Department(3, "Fashion");
Department books = new Department(4, "Books");
Seller seller1 = new Seller(1, "Alan Turing", "*****@*****.**", new DateTime(1912, 06, 23), 6500.00, computers);
Seller seller2 = new Seller(2, "Obi-Wan Kenobi", "*****@*****.**", new DateTime(1980, 12, 25), 3500.00, electronics);
Seller seller3 = new Seller(5, "Tony Stark", "*****@*****.**", new DateTime(1990, 09, 5), 3000.00, computers);
Seller seller4 = new Seller(4, "Luke Skywalker", "*****@*****.**", new DateTime(1995, 01, 15), 2500.00, books);
Seller seller5 = new Seller(3, "Leia Organa", "*****@*****.**", new DateTime(1995, 01, 15), 2500.00, fashion);
Seller seller6 = new Seller(6, "Marie Curie", "*****@*****.**", new DateTime(1867, 11, 7), 5500.00, electronics);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, seller1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, seller5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, seller4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, seller1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, seller3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, seller1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, seller2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, seller4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, seller6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, seller6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, seller2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, seller3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, seller4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, seller5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, seller1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, seller4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, seller1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, seller3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, seller5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, seller6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, seller2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, seller4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, seller2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, seller5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, seller3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, seller4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, seller1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, seller3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, seller5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, seller2);
_context.Department.AddRange(computers, electronics, fashion, books);
_context.Seller.AddRange(seller1, seller2, seller3, seller4, seller5, seller6);
_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();
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // o banco de dados já foi populado
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
// instanciando o objeto sem usar o construtor
//Department d5 = new Department { Id = 5, Name = "Daniel", };
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, 20), 3500.0, d1);
Seller s3 = new Seller(3, "Alex grey", "*****@*****.**", new DateTime(1998, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 1000.0, d1);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(1993, 12, 11), 1523.0, d1);
Seller s6 = new Seller(6, "Jones black", "*****@*****.**", new DateTime(1997, 10, 08), 2450.0, d1);
Seller s7 = new Seller(7, "Daniel Orlandi", "*****@*****.**", new DateTime(1984, 5, 01), 5000.0, d1);
// SalesRecord sr1 = new SalesRecord(1, new DateTime(2018 / 9 / 25), 11000.0, Models.Enums.SaleStatus.Billed);// para remover o namespace da instancia... incluir o using... enums
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, s7);
_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();
}
public void Seed()
{
if (_context.Departament.Any() ||
_context.SalesRecord.Any() ||
_context.Seller.Any())
{
return; // DB has been seeded
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Eletronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
Departament d5 = new Departament {
Id = 5, Name = "Course"
};
Seller s1 = new Seller(1, "Willian", "*****@*****.**", new DateTime(1990, 5, 08), 5000.0, d2);
Seller s2 = new Seller(2, "Pedro", "*****@*****.**", new DateTime(1992, 9, 20), 5000.0, d1);
Seller s3 = new Seller(3, "Maria", "*****@*****.**", new DateTime(1993, 7, 18), 5000.0, d3);
Seller s4 = new Seller(4, "Joana", "*****@*****.**", new DateTime(1994, 6, 28), 5000.0, d4);
Seller s5 = new Seller(5, "Ana", "*****@*****.**", new DateTime(1995, 4, 01), 5000.0, d5);
SalesRecord r1 = new SalesRecord(1, new DateTime(2020, 12, 25), 10520.05, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2020, 12, 22), 10520.05, SaleStatus.Billed, s4);
SalesRecord r3 = new SalesRecord(3, new DateTime(2020, 12, 23), 10520.05, SaleStatus.Billed, s5);
SalesRecord r4 = new SalesRecord(4, new DateTime(2020, 12, 24), 10520.05, SaleStatus.Billed, s3);
SalesRecord r5 = new SalesRecord(5, new DateTime(2020, 12, 25), 10520.05, SaleStatus.Billed, s2);
SalesRecord r6 = new SalesRecord(6, new DateTime(2020, 12, 26), 10520.05, SaleStatus.Billed, s3);
SalesRecord r7 = new SalesRecord(7, new DateTime(2020, 12, 27), 10520.05, SaleStatus.Billed, s1);
SalesRecord r8 = new SalesRecord(8, new DateTime(2020, 12, 28), 10520.05, SaleStatus.Billed, s2);
SalesRecord r9 = new SalesRecord(9, new DateTime(2020, 12, 29), 10520.05, SaleStatus.Billed, s4);
SalesRecord r10 = new SalesRecord(10, new DateTime(2020, 12, 22), 10520.05, SaleStatus.Billed, s4);
SalesRecord r11 = new SalesRecord(11, new DateTime(2020, 12, 23), 10520.05, SaleStatus.Billed, s3);
SalesRecord r12 = new SalesRecord(12, new DateTime(2020, 12, 24), 10520.05, SaleStatus.Billed, s5);
SalesRecord r13 = new SalesRecord(13, new DateTime(2020, 12, 25), 10520.05, SaleStatus.Billed, s1);
SalesRecord r14 = new SalesRecord(14, new DateTime(2020, 12, 26), 10520.05, SaleStatus.Billed, s2);
SalesRecord r15 = new SalesRecord(15, new DateTime(2020, 12, 27), 10520.05, SaleStatus.Billed, s3);
SalesRecord r16 = new SalesRecord(16, new DateTime(2020, 12, 28), 10520.05, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2020, 12, 29), 10520.05, SaleStatus.Billed, s4);
SalesRecord r18 = new SalesRecord(18, new DateTime(2020, 12, 1), 10520.05, SaleStatus.Billed, s5);
SalesRecord r19 = new SalesRecord(19, new DateTime(2020, 12, 2), 10520.05, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2020, 12, 2), 10520.05, SaleStatus.Billed, s4);
SalesRecord r21 = new SalesRecord(21, new DateTime(2020, 12, 2), 10520.05, SaleStatus.Billed, s3);
SalesRecord r22 = new SalesRecord(22, new DateTime(2020, 12, 22), 10520.05, SaleStatus.Billed, s2);
SalesRecord r23 = new SalesRecord(23, new DateTime(2020, 12, 23), 10520.05, SaleStatus.Billed, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2020, 12, 24), 10520.05, SaleStatus.Billed, s1);
SalesRecord r25 = new SalesRecord(25, new DateTime(2020, 12, 25), 10520.05, SaleStatus.Billed, s1);
SalesRecord r26 = new SalesRecord(26, new DateTime(2020, 12, 26), 10520.05, SaleStatus.Billed, s1);
SalesRecord r27 = new SalesRecord(27, new DateTime(2020, 12, 27), 10520.05, SaleStatus.Billed, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2020, 12, 28), 10520.05, SaleStatus.Billed, s1);
SalesRecord r29 = new SalesRecord(29, new DateTime(2020, 12, 29), 10520.05, SaleStatus.Billed, s1);
SalesRecord r30 = new SalesRecord(30, new DateTime(2020, 12, 1), 10520.05, SaleStatus.Billed, s1);
_context.Departament.AddRange(d1, d2, d3, d4, d5);
_context.Seller.AddRange(s1, s2, s3, s4, s5);
_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();
}
public void Seed()
{
//Responsável por popular a base de dados
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; //DB já foi populado
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
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.0, d1);
Seller s2 = new Seller(2, "Karina", "*****@*****.**", new DateTime(1986, 05, 15), 1500.00, d3);
Seller s3 = new Seller(3, "Gisele", "*****@*****.**", new DateTime(1986, 05, 16), 1300.00, d3);
Seller s4 = new Seller(4, "Victor", "*****@*****.**", new DateTime(1989, 12, 14), 2000.00, d2);
Seller s5 = new Seller(5, "Guilherme", "*****@*****.**", new DateTime(1990, 06, 14), 1700.00, d4);
Seller s6 = new Seller(6, "Natalia", "*****@*****.**", new DateTime(1985, 07, 31), 1350.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);
//Addrange = Permite que você adicione varios objetos de uma vez no banco de dados
_context.Department.AddRange(d1, d2, d3, d4); //Permite que vocÊ adicione vários objetos de uma xzó vez
_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(); //Confirma e salva os registros no banco de dados
}
//Responsavel por popular os dados no banco de dados
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // DB been seeded -> banco de dados já foi populado
}
//Department d5 = new Department { Id = 5, Name = "Victor" };
//Departamentos
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
//Associação - Vendedores
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);
//Detalhes de vendas com associação com vendedores
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);
//Adicionar os objetos no banco de dados
//AddRange -> permite adicionar varios objetos de uma vez
_context.Department.AddRange(d1, d2, d3, d4);
//Adicionando vendedores
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
//Adicionando dados da venda
_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
);
//Salva e confirma as alterações no banco de dados
_context.SaveChanges();
//Depois adicionar um parametro no metodo Configure da classe Startup.cs(SeedingService seedingService)
}
public void Seed()
{
// Se existe dados na base
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SalesRecords.Any())
{
return;// o banco de dados ja foi populado
}
// Estanciamento dos objetos para base
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Electronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
// Associação entre os objetos
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);
// Registro de vendas
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);
// Adicionar objetos ao banco de dados com entity framework
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecords.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
);
// Salvar e confirmar as alterações no banco de dados
_context.SaveChanges();
}
public void Seed()/// popular a base de dados
{
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any()) /// any verifica se a tabela tem registro
{
return; /// o banco de dados ja foi populado
}
Departament d1 = new Departament(1, "Computers"); // se nao entra no if ele adiciona o registro no banco
Departament d2 = new Departament(2, "Eletronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament {
Id = 4, Name = "Books"
}; // outro jeito de adicionar no contrutor
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(1998, 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", "*****@*****.**", 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);
_context.Departament.AddRange(d1, d2, d3, d4);///addrang pode adicionar tudo de uma vez
_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();
}
public void Seed() //método que vai servir para popular a base
{
if (_context.Department.Any() ||
_context.Seller.Any() || //condição que vai testar e conferir se já tem algum registro na base
_context.SalesRecord.Any())
{
return; // DB já foi populado
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "pessoa1", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d1);
Seller s2 = new Seller(2, "pessoa2", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d2);
Seller s3 = new Seller(3, "pessoa3", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d1);
Seller s4 = new Seller(4, "pessoa4", "*****@*****.**", new DateTime(1998, 5, 21), 1000.0, d4);
Seller s5 = new Seller(5, "pessoa5", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d3);
Seller s6 = new Seller(6, "pessoa6", "*****@*****.**", new DateTime(1998, 4, 21), 1000.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);
_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(); //salva e confirma as alterações na base de dados
}
public void Seed()
{
//verificando se as tabelas já existem dados
if (_context.Department.Any() ||
_context.Sellers.Any() ||
_context.SalesRecords.Any())
{
return; // O banco de dados já foi populado
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
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.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);
//Adicinar no banco de dados, permite instalar varios objetos de uma vez
//Adicionando departamentos
_context.Department.AddRange(d1, d2, d3, d4);
//Adicionando vendedores
_context.Sellers.AddRange(s1, s2, s3, s4, s5, s6);
//Adicinando vendas
_context.SalesRecords.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
);
//efetuar as alterações
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return;
}
Department d1 = new Department {
Name = "Computers"
};
Department d2 = new Department {
Name = "Electronics"
};
Department d3 = new Department {
Name = "Fashion"
};
Department d4 = new Department {
Name = "Books"
};
Seller s1 = new Seller {
Name = "Bob Brown", Email = "*****@*****.**", BirthDate = new DateTime(1998, 4, 21), BaseSalary = 1000.0, Department = d1
};
Seller s2 = new Seller {
Name = "Maria Green", Email = "*****@*****.**", BirthDate = new DateTime(1979, 12, 31), BaseSalary = 3500.0, Department = d2
};
Seller s3 = new Seller {
Name = "Alex Grey", Email = "*****@*****.**", BirthDate = new DateTime(1988, 1, 15), BaseSalary = 2200.0, Department = d1
};
Seller s4 = new Seller {
Name = "Martha Red", Email = "*****@*****.**", BirthDate = new DateTime(1993, 11, 30), BaseSalary = 3000.0, Department = d4
};
Seller s5 = new Seller {
Name = "Donald Blue", Email = "*****@*****.**", BirthDate = new DateTime(2000, 1, 9), BaseSalary = 4000.0, Department = d3
};
Seller s6 = new Seller {
Name = "Alex Pink", Email = "*****@*****.**", BirthDate = new DateTime(1997, 3, 4), BaseSalary = 3000.0, Department = d2
};
SalesRecord r1 = new SalesRecord {
Date = new DateTime(2018, 09, 25), Amount = 11000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r2 = new SalesRecord {
Date = new DateTime(2018, 09, 4), Amount = 7000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r3 = new SalesRecord {
Date = new DateTime(2018, 09, 13), Amount = 4000.0, Status = SaleStatus.Canceled, Seller = s4
};
SalesRecord r4 = new SalesRecord {
Date = new DateTime(2018, 09, 1), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r5 = new SalesRecord {
Date = new DateTime(2018, 09, 21), Amount = 3000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r6 = new SalesRecord {
Date = new DateTime(2018, 09, 15), Amount = 2000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r7 = new SalesRecord {
Date = new DateTime(2018, 09, 28), Amount = 13000.0, Status = SaleStatus.Billed, Seller = s2
};
SalesRecord r8 = new SalesRecord {
Date = new DateTime(2018, 09, 11), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r9 = new SalesRecord {
Date = new DateTime(2018, 09, 14), Amount = 11000.0, Status = SaleStatus.Pending, Seller = s6
};
SalesRecord r10 = new SalesRecord {
Date = new DateTime(2018, 09, 7), Amount = 9000.0, Status = SaleStatus.Billed, Seller = s6
};
SalesRecord r11 = new SalesRecord {
Date = new DateTime(2018, 09, 13), Amount = 6000.0, Status = SaleStatus.Billed, Seller = s2
};
SalesRecord r12 = new SalesRecord {
Date = new DateTime(2018, 09, 25), Amount = 7000.0, Status = SaleStatus.Pending, Seller = s3
};
SalesRecord r13 = new SalesRecord {
Date = new DateTime(2018, 09, 29), Amount = 10000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r14 = new SalesRecord {
Date = new DateTime(2018, 09, 4), Amount = 3000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r15 = new SalesRecord {
Date = new DateTime(2018, 09, 12), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r16 = new SalesRecord {
Date = new DateTime(2018, 10, 5), Amount = 2000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r17 = new SalesRecord {
Date = new DateTime(2018, 10, 1), Amount = 12000.0, Status = SaleStatus.Billed, Seller = s1
};
SalesRecord r18 = new SalesRecord {
Date = new DateTime(2018, 10, 24), Amount = 6000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r19 = new SalesRecord {
Date = new DateTime(2018, 10, 22), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r20 = new SalesRecord {
Date = new DateTime(2018, 10, 15), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s6
};
SalesRecord r21 = new SalesRecord {
Date = new DateTime(2018, 10, 17), Amount = 9000.0, Status = SaleStatus.Billed, Seller = s2
};
SalesRecord r22 = new SalesRecord {
Date = new DateTime(2018, 10, 24), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r23 = new SalesRecord {
Date = new DateTime(2018, 10, 19), Amount = 11000.0, Status = SaleStatus.Canceled, Seller = s2
};
SalesRecord r24 = new SalesRecord {
Date = new DateTime(2018, 10, 12), Amount = 8000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r25 = new SalesRecord {
Date = new DateTime(2018, 10, 31), Amount = 7000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r26 = new SalesRecord {
Date = new DateTime(2018, 10, 6), Amount = 5000.0, Status = SaleStatus.Billed, Seller = s4
};
SalesRecord r27 = new SalesRecord {
Date = new DateTime(2018, 10, 13), Amount = 9000.0, Status = SaleStatus.Pending, Seller = s1
};
SalesRecord r28 = new SalesRecord {
Date = new DateTime(2018, 10, 7), Amount = 4000.0, Status = SaleStatus.Billed, Seller = s3
};
SalesRecord r29 = new SalesRecord {
Date = new DateTime(2018, 10, 23), Amount = 12000.0, Status = SaleStatus.Billed, Seller = s5
};
SalesRecord r30 = new SalesRecord {
Date = new DateTime(2018, 10, 12), Amount = 5000.0, Status = SaleStatus.Billed, Seller = 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();
}
public void Seed()
{
if (!_context.Set <Department>().Any())
{
var departments = new List <Department>()
{
new Department()
{
Name = "Eletronics"
},
new Department()
{
Name = "Computer"
},
new Department()
{
Name = "Books"
}
};
_context.Set <Department>().AddRange(departments);
_context.SaveChanges();
}
if (!_context.Set <Seller>().Any())
{
var sellers = new List <Seller>()
{
new Seller()
{
Name = "Richard Marchel", Email = "*****@*****.**", BaseSalary = 3000, BirthDate = DateTime.Parse("1985-01-10"), DepartmentId = 2
},
new Seller()
{
Name = "Marco Aurelio", Email = "*****@*****.**", BaseSalary = 2500, BirthDate = DateTime.Parse("1989-07-11"), DepartmentId = 1
},
new Seller()
{
Name = "Ricardo Alves", Email = "*****@*****.**", BaseSalary = 1000, BirthDate = DateTime.Parse("1992-01-20"), DepartmentId = 3
},
};
_context.Set <Seller>().AddRange(sellers);
_context.SaveChanges();
}
if (!_context.Set <SalesRecord>().Any())
{
var salesRecords = new List <SalesRecord>()
{
new SalesRecord()
{
Amount = 7000, Date = DateTime.Parse("2020-11-18"), Status = SaleStatus.BILLED, SellerId = 1
},
new SalesRecord()
{
Amount = 3000, Date = DateTime.Parse("2020-10-20"), Status = SaleStatus.PENDING, SellerId = 2
},
new SalesRecord()
{
Amount = 2500, Date = DateTime.Parse("2020-09-30"), Status = SaleStatus.CANCELED, SellerId = 3
}
};
_context.Set <SalesRecord>().AddRange(salesRecords);
_context.SaveChanges();
}
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; //Banco de dados populado
}
Department d1 = new Department(1, "Informática");
Department d2 = new Department(2, "Electronicos");
Department d3 = new Department(3, "Ferramentas");
Department d4 = new Department(4, "Livros");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 2000.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(2021, 01, 25), 10200.0, SaleStatus.Faturado, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2021, 01, 4), 7000.0, SaleStatus.Faturado, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2021, 01, 13), 4000.0, SaleStatus.Cancelado, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2021, 01, 1), 8000.0, SaleStatus.Faturado, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2021, 01, 21), 3000.0, SaleStatus.Faturado, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2021, 01, 15), 2000.0, SaleStatus.Faturado, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2021, 01, 28), 13000.0, SaleStatus.Faturado, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2021, 01, 11), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2021, 01, 14), 10200.0, SaleStatus.Pendente, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2021, 01, 7), 9000.0, SaleStatus.Faturado, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2021, 01, 13), 6000.0, SaleStatus.Faturado, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2021, 01, 25), 7000.0, SaleStatus.Pendente, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2021, 01, 29), 02000.0, SaleStatus.Faturado, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2021, 01, 4), 3000.0, SaleStatus.Faturado, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2021, 01, 12), 4000.0, SaleStatus.Faturado, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2021, 02, 5), 2000.0, SaleStatus.Faturado, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2021, 02, 1), 12000.0, SaleStatus.Faturado, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2021, 02, 24), 6000.0, SaleStatus.Faturado, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2021, 02, 22), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2021, 02, 15), 8000.0, SaleStatus.Faturado, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2021, 02, 17), 9000.0, SaleStatus.Faturado, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2021, 02, 24), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2021, 02, 19), 10200.0, SaleStatus.Cancelado, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2021, 02, 12), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2021, 02, 27), 7000.0, SaleStatus.Faturado, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2021, 02, 6), 5000.0, SaleStatus.Faturado, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2021, 02, 13), 9000.0, SaleStatus.Pendente, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2021, 02, 7), 4000.0, SaleStatus.Faturado, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2021, 02, 23), 12000.0, SaleStatus.Faturado, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2021, 02, 12), 5000.0, SaleStatus.Faturado, s2);
SalesRecord r31 = new SalesRecord(31, new DateTime(2021, 03, 25), 10200.0, SaleStatus.Faturado, s1);
SalesRecord r32 = new SalesRecord(32, new DateTime(2021, 03, 4), 7000.0, SaleStatus.Faturado, s5);
SalesRecord r33 = new SalesRecord(33, new DateTime(2021, 03, 13), 4000.0, SaleStatus.Cancelado, s4);
SalesRecord r34 = new SalesRecord(34, new DateTime(2021, 03, 1), 8000.0, SaleStatus.Faturado, s1);
SalesRecord r35 = new SalesRecord(35, new DateTime(2021, 03, 21), 3000.0, SaleStatus.Faturado, s3);
SalesRecord r36 = new SalesRecord(36, new DateTime(2021, 03, 15), 2000.0, SaleStatus.Faturado, s1);
SalesRecord r37 = new SalesRecord(37, new DateTime(2021, 03, 28), 13000.0, SaleStatus.Faturado, s2);
SalesRecord r38 = new SalesRecord(38, new DateTime(2021, 03, 11), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r39 = new SalesRecord(39, new DateTime(2021, 03, 14), 10200.0, SaleStatus.Pendente, s6);
SalesRecord r40 = new SalesRecord(40, new DateTime(2021, 03, 7), 9000.0, SaleStatus.Faturado, s6);
SalesRecord r41 = new SalesRecord(41, new DateTime(2021, 03, 13), 6000.0, SaleStatus.Faturado, s2);
SalesRecord r42 = new SalesRecord(42, new DateTime(2021, 03, 25), 7000.0, SaleStatus.Pendente, s3);
SalesRecord r43 = new SalesRecord(43, new DateTime(2021, 04, 29), 02000.0, SaleStatus.Faturado, s4);
SalesRecord r44 = new SalesRecord(44, new DateTime(2021, 04, 4), 3000.0, SaleStatus.Faturado, s5);
SalesRecord r45 = new SalesRecord(45, new DateTime(2021, 04, 12), 4000.0, SaleStatus.Faturado, s1);
SalesRecord r46 = new SalesRecord(46, new DateTime(2021, 04, 5), 2000.0, SaleStatus.Faturado, s4);
SalesRecord r47 = new SalesRecord(47, new DateTime(2021, 04, 1), 12000.0, SaleStatus.Faturado, s1);
SalesRecord r48 = new SalesRecord(48, new DateTime(2021, 04, 24), 6000.0, SaleStatus.Faturado, s3);
SalesRecord r49 = new SalesRecord(49, new DateTime(2021, 04, 22), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r50 = new SalesRecord(50, new DateTime(2021, 04, 15), 8000.0, SaleStatus.Faturado, s6);
SalesRecord r51 = new SalesRecord(51, new DateTime(2021, 04, 17), 9000.0, SaleStatus.Faturado, s2);
SalesRecord r52 = new SalesRecord(52, new DateTime(2021, 04, 24), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r53 = new SalesRecord(53, new DateTime(2021, 04, 19), 10200.0, SaleStatus.Cancelado, s2);
SalesRecord r54 = new SalesRecord(54, new DateTime(2021, 04, 12), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r55 = new SalesRecord(55, new DateTime(2021, 04, 27), 7000.0, SaleStatus.Faturado, s3);
SalesRecord r56 = new SalesRecord(56, new DateTime(2021, 04, 6), 5000.0, SaleStatus.Faturado, s4);
SalesRecord r57 = new SalesRecord(57, new DateTime(2021, 04, 13), 9000.0, SaleStatus.Pendente, s1);
SalesRecord r58 = new SalesRecord(58, new DateTime(2021, 04, 7), 4000.0, SaleStatus.Faturado, s3);
SalesRecord r59 = new SalesRecord(59, new DateTime(2021, 04, 23), 12000.0, SaleStatus.Faturado, s5);
SalesRecord r60 = new SalesRecord(60, new DateTime(2021, 04, 12), 5000.0, SaleStatus.Faturado, s2);
SalesRecord r61 = new SalesRecord(61, new DateTime(2021, 05, 25), 10200.0, SaleStatus.Faturado, s1);
SalesRecord r62 = new SalesRecord(62, new DateTime(2021, 05, 4), 7000.0, SaleStatus.Faturado, s5);
SalesRecord r63 = new SalesRecord(63, new DateTime(2021, 05, 13), 4000.0, SaleStatus.Cancelado, s4);
SalesRecord r64 = new SalesRecord(64, new DateTime(2021, 05, 1), 8000.0, SaleStatus.Faturado, s1);
SalesRecord r65 = new SalesRecord(65, new DateTime(2021, 05, 21), 3000.0, SaleStatus.Faturado, s3);
SalesRecord r66 = new SalesRecord(66, new DateTime(2021, 05, 15), 2000.0, SaleStatus.Faturado, s1);
SalesRecord r67 = new SalesRecord(67, new DateTime(2021, 05, 28), 13000.0, SaleStatus.Faturado, s2);
SalesRecord r68 = new SalesRecord(68, new DateTime(2021, 05, 11), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r69 = new SalesRecord(69, new DateTime(2021, 05, 14), 10200.0, SaleStatus.Pendente, s6);
SalesRecord r70 = new SalesRecord(70, new DateTime(2021, 05, 7), 9000.0, SaleStatus.Faturado, s6);
SalesRecord r71 = new SalesRecord(71, new DateTime(2021, 05, 13), 6000.0, SaleStatus.Faturado, s2);
SalesRecord r72 = new SalesRecord(72, new DateTime(2021, 05, 25), 7000.0, SaleStatus.Pendente, s3);
SalesRecord r73 = new SalesRecord(73, new DateTime(2021, 05, 29), 02000.0, SaleStatus.Faturado, s4);
SalesRecord r74 = new SalesRecord(74, new DateTime(2021, 05, 4), 3000.0, SaleStatus.Faturado, s5);
SalesRecord r75 = new SalesRecord(75, new DateTime(2021, 05, 12), 4000.0, SaleStatus.Faturado, s1);
SalesRecord r76 = new SalesRecord(76, new DateTime(2021, 05, 5), 2000.0, SaleStatus.Faturado, s4);
SalesRecord r77 = new SalesRecord(77, new DateTime(2021, 05, 1), 12000.0, SaleStatus.Faturado, s1);
SalesRecord r78 = new SalesRecord(78, new DateTime(2021, 05, 24), 6000.0, SaleStatus.Faturado, s3);
SalesRecord r79 = new SalesRecord(79, new DateTime(2021, 05, 22), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r80 = new SalesRecord(80, new DateTime(2021, 05, 15), 8000.0, SaleStatus.Faturado, s6);
SalesRecord r81 = new SalesRecord(81, new DateTime(2021, 05, 17), 9000.0, SaleStatus.Faturado, s2);
SalesRecord r82 = new SalesRecord(82, new DateTime(2021, 05, 24), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r83 = new SalesRecord(83, new DateTime(2021, 05, 19), 10200.0, SaleStatus.Cancelado, s2);
SalesRecord r84 = new SalesRecord(84, new DateTime(2021, 05, 12), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r85 = new SalesRecord(85, new DateTime(2021, 06, 27), 7000.0, SaleStatus.Faturado, s3);
SalesRecord r86 = new SalesRecord(86, new DateTime(2021, 06, 6), 5000.0, SaleStatus.Faturado, s4);
SalesRecord r87 = new SalesRecord(87, new DateTime(2021, 06, 13), 9000.0, SaleStatus.Pendente, s1);
SalesRecord r88 = new SalesRecord(88, new DateTime(2021, 06, 7), 4000.0, SaleStatus.Faturado, s3);
SalesRecord r89 = new SalesRecord(89, new DateTime(2021, 06, 23), 12000.0, SaleStatus.Faturado, s5);
SalesRecord r90 = new SalesRecord(90, new DateTime(2021, 06, 12), 5000.0, SaleStatus.Faturado, s2);
SalesRecord r91 = new SalesRecord(91, new DateTime(2021, 06, 25), 10200.0, SaleStatus.Faturado, s1);
SalesRecord r92 = new SalesRecord(92, new DateTime(2021, 06, 4), 7000.0, SaleStatus.Faturado, s5);
SalesRecord r93 = new SalesRecord(93, new DateTime(2021, 06, 13), 4000.0, SaleStatus.Cancelado, s4);
SalesRecord r94 = new SalesRecord(94, new DateTime(2021, 06, 1), 8000.0, SaleStatus.Faturado, s1);
SalesRecord r95 = new SalesRecord(95, new DateTime(2021, 06, 21), 3000.0, SaleStatus.Faturado, s3);
SalesRecord r96 = new SalesRecord(96, new DateTime(2021, 06, 15), 2000.0, SaleStatus.Faturado, s1);
SalesRecord r97 = new SalesRecord(97, new DateTime(2021, 06, 28), 13000.0, SaleStatus.Faturado, s2);
SalesRecord r98 = new SalesRecord(98, new DateTime(2021, 06, 11), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r99 = new SalesRecord(99, new DateTime(2021, 06, 14), 10200.0, SaleStatus.Pendente, s6);
SalesRecord r100 = new SalesRecord(100, new DateTime(2021, 07, 7), 9000.0, SaleStatus.Faturado, s6);
SalesRecord r101 = new SalesRecord(101, new DateTime(2021, 07, 13), 6000.0, SaleStatus.Faturado, s2);
SalesRecord r102 = new SalesRecord(102, new DateTime(2021, 07, 25), 7000.0, SaleStatus.Pendente, s3);
SalesRecord r103 = new SalesRecord(103, new DateTime(2021, 07, 29), 02000.0, SaleStatus.Faturado, s4);
SalesRecord r104 = new SalesRecord(104, new DateTime(2021, 07, 4), 3000.0, SaleStatus.Faturado, s5);
SalesRecord r105 = new SalesRecord(105, new DateTime(2021, 07, 12), 4000.0, SaleStatus.Faturado, s1);
SalesRecord r106 = new SalesRecord(106, new DateTime(2021, 07, 5), 2000.0, SaleStatus.Faturado, s4);
SalesRecord r107 = new SalesRecord(107, new DateTime(2021, 07, 1), 12000.0, SaleStatus.Faturado, s1);
SalesRecord r108 = new SalesRecord(108, new DateTime(2021, 07, 24), 6000.0, SaleStatus.Faturado, s3);
SalesRecord r109 = new SalesRecord(109, new DateTime(2021, 07, 22), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r110 = new SalesRecord(110, new DateTime(2021, 07, 15), 8000.0, SaleStatus.Faturado, s6);
SalesRecord r111 = new SalesRecord(111, new DateTime(2021, 07, 17), 9000.0, SaleStatus.Faturado, s2);
SalesRecord r112 = new SalesRecord(112, new DateTime(2021, 07, 24), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r113 = new SalesRecord(113, new DateTime(2021, 07, 19), 10200.0, SaleStatus.Cancelado, s2);
SalesRecord r114 = new SalesRecord(114, new DateTime(2021, 07, 12), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r115 = new SalesRecord(115, new DateTime(2021, 08, 27), 7000.0, SaleStatus.Faturado, s3);
SalesRecord r116 = new SalesRecord(116, new DateTime(2021, 08, 6), 5000.0, SaleStatus.Faturado, s4);
SalesRecord r117 = new SalesRecord(117, new DateTime(2021, 08, 13), 9000.0, SaleStatus.Pendente, s1);
SalesRecord r118 = new SalesRecord(118, new DateTime(2021, 08, 7), 4000.0, SaleStatus.Faturado, s3);
SalesRecord r119 = new SalesRecord(119, new DateTime(2021, 08, 23), 12000.0, SaleStatus.Faturado, s5);
SalesRecord r120 = new SalesRecord(120, new DateTime(2021, 08, 12), 5000.0, SaleStatus.Faturado, s2);
SalesRecord r121 = new SalesRecord(121, new DateTime(2021, 08, 25), 10200.0, SaleStatus.Faturado, s1);
SalesRecord r122 = new SalesRecord(122, new DateTime(2021, 08, 4), 7000.0, SaleStatus.Faturado, s5);
SalesRecord r123 = new SalesRecord(123, new DateTime(2021, 08, 13), 4000.0, SaleStatus.Cancelado, s4);
SalesRecord r124 = new SalesRecord(124, new DateTime(2021, 08, 1), 8000.0, SaleStatus.Faturado, s1);
SalesRecord r125 = new SalesRecord(125, new DateTime(2021, 08, 21), 3000.0, SaleStatus.Faturado, s3);
SalesRecord r126 = new SalesRecord(126, new DateTime(2021, 08, 15), 2000.0, SaleStatus.Faturado, s1);
SalesRecord r127 = new SalesRecord(127, new DateTime(2021, 08, 28), 13000.0, SaleStatus.Faturado, s2);
SalesRecord r128 = new SalesRecord(128, new DateTime(2021, 08, 11), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r129 = new SalesRecord(129, new DateTime(2021, 08, 14), 10200.0, SaleStatus.Pendente, s6);
SalesRecord r130 = new SalesRecord(130, new DateTime(2021, 08, 7), 9000.0, SaleStatus.Faturado, s6);
SalesRecord r131 = new SalesRecord(131, new DateTime(2021, 08, 13), 6000.0, SaleStatus.Faturado, s2);
SalesRecord r132 = new SalesRecord(132, new DateTime(2021, 09, 25), 7000.0, SaleStatus.Pendente, s3);
SalesRecord r133 = new SalesRecord(133, new DateTime(2021, 09, 29), 02000.0, SaleStatus.Faturado, s4);
SalesRecord r134 = new SalesRecord(134, new DateTime(2021, 09, 4), 3000.0, SaleStatus.Faturado, s5);
SalesRecord r135 = new SalesRecord(135, new DateTime(2021, 09, 12), 4000.0, SaleStatus.Faturado, s1);
SalesRecord r136 = new SalesRecord(136, new DateTime(2021, 09, 5), 2000.0, SaleStatus.Faturado, s4);
SalesRecord r137 = new SalesRecord(137, new DateTime(2021, 09, 1), 12000.0, SaleStatus.Faturado, s1);
SalesRecord r138 = new SalesRecord(138, new DateTime(2021, 09, 24), 6000.0, SaleStatus.Faturado, s3);
SalesRecord r139 = new SalesRecord(139, new DateTime(2021, 09, 22), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r140 = new SalesRecord(140, new DateTime(2021, 09, 15), 8000.0, SaleStatus.Faturado, s6);
SalesRecord r141 = new SalesRecord(141, new DateTime(2021, 09, 17), 9000.0, SaleStatus.Faturado, s2);
SalesRecord r142 = new SalesRecord(142, new DateTime(2021, 09, 24), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r143 = new SalesRecord(143, new DateTime(2021, 09, 19), 10200.0, SaleStatus.Cancelado, s2);
SalesRecord r144 = new SalesRecord(144, new DateTime(2021, 09, 12), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r145 = new SalesRecord(145, new DateTime(2021, 09, 27), 7000.0, SaleStatus.Faturado, s3);
SalesRecord r146 = new SalesRecord(146, new DateTime(2021, 09, 6), 5000.0, SaleStatus.Faturado, s4);
SalesRecord r147 = new SalesRecord(147, new DateTime(2021, 09, 13), 9000.0, SaleStatus.Pendente, s1);
SalesRecord r148 = new SalesRecord(148, new DateTime(2021, 09, 7), 4000.0, SaleStatus.Faturado, s3);
SalesRecord r149 = new SalesRecord(149, new DateTime(2021, 09, 23), 12000.0, SaleStatus.Faturado, s5);
SalesRecord r150 = new SalesRecord(150, new DateTime(2021, 09, 12), 5000.0, SaleStatus.Faturado, s2);
SalesRecord r151 = new SalesRecord(151, new DateTime(2021, 10, 13), 6000.0, SaleStatus.Faturado, s2);
SalesRecord r152 = new SalesRecord(152, new DateTime(2021, 10, 25), 7000.0, SaleStatus.Pendente, s3);
SalesRecord r153 = new SalesRecord(153, new DateTime(2021, 10, 29), 02000.0, SaleStatus.Faturado, s4);
SalesRecord r154 = new SalesRecord(154, new DateTime(2021, 10, 4), 3000.0, SaleStatus.Faturado, s5);
SalesRecord r155 = new SalesRecord(155, new DateTime(2021, 10, 12), 4000.0, SaleStatus.Faturado, s1);
SalesRecord r156 = new SalesRecord(156, new DateTime(2021, 10, 5), 2000.0, SaleStatus.Faturado, s4);
SalesRecord r157 = new SalesRecord(157, new DateTime(2021, 10, 1), 12000.0, SaleStatus.Faturado, s1);
SalesRecord r158 = new SalesRecord(158, new DateTime(2021, 10, 24), 6000.0, SaleStatus.Faturado, s3);
SalesRecord r159 = new SalesRecord(159, new DateTime(2021, 10, 22), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r160 = new SalesRecord(160, new DateTime(2021, 10, 15), 8000.0, SaleStatus.Faturado, s6);
SalesRecord r161 = new SalesRecord(161, new DateTime(2021, 10, 17), 9000.0, SaleStatus.Faturado, s2);
SalesRecord r162 = new SalesRecord(162, new DateTime(2021, 10, 24), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r163 = new SalesRecord(163, new DateTime(2021, 10, 19), 10200.0, SaleStatus.Cancelado, s2);
SalesRecord r164 = new SalesRecord(164, new DateTime(2021, 10, 12), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r165 = new SalesRecord(165, new DateTime(2021, 10, 27), 7000.0, SaleStatus.Faturado, s3);
SalesRecord r166 = new SalesRecord(166, new DateTime(2021, 10, 6), 5000.0, SaleStatus.Faturado, s4);
SalesRecord r167 = new SalesRecord(167, new DateTime(2021, 10, 13), 9000.0, SaleStatus.Pendente, s1);
SalesRecord r168 = new SalesRecord(168, new DateTime(2021, 10, 7), 4000.0, SaleStatus.Faturado, s3);
SalesRecord r169 = new SalesRecord(169, new DateTime(2021, 11, 23), 12000.0, SaleStatus.Faturado, s5);
SalesRecord r170 = new SalesRecord(170, new DateTime(2021, 11, 12), 5000.0, SaleStatus.Faturado, s2);
SalesRecord r171 = new SalesRecord(171, new DateTime(2021, 11, 25), 10200.0, SaleStatus.Faturado, s1);
SalesRecord r172 = new SalesRecord(172, new DateTime(2021, 11, 4), 7000.0, SaleStatus.Faturado, s5);
SalesRecord r173 = new SalesRecord(173, new DateTime(2021, 11, 13), 4000.0, SaleStatus.Cancelado, s4);
SalesRecord r174 = new SalesRecord(174, new DateTime(2021, 11, 1), 8000.0, SaleStatus.Faturado, s1);
SalesRecord r175 = new SalesRecord(175, new DateTime(2021, 11, 21), 3000.0, SaleStatus.Faturado, s3);
SalesRecord r176 = new SalesRecord(176, new DateTime(2021, 11, 15), 2000.0, SaleStatus.Faturado, s1);
SalesRecord r177 = new SalesRecord(177, new DateTime(2021, 11, 28), 13000.0, SaleStatus.Faturado, s2);
SalesRecord r178 = new SalesRecord(178, new DateTime(2021, 11, 11), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r179 = new SalesRecord(179, new DateTime(2021, 11, 14), 10200.0, SaleStatus.Pendente, s6);
SalesRecord r180 = new SalesRecord(180, new DateTime(2021, 11, 7), 9000.0, SaleStatus.Faturado, s6);
SalesRecord r181 = new SalesRecord(181, new DateTime(2021, 11, 13), 6000.0, SaleStatus.Faturado, s2);
SalesRecord r182 = new SalesRecord(182, new DateTime(2021, 11, 25), 7000.0, SaleStatus.Pendente, s3);
SalesRecord r183 = new SalesRecord(183, new DateTime(2021, 11, 29), 02000.0, SaleStatus.Faturado, s4);
SalesRecord r184 = new SalesRecord(184, new DateTime(2021, 12, 4), 3000.0, SaleStatus.Faturado, s5);
SalesRecord r185 = new SalesRecord(185, new DateTime(2021, 12, 12), 4000.0, SaleStatus.Faturado, s1);
SalesRecord r186 = new SalesRecord(186, new DateTime(2021, 12, 5), 2000.0, SaleStatus.Faturado, s4);
SalesRecord r187 = new SalesRecord(187, new DateTime(2021, 12, 1), 12000.0, SaleStatus.Faturado, s1);
SalesRecord r188 = new SalesRecord(188, new DateTime(2021, 12, 24), 6000.0, SaleStatus.Faturado, s3);
SalesRecord r189 = new SalesRecord(189, new DateTime(2021, 12, 22), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r190 = new SalesRecord(190, new DateTime(2021, 12, 15), 8000.0, SaleStatus.Faturado, s6);
SalesRecord r191 = new SalesRecord(191, new DateTime(2021, 12, 17), 9000.0, SaleStatus.Faturado, s2);
SalesRecord r192 = new SalesRecord(192, new DateTime(2021, 12, 24), 4000.0, SaleStatus.Faturado, s4);
SalesRecord r193 = new SalesRecord(193, new DateTime(2021, 12, 19), 10200.0, SaleStatus.Cancelado, s2);
SalesRecord r194 = new SalesRecord(194, new DateTime(2021, 12, 12), 8000.0, SaleStatus.Faturado, s5);
SalesRecord r195 = new SalesRecord(195, new DateTime(2021, 12, 27), 7000.0, SaleStatus.Faturado, s3);
SalesRecord r196 = new SalesRecord(196, new DateTime(2021, 12, 6), 5000.0, SaleStatus.Faturado, s4);
SalesRecord r197 = new SalesRecord(197, new DateTime(2021, 12, 13), 9000.0, SaleStatus.Pendente, s1);
SalesRecord r198 = new SalesRecord(198, new DateTime(2021, 12, 7), 4000.0, SaleStatus.Faturado, s3);
SalesRecord r199 = new SalesRecord(199, new DateTime(2021, 12, 23), 12000.0, SaleStatus.Faturado, s5);
SalesRecord r200 = new SalesRecord(200, new DateTime(2021, 12, 12), 5000.0, SaleStatus.Faturado, 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,
r31, r32, r33, r34, r35, r36, r37, r38, r39, r40,
r41, r42, r43, r44, r45, r46, r47, r48, r49, r50,
r51, r52, r53, r54, r55, r56, r57, r58, r59, r60,
r61, r62, r63, r64, r65, r66, r67, r68, r69, r70,
r71, r72, r73, r74, r75, r76, r77, r78, r79, r80,
r81, r82, r83, r84, r85, r86, r87, r88, r89, r90,
r91, r92, r93, r94, r95, r96, r97, r98, r99, r100,
r101, r102, r103, r104, r105, r106, r107, r108, r109,
r110, r111, r112, r113, r114, r115, r116, r117, r118,
r119, r120, r121, r122, r123, r124, r125, r126, r127,
r128, r129, r130, r131, r132, r133, r134, r135, r136,
r137, r138, r139, r140, r141, r142, r143, r144, r145,
r146, r147, r148, r149, r150, r151, r152, r153, r154,
r155, r156, r157, r158, r159, r160, r161, r162, r163,
r164, r165, r166, r167, r168, r169, r170, r171, r172,
r173, r174, r175, r176, r177, r178, r179, r180, r181,
r182, r183, r184, r185, r186, r187, r188, r189, r190,
r191, r192, r193, r194, r195, r196, r197, r198, r199, r200
);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return;
}
Department d1 = new Department(1, "Computadores");
Department d2 = new Department(2, "Eletrônicos");
Department d3 = new Department(3, "Filmes");
Department d4 = new Department(4, "Livros");
Seller s1 = new Seller(1, "Carlos Alberto", "*****@*****.**", new DateTime(1988, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Santos", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Pedro Junior", "*****@*****.**", new DateTime(1990, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Marta Lima", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller(5, "Davi Correia", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller(6, "Roberto Silva", "*****@*****.**", 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);
_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();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // DB has been seeded.
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Marcio Silva", "Marcio@gmail", new DateTime(1986, 11, 27), 2000, d1);
Seller s2 = new Seller(2, "Maysa Vitor", "Maysa@gmail", new DateTime(2009, 2, 25), 1500, d3);
Seller s3 = new Seller(3, "Elenilce Vitor", "Elenilce@gmail", new DateTime(1984, 2, 14), 1500, d3);
Seller s4 = new Seller(4, "Francisca Santos", "Francisca@gmail", new DateTime(1965, 11, 24), 2000, d2);
Seller s5 = new Seller(5, "Flavio Santos", "Flavio@gmail", new DateTime(1963, 5, 27), 1500, d4);
Seller s6 = new Seller(6, "Flavia Silva", "Flavia@gmail", new DateTime(1983, 12, 14), 2000, 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.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();
}
public void Seed()
{
/*Popular a base de dados*/
if (_context.Department.Any() ||//Se ja existe algum dado na tabela...
_context.Seller.Any() ||
_context.Seller.Any())
{
return; //Corta a execução do método ( DB has been seeded)
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
// Department d5 = new Department { Id = 5, Name = "Nellion" };
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(1998, 1, 22), 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 os objetos no banco de dados*/
_context.Department.AddRange(d1, d2, d3, d4);
/*AddRange -> Permite que adicione vários objetos de uma só vez*/
_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
);
/*Efetivar as alterações: */
_context.SaveChanges();
}
//3 --->
public void Seed()
{//Aqui o if testa se possui algum dado na base de dados. O ANY testa de existe algum registro na tabela informada
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;//colocado um return para caso exista registro ele pare por aqui
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
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.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);
//AddRange permite adicionar vários objetos de uma vez
_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
);
//para confirmar/salvar a inclusão dos objetos no banco de dados
_context.SaveChanges();
}
public void Seed()
{
//Verifica se a base de dados está populada / verify database seeding
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; //DB has been seeded
}
//_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Department ON");
//_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Seller ON");
//_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT SalesRecord ON");
//Start Seeding
//Depaartment
Department d1 = new Department("Computers");
Department d2 = new Department("Eletronics");
Department d3 = new Department("Fashion");
Department d4 = new Department("Books");
//Seller
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);
//Sales
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();
//_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Department OFF");
//_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Seller OFF");
//_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT SalesRecord OFF");
}
public void Seed()
{
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.Sales.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, "Matheus", "*****@*****.**", new DateTime(1998, 2, 27), 1000.0, d1);
Seller s2 = new Seller(2, "Michele", "*****@*****.**", new DateTime(1993, 11, 30), 1500.0, d2);
Seller s3 = new Seller(3, "Kelly Campos", "*****@*****.**", new DateTime(1978, 1, 25), 1700.0, d3);
Seller s4 = new Seller(4, "Washington", "*****@*****.**", new DateTime(1970, 11, 24), 1559.0, d4);
Seller s5 = new Seller(5, "Davi", "*****@*****.**", new DateTime(2013, 2, 15), 2000.0, d2);
Seller s6 = new Seller(6, "Felipe", "*****@*****.**", new DateTime(2002, 12, 2), 1250.0, d4);
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.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.Sales.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() // responsavel por popular a base de dados
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.Seller.Any()
) // este if serve para verificar se já existe dados no BD
{
// operação Any verifica se já existe algo na tabela x
return; // se já existe retorna Obs: "O BD já foi populado"
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
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.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);
// add os dados no BD
_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();// salva os itens add
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // DB has been seeded
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
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.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.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();
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // BD has been seeded
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Dário Costa", "*****@*****.**", new DateTime(2000, 7, 25), 4000.0, d1);
Seller s2 = new Seller(2, "Ferdinand Mckay", "*****@*****.**", new DateTime(1999, 2, 28), 3000.0, d2);
Seller s3 = new Seller(3, "Kevyn Martins", "*****@*****.**", new DateTime(1990, 12, 05), 2000.0, d3);
Seller s4 = new Seller(4, "Guilherme Luz", "*****@*****.**", new DateTime(1998, 11, 11), 1000.0, d2);
Seller s5 = new Seller(5, "Pedro Vees", "*****@*****.**", new DateTime(1994, 1, 22), 2400.0, d3);
Seller s6 = new Seller(6, "Bernardo Batista", "*****@*****.**", new DateTime(1992, 4, 14), 1900.0, d4);
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.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();
}
