public void Seed() { //validação pra saber se o banco de dados já foi populado 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, "Financeiro"); Department d3 = new Department(3, "Vendas"); Department d4 = new Department(4, "Marketing"); Seller s1 = new Seller(1, "Bruno", "*****@*****.**", new DateTime(1987, 8, 14), 10.000, d1); Seller s2 = new Seller(2, "Guilherme", "*****@*****.**", new DateTime(1987, 7, 14), 1.000, d2); Seller s3 = new Seller(3, "Gabriel", "*****@*****.**", new DateTime(1987, 9, 14), 1.000, d3); Seller s4 = new Seller(4, "Felipe", "*****@*****.**", new DateTime(1987, 6, 14), 7.000, d2); SalesRecords sr1 = new SalesRecords(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s4); SalesRecords sr2 = new SalesRecords(2, new DateTime(2018, 09, 28), 1000.0, SaleStatus.Billed, s2); SalesRecords sr3 = new SalesRecords(3, new DateTime(2018, 08, 25), 1000.0, SaleStatus.Billed, s1); SalesRecords sr4 = new SalesRecords(4, new DateTime(2018, 12, 25), 711000.0, SaleStatus.Billed, s3); SalesRecords sr5 = new SalesRecords(5, new DateTime(2018, 10, 25), 11.0, SaleStatus.Billed, s2); _context.Department.AddRange(d1, d2, d3, d4); _context.Seller.AddRange(s1, s2, s3, s4); _context.SalesRecord.AddRange(sr1, sr2, sr3, sr4, sr5); _context.SaveChanges(); }
//add to sales button clicked private void AddToSalesButton_Click(object sender, EventArgs e) { try { string ItemName = this.billingName.Text; string Category = this.billingCategory.Text; int Quantity = Convert.ToInt32(billingQuantity.Text); double Price = helper.GetPrice(RecordsGridView, ItemName, ItemNameColumn.Index, ItemPriceColumn.Index); if (ItemName != null && ItemName != "" && Category != null && Category != "" && Quantity >= 0) { //create new instance of SalesRecords for (int i = 1; i <= Quantity; i++) { int RowIndex = helper.GetEmptyRowIndex(SalesGridView); salesRecords = new SalesRecords(ItemName, Category, Price); salesRecords.AddToRecords(RowIndex, SalesGridView); } MessageBox.Show("Given items has been sold", "Item Sold", MessageBoxButtons.OK, MessageBoxIcon.Information); helper.ClearFields(billingQuantity); GenerateChart(); } else { MessageBox.Show("Please fill up all fields properly.", "Fields Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (FormatException) { MessageBox.Show("Please enter a valid quantity.", "Invalid quantity", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Seed() { if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecords.Any()) { return; //o Banco de Dados já foi populado! } Department d1 = new Department(1, "Computers"); Department d2 = new Department(2, "Electronics"); Department d3 = new Department(3, "Fashion"); Department d4 = new Department(4, "Books"); Seller s1 = new Seller(1, "Bob Marley", "*****@*****.**", new DateTime(1998, 04, 21), 1000.00, d4); Seller s2 = new Seller(2, "Camila Barbosa", "*****@*****.**", new DateTime(1991, 03, 21), 5000.00, d3); Seller s3 = new Seller(3, "John Doe", "*****@*****.**", new DateTime(1989, 02, 02), 4000.00, d1); Seller s4 = new Seller(4, "Petter Kim", "*****@*****.**", new DateTime(1985, 08, 15), 17000.00, d2); SalesRecords r1 = new SalesRecords(1, new DateTime(2018, 09, 25), 5000.0, Models.Enums.SaleStatus.Billed, s1); SalesRecords r2 = new SalesRecords(2, new DateTime(2018, 01, 15), 12000.0, Models.Enums.SaleStatus.Billed, s2); SalesRecords r3 = new SalesRecords(3, new DateTime(2018, 05, 05), 30000.0, Models.Enums.SaleStatus.Billed, s3); SalesRecords r4 = new SalesRecords(4, new DateTime(2018, 02, 10), 1000.0, Models.Enums.SaleStatus.Billed, s4); _context.Department.AddRange(d1, d2, d4); _context.Seller.AddRange(s1, s2, s3, s4); _context.SalesRecords.AddRange(r1, r2, r3, r4); _context.SaveChanges(); }
public void Seed() { if (_context.Department.Any() || _context.SalesRecords.Any() || _context.Seller.Any()) { return; // DB ja populado } Department d1 = new Department(1, "Eletronics"); Department d2 = new Department(2, "Fashion"); Department d3 = new Department(3, "Books"); Department d4 = new Department(4, "Machines"); Seller s1 = new Seller(1, "Bob Brown", "*****@*****.**", new DateTime(1997, 6, 25), 900.00, d1); Seller s2 = new Seller(2, "Maisa Brown", "*****@*****.**", new DateTime(1997, 6, 25), 300.00, d2); Seller s3 = new Seller(3, "Lucas Purpule", "*****@*****.**", new DateTime(1997, 6, 25), 200.00, d3); Seller s4 = new Seller(4, "Maicon Green", "*****@*****.**", new DateTime(1997, 6, 25), 11100.00, d4); SalesRecords sr1 = new SalesRecords(1, new DateTime(2020, 2, 16), 25000, SaleStatus.Billed, s1); SalesRecords sr2 = new SalesRecords(2, new DateTime(2020, 4, 6), 2225000, SaleStatus.Canceled, s2); SalesRecords sr3 = new SalesRecords(3, new DateTime(2020, 6, 21), 15000, SaleStatus.Pending, s1); _context.Department.AddRange(d1, d2, d3, d4); _context.Seller.AddRange(s1, s2, s3, s4); _context.SalesRecords.AddRange(sr1, sr2, sr3); _context.SaveChanges(); }
public void Seed() { // Checking if there are registers if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecord.Any()) { return; // Database has been populated } Department d1 = new Department(1, "Eletronics"); Department d2 = new Department(2, "Tools"); Department d3 = new Department(3, "Computers"); Department d4 = new Department(4, "Books"); Seller s1 = new Seller(1, "Wag Serrano", "*****@*****.**", new DateTime(1993, 11, 16), 10000.0, d3); Seller s2 = new Seller(2, "Cam Serrano", "*****@*****.**", new DateTime(2000, 9, 24), 8500.0, d1); Seller s3 = new Seller(3, "Ryan Serrano", "*****@*****.**", new DateTime(2000, 11, 16), 5000.0, d2); Seller s4 = new Seller(4, "Renzo Serrano", "*****@*****.**", new DateTime(2000, 11, 16), 10000.0, d2); Seller s5 = new Seller(5, "Ralph Serrano", "*****@*****.**", new DateTime(2000, 11, 16), 10000.0, d4); Seller s6 = new Seller(6, "Rickson Serrano", "*****@*****.**", new DateTime(2000, 11, 16), 10000.0, d4); //SalesRecord sr1 = new SalesRecord(1, new DateTime(2020, 9, 21), 10000.0, Models.Enums.SaleStatus.Billed, s1); SalesRecords sr1 = new SalesRecords(1, new DateTime(2020, 9, 21), 10000.0, SaleStatus.Billed, s1); SalesRecords sr2 = new SalesRecords(2, new DateTime(2020, 9, 21), 17000.0, SaleStatus.Billed, s2); SalesRecords sr3 = new SalesRecords(3, new DateTime(2020, 9, 21), 8000.0, SaleStatus.Billed, s3); SalesRecords sr4 = new SalesRecords(4, new DateTime(2020, 9, 21), 6500.0, SaleStatus.Billed, s4); SalesRecords sr5 = new SalesRecords(5, new DateTime(2020, 9, 21), 12000.0, SaleStatus.Billed, s5); SalesRecords sr6 = new SalesRecords(6, new DateTime(2020, 9, 21), 9000.0, SaleStatus.Billed, s6); _context.Department.AddRange(d1, d2, d3, d4); _context.Seller.AddRange(s1, s2, s3, s4, s5, s6); _context.SalesRecord.AddRange(sr1, sr2, sr3, sr4, sr5, sr6); _context.SaveChanges(); }
public void Seed() { if (_context.Department.Any() || _context.Seller.Any() || _context.SalesRecords.Any()) { return; // DB has been seeded } Department d1 = new Department(1, "Computers"); Department d2 = new Department(2, "Eletronics"); Department d3 = new Department(3, "Fashion"); Department d4 = new Department(4, "Books"); Seller s1 = new Seller(1, "Bob 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); SalesRecords r1 = new SalesRecords(1, new DateTime(2018, 09, 25), 11000.0, SaleStatus.Billed, s1); SalesRecords r2 = new SalesRecords(2, new DateTime(2018, 09, 4), 7000.0, SaleStatus.Billed, s5); SalesRecords r3 = new SalesRecords(3, new DateTime(2018, 09, 13), 4000.0, SaleStatus.Canceled, s4); SalesRecords r4 = new SalesRecords(4, new DateTime(2018, 09, 1), 8000.0, SaleStatus.Billed, s1); SalesRecords r5 = new SalesRecords(5, new DateTime(2018, 09, 21), 3000.0, SaleStatus.Billed, s3); SalesRecords r6 = new SalesRecords(6, new DateTime(2018, 09, 15), 2000.0, SaleStatus.Billed, s1); SalesRecords r7 = new SalesRecords(7, new DateTime(2018, 09, 28), 13000.0, SaleStatus.Billed, s2); SalesRecords r8 = new SalesRecords(8, new DateTime(2018, 09, 11), 4000.0, SaleStatus.Billed, s4); SalesRecords r9 = new SalesRecords(9, new DateTime(2018, 09, 14), 11000.0, SaleStatus.Pending, s6); SalesRecords r10 = new SalesRecords(10, new DateTime(2018, 09, 7), 9000.0, SaleStatus.Billed, s6); SalesRecords r11 = new SalesRecords(11, new DateTime(2018, 09, 13), 6000.0, SaleStatus.Billed, s2); SalesRecords r12 = new SalesRecords(12, new DateTime(2018, 09, 25), 7000.0, SaleStatus.Pending, s3); SalesRecords r13 = new SalesRecords(13, new DateTime(2018, 09, 29), 10000.0, SaleStatus.Billed, s4); SalesRecords r14 = new SalesRecords(14, new DateTime(2018, 09, 4), 3000.0, SaleStatus.Billed, s5); SalesRecords r15 = new SalesRecords(15, new DateTime(2018, 09, 12), 4000.0, SaleStatus.Billed, s1); SalesRecords r16 = new SalesRecords(16, new DateTime(2018, 10, 5), 2000.0, SaleStatus.Billed, s4); SalesRecords r17 = new SalesRecords(17, new DateTime(2018, 10, 1), 12000.0, SaleStatus.Billed, s1); SalesRecords r18 = new SalesRecords(18, new DateTime(2018, 10, 24), 6000.0, SaleStatus.Billed, s3); SalesRecords r19 = new SalesRecords(19, new DateTime(2018, 10, 22), 8000.0, SaleStatus.Billed, s5); SalesRecords r20 = new SalesRecords(20, new DateTime(2018, 10, 15), 8000.0, SaleStatus.Billed, s6); SalesRecords r21 = new SalesRecords(21, new DateTime(2018, 10, 17), 9000.0, SaleStatus.Billed, s2); SalesRecords r22 = new SalesRecords(22, new DateTime(2018, 10, 24), 4000.0, SaleStatus.Billed, s4); SalesRecords r23 = new SalesRecords(23, new DateTime(2018, 10, 19), 11000.0, SaleStatus.Canceled, s2); SalesRecords r24 = new SalesRecords(24, new DateTime(2018, 10, 12), 8000.0, SaleStatus.Billed, s5); SalesRecords r25 = new SalesRecords(25, new DateTime(2018, 10, 31), 7000.0, SaleStatus.Billed, s3); SalesRecords r26 = new SalesRecords(26, new DateTime(2018, 10, 6), 5000.0, SaleStatus.Billed, s4); SalesRecords r27 = new SalesRecords(27, new DateTime(2018, 10, 13), 9000.0, SaleStatus.Pending, s1); SalesRecords r28 = new SalesRecords(28, new DateTime(2018, 10, 7), 4000.0, SaleStatus.Billed, s3); SalesRecords r29 = new SalesRecords(29, new DateTime(2018, 10, 23), 12000.0, SaleStatus.Billed, s5); SalesRecords r30 = new SalesRecords(30, new DateTime(2018, 10, 12), 5000.0, SaleStatus.Billed, s2); _context.Department.AddRange(d1, d2, d3, d4); _context.Seller.AddRange(s1, s2, s3, s4); _context.SalesRecords.AddRange( r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14, r15, r16, r17, r18, r19, r20, r21, r22, r23, r24, r25, r26, r27, r28, r29, r30); _context.SaveChanges(); }
public void RemuveSales(SalesRecords sr) { Sales.Remove(sr); }
public void AddSales(SalesRecords sr) { Sales.Add(sr); }