public void Seed()
{
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SalesRecords.Any())
{
return; //DB has been seeded
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Electronics");
Departament d3 = new Departament(3, "Tools");
Seller s1 = new Seller(1, "Rafael", "*****@*****.**", 1000.0, new DateTime(1999, 9, 9), d1);
Seller s2 = new Seller(2, "Laura", "*****@*****.**", 2000.0, new DateTime(2000, 3, 1), d2);
Seller s3 = new Seller(3, "Fabio", "*****@*****.**", 3000.0, new DateTime(1999, 9, 9), d3);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 9, 9), 300, SaleStatus.Pading, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 7, 9), 1000, SaleStatus.Canceled, s2);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 7, 10), 2000, SaleStatus.Billed, s3);
//Include Obj from DB
_context.Departament.AddRange(d1, d2, d3);
_context.Seller.AddRange(s1, s2, s3);
_context.SalesRecords.AddRange(r1, r2, r3);
_context.SaveChanges();
}
public void Seed()
{
// Check if have any data inside a database, then stop
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // DataBase has been seeded
}
// Fills Database
// Create Departments
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
// Create Sellers
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d3);
// Create Sales
SalesRecord sr1 = new SalesRecord(1, new DateTime(2019, 04, 01), 1000.0, SaleStatus.Billed, s1);
// Add objects on Database
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1);
_context.SalesRecord.AddRange(sr1);
// Save objects on Database
_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, "Abercyldo", "*****@*****.**", new DateTime(1998, 4, 21), 1000, d1);
Seller s2 = new Seller(2, "Weskleysson", "*****@*****.**", new DateTime(1995, 7, 8), 4000, d2);
Seller s3 = new Seller(3, "Arnaldo", "*****@*****.**", new DateTime(1974, 2, 21), 2000, d3);
Seller s4 = new Seller(4, "José Carlos", "*****@*****.**", new DateTime(1988, 4, 6), 9000, d4);
SalesRecord sr1 = new SalesRecord(1, new DateTime(2020, 01, 18), 4000, SaleStatus.Billed, s4);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4);
_context.SalesRecord.Add(sr1);
_context.SaveChanges();
}
//Feita a injeção de dependência. Sempre que um SeedingService for criado, irá receber uma instância do context.
public void Seed() //Método responsável por popular a base de dados.
{
//Se já existe algum dado nas entidades abaixo, a operação será interrompida.
if (_context.Department.Any() || _context.SalesRecord.Any() || _context.Seller.Any())
{
return;
}
//Como estamos utilizando o WorkFlow CodeFirst (cria objetos pra depois criar base de dados)
//iremos fazer a instanciação desses objetos e salvar na base de dados.
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(1990, 12, 03), 2500.0, d1);
Seller s2 = new Seller(2, "Maria Gutz", "*****@*****.**", new DateTime(1985, 7, 21), 3500.0, d2);
Seller s3 = new Seller(3, "Michael Eggers", "*****@*****.**", new DateTime(1979, 1, 9), 3500.0, d3);
Seller s4 = new Seller(4, "Erika Lins", "*****@*****.**", new DateTime(1993, 10, 13), 1800.0, d4);
Seller s5 = new Seller(5, "Luke Stanford", "*****@*****.**", new DateTime(1984, 6, 20), 2800.0, d2);
SalesRecord sr1 = new SalesRecord(1, new DateTime(2020, 01, 12, 10, 12, 45), 580.0, Models.Enums.SaleStatus.Billed, s2);
SalesRecord sr2 = new SalesRecord(2, new DateTime(2020, 02, 3, 13, 32, 11), 1020.0, Models.Enums.SaleStatus.Billed, s5);
SalesRecord sr3 = new SalesRecord(3, new DateTime(2020, 02, 4, 15, 10, 23), 210.0, Models.Enums.SaleStatus.Billed, s4);
//Adicionando e salvando todos os objetos acima no banco.
_context.Department.AddRange(d1, d2, d3, d4); //O Método AddRange permite que adicionemos varios objetos de uma só vez.
_context.Seller.AddRange(s1, s2, s3, s4, s5);
_context.SalesRecord.AddRange(sr1, sr2, sr3);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.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 Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // DB já possui elementos salvos
}
//instanciando os objetos
Department d1 = new Department(1, "Computer");
Department d2 = new Department(2, "Smarthfone");
Department d3 = new Department(3, "Book");
Seller s1 = new Seller(1, "vendedor 1 ", "*****@*****.**", new DateTime(1996, 12, 28), 1000.0, d1);
Seller s2 = new Seller(2, "vendedor 2 ", "*****@*****.**", new DateTime(1997, 2, 7), 1000.0, d1);
Seller s3 = new Seller(3, "vendedor 3 ", "*****@*****.**", new DateTime(1998, 8, 6), 1000.0, d2);
Seller s4 = new Seller(4, "vendedor 4 ", "*****@*****.**", new DateTime(1996, 12, 28), 1000.0, d2);
Seller s5 = new Seller(5, "vendedor 5 ", "*****@*****.**", new DateTime(2000, 2, 23), 1000.0, d3);
Seller s6 = new Seller(6, "vendedor 6 ", "*****@*****.**", new DateTime(2002, 8, 6), 1000.0, d3);
SalesRecord sr1 = new SalesRecord(1, new DateTime(2019, 01, 3), 2300.0, SaleStatus.Billed, s1);
SalesRecord sr2 = new SalesRecord(2, new DateTime(2019, 01, 2), 2000.0, SaleStatus.Pending, s3);
SalesRecord sr3 = new SalesRecord(3, new DateTime(2019, 01, 1), 978.50, SaleStatus.Billed, s4);
SalesRecord sr4 = new SalesRecord(4, new DateTime(2019, 01, 3), 3800.0, SaleStatus.Canceled, s1);
// Adicionando os elementos no BD
_context.Department.AddRange(d1, d2, d3);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(sr1, sr2, sr3, sr4);
_context.SaveChanges(); // Salvando e confirmando os dados no DB
}
public void Seed()
{
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // DB já foi populado
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Eletronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green ", "*****@*****.**", new DateTime(1999, 5, 24), 1000.0, d1);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1997, 6, 23), 1000.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1995, 7, 22), 1000.0, d1);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SalesStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 26), 11100.0, SalesStatus.Billed, s1);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 10, 27), 11110.0, SalesStatus.Billed, s1);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 11, 28), 11111.0, SalesStatus.Billed, s1);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4);
_context.SalesRecord.AddRange(r1, r2, r3, r4);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.salesRecord.Any())
{
return; //DB já está copulado
}
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), 10000, d1);
Seller s2 = new Seller(2, "Bob 2", "*****@*****.**", new DateTime(1998, 4, 21), 10000, d2);
Seller s3 = new Seller(3, "Bob Teste", "*****@*****.**", new DateTime(1998, 4, 21), 2000, d3);
SalesRecord r1 = new SalesRecord(1, new DateTime(1998, 3, 5), 11000, SalerStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(1996, 3, 5), 12000, SalerStatus.Billed, s2);
SalesRecord r3 = new SalesRecord(3, new DateTime(1994, 3, 5), 11000, SalerStatus.Billed, s3);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3);
_context.salesRecord.AddRange(r1, r2, r3);
_context.SaveChanges(); //Commit
}
public void Seed()
{
//verifica se existe algum registro na base
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; //Database 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 {
Id = 5, Name = "Books"
};
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1988, 07, 22), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1984, 07, 22), 2000.0, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1980, 07, 22), 1500.0, d3);
Seller s4 = new Seller(4, "Donald Blue", "*****@*****.**", new DateTime(1975, 07, 22), 1200.0, d4);
SalesRecord r1 = new SalesRecord(1, new DateTime(2021, 02, 05), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2021, 02, 06), 5000.0, SaleStatus.Canceled, s2);
SalesRecord r3 = new SalesRecord(3, new DateTime(2021, 02, 07), 3000.0, SaleStatus.Pending, s3);
SalesRecord r4 = new SalesRecord(4, new DateTime(2021, 02, 08), 4000.0, SaleStatus.Billed, s4);
//Add records on database using entity framework
_context.Department.AddRange(d1, d2, d3, d4); //AddRange allow insert many records at the same time
_context.Seller.AddRange(s1, s2, s3, s4);
_context.SalesRecord.AddRange(r1, r2, r3, r4);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departaments.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; //DB has been Seeded
}
Departaments d1 = new Departaments(1, "Computers");
Departaments d2 = new Departaments(2, "Electronics");
Departaments d3 = new Departaments(3, "Fashion");
Departaments d4 = new Departaments(4, "Books");
Seller s1 = new Seller(1, "Jonathan Lima", "*****@*****.**", new DateTime(1991, 11, 26), 1500.0, d1);
Seller s2 = new Seller(2, "Mozart Maia", "*****@*****.**", new DateTime(1999, 6, 4), 1500.0, d2);
Seller s3 = new Seller(3, "Daniel Amaro", "*****@*****.**", new DateTime(1995, 11, 14), 1500.0, d2);
Seller s4 = new Seller(4, "Thallita Pedreira", "*****@*****.**", new DateTime(1997, 7, 10), 1500.0, d3);
Seller s5 = new Seller(5, "Raul Luar", "*****@*****.**", new DateTime(1977, 7, 10), 1500.0, d4);
SalesRecord sr1 = new SalesRecord(1, new DateTime(2019, 10, 9), 11000.0, SaleStatus.Billed, s1);
SalesRecord sr2 = new SalesRecord(2, new DateTime(2019, 10, 10), 9000.0, SaleStatus.Billed, s2);
SalesRecord sr3 = new SalesRecord(3, new DateTime(2019, 10, 28), 7000.0, SaleStatus.Billed, s3);
SalesRecord sr4 = new SalesRecord(4, new DateTime(2019, 10, 15), 8000.0, SaleStatus.Billed, s4);
SalesRecord sr5 = new SalesRecord(5, new DateTime(2019, 10, 3), 3000.0, SaleStatus.Billed, s5);
_context.Departaments.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5);
_context.SalesRecord.AddRange(sr1, sr2, sr3, sr4, sr5);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.SalesRecord.Any() || _context.Seller.Any())
{
return; // DB já está alimentado
}
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", "*****@*****.**", new DateTime(1988, 4, 25), 1000, d1);
Seller s2 = new Seller(2, "Bruno", "*****@*****.**", new DateTime(1986, 8, 15), 1000, d2);
Seller s3 = new Seller(3, "Izabela", "*****@*****.**", new DateTime(1986, 6, 22), 1000, d3);
Seller s4 = new Seller(4, "Izadora", "*****@*****.**", new DateTime(1990, 8, 21), 1000, d4);
SalesRecord sr1 = new SalesRecord(1, new DateTime(2018, 10, 12), 9670, SaleStatus.Billed, s1);
SalesRecord sr2 = new SalesRecord(2, new DateTime(2018, 10, 12), 3320, SaleStatus.Billed, s2);
SalesRecord sr3 = new SalesRecord(3, new DateTime(2018, 10, 12), 4400, SaleStatus.Billed, s3);
SalesRecord sr4 = new SalesRecord(4, new DateTime(2018, 10, 14), 2353, SaleStatus.Billed, s4);
SalesRecord sr5 = new SalesRecord(5, new DateTime(2018, 10, 14), 2130, SaleStatus.Billed, s4);
SalesRecord sr6 = new SalesRecord(6, new DateTime(2018, 10, 14), 2330, SaleStatus.Billed, s2);
SalesRecord sr7 = new SalesRecord(7, new DateTime(2018, 10, 17), 3230, SaleStatus.Billed, s1);
SalesRecord sr8 = new SalesRecord(8, new DateTime(2018, 10, 17), 4560, SaleStatus.Billed, s3);
SalesRecord sr9 = new SalesRecord(9, new DateTime(2018, 10, 18), 2300, SaleStatus.Billed, s3);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4);
_context.SalesRecord.AddRange(sr1, sr2, sr3, sr4, sr5, sr6, sr7, sr8, sr9);
_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", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Milly", "*****@*****.**", new DateTime(2004, 2, 19), 5000.99, d3);
Seller s3 = new Seller(3, "Daniel Radcliffe", "*****@*****.**", new DateTime(1989, 7, 23), 6000.0, d4);
Seller s4 = new Seller(5, "Judi Dench", "*****@*****.**", new DateTime(1934, 12, 9), 10000.0, d2);
Seller s5 = new Seller(6, "Tilda Swinton", "*****@*****.**", new DateTime(1960, 11, 5), 8000.0, d3);
Seller s6 = new Seller(7, "Tom Holland", "*****@*****.**", new DateTime(1996, 7, 1), 11000.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, s3, 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.SallesRecord.Any())
{
return;
}
else
{
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Departamets");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1987, 10, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Weslley Alberto", "*****@*****.**", new DateTime(2000, 5, 5), 2500.99, d2);
Seller s3 = new Seller(3, "Marina Pereira", "*****@*****.**", new DateTime(1954, 10, 18), 2355.99, d3);
Seller s4 = new Seller(4, "Gabriel Bebe", "*****@*****.**", new DateTime(2010, 10, 10), 5999.85, d4);
Seller s5 = new Seller(5, "Jonas Reques", "*****@*****.**", new DateTime(1964, 05, 06), 2000.85, d4);
Seller s6 = new Seller(6, "Carcara Pereira", "*****@*****.**", new DateTime(2012, 10, 9), 2000.0, d1);
Seller s7 = new Seller(7, "Vigario Pacheco", "*****@*****.**", new DateTime(1987, 10, 7), 1555.54, d3);
Seller s8 = new Seller(8, "Marcelos Santos", "*****@*****.**", new DateTime(1995, 5, 3), 1999.99, d3);
SallesRecord r1 = new SallesRecord(1, new DateTime(2018, 9, 25), 11000.95, Models.Enuns.SallesStatus.Billed, s1);
SallesRecord r2 = new SallesRecord(2, new DateTime(2019, 1, 1), 2000.54, Models.Enuns.SallesStatus.Canceled, s2);
SallesRecord r3 = new SallesRecord(3, new DateTime(2019, 5, 4), 2544.87, Models.Enuns.SallesStatus.Peding, s8);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6, s7, s8);
_context.SallesRecord.AddRange(r1, r2, r3);
_context.SaveChanges();
}
}
public void Seed()
{
//se tem algum registro na tabela Department, Seller e SalesRecord
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Books");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Eletronics");
Seller s1 = new Seller(1, "Cali", "*****@*****.**", new DateTime(1995, 11, 19), 1600.00, d1);
Seller s2 = new Seller(2, "Claudia", "*****@*****.**", new DateTime(1996, 11, 19), 1600.00, d2);
Seller s3 = new Seller(3, "Josueh", "*****@*****.**", new DateTime(1997, 11, 19), 1600.00, d3);
SalesRecord sr1 = new SalesRecord(1, new DateTime(2021, 01, 15), 800.00, SalesStatus.Billed, s1);
SalesRecord sr2 = new SalesRecord(2, DateTime.Now, 850.00, SalesStatus.Billed, s2);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3);
_context.SalesRecord.AddRange(sr1, sr2);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; //Banco de Dados ja populado;
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Gammer");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Hygor Martins", "*****@*****.**", new DateTime(1998, 4, 21), 1000.00, d1);
Seller s2 = new Seller(2, "Tianinha Martins", "*****@*****.**", new DateTime(1979, 12, 31), 3500.00, d2);
Seller s3 = new Seller(3, "Jose Alves", "*****@*****.**", new DateTime(1988, 1, 15), 2200.00, d1);
Seller s4 = new Seller(4, "Wesley Jose", "*****@*****.**", new DateTime(1993, 11, 30), 3000.00, d4);
Seller s5 = new Seller(5, "Regiane Aparecida", "*****@*****.**", new DateTime(2000, 1, 9), 4000.00, d3);
Seller s6 = new Seller(6, "Ronaldinho Gaucho", "*****@*****.**", new DateTime(1997, 3, 4), 3000.00, 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.Departament.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // banco populado
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Eletronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
Seller s1 = new Seller(1, "Bastião", "bastiao@gmail", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Joaquina", "joaquina@gmail", new DateTime(1979, 12, 31), 1000.0, d2);
Seller s3 = new Seller(3, "Maria Antunieta", "maria@gmail", new DateTime(1988, 11, 23), 1000.0, d1);
Seller s4 = new Seller(4, "Manuel", "manuel@gmail", new DateTime(2000, 1, 16), 1000.0, d4);
Seller s5 = new Seller(5, "João das Neves", "neves@gmail", new DateTime(1964, 5, 11), 1000.0, d3);
Seller s6 = new Seller(6, "Erondina", "erondina@gmail", new DateTime(1980, 12, 25), 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.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departamento.Any() || _context.RegistroVendas.Any() || _context.Vendedor.Any())
{
return;
}
Departamento d1 = new Departamento("Informatica/Computadores");
Departamento d2 = new Departamento("Livros");
Departamento d3 = new Departamento("Modas");
Departamento d4 = new Departamento("Eletronicos");
Vendedor v1 = new Vendedor("Bob Brown", "*****@*****.**", new DateTime(1997, 4, 21), 1000.0, d1);
Vendedor v2 = new Vendedor("Charlote", "*****@*****.**", new DateTime(1997, 3, 24), 1200.0, d2);
Vendedor v3 = new Vendedor("Carlos Alberto", "*****@*****.**", new DateTime(1976, 2, 12), 1350.0, d1);
Vendedor v4 = new Vendedor("Daniel Lopes", "*****@*****.**", new DateTime(1989, 7, 13), 2199.0, d4);
Vendedor v5 = new Vendedor("Barbara Ohana", "*****@*****.**", new DateTime(1977, 3, 19), 4500.0, d3);
Vendedor v6 = new Vendedor("Matheus Vazamim", "*****@*****.**", new DateTime(1998, 10, 22), 1900.0, d2);
RegistroVendas r1 = new RegistroVendas(new DateTime(2018, 09, 25), 11000.0, VendaStatus.Faturado, v1);
RegistroVendas r2 = new RegistroVendas(new DateTime(2018, 09, 4), 7000.0, VendaStatus.Faturado, v5);
RegistroVendas r3 = new RegistroVendas(new DateTime(2018, 09, 13), 4000.0, VendaStatus.Cancelado, v4);
RegistroVendas r4 = new RegistroVendas(new DateTime(2018, 09, 1), 8000.0, VendaStatus.Faturado, v1);
RegistroVendas r5 = new RegistroVendas(new DateTime(2018, 09, 21), 3000.0, VendaStatus.Faturado, v3);
RegistroVendas r6 = new RegistroVendas(new DateTime(2018, 09, 15), 2000.0, VendaStatus.Faturado, v1);
RegistroVendas r7 = new RegistroVendas(new DateTime(2018, 09, 28), 13000.0, VendaStatus.Faturado, v2);
RegistroVendas r8 = new RegistroVendas(new DateTime(2018, 09, 11), 4000.0, VendaStatus.Faturado, v4);
RegistroVendas r9 = new RegistroVendas(new DateTime(2018, 09, 14), 11000.0, VendaStatus.Pendente, v6);
RegistroVendas r10 = new RegistroVendas(new DateTime(2018, 09, 7), 9000.0, VendaStatus.Faturado, v6);
RegistroVendas r11 = new RegistroVendas(new DateTime(2018, 09, 13), 6000.0, VendaStatus.Faturado, v2);
RegistroVendas r12 = new RegistroVendas(new DateTime(2018, 09, 25), 7000.0, VendaStatus.Pendente, v3);
RegistroVendas r13 = new RegistroVendas(new DateTime(2018, 09, 29), 10000.0, VendaStatus.Faturado, v4);
RegistroVendas r14 = new RegistroVendas(new DateTime(2018, 09, 4), 3000.0, VendaStatus.Faturado, v5);
RegistroVendas r15 = new RegistroVendas(new DateTime(2018, 09, 12), 4000.0, VendaStatus.Faturado, v1);
RegistroVendas r16 = new RegistroVendas(new DateTime(2018, 10, 5), 2000.0, VendaStatus.Faturado, v4);
RegistroVendas r17 = new RegistroVendas(new DateTime(2018, 10, 1), 12000.0, VendaStatus.Faturado, v1);
RegistroVendas r18 = new RegistroVendas(new DateTime(2018, 10, 24), 6000.0, VendaStatus.Faturado, v3);
RegistroVendas r19 = new RegistroVendas(new DateTime(2018, 10, 22), 8000.0, VendaStatus.Faturado, v5);
RegistroVendas r20 = new RegistroVendas(new DateTime(2018, 10, 15), 8000.0, VendaStatus.Faturado, v6);
RegistroVendas r21 = new RegistroVendas(new DateTime(2018, 10, 17), 9000.0, VendaStatus.Faturado, v2);
RegistroVendas r22 = new RegistroVendas(new DateTime(2018, 10, 24), 4000.0, VendaStatus.Faturado, v4);
RegistroVendas r23 = new RegistroVendas(new DateTime(2018, 10, 19), 11000.0, VendaStatus.Cancelado, v2);
RegistroVendas r24 = new RegistroVendas(new DateTime(2018, 10, 12), 8000.0, VendaStatus.Faturado, v5);
RegistroVendas r25 = new RegistroVendas(new DateTime(2018, 10, 31), 7000.0, VendaStatus.Faturado, v3);
RegistroVendas r26 = new RegistroVendas(new DateTime(2018, 10, 6), 5000.0, VendaStatus.Faturado, v4);
RegistroVendas r27 = new RegistroVendas(new DateTime(2018, 10, 13), 9000.0, VendaStatus.Pendente, v1);
RegistroVendas r28 = new RegistroVendas(new DateTime(2018, 10, 7), 4000.0, VendaStatus.Faturado, v3);
RegistroVendas r29 = new RegistroVendas(new DateTime(2018, 10, 23), 12000.0, VendaStatus.Faturado, v5);
RegistroVendas r30 = new RegistroVendas(new DateTime(2018, 10, 12), 5000.0, VendaStatus.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.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(1997, 6, 22), 1600.00, d1);
Seller s2 = new Seller(2, "Ana Bela", "*****@*****.**", new DateTime(1999, 4, 13), 1700.00, d3);
Seller s3 = new Seller(3, "Richard Melow", "*****@*****.**", new DateTime(1996, 8, 28), 1800.00, d2);
Seller s4 = new Seller(4, "Juan Robin", "*****@*****.**", new DateTime(1994, 11, 14), 2300.00, d1);
Seller s5 = new Seller(5, "Graça Alves", "*****@*****.**", new DateTime(1993, 7, 15), 1900.00, d4);
Seller s6 = new Seller(6, "Júnior Lima", "*****@*****.**", new DateTime(1997, 5, 13), 2500.00, 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;
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Tools");
Department d4 = new Department(4, "Ebooks");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 5), 1000.00, d1);
Seller s2 = new Seller(2, "Cris Nogueira", "*****@*****.**", new DateTime(1960, 3, 29), 1100.00, d2);
Seller s3 = new Seller(3, "Cicero Silva", "*****@*****.**", new DateTime(1989, 7, 12), 1200.00, d3);
Seller s4 = new Seller(4, "Josi Santos", "*****@*****.**", new DateTime(2000, 9, 6), 1300.00, d1);
Seller s5 = new Seller(5, "Danilo Barbosa", "*****@*****.**", new DateTime(1996, 11, 24), 1400.00, d2);
Seller s6 = new Seller(6, "Dimas Diogenes", "*****@*****.**", new DateTime(1991, 1, 17), 1500.00, d3);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
_context.AddRange(d1, d2, d3, d4);
_context.AddRange(s1, s2, s3, s4, s5, s6);
_context.AddRange(r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14, r15, r16, r17, r18, r19, r20, r21, r22, r23, r24, r25, r26, r27, r28, r29, r30);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; //Database ja etá populado
}
Department d1 = new Department("Computers");
Department d2 = new Department("Electronics");
Department d3 = new Department("Fashion");
Department d4 = new Department("Books");
Seller s1 = new Seller("Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller("Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller("Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Seller s4 = new Seller("Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller("Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller("Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
SalesRecord r1 = new SalesRecord(new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
_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
);
_context.SaveChanges();
}
public void seed()
{
if (_context.Departamants.Any() || _context.Seller.Any() || _context.SellerRecord.Any())
//Com isso aqui é para saber se tem alguma informação no banco de dados
{
return;
}
Departamants d1 = new Departamants(1, "Eletronics");
Departamants d2 = new Departamants(2, "Fashion");
Departamants d3 = new Departamants(3, "Books");
Departamants d4 = new Departamants(4, "Computer");
Seller ved1 = new Seller(1, "Bob brow", "*****@*****.**", 100.0, new DateTime(1998, 01, 20), d1);
Seller ved2 = new Seller(2, "kaka", "*****@*****.**", 200.0, new DateTime(1998, 09, 12), d2);
Seller ved3 = new Seller(3, "Cristiano Ronaldo", "*****@*****.**", 900.0, new DateTime(1991, 07, 14), d3);
Seller ved4 = new Seller(4, "Neymar", "*****@*****.**", 300.0, new DateTime(1994, 06, 23), d4);
SellerReacts r1 = new SellerReacts(1, new DateTime(2019, 09, 25), 1100, Status.Bilder, ved1);
SellerReacts r2 = new SellerReacts(2, new DateTime(2019, 08, 22), 2100, Status.Bilder, ved2);
SellerReacts r3 = new SellerReacts(3, new DateTime(2019, 07, 21), 1200, Status.Bilder, ved3);
SellerReacts r4 = new SellerReacts(4, new DateTime(2019, 09, 21), 1500, Status.Bilder, ved2);
SellerReacts r5 = new SellerReacts(5, new DateTime(2019, 10, 23), 1900, Status.Bilder, ved3);
SellerReacts r6 = new SellerReacts(6, new DateTime(2019, 11, 25), 1500, Status.Bilder, ved1);
SellerReacts r7 = new SellerReacts(7, new DateTime(2019, 12, 29), 1350, Status.Bilder, ved4);
SellerReacts r8 = new SellerReacts(8, new DateTime(2019, 01, 24), 1220, Status.Bilder, ved4);
SellerReacts r9 = new SellerReacts(9, new DateTime(2019, 02, 21), 1200, Status.Bilder, ved3);
SellerReacts r10 = new SellerReacts(10, new DateTime(2019, 03, 30), 1300, Status.Bilder, ved2);
SellerReacts r11 = new SellerReacts(11, new DateTime(2019, 04, 21), 1500, Status.Bilder, ved1);
SellerReacts r12 = new SellerReacts(12, new DateTime(2019, 02, 22), 1600, Status.Bilder, ved3);
SellerReacts r13 = new SellerReacts(13, new DateTime(2019, 06, 25), 1800, Status.Bilder, ved2);
SellerReacts r14 = new SellerReacts(14, new DateTime(2019, 09, 21), 1900, Status.Bilder, ved4);
SellerReacts r15 = new SellerReacts(15, new DateTime(2019, 04, 20), 1400, Status.Bilder, ved3);
SellerReacts r16 = new SellerReacts(16, new DateTime(2019, 06, 22), 1200, Status.Bilder, ved2);
SellerReacts r17 = new SellerReacts(17, new DateTime(2019, 03, 23), 1100, Status.Bilder, ved3);
SellerReacts r18 = new SellerReacts(18, new DateTime(2019, 08, 24), 1300, Status.Bilder, ved4);
SellerReacts r19 = new SellerReacts(19, new DateTime(2019, 02, 26), 1600, Status.Bilder, ved2);
SellerReacts r20 = new SellerReacts(20, new DateTime(2019, 03, 28), 1800, Status.Bilder, ved3);
SellerReacts r21 = new SellerReacts(21, new DateTime(2019, 05, 29), 1900, Status.Bilder, ved1);
SellerReacts r22 = new SellerReacts(22, new DateTime(2019, 04, 30), 1200, Status.Bilder, ved3);
SellerReacts r23 = new SellerReacts(23, new DateTime(2019, 06, 15), 1600, Status.Bilder, ved4);
SellerReacts r24 = new SellerReacts(24, new DateTime(2019, 04, 12), 5100, Status.Bilder, ved2);
SellerReacts r25 = new SellerReacts(25, new DateTime(2019, 08, 13), 6100, Status.Bilder, ved1);
SellerReacts r26 = new SellerReacts(26, new DateTime(2019, 10, 22), 9100, Status.Bilder, ved1);
SellerReacts r27 = new SellerReacts(27, new DateTime(2019, 11, 23), 15000, Status.Bilder, ved1);
SellerReacts r28 = new SellerReacts(28, new DateTime(2019, 12, 24), 11000, Status.Bilder, ved2);
SellerReacts r29 = new SellerReacts(29, new DateTime(2019, 11, 25), 16000, Status.Bilder, ved4);
SellerReacts r30 = new SellerReacts(30, new DateTime(2019, 10, 26), 11000, Status.Bilder, ved4);
_context.Departamants.AddRange(d1, d2, d3, d4);//Este metodo pertimir que voce selecione varios objetos de uma vez
_context.Seller.AddRange(ved1, ved2, ved3, ved4);
_context.SellerRecord.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();//AQUI SALVAR NO BD
}
//Método/funcão responsavel por popular a base de dados
public void Seed()
{
//Testa se existe algum registro na tabela
if (_context.Departments.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return;
}
Departments d1 = new Departments("Computers");
Departments d2 = new Departments("Electronics");
Departments d3 = new Departments("Books");
Seller s1 = new Seller("Bob", "*****@*****.**", 1000, new DateTime(1998, 4, 21), d1);
Seller s2 = new Seller("Alex", "*****@*****.**", 1500, new DateTime(1990, 7, 15), d1);
SalesRecord sr1 = new SalesRecord(new DateTime(2020, 01, 01), 1000, SaleStatus.Billed, s1);
SalesRecord sr2 = new SalesRecord(new DateTime(2020, 01, 02), 1000, SaleStatus.Canceled, s2);
SalesRecord sr3 = new SalesRecord(new DateTime(2020, 01, 03), 1000, SaleStatus.Pending, s2);
SalesRecord sr4 = new SalesRecord(new DateTime(2020, 01, 04), 1000, SaleStatus.Pending, s2);
SalesRecord sr5 = new SalesRecord(new DateTime(2020, 01, 05), 1000, SaleStatus.Pending, s2);
SalesRecord sr6 = new SalesRecord(new DateTime(2020, 01, 06), 1000, SaleStatus.Pending, s2);
SalesRecord sr7 = new SalesRecord(new DateTime(2020, 01, 07), 1000, SaleStatus.Pending, s2);
SalesRecord sr8 = new SalesRecord(new DateTime(2020, 01, 08), 1000, SaleStatus.Pending, s2);
SalesRecord sr9 = new SalesRecord(new DateTime(2020, 01, 09), 1000, SaleStatus.Canceled, s2);
SalesRecord sr10 = new SalesRecord(new DateTime(2020, 01, 10), 1000, SaleStatus.Pending, s1);
SalesRecord sr11 = new SalesRecord(new DateTime(2019, 01, 01), 10000, SaleStatus.Billed, s2);
SalesRecord sr12 = new SalesRecord(new DateTime(2019, 01, 02), 10000, SaleStatus.Billed, s1);
SalesRecord sr13 = new SalesRecord(new DateTime(2019, 01, 03), 10000, SaleStatus.Billed, s1);
SalesRecord sr14 = new SalesRecord(new DateTime(2019, 01, 04), 10000, SaleStatus.Pending, s2);
SalesRecord sr15 = new SalesRecord(new DateTime(2019, 01, 05), 10000, SaleStatus.Canceled, s1);
SalesRecord sr16 = new SalesRecord(new DateTime(2019, 01, 06), 10000, SaleStatus.Pending, s2);
SalesRecord sr17 = new SalesRecord(new DateTime(2019, 01, 07), 10000, SaleStatus.Pending, s1);
SalesRecord sr18 = new SalesRecord(new DateTime(2019, 01, 08), 10000, SaleStatus.Canceled, s2);
SalesRecord sr19 = new SalesRecord(new DateTime(2019, 01, 09), 10000, SaleStatus.Billed, s1);
SalesRecord sr20 = new SalesRecord(new DateTime(2019, 01, 10), 10000, SaleStatus.Pending, s2);
SalesRecord sr21 = new SalesRecord(new DateTime(2020, 02, 02), 500, SaleStatus.Pending, s1);
SalesRecord sr22 = new SalesRecord(new DateTime(2020, 02, 03), 500, SaleStatus.Billed, s2);
SalesRecord sr23 = new SalesRecord(new DateTime(2020, 02, 04), 500, SaleStatus.Pending, s1);
SalesRecord sr24 = new SalesRecord(new DateTime(2020, 02, 05), 500, SaleStatus.Billed, s2);
SalesRecord sr25 = new SalesRecord(new DateTime(2020, 02, 06), 500, SaleStatus.Pending, s1);
//Grava diversos objetos de uma so vez
_context.Departments.AddRange(d1, d2, d3);
_context.Seller.AddRange(s1, s2);
_context.SalesRecord.AddRange(sr1, sr2, sr3, sr4, sr5, sr6, sr7, sr8, sr9, sr10, sr11, sr12, sr13, sr14, sr15, sr16, sr17, sr18, sr19, sr20, sr21, sr22, sr23, sr24, sr25);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departments.Any() || _context.Seller.Any() || _context.SalesRecords.Any())
{
return; //Banco tem dados
}
Departments d1 = new Departments(1, "Computers");
Departments d2 = new Departments(2, "Eletronics");
Departments d3 = new Departments(3, "Fashion");
Departments d4 = new Departments(4, "Books");
Seller s1 = new Seller(1, "Bob Bro", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Anna Frank", "*****@*****.**", new DateTime(1988, 12, 1), 3000.0, d2);
Seller s3 = new Seller(3, "Carlos Slim", "*****@*****.**", new DateTime(1970, 10, 15), 5000.0, d3);
Seller s4 = new Seller(4, "Michael Owen", "*****@*****.**", new DateTime(1990, 1, 30), 2000.0, d4);
Seller s5 = new Seller(5, "John Mayer", "*****@*****.**", new DateTime(1981, 5, 6), 4000.0, d1);
Seller s6 = new Seller(6, "Kevin Durant", "*****@*****.**", new DateTime(2000, 8, 13), 6000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2019, 10, 11), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2019, 10, 12), 10000.0, SaleStatus.Billed, s2);
SalesRecord r3 = new SalesRecord(3, new DateTime(2019, 11, 15), 9000.0, SaleStatus.Billed, s1);
SalesRecord r4 = new SalesRecord(4, new DateTime(2019, 11, 11), 7000.0, SaleStatus.Billed, s2);
SalesRecord r5 = new SalesRecord(5, new DateTime(2019, 12, 25), 15000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2019, 12, 26), 31000.0, SaleStatus.Billed, s4);
SalesRecord r7 = new SalesRecord(7, new DateTime(2019, 9, 1), 1500.0, SaleStatus.Billed, s3);
SalesRecord r8 = new SalesRecord(8, new DateTime(2019, 9, 22), 1000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2019, 8, 5), 4000.0, SaleStatus.Billed, s5);
SalesRecord r10 = new SalesRecord(10, new DateTime(2019, 8, 20), 800.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2019, 7, 21), 1200.0, SaleStatus.Billed, s6);
SalesRecord r12 = new SalesRecord(12, new DateTime(2019, 7, 12), 1750.0, SaleStatus.Billed, s5);
_context.Departments.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);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departament.Any() || _context.Seller.Any() || _context.SallesRecord.Any())
{
return; //DB is already seeded
}
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 sel1 = new Seller(1, "Eduardo Hermes", "*****@*****.**", new DateTime(2000, 9, 13), 1000.00, d1);
Seller sel2 = new Seller(2, "Amanda Hermes", "*****@*****.**", new DateTime(1999, 4, 27), 1000.00, d3);
SallesRecord sale = new SallesRecord(1, new DateTime(2020, 5, 31), 11000.00, SaleStatus.Billed, sel1);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(sel1, sel2);
_context.SallesRecord.AddRange(sale);
_context.SaveChanges();
}
// operação de popular a base de dados
public void Seed()
{
// se já existe um dado na base de dados será interrompido a operação
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");
// vendedores
Seller s1 = new Seller(1, "Bod Brow", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1998, 4, 21), 2000.0, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1998, 4, 21), 3000.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1998, 4, 21), 5000.0, d4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(1998, 4, 21), 8000.0, d3);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1998, 4, 21), 3000.0, d2);
// vendas
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
// insere os dados no banco de dados
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(r1);
// salva os inserts no banco
_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, "Bob brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1);
_context.SalesRecord.AddRange(r1);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Departament.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // banco de dados ja foi populado
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Eletronics");
Departament d3 = new Departament(3, "Fashion");
Departament d4 = new Departament(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.00, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 1500.00, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1998, 4, 21), 3500.00, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 2500.00, d4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 01, 09), 4000.00, d3);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 03, 04), 3000.00, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.00, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 04), 7000.00, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.00, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.00, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.00, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.00, SaleStatus.Billed, s1);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6
);
_context.SaveChanges();
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return; // DB has been seeded
}
//Departments
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
Seller s1 = new Seller(1, "Diego Oliveira Medeiros", "*****@*****.**", new DateTime(1987, 09, 11), 1000.0, d2);
Seller s2 = new Seller(2, "Dayane Oliveira Medeiros", "*****@*****.**", new DateTime(1988, 10, 14), 1500.0, d3);
Seller s3 = new Seller(3, "Lucas Oliveira Neves", "*****@*****.**", new DateTime(1993, 07, 21), 2500.0, d1);
Seller s4 = new Seller(4, "Milane Almeida de Souza Oliveira ", "*****@*****.**", new DateTime(1998, 05, 10), 1500.0, d3);
Seller s5 = new Seller(5, "Renilda das Gracas de Oliveira", "*****@*****.**", new DateTime(1968, 07, 09), 1500.0, d3);
Seller s6 = new Seller(6, "Cecilia Oliveira Almeida", "*****@*****.**", new DateTime(2019, 07, 11), 3500.0, d4);
//Sales
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();
}
/*Operação responsável por popular a base de dados:*/
public void Seed()
{
/*Testando: se já existe algum dado na base de dados, a operação será interrompida:*/
//OBS: A operação any do linq testa se existe algum registro na tabela indicada:
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
//Apenas dar um return para cortar a execução do método:
return;
}
/*Instanciamos para depois mandar para a base de dados:*/
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Eletronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 12), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4);
Seller s5 = new Seller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3);
Seller s6 = new Seller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2);
SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5);
SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4);
SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1);
SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3);
SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1);
SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2);
SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4);
SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6);
SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6);
SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2);
SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3);
SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4);
SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5);
SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1);
SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4);
SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1);
SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3);
SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5);
SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6);
SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2);
SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4);
SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2);
SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5);
SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3);
SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4);
SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1);
SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3);
SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5);
SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2);
//Adicionando esses objetos no banco de dados:
//obs: o AddRange permite adicionar vários objetos de uma só vez:
_context.Department.AddRange(d1, d2, d3, d4);
_context.AddRange(s1, s2, s3, s4, s5, s6);
_context.SalesRecord.AddRange(
r1, r2, r3, r4, r5, r6, r7, r8, r9, r10,
r11, r12, r13, r14, r15, r16, r17, r18, r19, r20,
r21, r22, r23, r24, r25, r26, r27, r28, r29, r30
);
/*SaveChanges salva as alterações e confirma no banco de dados*/
_context.SaveChanges();
}
//Responsável por popular a base de dados
public void Seed() //Essa Seed será chamada dentro do Startup.cs no método Configure
{
//Verifica se já existe algum registro na base de dados, senão, interrompe o processo
if (_context.Department.Any() ||
_context.Seller.Any() ||
_context.SalesRecord.Any())
{
return; // DB has been seeded
}
//Como está sendo usada a metodologia "Code First", serão instanciados objetos, que depois serão incluídos no banco de dados
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);
//Depois de criados os objetos, eles serão adicionados ao banco de dados, através das operações:
_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();
}
