//Populando a base de dados caso não esteja ainda
public void PopularDados()
{
//Operação Any do linq vai testar se existe algum registro nessa tabela
if (_context.Departamento.Any() || _context.Vendedor.Any() || _context.RecordeVendas.Any())
{
//se existe registro, o return vai cortar a execução do método e não vai retornar nada. Banco já está preenchido
return;
}
Departamento d1 = new Departamento("Computador");
Departamento d2 = new Departamento("Eletronicos");
Departamento d3 = new Departamento("Moda");
Departamento d4 = new Departamento("Livro");
Vendedor v1 = new Vendedor("Filipe", "*****@*****.**", new DateTime(1992, 3, 19), 6000.0, d1);
Vendedor v2 = new Vendedor("Queiroz", "*****@*****.**", new DateTime(1990, 3, 25), 4000.0, d2);
Vendedor v3 = new Vendedor("Luzia", "*****@*****.**", new DateTime(1998, 11, 09), 5000.0, d4);
Vendedor v4 = new Vendedor("Angel", "*****@*****.**", new DateTime(2019, 03, 19), 500.0, d3);
RecordeVenda r1 = new RecordeVenda(new DateTime(2018, 09, 25), 1100.0, StatusVenda.Faturado, v1);
RecordeVenda r2 = new RecordeVenda(new DateTime(2018, 07, 10), 2000.0, StatusVenda.Pendente, v2);
RecordeVenda r3 = new RecordeVenda(new DateTime(2019, 11, 25), 900.0, StatusVenda.Faturado, v3);
RecordeVenda r4 = new RecordeVenda(new DateTime(2020, 02, 15), 200.0, StatusVenda.Cancelado, v4);
RecordeVenda r5 = new RecordeVenda(new DateTime(2021, 09, 25), 3000.0, StatusVenda.Faturado, v1);
RecordeVenda r6 = new RecordeVenda(new DateTime(2021, 12, 22), 4000.0, StatusVenda.Faturado, v3);
_context.Departamento.AddRange(d1, d2, d3, d4);
_context.Vendedor.AddRange(v1, v2, v3, v4);
_context.RecordeVendas.AddRange(r1, r2, r3, r4, r5, r6);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departamento.Any() ||
_context.Vendedor.Any() ||
_context.registroDeVendas.Any())
{
return; // O banco de dados já foi populado
}
Departamento d1 = new Departamento(1, "Computadores");
Departamento d2 = new Departamento(2, "Eletronicos");
Departamento d3 = new Departamento(3, "Moda");
Departamento d4 = new Departamento(4, "Livros");
Vendedor v1 = new Vendedor(1, "Boby brow", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Vendedor v2 = new Vendedor(2, "Maria elisa", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d2);
Vendedor v3 = new Vendedor(3, "Joana Dark", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d3);
Vendedor v4 = new Vendedor(4, "Messias Bolsonaro", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d4);
RegistroDeVendas r1 = new RegistroDeVendas(1, new DateTime(2018, 9, 25), 11000.00, SaleStatus.Faturado, v1);
RegistroDeVendas r2 = new RegistroDeVendas(2, new DateTime(2018, 9, 25), 11000.00, SaleStatus.Faturado, v2);
RegistroDeVendas r3 = new RegistroDeVendas(3, new DateTime(2018, 9, 25), 11000.00, SaleStatus.Faturado, v1);
RegistroDeVendas r4 = new RegistroDeVendas(4, new DateTime(2018, 9, 25), 11000.00, SaleStatus.Faturado, v2);
_context.Departamento.AddRange(d1, d2, d3, d4);
_context.Vendedor.AddRange(v1, v2, v3, v4);
_context.registroDeVendas.AddRange(r1, r2, r3, r4);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.Vendedor.Any() || _context.RegistroDeVendas.Any())
{
return; //BD já tem dados
}
Department d1 = new Department(1, "Computadores");
Department d2 = new Department(2, "Eletronicos");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Livros");
Vendedor v1 = new Vendedor(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Vendedor v2 = new Vendedor(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Vendedor v3 = new Vendedor(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Vendedor v4 = new Vendedor(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Vendedor v5 = new Vendedor(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Vendedor v6 = 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, StatusDeVenda.Faturado, v1);
RegistroDeVendas r2 = new RegistroDeVendas(2, new DateTime(2018, 09, 4), 7000.0, StatusDeVenda.Faturado, v5);
RegistroDeVendas r3 = new RegistroDeVendas(3, new DateTime(2018, 09, 13), 4000.0, StatusDeVenda.Cancelado, v4);
RegistroDeVendas r4 = new RegistroDeVendas(4, new DateTime(2018, 09, 1), 8000.0, StatusDeVenda.Faturado, v1);
RegistroDeVendas r5 = new RegistroDeVendas(5, new DateTime(2018, 09, 21), 3000.0, StatusDeVenda.Faturado, v3);
RegistroDeVendas r6 = new RegistroDeVendas(6, new DateTime(2018, 09, 15), 2000.0, StatusDeVenda.Faturado, v1);
RegistroDeVendas r7 = new RegistroDeVendas(7, new DateTime(2018, 09, 28), 13000.0, StatusDeVenda.Faturado, v2);
RegistroDeVendas r8 = new RegistroDeVendas(8, new DateTime(2018, 09, 11), 4000.0, StatusDeVenda.Faturado, v4);
RegistroDeVendas r9 = new RegistroDeVendas(9, new DateTime(2018, 09, 14), 11000.0, StatusDeVenda.Pendente, v6);
RegistroDeVendas r10 = new RegistroDeVendas(10, new DateTime(2018, 09, 7), 9000.0, StatusDeVenda.Faturado, v6);
RegistroDeVendas r11 = new RegistroDeVendas(11, new DateTime(2018, 09, 13), 6000.0, StatusDeVenda.Faturado, v2);
RegistroDeVendas r12 = new RegistroDeVendas(12, new DateTime(2018, 09, 25), 7000.0, StatusDeVenda.Pendente, v3);
RegistroDeVendas r13 = new RegistroDeVendas(13, new DateTime(2018, 09, 29), 10000.0, StatusDeVenda.Faturado, v4);
RegistroDeVendas r14 = new RegistroDeVendas(14, new DateTime(2018, 09, 4), 3000.0, StatusDeVenda.Faturado, v5);
RegistroDeVendas r15 = new RegistroDeVendas(15, new DateTime(2018, 09, 12), 4000.0, StatusDeVenda.Faturado, v1);
RegistroDeVendas r16 = new RegistroDeVendas(16, new DateTime(2018, 10, 5), 2000.0, StatusDeVenda.Faturado, v4);
RegistroDeVendas r17 = new RegistroDeVendas(17, new DateTime(2018, 10, 1), 12000.0, StatusDeVenda.Faturado, v1);
RegistroDeVendas r18 = new RegistroDeVendas(18, new DateTime(2018, 10, 24), 6000.0, StatusDeVenda.Faturado, v3);
RegistroDeVendas r19 = new RegistroDeVendas(19, new DateTime(2018, 10, 22), 8000.0, StatusDeVenda.Faturado, v5);
RegistroDeVendas r20 = new RegistroDeVendas(20, new DateTime(2018, 10, 15), 8000.0, StatusDeVenda.Faturado, v6);
RegistroDeVendas r21 = new RegistroDeVendas(21, new DateTime(2018, 10, 17), 9000.0, StatusDeVenda.Faturado, v2);
RegistroDeVendas r22 = new RegistroDeVendas(22, new DateTime(2018, 10, 24), 4000.0, StatusDeVenda.Faturado, v4);
RegistroDeVendas r23 = new RegistroDeVendas(23, new DateTime(2018, 10, 19), 11000.0, StatusDeVenda.Cancelado, v2);
RegistroDeVendas r24 = new RegistroDeVendas(24, new DateTime(2018, 10, 12), 8000.0, StatusDeVenda.Faturado, v5);
RegistroDeVendas r25 = new RegistroDeVendas(25, new DateTime(2018, 10, 31), 7000.0, StatusDeVenda.Faturado, v3);
RegistroDeVendas r26 = new RegistroDeVendas(26, new DateTime(2018, 10, 6), 5000.0, StatusDeVenda.Faturado, v4);
RegistroDeVendas r27 = new RegistroDeVendas(27, new DateTime(2018, 10, 13), 9000.0, StatusDeVenda.Pendente, v1);
RegistroDeVendas r28 = new RegistroDeVendas(28, new DateTime(2018, 10, 7), 4000.0, StatusDeVenda.Faturado, v3);
RegistroDeVendas r29 = new RegistroDeVendas(29, new DateTime(2018, 10, 23), 12000.0, StatusDeVenda.Faturado, v5);
RegistroDeVendas r30 = new RegistroDeVendas(30, new DateTime(2018, 10, 12), 5000.0, StatusDeVenda.Faturado, v2);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Vendedor.AddRange(v1, v2, v3, v4, v5, v6);
_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 Enviar()
{
if (_context.Departamento.Any() || _context.Vendedor.Any() || _context.HistoricoDeVendas.Any())
{
return; // se essa consição for verdadeira, então a base de dados já está povoado
}
Departamento d1 = new Departamento(1, "Computadores");
Departamento d2 = new Departamento(2, "Eletrônicos");
Departamento d3 = new Departamento(3, "Smartphone");
Departamento d4 = new Departamento(4, "Livros");
Vendedor v1 = new Vendedor(1, "João", "*****@*****.**", new DateTime(1990, 01, 27), 1000.0, d1);
Vendedor v2 = new Vendedor(2, "Pedro", "*****@*****.**", new DateTime(1991, 12, 28), 1100.0, d2);
Vendedor v3 = new Vendedor(3, "Maria", "*****@*****.**", new DateTime(1992, 03, 29), 1200.0, d3);
Vendedor v4 = new Vendedor(4, "Lucas", "*****@*****.**", new DateTime(1993, 04, 30), 1300.0, d4);
Vendedor v5 = new Vendedor(5, "Marcos", "*****@*****.**", new DateTime(1994, 05, 31), 1400.0, d1);
Vendedor v6 = new Vendedor(6, "Paulo", "*****@*****.**", new DateTime(1995, 01, 20), 1500.0, d2);
HistoricoDeVenda h1 = new HistoricoDeVenda(1, new DateTime(2019, 05, 20), 11000.0, StatusDaVenda.Vendido, v1);
HistoricoDeVenda h2 = new HistoricoDeVenda(2, new DateTime(2019, 06, 21), 11000.0, StatusDaVenda.Pendente, v2);
HistoricoDeVenda h3 = new HistoricoDeVenda(3, new DateTime(2019, 07, 22), 11000.0, StatusDaVenda.Vendido, v3);
HistoricoDeVenda h4 = new HistoricoDeVenda(4, new DateTime(2019, 08, 23), 11000.0, StatusDaVenda.Pendente, v4);
HistoricoDeVenda h5 = new HistoricoDeVenda(5, new DateTime(2019, 09, 24), 11000.0, StatusDaVenda.Vendido, v5);
HistoricoDeVenda h6 = new HistoricoDeVenda(6, new DateTime(2019, 10, 25), 11000.0, StatusDaVenda.Pendente, v6);
HistoricoDeVenda h7 = new HistoricoDeVenda(7, new DateTime(2019, 11, 26), 11000.0, StatusDaVenda.Vendido, v1);
HistoricoDeVenda h8 = new HistoricoDeVenda(8, new DateTime(2019, 12, 27), 11000.0, StatusDaVenda.Pendente, v2);
HistoricoDeVenda h9 = new HistoricoDeVenda(9, new DateTime(2019, 01, 28), 11000.0, StatusDaVenda.Vendido, v3);
HistoricoDeVenda h10 = new HistoricoDeVenda(10, new DateTime(2019, 02, 28), 11000.0, StatusDaVenda.Cancelado, v4);
HistoricoDeVenda h11 = new HistoricoDeVenda(11, new DateTime(2019, 03, 30), 11000.0, StatusDaVenda.Vendido, v5);
HistoricoDeVenda h12 = new HistoricoDeVenda(12, new DateTime(2019, 04, 11), 11000.0, StatusDaVenda.Cancelado, v6);
HistoricoDeVenda h13 = new HistoricoDeVenda(13, new DateTime(2019, 05, 01), 11000.0, StatusDaVenda.Vendido, v1);
HistoricoDeVenda h14 = new HistoricoDeVenda(14, new DateTime(2019, 06, 02), 11000.0, StatusDaVenda.Cancelado, v2);
_context.Departamento.AddRange(d1, d2, d3, d4);
_context.Vendedor.AddRange(v1, v2, v3, v4, v5, v6);
_context.HistoricoDeVendas.AddRange(h1, h2, h3, h4, h5, h6, h7, h8, h9, h10, h11, h12, h13, h4);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", 1000.0, new DateTime(1993, 10, 12), d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", 2500.0, new DateTime(1979, 11, 21), d3);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", 1500.0, new DateTime(1995, 10, 15), d2);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", 7000.0, new DateTime(1995, 12, 12), d1);
Seller s5 = new Seller(5, "Jose da Silva", "*****@*****.**", 5000.0, new DateTime(1983, 12, 12), d4);
Seller s6 = new Seller(6, "Ana da Costa", "*****@*****.**", 500.0, new DateTime(1973, 04, 01), d3);
SalesRecord r1 = new SalesRecord(1, new DateTime(2019, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2019, 03, 18), 7000.0, SaleStatus.Billed, s2);
SalesRecord r3 = new SalesRecord(3, new DateTime(2020, 03, 01), 5000.0, SaleStatus.Billed, s3);
SalesRecord r4 = new SalesRecord(4, new DateTime(2020, 04, 20), 34000.0, SaleStatus.Billed, s4);
SalesRecord r5 = new SalesRecord(5, new DateTime(2020, 06, 25), 11000.0, SaleStatus.Billed, s5);
SalesRecord r6 = new SalesRecord(6, new DateTime(2020, 05, 03), 11000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2019, 07, 04), 7000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2020, 04, 11), 5000.0, SaleStatus.Billed, s3);
SalesRecord r9 = new SalesRecord(9, new DateTime(2019, 12, 21), 34000.0, SaleStatus.Billed, s4);
SalesRecord r10 = new SalesRecord(10, new DateTime(2019, 10, 10), 11000.0, SaleStatus.Billed, s5);
_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);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departamento.Any() || _context.Vendedor.Any() || _context.RegistroVendas.Any())
{
return; //DB já semeado
}
Departamento d1 = new Departamento(1, "Informática");
Departamento d2 = new Departamento(2, "Eletrônicos");
Departamento d3 = new Departamento(3, "Vestuário");
Departamento d4 = new Departamento(4, "Livros");
Vendedor v1 = new Vendedor(1, "João Cunha", "*****@*****.**", new DateTime(1998, 9, 23), 1000.0, d1);
Vendedor v2 = new Vendedor(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Vendedor v3 = new Vendedor(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Vendedor v4 = new Vendedor(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Vendedor v5 = new Vendedor(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Vendedor v6 = new Vendedor(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
VendasRegistro r1 = new VendasRegistro(1, new DateTime(2018, 09, 25), 11000.0, StatusVenda.Faturado, v1);
VendasRegistro r2 = new VendasRegistro(2, new DateTime(2018, 09, 4), 7000.0, StatusVenda.Faturado, v5);
VendasRegistro r3 = new VendasRegistro(3, new DateTime(2018, 09, 13), 4000.0, StatusVenda.Cancelado, v4);
VendasRegistro r4 = new VendasRegistro(4, new DateTime(2018, 09, 1), 8000.0, StatusVenda.Faturado, v1);
VendasRegistro r5 = new VendasRegistro(5, new DateTime(2018, 09, 21), 3000.0, StatusVenda.Faturado, v3);
VendasRegistro r6 = new VendasRegistro(6, new DateTime(2018, 09, 15), 2000.0, StatusVenda.Faturado, v1);
VendasRegistro r7 = new VendasRegistro(7, new DateTime(2018, 09, 28), 13000.0, StatusVenda.Faturado, v2);
VendasRegistro r8 = new VendasRegistro(8, new DateTime(2018, 09, 11), 4000.0, StatusVenda.Faturado, v4);
VendasRegistro r9 = new VendasRegistro(9, new DateTime(2018, 09, 14), 11000.0, StatusVenda.Pendente, v6);
VendasRegistro r10 = new VendasRegistro(10, new DateTime(2018, 09, 7), 9000.0, StatusVenda.Faturado, v6);
VendasRegistro r11 = new VendasRegistro(11, new DateTime(2018, 09, 13), 6000.0, StatusVenda.Faturado, v2);
VendasRegistro r12 = new VendasRegistro(12, new DateTime(2018, 09, 25), 7000.0, StatusVenda.Pendente, v3);
VendasRegistro r13 = new VendasRegistro(13, new DateTime(2018, 09, 29), 10000.0, StatusVenda.Faturado, v4);
VendasRegistro r14 = new VendasRegistro(14, new DateTime(2018, 09, 4), 3000.0, StatusVenda.Faturado, v5);
VendasRegistro r15 = new VendasRegistro(15, new DateTime(2018, 09, 12), 4000.0, StatusVenda.Faturado, v1);
VendasRegistro r16 = new VendasRegistro(16, new DateTime(2018, 10, 5), 2000.0, StatusVenda.Faturado, v4);
VendasRegistro r17 = new VendasRegistro(17, new DateTime(2018, 10, 1), 12000.0, StatusVenda.Faturado, v1);
VendasRegistro r18 = new VendasRegistro(18, new DateTime(2018, 10, 24), 6000.0, StatusVenda.Faturado, v3);
VendasRegistro r19 = new VendasRegistro(19, new DateTime(2018, 10, 22), 8000.0, StatusVenda.Faturado, v5);
VendasRegistro r20 = new VendasRegistro(20, new DateTime(2018, 10, 15), 8000.0, StatusVenda.Faturado, v6);
VendasRegistro r21 = new VendasRegistro(21, new DateTime(2018, 10, 17), 9000.0, StatusVenda.Faturado, v2);
VendasRegistro r22 = new VendasRegistro(22, new DateTime(2018, 10, 24), 4000.0, StatusVenda.Faturado, v4);
VendasRegistro r23 = new VendasRegistro(23, new DateTime(2018, 10, 19), 11000.0, StatusVenda.Cancelado, v2);
VendasRegistro r24 = new VendasRegistro(24, new DateTime(2018, 10, 12), 8000.0, StatusVenda.Faturado, v5);
VendasRegistro r25 = new VendasRegistro(25, new DateTime(2018, 10, 31), 7000.0, StatusVenda.Faturado, v3);
VendasRegistro r26 = new VendasRegistro(26, new DateTime(2018, 10, 6), 5000.0, StatusVenda.Faturado, v4);
VendasRegistro r27 = new VendasRegistro(27, new DateTime(2018, 10, 13), 9000.0, StatusVenda.Pendente, v1);
VendasRegistro r28 = new VendasRegistro(28, new DateTime(2018, 10, 7), 4000.0, StatusVenda.Faturado, v3);
VendasRegistro r29 = new VendasRegistro(29, new DateTime(2018, 10, 23), 12000.0, StatusVenda.Faturado, v5);
VendasRegistro r30 = new VendasRegistro(30, new DateTime(2018, 10, 12), 5000.0, StatusVenda.Faturado, v2);
_context.Departamento.AddRange(d1, d2, d3, d4);
_context.Vendedor.AddRange(v1, v2, v3, v4, v5, v6);
_context.RegistroVendas.AddRange(
r1, r2, r3, r4, r5, r6, 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.RegistroVendas.Any())
{
return; // base já populada
}
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);
RegistroVendas r1 = new RegistroVendas(1, new DateTime(2018, 09, 25), 11000.0, StatusVenda.Faturado, s1);
RegistroVendas r2 = new RegistroVendas(2, new DateTime(2018, 09, 4), 7000.0, StatusVenda.Faturado, s5);
RegistroVendas r3 = new RegistroVendas(3, new DateTime(2018, 09, 13), 4000.0, StatusVenda.Cancelado, s4);
RegistroVendas r4 = new RegistroVendas(4, new DateTime(2018, 09, 1), 8000.0, StatusVenda.Faturado, s1);
RegistroVendas r5 = new RegistroVendas(5, new DateTime(2018, 09, 21), 3000.0, StatusVenda.Faturado, s3);
RegistroVendas r6 = new RegistroVendas(6, new DateTime(2018, 09, 15), 2000.0, StatusVenda.Faturado, s1);
RegistroVendas r7 = new RegistroVendas(7, new DateTime(2018, 09, 28), 13000.0, StatusVenda.Faturado, s2);
RegistroVendas r8 = new RegistroVendas(8, new DateTime(2018, 09, 11), 4000.0, StatusVenda.Faturado, s4);
RegistroVendas r9 = new RegistroVendas(9, new DateTime(2018, 09, 14), 11000.0, StatusVenda.Pendente, s6);
RegistroVendas r10 = new RegistroVendas(10, new DateTime(2018, 09, 7), 9000.0, StatusVenda.Faturado, s6);
RegistroVendas r11 = new RegistroVendas(11, new DateTime(2018, 09, 13), 6000.0, StatusVenda.Faturado, s2);
RegistroVendas r12 = new RegistroVendas(12, new DateTime(2018, 09, 25), 7000.0, StatusVenda.Pendente, s3);
RegistroVendas r13 = new RegistroVendas(13, new DateTime(2018, 09, 29), 10000.0, StatusVenda.Faturado, s4);
RegistroVendas r14 = new RegistroVendas(14, new DateTime(2018, 09, 4), 3000.0, StatusVenda.Faturado, s5);
RegistroVendas r15 = new RegistroVendas(15, new DateTime(2018, 09, 12), 4000.0, StatusVenda.Faturado, s1);
RegistroVendas r16 = new RegistroVendas(16, new DateTime(2018, 10, 5), 2000.0, StatusVenda.Faturado, s4);
RegistroVendas r17 = new RegistroVendas(17, new DateTime(2018, 10, 1), 12000.0, StatusVenda.Faturado, s1);
RegistroVendas r18 = new RegistroVendas(18, new DateTime(2018, 10, 24), 6000.0, StatusVenda.Faturado, s3);
RegistroVendas r19 = new RegistroVendas(19, new DateTime(2018, 10, 22), 8000.0, StatusVenda.Faturado, s5);
RegistroVendas r20 = new RegistroVendas(20, new DateTime(2018, 10, 15), 8000.0, StatusVenda.Faturado, s6);
RegistroVendas r21 = new RegistroVendas(21, new DateTime(2018, 10, 17), 9000.0, StatusVenda.Faturado, s2);
RegistroVendas r22 = new RegistroVendas(22, new DateTime(2018, 10, 24), 4000.0, StatusVenda.Faturado, s4);
RegistroVendas r23 = new RegistroVendas(23, new DateTime(2018, 10, 19), 11000.0, StatusVenda.Cancelado, s2);
RegistroVendas r24 = new RegistroVendas(24, new DateTime(2018, 10, 12), 8000.0, StatusVenda.Faturado, s5);
RegistroVendas r25 = new RegistroVendas(25, new DateTime(2018, 10, 31), 7000.0, StatusVenda.Faturado, s3);
RegistroVendas r26 = new RegistroVendas(26, new DateTime(2018, 10, 6), 5000.0, StatusVenda.Faturado, s4);
RegistroVendas r27 = new RegistroVendas(27, new DateTime(2018, 10, 13), 9000.0, StatusVenda.Pendente, s1);
RegistroVendas r28 = new RegistroVendas(28, new DateTime(2018, 10, 7), 4000.0, StatusVenda.Faturado, s3);
RegistroVendas r29 = new RegistroVendas(29, new DateTime(2018, 10, 23), 12000.0, StatusVenda.Faturado, s5);
RegistroVendas r30 = new RegistroVendas(30, new DateTime(2018, 10, 12), 5000.0, StatusVenda.Faturado, s2);
_context.Departamento.AddRange(d1, d2, d3, d4);
_context.Vendedor.AddRange(s1, s2, s3, s4, s5, s6);
_context.RegistroVendas.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges();
}
// Operação responsável para popular o banco de dados
public void Seed()
{
// Teste para saber se existe já algum dado na BD
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;
}
// Populando o BD
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, "Idel", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Leonor", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s3 = new Seller(3, "Lena", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d2);
Seller s4 = new Seller(4, "Alba", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d2);
Seller s5 = new Seller(5, "Regina", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d3);
Seller s6 = new Seller(6, "Alber", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d4);
SalesRecord r1 = new SalesRecord(1, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s1);
SalesRecord r3 = new SalesRecord(3, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s1);
SalesRecord r4 = new SalesRecord(4, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s1);
SalesRecord r6 = new SalesRecord(6, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s2);
SalesRecord r9 = new SalesRecord(9, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s2);
SalesRecord r10 = new SalesRecord(10, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s2);
SalesRecord r11 = new SalesRecord(11, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s2);
SalesRecord r13 = new SalesRecord(13, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s3);
SalesRecord r14 = new SalesRecord(14, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s3);
SalesRecord r15 = new SalesRecord(15, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s3);
SalesRecord r16 = new SalesRecord(16, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s3);
SalesRecord r17 = new SalesRecord(17, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s4);
SalesRecord r18 = new SalesRecord(18, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s4);
SalesRecord r19 = new SalesRecord(19, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s4);
SalesRecord r20 = new SalesRecord(20, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s4);
SalesRecord r21 = new SalesRecord(21, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s5);
SalesRecord r22 = new SalesRecord(22, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s5);
SalesRecord r23 = new SalesRecord(23, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s5);
SalesRecord r24 = new SalesRecord(24, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s6);
SalesRecord r26 = new SalesRecord(26, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s6);
SalesRecord r27 = new SalesRecord(27, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s6);
SalesRecord r28 = new SalesRecord(28, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s6);
SalesRecord r29 = new SalesRecord(29, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s6);
SalesRecord r30 = new SalesRecord(30, new DateTime(2020, 11, 1), 15000.0, SalesStatus.Billed, s6);
// Adicionando os departamentos
_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
);
// Salvando as inclusões
_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, "Computadores");
Department d2 = new Department(2, "Eletronicos");
Department d3 = new Department(3, "Moda");
Department d4 = new Department(4, "Livros");
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);
_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 PopularBaseDados()
{
if (_context.Departamento.Any() || _context.Vendedor.Any() || _context.RegistroVenda.Any())
{
return;// banco de dados ja foi populado.
}
Departamento departamento1 = new Departamento(1, "Computadores");
Departamento departamento2 = new Departamento(2, "Eletronicos");
Departamento departamento3 = new Departamento(3, "Moda");
Departamento departamento4 = new Departamento(4, "Livros");
Vendedor vendedor1 = new Vendedor(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, departamento1);
Vendedor vendedor2 = new Vendedor(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, departamento2);
Vendedor vendedor3 = new Vendedor(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, departamento1);
Vendedor vendedor4 = new Vendedor(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, departamento4);
Vendedor vendedor5 = new Vendedor(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, departamento3);
Vendedor vendedor6 = new Vendedor(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, departamento2);
RegistroVenda registroVenda1 = new RegistroVenda(1, new DateTime(2018, 09, 25), 11000.0, StatusVenda.Faturado, vendedor1);
RegistroVenda registroVenda2 = new RegistroVenda(2, new DateTime(2018, 09, 4), 7000.0, StatusVenda.Faturado, vendedor5);
RegistroVenda registroVenda3 = new RegistroVenda(3, new DateTime(2018, 09, 13), 4000.0, StatusVenda.Cancelado, vendedor4);
RegistroVenda registroVenda4 = new RegistroVenda(4, new DateTime(2018, 09, 1), 8000.0, StatusVenda.Faturado, vendedor1);
RegistroVenda registroVenda5 = new RegistroVenda(5, new DateTime(2018, 09, 21), 3000.0, StatusVenda.Faturado, vendedor3);
RegistroVenda registroVenda6 = new RegistroVenda(6, new DateTime(2018, 09, 15), 2000.0, StatusVenda.Faturado, vendedor1);
RegistroVenda registroVenda7 = new RegistroVenda(7, new DateTime(2018, 09, 28), 13000.0, StatusVenda.Faturado, vendedor2);
RegistroVenda registroVenda8 = new RegistroVenda(8, new DateTime(2018, 09, 11), 4000.0, StatusVenda.Faturado, vendedor4);
RegistroVenda registroVenda9 = new RegistroVenda(9, new DateTime(2018, 09, 14), 11000.0, StatusVenda.Pendente, vendedor6);
RegistroVenda registroVenda10 = new RegistroVenda(10, new DateTime(2018, 09, 7), 9000.0, StatusVenda.Faturado, vendedor6);
RegistroVenda registroVenda11 = new RegistroVenda(11, new DateTime(2018, 09, 13), 6000.0, StatusVenda.Faturado, vendedor2);
RegistroVenda registroVenda12 = new RegistroVenda(12, new DateTime(2018, 09, 25), 7000.0, StatusVenda.Pendente, vendedor3);
RegistroVenda registroVenda13 = new RegistroVenda(13, new DateTime(2018, 09, 29), 10000.0, StatusVenda.Faturado, vendedor4);
RegistroVenda registroVenda14 = new RegistroVenda(14, new DateTime(2018, 09, 4), 3000.0, StatusVenda.Faturado, vendedor5);
RegistroVenda registroVenda15 = new RegistroVenda(15, new DateTime(2018, 09, 12), 4000.0, StatusVenda.Faturado, vendedor1);
RegistroVenda registroVenda16 = new RegistroVenda(16, new DateTime(2018, 10, 5), 2000.0, StatusVenda.Faturado, vendedor4);
RegistroVenda registroVenda17 = new RegistroVenda(17, new DateTime(2018, 10, 1), 12000.0, StatusVenda.Faturado, vendedor1);
RegistroVenda registroVenda18 = new RegistroVenda(18, new DateTime(2018, 10, 24), 6000.0, StatusVenda.Faturado, vendedor3);
RegistroVenda registroVenda19 = new RegistroVenda(19, new DateTime(2018, 10, 22), 8000.0, StatusVenda.Faturado, vendedor5);
RegistroVenda registroVenda20 = new RegistroVenda(20, new DateTime(2018, 10, 15), 8000.0, StatusVenda.Faturado, vendedor6);
RegistroVenda registroVenda21 = new RegistroVenda(21, new DateTime(2018, 10, 17), 9000.0, StatusVenda.Faturado, vendedor2);
RegistroVenda registroVenda22 = new RegistroVenda(22, new DateTime(2018, 10, 24), 4000.0, StatusVenda.Faturado, vendedor4);
RegistroVenda registroVenda23 = new RegistroVenda(23, new DateTime(2018, 10, 19), 11000.0, StatusVenda.Cancelado, vendedor2);
RegistroVenda registroVenda24 = new RegistroVenda(24, new DateTime(2018, 10, 12), 8000.0, StatusVenda.Faturado, vendedor5);
RegistroVenda registroVenda25 = new RegistroVenda(25, new DateTime(2018, 10, 31), 7000.0, StatusVenda.Faturado, vendedor3);
RegistroVenda registroVenda26 = new RegistroVenda(26, new DateTime(2018, 10, 6), 5000.0, StatusVenda.Faturado, vendedor4);
RegistroVenda registroVenda27 = new RegistroVenda(27, new DateTime(2018, 10, 13), 9000.0, StatusVenda.Pendente, vendedor1);
RegistroVenda registroVenda28 = new RegistroVenda(28, new DateTime(2018, 10, 7), 4000.0, StatusVenda.Faturado, vendedor3);
RegistroVenda registroVenda29 = new RegistroVenda(29, new DateTime(2018, 10, 23), 12000.0, StatusVenda.Faturado, vendedor5);
RegistroVenda registroVenda30 = new RegistroVenda(30, new DateTime(2018, 10, 12), 5000.0, StatusVenda.Faturado, vendedor2);
//add o departamentos
_context.Departamento.AddRange(departamento1, departamento2, departamento3, departamento4);
//add os vendedores
_context.Vendedor.AddRange(vendedor1, vendedor2, vendedor3, vendedor4, vendedor5, vendedor6);
//add os resgistros de vendas
_context.RegistroVenda.AddRange(
registroVenda1, registroVenda2, registroVenda3, registroVenda4, registroVenda5, registroVenda6, registroVenda7, registroVenda8,
registroVenda9, registroVenda10, registroVenda11, registroVenda12, registroVenda13, registroVenda14, registroVenda15, registroVenda16,
registroVenda17, registroVenda18, registroVenda19, registroVenda20, registroVenda21, registroVenda22, registroVenda23, registroVenda24,
registroVenda25, registroVenda26, registroVenda27, registroVenda28, registroVenda29, registroVenda30
);
//salva e confirma as alteracaoes nao banco de dados
_context.SaveChanges();
}
public void Seed() // Função responsavel por "criar" a Base Dados
{
if (_context.Department.Any() || // Verifica se existe algum valor na Base Dados Department. Any no Linq, verifica se existe algum registo numa tabela.
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // Base Dados já criada.
}
Department d1 = new Department(1, "Computers"); // Instanciação / criação de quatro Departamentos.
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); // d1 é o Departamento. Faço já a associação dos 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); // s1 é o vendedor.
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); // Adiciona o objeto na Base Dados. AssRange permite adicionar V+arios objetos 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(); // Para confirmar as alterações na Base de Dados.
}
