public async Task <IActionResult> Edit(int id, Saller saller) { if (!ModelState.IsValid) { var departaments = await _departamentservice.FindAllAsync(); var viewModel = new SellerFormViewModel { Saller = saller, Departaments = departaments }; return(View(viewModel)); } if (id != saller.Id) { return(RedirectToAction(nameof(Error), new { message = "Id não corresponde" })); } try { await _sellerService.UpdateAsync(saller); return(RedirectToAction(nameof(Index))); } catch (NotFoundException e) { return(RedirectToAction(nameof(Error), new { message = e.Message })); } catch (DbConcurrencyException e) { return(RedirectToAction(nameof(Error), new { message = e.Message })); } }
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Email,BirthDate,BaseSalary")] Saller saller) { if (id != saller.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(saller); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SallerExists(saller.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(saller)); }
public async Task <IActionResult> Edit(int Id, Saller saller) { if (!ModelState.IsValid) { var departments = await _departmentService.FindAllAsync(); var viewModels = new SallerFromViewModel { Saller = saller, Departments = departments }; return(View(viewModels)); } if (Id != saller.Id) { return(BadRequest()); } try { await _sallerService.UpdateAsync(saller); return(RedirectToAction(nameof(Index))); } catch (NotFoundException e) { return(RedirectToAction(nameof(Error), new { message = e.Message })); } catch (DbConcurrencyException e) { return(RedirectToAction(nameof(Error), new { message = e.Message })); } }
public void Seed() { if (_context.Department.Any() || _context.Saller.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"); Saller s1 = new Saller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.00, d1); Saller s2 = new Saller(2, "Julia Ramos", "*****@*****.**", new DateTime(2002, 3, 25), 10750.00, d4); Saller s3 = new Saller(3, "Fabricio Alves", "*****@*****.**", new DateTime(2000, 10, 11), 2200.00, d1); Saller s4 = new Saller(4, "Renan Geronazzo", "*****@*****.**", new DateTime(2000, 9, 15), 1200.00, d3); Saller s5 = new Saller(5, "Diego Tadeu", "*****@*****.**", new DateTime(1999, 8, 13), 1000.00, d2); Saller s6 = new Saller(6, "Matheus Armelin", "*****@*****.**", new DateTime(2001, 4, 29), 500.00, d1); 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.Saller.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 SalesRecord(int id, DateTime date, double amount, SaleStatus status, Saller saller) { Id = id; Date = date; Amount = amount; Status = status; Saller = saller; }
public void Seed() { if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecords.Any()) { return; // db ja 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"); Saller s1 = new Saller(1, "Bob Brown", "*****@*****.**", new DateTime(1998, 4, 21), 1000.0, d1); Saller s2 = new Saller(2, "Maria Green", "*****@*****.**", new DateTime(1979, 12, 31), 3500.0, d2); Saller s3 = new Saller(3, "Alex Grey", "*****@*****.**", new DateTime(1988, 1, 15), 2200.0, d1); Saller s4 = new Saller(4, "Martha Red", "*****@*****.**", new DateTime(1993, 11, 30), 3000.0, d4); Saller s5 = new Saller(5, "Donald Blue", "*****@*****.**", new DateTime(2000, 1, 9), 4000.0, d3); Saller s6 = new Saller(6, "Alex Pink", "*****@*****.**", new DateTime(1997, 3, 4), 3000.0, d2); SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SalesStatus.Billed, s1); SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SalesStatus.Billed, s5); SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SalesStatus.Canceled, s4); SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SalesStatus.Billed, s1); SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SalesStatus.Billed, s3); SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SalesStatus.Billed, s1); SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SalesStatus.Billed, s2); SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SalesStatus.Billed, s4); SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SalesStatus.Pending, s6); SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SalesStatus.Billed, s6); SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SalesStatus.Billed, s2); SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SalesStatus.Pending, s3); SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SalesStatus.Billed, s4); SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SalesStatus.Billed, s5); SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SalesStatus.Billed, s1); SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SalesStatus.Billed, s4); SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SalesStatus.Billed, s1); SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SalesStatus.Billed, s3); SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SalesStatus.Billed, s5); SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SalesStatus.Billed, s6); SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SalesStatus.Billed, s2); SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SalesStatus.Billed, s4); SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SalesStatus.Canceled, s2); SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SalesStatus.Billed, s5); SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SalesStatus.Billed, s3); SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SalesStatus.Billed, s4); SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SalesStatus.Pending, s1); SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SalesStatus.Billed, s3); SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SalesStatus.Billed, s5); SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SalesStatus.Billed, s2); _context.Department.AddRange(d1, d2, d3, d4); _context.Seller.AddRange(s1, s2, s3, s4, s5, s6); _context.SalesRecords.AddRange(r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14, r15, r16, r17, r18, r19, r20, r21, r22, r23, r24, r25, r26, r27, r28, r29, r30); _context.SaveChanges(); }
public async Task <IActionResult> Create([Bind("Id,Name,Email,BirthDate,BaseSalary")] Saller saller) { if (ModelState.IsValid) { _context.Add(saller); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(saller)); }
public async Task <IActionResult> Create(Saller saller) { if (!ModelState.IsValid) { var departaments = await _departamentservice.FindAllAsync(); var viewModel = new SellerFormViewModel { Saller = saller, Departaments = departaments }; return(View(viewModel)); } await _sellerService.InsertAsync(saller); return(RedirectToAction(nameof(Index))); }
public async Task UpdateAsync(Saller obj) { bool hasAny = await _context.Saller.AnyAsync(x => x.Id == obj.Id); if (!hasAny) { throw new NotFoundException("Id não encontrado"); } try { _context.Update(obj); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException e) { throw new DbConcurrencyException(e.Message); } }
public void Seed() { //usa o linq para testar se existe registro na tabela if (_context.Department.Any() || _context.Saller.Any() || _context.SalesRecord.Any() || _context.Product.Any()) { return;//este retorno mata a instrucão e o méthodo } //Departamentos Department d1 = new Department(1, "Informática"); Department d2 = new Department(2, "Recurssos Humanos"); Department d3 = new Department(3, "Marketing"); Department d4 = new Department(4, "Contabilidade"); Department d5 = new Department(5, "Financeiro"); Department d6 = new Department(6, "Almoxarifado"); Department d7 = new Department(7, "Desenvolvimento"); //vendedores Saller s1 = new Saller(1, "Renato de Azevedo", "*****@*****.**", new DateTime(1982, 6, 11), 1000.00, d7); Saller s2 = new Saller(2, "Francisco Junior", "*****@*****.**", new DateTime(1982, 6, 11), 1050.00, d7); Saller s3 = new Saller(3, "Roger Guerra", "*****@*****.**", new DateTime(1982, 6, 11), 1700.00, d1); Saller s4 = new Saller(4, "Lucas Pinto", "*****@*****.**", new DateTime(1982, 6, 11), 2000.00, d1); //vendas SalesRecord r1 = new SalesRecord(1, new DateTime(2020, 6, 30), 5000.0, SaleStatus.Billed, s1); SalesRecord r2 = new SalesRecord(2, new DateTime(2020, 6, 30), 5000.0, SaleStatus.Pending, s1); SalesRecord r3 = new SalesRecord(3, new DateTime(2020, 6, 30), 5000.0, SaleStatus.Billed, s2); SalesRecord r4 = new SalesRecord(4, new DateTime(2020, 6, 30), 5000.0, SaleStatus.Canceled, s2); //produtos Product p1 = new Product(1, "000000000001", "Caneta", "Caneta Esferografica Bique", 1.00, 2.00, 550, true, new DateTime(2020, 6, 23)); Product p2 = new Product(2, "000000000002", "Borracha", "Faber Castel", 0.50, 1.50, 550, true, new DateTime(2020, 6, 23)); Product p3 = new Product(3, "000000000003", "PenDriver", "Scan DSK", 10.00, 25.00, 25, true, new DateTime(2020, 6, 23)); Product p4 = new Product(4, "000000000004", "Calculadora", "Calculadora h3 bit", 15.00, 32.00, 100, true, new DateTime(2020, 6, 23)); //add _context.Department.AddRange(d1, d2, d3, d4, d5, d6, d7); _context.Saller.AddRange(s1, s2, s3, s4); _context.SalesRecord.AddRange(r1, r2, r3, r4); _context.Product.AddRange(p1, p2, p3, p4); _context.SaveChanges(); }
public void Seed() { if (_context.Departament.Any() || _context.SalesRecord.Any() || _context.Saller.Any()) { return; } Departament d1 = new Departament(new int(), "Eletronics"); Departament d2 = new Departament(new int(), "Ferramentas"); Saller s1 = new Saller(new int(), "Danilo", "*****@*****.**", new DateTime(1999, 3, 12), 1234.00, d1); Saller s2 = new Saller(new int(), "Tais", "*****@*****.**", new DateTime(1999, 3, 12), 1234.00, d2); SalesRecord w1 = new SalesRecord(new int(), new DateTime(23, 11, 12), 1200.00, SalesStatus.Pending, s1); SalesRecord w2 = new SalesRecord(new int(), new DateTime(23, 11, 12), 1100.00, SalesStatus.Billed, s2); _context.Departament.AddRange(d1, d2); _context.Saller.AddRange(s1, s2); _context.SalesRecord.AddRange(w1, w2); _context.SaveChanges(); }
public async Task InsertAsync(Saller saller) { _context.Add(saller); await _context.SaveChangesAsync(); }
public void Seed() { if (_context.Department.Any() || _context.Saller.Any() || _context.SalesRecords.Any()) { return; } Department d1 = new Department(1, "Computers"); Department d2 = new Department(2, "Electronics"); Department d3 = new Department(3, "Fashion"); Department d4 = new Department(4, "Books"); Saller s1 = new Saller(1, "Bob Brown", "*****@*****.**", 1000, new DateTime(1998, 4, 21), d1); Saller s2 = new Saller(2, "Maria Green", "*****@*****.**", 3500.0, new DateTime(1979, 12, 31), d2); Saller s3 = new Saller(3, "Alex Grey", "*****@*****.**", 2200.0, new DateTime(1988, 1, 15), d1); Saller s4 = new Saller(4, "Martha Red", "*****@*****.**", 3000.0, new DateTime(1993, 11, 30), d4); Saller s5 = new Saller(5, "Donald Blue", "*****@*****.**", 4000.0, new DateTime(2000, 1, 9), d3); Saller s6 = new Saller(6, "Alex Pink", "*****@*****.**", 3000.0, new DateTime(1997, 3, 4), d2); Saller s7 = new Saller(7, "Marcelo Fiats", "*****@*****.**", 3000.0, new DateTime(1987, 2, 19), d1); Saller s8 = new Saller(6, "Fernando Baioco", "*****@*****.**", 2000.0, new DateTime(2000, 8, 12), d2); Saller s9 = new Saller(6, "Daniel Vendan", "*****@*****.**", 5000.0, new DateTime(1995, 3, 18), d1); Saller s10 = new Saller(6, "Verônica Fiats", "*****@*****.**", 4000.0, new DateTime(1991, 12, 13), d3); Saller s11 = new Saller(6, "Madalena", "*****@*****.**", 2500.0, new DateTime(1960, 7, 20), d4); SalesRecord r1 = new SalesRecord(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1); SalesRecord r2 = new SalesRecord(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5); SalesRecord r3 = new SalesRecord(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4); SalesRecord r4 = new SalesRecord(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1); SalesRecord r5 = new SalesRecord(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3); SalesRecord r6 = new SalesRecord(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1); SalesRecord r7 = new SalesRecord(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2); SalesRecord r8 = new SalesRecord(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4); SalesRecord r9 = new SalesRecord(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6); SalesRecord r10 = new SalesRecord(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6); SalesRecord r11 = new SalesRecord(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2); SalesRecord r12 = new SalesRecord(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3); SalesRecord r13 = new SalesRecord(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4); SalesRecord r14 = new SalesRecord(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5); SalesRecord r15 = new SalesRecord(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1); SalesRecord r16 = new SalesRecord(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4); SalesRecord r17 = new SalesRecord(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1); SalesRecord r18 = new SalesRecord(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3); SalesRecord r19 = new SalesRecord(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5); SalesRecord r20 = new SalesRecord(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6); SalesRecord r21 = new SalesRecord(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2); SalesRecord r22 = new SalesRecord(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4); SalesRecord r23 = new SalesRecord(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2); SalesRecord r24 = new SalesRecord(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5); SalesRecord r25 = new SalesRecord(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3); SalesRecord r26 = new SalesRecord(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4); SalesRecord r27 = new SalesRecord(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1); SalesRecord r28 = new SalesRecord(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3); SalesRecord r29 = new SalesRecord(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5); SalesRecord r30 = new SalesRecord(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2); SalesRecord r31 = new SalesRecord(31, new DateTime(2018, 11, 12), 22000.0, SaleStatus.Billed, s7); SalesRecord r32 = new SalesRecord(32, new DateTime(2018, 11, 13), 9000.0, SaleStatus.Billed, s7); SalesRecord r33 = new SalesRecord(33, new DateTime(2018, 11, 24), 4000.0, SaleStatus.Billed, s8); SalesRecord r34 = new SalesRecord(34, new DateTime(2018, 11, 19), 11000.0, SaleStatus.Canceled, s9); SalesRecord r35 = new SalesRecord(35, new DateTime(2018, 11, 12), 8000.0, SaleStatus.Billed, s11); SalesRecord r36 = new SalesRecord(36, new DateTime(2018, 11, 31), 7000.0, SaleStatus.Billed, s11); SalesRecord r37 = new SalesRecord(37, new DateTime(2018, 11, 6), 5000.0, SaleStatus.Billed, s11); SalesRecord r38 = new SalesRecord(38, new DateTime(2018, 11, 13), 9000.0, SaleStatus.Pending, s10); SalesRecord r39 = new SalesRecord(39, new DateTime(2018, 11, 7), 4000.0, SaleStatus.Billed, s10); SalesRecord r40 = new SalesRecord(40, new DateTime(2018, 11, 23), 12000.0, SaleStatus.Billed, s10); SalesRecord r41 = new SalesRecord(41, new DateTime(2018, 11, 12), 5000.0, SaleStatus.Billed, s9); _context.Department.AddRange(d1, d2, d3, d4); _context.Saller.AddRange(s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11); _context.SalesRecords.AddRange( r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14, r15, r16, r17, r18, r19, r20, r21, r22, r23, r24, r25, r26, r27, r28, r29, r30, r31, r32, r33, r34, r35, r36, r37, r38, r39, r40, r41 ); _context.SaveChanges(); }
public static List <string[]> Main_(string member) { List <string[]> result = new List <string[]>(); Entity[] temp; switch (member) { case "Buyer": BuyerRepository buyer = new BuyerRepository(Global.ConnectionStringSql, Global.ProviderName); temp = buyer.GetAll().ToArray <Entity>(); Buyer[] buyers = new Buyer[temp.Length]; for (int i = 0; i < temp.Length; i++) { buyers[i] = (Buyer)temp[i]; } for (int i = 0; i < buyers.Length; i++) { result.Add(new string[5]); result[i][0] = buyers[i].Id.ToString(); result[i][1] = buyers[i].CreationDate.ToString(); result[i][2] = buyers[i].DeletedDate.ToString(); result[i][3] = buyers[i].Name.ToString(); result[i][4] = buyers[i].Surname.ToString(); } break; case "Deal": DealRepository deal = new DealRepository(Global.ConnectionStringSql, Global.ProviderName); temp = deal.GetAll().ToArray <Entity>(); Deal[] deals = new Deal[temp.Length]; for (int i = 0; i < temp.Length; i++) { deals[i] = (Deal)temp[i]; } for (int i = 0; i < deals.Length; i++) { result.Add(new string[7]); result[i][0] = deals[i].Id.ToString(); result[i][1] = deals[i].CreationDate.ToString(); //result[i][2] = deals[i].DeletedDate.ToString(); result[i][3] = deals[i].IdBuyer.ToString(); result[i][4] = deals[i].IdSeller.ToString(); result[i][5] = deals[i].Summ.ToString(); result[i][6] = deals[i].Date.ToString(); } break; case "Saller": SallerRepository saller = new SallerRepository(Global.ConnectionStringSql, Global.ProviderName); temp = saller.GetAll().ToArray <Entity>(); Saller[] sallers = new Saller[temp.Length]; for (int i = 0; i < temp.Length; i++) { sallers[i] = (Saller)temp[i]; } for (int i = 0; i < sallers.Length; i++) { result.Add(new string[5]); result[i][0] = sallers[i].Id.ToString(); result[i][1] = sallers[i].CreationDate.ToString(); //result[i][2] = sallers[i].DeletedDate.ToString(); result[i][3] = sallers[i].Name.ToString(); result[i][4] = sallers[i].Surname.ToString(); } break; } return(result); }
public void RemovSaller(Saller saller) { Sallers.Remove(saller); }
public void AddSaller(Saller saller) { Sallers.Add(saller); }