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);
}
