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()
{
if (_context.Departament.Any() || _context.Seller.Any() || _context.SellesRecord.Any())
{
return;
}
Departament d1 = new Departament(1, "Computeres");
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, "Bob Brown2", "*****@*****.**", new DateTime(1998, 4, 21), 2000.0, d2);
Seller s3 = new Seller(3, "Bob Brown3", "*****@*****.**", new DateTime(1998, 4, 21), 3000.0, d2);
Seller s4 = new Seller(4, "Bob Brown4", "*****@*****.**", new DateTime(1998, 4, 21), 4000.0, d3);
SallesRecord r1 = new SallesRecord(1, new DateTime(2018, 12, 1), 11000.00, SalleStatusEnum.Billed, s1);
SallesRecord r2 = new SallesRecord(2, new DateTime(2018, 12, 1), 11000.00, SalleStatusEnum.Billed, s2);
SallesRecord r3 = new SallesRecord(3, new DateTime(2018, 12, 1), 11000.00, SalleStatusEnum.Billed, s3);
SallesRecord r4 = new SallesRecord(4, new DateTime(2018, 12, 1), 11000.00, SalleStatusEnum.Billed, s4);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4);
_context.SellesRecord.AddRange(r1, r2, r3, r4);
_context.SaveChanges();
}
public async Task <IActionResult> Edit(int id, [Bind("id,Date,Amount,Status")] SallesRecord sallesRecord)
{
if (id != sallesRecord.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(sallesRecord);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SallesRecordExists(sallesRecord.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(sallesRecord));
}
public void Seed()
{
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SallesRecords.Any())
{
return; // Banco has been seeded.
}
Departament d1 = new Departament(1, "Computers");
Departament d2 = new Departament(2, "Electronics");
Seller s1 = new Seller(1, "Alexandre", "*****@*****.**", 1000.00, new DateTime(1998, 12, 03), d1);
Seller s2 = new Seller(2, "Amanda", "*****@*****.**", 2000.00, new DateTime(1998, 12, 03), d2);
SallesRecord r1 = new SallesRecord(1, new DateTime(2018, 09, 25), 1000.00, SaleStatus.Billed, s1);
SallesRecord r2 = new SallesRecord(2, new DateTime(2015, 09, 25), 1000.00, SaleStatus.Billed, s2);
SallesRecord r3 = new SallesRecord(3, new DateTime(2019, 09, 25), 1000.00, SaleStatus.Billed, s1);
_context.Departament.AddRange(d1, d2);
_context.Seller.AddRange(s1, s2);
_context.SallesRecords.AddRange(r1, r2, r3);
_context.SaveChanges();
}
public async Task <IActionResult> Create([Bind("id,Date,Amount,Status")] SallesRecord sallesRecord)
{
if (ModelState.IsValid)
{
_context.Add(sallesRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(sallesRecord));
}
public void Seed()
{
if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any())
{
return;//DB HAS BEEN SEEDED
}
Department d1 = new Department(1, "Computers");
Department d2 = new Department(2, "Electronics");
Department d3 = new Department(3, "Fashion");
Department d4 = new Department(4, "Books");
Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2);
Seller s3 = new Seller(3, "Alex Gray", "*****@*****.**", new DateTime(1988, 1, 15), 3000.0, d1);
Seller s4 = new Seller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 2200.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);
SallesRecord r1 = new SallesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1);
SallesRecord r2 = new SallesRecord(2, new DateTime(2018, 10, 10), 10000.0, SaleStatus.Pending, s3);
SallesRecord r3 = new SallesRecord(3, new DateTime(2018, 10, 11), 40000.0, SaleStatus.Pending, s4);
SallesRecord r4 = new SallesRecord(4, new DateTime(2018, 10, 12), 70000.0, SaleStatus.Pending, s2);
SallesRecord r5 = new SallesRecord(5, new DateTime(2018, 10, 13), 20000.0, SaleStatus.Billed, s6);
SallesRecord r6 = new SallesRecord(6, new DateTime(2018, 10, 14), 90000.0, SaleStatus.Billed, s5);
SallesRecord r7 = new SallesRecord(7, new DateTime(2018, 10, 15), 30000.0, SaleStatus.Canceled, s1);
SallesRecord r8 = new SallesRecord(8, new DateTime(2018, 10, 16), 50000.0, SaleStatus.Canceled, s2);
SallesRecord r9 = new SallesRecord(9, new DateTime(2018, 10, 17), 12000.0, SaleStatus.Pending, s3);
SallesRecord r10 = new SallesRecord(10, new DateTime(2018, 10, 18), 13000.0, SaleStatus.Billed, s4);
SallesRecord r11 = new SallesRecord(11, new DateTime(2018, 10, 19), 14000.0, SaleStatus.Billed, s5);
SallesRecord r12 = new SallesRecord(12, new DateTime(2018, 10, 20), 15000.0, SaleStatus.Canceled, s6);
SallesRecord r13 = new SallesRecord(13, new DateTime(2018, 10, 21), 16000.0, SaleStatus.Canceled, s2);
SallesRecord r14 = new SallesRecord(14, new DateTime(2018, 10, 22), 17000.0, SaleStatus.Pending, s6);
SallesRecord r15 = new SallesRecord(15, new DateTime(2018, 10, 23), 18000.0, SaleStatus.Billed, s3);
SallesRecord r16 = new SallesRecord(16, new DateTime(2018, 10, 24), 19000.0, SaleStatus.Billed, s4);
SallesRecord r17 = new SallesRecord(17, new DateTime(2018, 10, 25), 20000.0, SaleStatus.Pending, s1);
SallesRecord r18 = new SallesRecord(18, new DateTime(2018, 10, 26), 21000.0, SaleStatus.Canceled, s1);
SallesRecord r19 = new SallesRecord(19, new DateTime(2018, 10, 27), 22000.0, SaleStatus.Billed, s2);
SallesRecord r20 = new SallesRecord(20, new DateTime(2018, 10, 28), 23000.0, SaleStatus.Canceled, s3);
SallesRecord r21 = new SallesRecord(21, new DateTime(2018, 10, 29), 24000.0, SaleStatus.Pending, s4);
SallesRecord r22 = new SallesRecord(22, new DateTime(2018, 10, 30), 25000.0, SaleStatus.Pending, s5);
SallesRecord r23 = new SallesRecord(23, new DateTime(2018, 10, 31), 26000.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, r21, r22, r23); // add range serve para mandar um grupo de argumentos
_context.SaveChanges(); // save changes pra salvar no banco de dados
}
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();
}
public void Seed()
{
//testar se existe dados na tabela
if (_context.Departament.Any() ||
_context.Seller.Any() ||
_context.SallesRecord.Any())
{
return; // A base de dados Já foi populada
}
Departament d1 = new Departament(1, "TI", "Alberto");
Departament d2 = new Departament(2, "Impressão", "João");
Departament d3 = new Departament(3, "Pesos e Medidas", "Maria");
Departament d4 = new Departament(4, "Suprimentos", "Carlos");
Seller s1 = new Seller(1, "Vendedor Sistema", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1);
Seller s2 = new Seller(2, "Vendedor Sistema1", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d2);
Seller s3 = new Seller(3, "Vendedor Sistema2", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d3);
Seller s4 = new Seller(4, "Vendedor Sistema3", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d4);
SallesRecord r1 = new SallesRecord(1, new DateTime(1998, 1, 21), 11000.0, SaleStatus.Billed, s1);
SallesRecord r2 = new SallesRecord(2, new DateTime(1998, 1, 20), 11000.0, SaleStatus.Billed, s2);
SallesRecord r3 = new SallesRecord(3, new DateTime(1998, 1, 21), 11000.0, SaleStatus.Billed, s3);
SallesRecord r4 = new SallesRecord(4, new DateTime(1998, 1, 27), 11000.0, SaleStatus.Billed, s4);
_context.Departament.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4);
_context.SallesRecord.AddRange(r1, r2, r3, r4);
_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, "Fashio");
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);
SallesRecord r1 = new SallesRecord(1, new DateTime(2018, 09, 25), 11000.0, SalleStatus.Billed, s1);
SallesRecord r2 = new SallesRecord(2, new DateTime(2018, 09, 4), 7000.0, SalleStatus.Billed, s5);
SallesRecord r3 = new SallesRecord(3, new DateTime(2018, 09, 13), 4000.0, SalleStatus.Canceled, s4);
SallesRecord r4 = new SallesRecord(4, new DateTime(2018, 09, 1), 8000.0, SalleStatus.Billed, s1);
SallesRecord r5 = new SallesRecord(5, new DateTime(2018, 09, 21), 3000.0, SalleStatus.Billed, s3);
SallesRecord r6 = new SallesRecord(6, new DateTime(2018, 09, 15), 2000.0, SalleStatus.Billed, s1);
SallesRecord r7 = new SallesRecord(7, new DateTime(2018, 09, 28), 13000.0, SalleStatus.Billed, s2);
SallesRecord r8 = new SallesRecord(8, new DateTime(2018, 09, 11), 4000.0, SalleStatus.Billed, s4);
SallesRecord r9 = new SallesRecord(9, new DateTime(2018, 09, 14), 11000.0, SalleStatus.Pending, s6);
SallesRecord r10 = new SallesRecord(10, new DateTime(2018, 09, 7), 9000.0, SalleStatus.Billed, s6);
SallesRecord r11 = new SallesRecord(11, new DateTime(2018, 09, 13), 6000.0, SalleStatus.Billed, s2);
SallesRecord r12 = new SallesRecord(12, new DateTime(2018, 09, 25), 7000.0, SalleStatus.Pending, s3);
SallesRecord r13 = new SallesRecord(13, new DateTime(2018, 09, 29), 10000.0, SalleStatus.Billed, s4);
SallesRecord r14 = new SallesRecord(14, new DateTime(2018, 09, 4), 3000.0, SalleStatus.Billed, s5);
SallesRecord r15 = new SallesRecord(15, new DateTime(2018, 09, 12), 4000.0, SalleStatus.Billed, s1);
SallesRecord r16 = new SallesRecord(16, new DateTime(2018, 10, 5), 2000.0, SalleStatus.Billed, s4);
SallesRecord r17 = new SallesRecord(17, new DateTime(2018, 10, 1), 12000.0, SalleStatus.Billed, s1);
SallesRecord r18 = new SallesRecord(18, new DateTime(2018, 10, 24), 6000.0, SalleStatus.Billed, s3);
SallesRecord r19 = new SallesRecord(19, new DateTime(2018, 10, 22), 8000.0, SalleStatus.Billed, s5);
SallesRecord r20 = new SallesRecord(20, new DateTime(2018, 10, 15), 8000.0, SalleStatus.Billed, s6);
SallesRecord r21 = new SallesRecord(21, new DateTime(2018, 10, 17), 9000.0, SalleStatus.Billed, s2);
SallesRecord r22 = new SallesRecord(22, new DateTime(2018, 10, 24), 4000.0, SalleStatus.Billed, s4);
SallesRecord r23 = new SallesRecord(23, new DateTime(2018, 10, 19), 11000.0, SalleStatus.Canceled, s2);
SallesRecord r24 = new SallesRecord(24, new DateTime(2018, 10, 12), 8000.0, SalleStatus.Billed, s5);
SallesRecord r25 = new SallesRecord(25, new DateTime(2018, 10, 31), 7000.0, SalleStatus.Billed, s3);
SallesRecord r26 = new SallesRecord(26, new DateTime(2018, 10, 6), 5000.0, SalleStatus.Billed, s4);
SallesRecord r27 = new SallesRecord(27, new DateTime(2018, 10, 13), 9000.0, SalleStatus.Pending, s1);
SallesRecord r28 = new SallesRecord(28, new DateTime(2018, 10, 7), 4000.0, SalleStatus.Billed, s3);
SallesRecord r29 = new SallesRecord(29, new DateTime(2018, 10, 23), 12000.0, SalleStatus.Billed, s5);
SallesRecord r30 = new SallesRecord(30, new DateTime(2018, 10, 12), 5000.0, SalleStatus.Billed, s2);
_context.Department.AddRange(d1, d2, d3, d4);
_context.Seller.AddRange(s1, s2, s3, s4, 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();
}
