public async void ConfirmOrder(object sender, EventArgs e)
{
var client = Model.Context.Clients.AsNoTracking().SingleOrDefault(u => u.Name == View.ComboClient.SelectedItem.ToString());
var newOrder = new Order()
{
OrderData = DateTime.Now,
ClientFk = client.Id
};
Model.Context.Orders.Add(newOrder);
foreach (ListViewItem item in View.ListViewOrder.Items)
{
var newPartsInOrder = new PartsInOrder()
{
PartFk = long.Parse(item.SubItems[3].Text),
Order = newOrder,
Count = int.Parse(item.SubItems[2].Text),
TotalCost = Decimal.Parse(View.TotalCost.Text)
};
Model.Context.PartsInOrders.Add(newPartsInOrder);
var count = await Model.Context.PartsCountHave.FirstOrDefaultAsync(u => u.PartFk == newPartsInOrder.PartFk);
if (count != null)
{
count.Count = count.Count - int.Parse(item.SubItems[2].Text);
try
{
await Model.Context.SaveChangesAsync();
}
catch
{
MessageBox.Show("Count was not change", "Not Change", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
await Model.Context.SaveChangesAsync();
}
protected override void Seed(MyStoreContext context)
{
var manufacturers = new Manufacturer[]
{
new Manufacturer {
Id = 1, Name = "Roda"
},
new Manufacturer {
Id = 2, Name = "Termomont"
},
new Manufacturer {
Id = 3, Name = "Honeywell"
},
new Manufacturer {
Id = 4, Name = "Spirotech"
}
};
foreach (var manufacturer in manufacturers)
{
context.Manufacturers.Add(manufacturer);
}
// Или можно вот так:
// Array.ForEach(authors, author => context.Authors.Add(author));
var clients = new Client[]
{
new Client {
Id = 1, Name = "Ник лтд", Adrress = "Одесса, ул.Небесной сотни 15", Bonus = 15
},
new Client {
Id = 2, Name = "ТелеКом", Adrress = "Одесса, ул.Решельевская 3", Bonus = 7.5
},
new Client {
Id = 3, Name = "УкрЭнерго", Adrress = "Херсон, ул.Бориспольская 7", Bonus = 22.5
},
new Client {
Id = 4, Name = "АрмТек", Adrress = "Киев, ул.Черноморская 6", Bonus = 15
},
new Client {
Id = 5, Name = "Энергия сервис", Adrress = "Чернигов, ул.Гончая 51", Bonus = 10
},
new Client {
Id = 6, Name = "Овк комплект", Adrress = "Киев, ул.Институтская 16", Bonus = 13
},
};
foreach (var client in clients)
{
context.Clients.Add(client);
}
// Или можно вот так:
// Array.ForEach(presses, press => context.Presses.Add(press));
var parts = new Part[]
{
new Part {
Id = 1, Name = "Электрический котел Roda Storm SL 8 - 7,5 кВт", Cost = 499, ManufacturerFk = manufacturers[0].Id
},
new Part {
Id = 2, Name = "Электрический котел Roda Storm SL 18 - 18 кВт", Cost = 527, ManufacturerFk = manufacturers[0].Id
},
new Part {
Id = 3, Name = "Электрический котел Roda Storm SL 15 - 15 кВт", Cost = 527, ManufacturerFk = manufacturers[0].Id
},
new Part {
Id = 4, Name = "Твердотопливный котёл Termomont ТКК3-25 кВт", Cost = 1453, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 5, Name = "Твердотопливный котёл Termomont ТКU3-20 кВт", Cost = 1514, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 6, Name = "Твердотопливный котёл Termomont ТКК3-30 кВт", Cost = 1574, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 7, Name = "Твердотопливный котёл Termomont ТКU3-25 кВт", Cost = 1635, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 8, Name = "Пеллетный котел Termomont TOBY 12В 12 кВт", Cost = 3269, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 9, Name = "Пеллетный котел Termomont TOBY 12Н 12 кВт", Cost = 3451, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 10, Name = "Пеллетная горелка Termomont Biotermec 50 (10-50 кВт)", Cost = 1639, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 11, Name = "Пеллетная горелка Termomont Biotermec 100 (50-100 кВт)", Cost = 2795, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 12, Name = "Пеллетная горелка Termomont Agrotermec 50 кВт", Cost = 3255, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 13, Name = "Топливная емкость MAFA MINI-300", Cost = 605, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 14, Name = "Топливная емкость MAFA MIDI-730", Cost = 1090, ManufacturerFk = manufacturers[1].Id
},
new Part {
Id = 15, Name = "Автоматический воздухоотводчик Honeywell E121-3/8A", Cost = 9, ManufacturerFk = manufacturers[2].Id
},
new Part {
Id = 16, Name = "Автоматический воздухоотводчик Honeywell E121-1/2A", Cost = 10, ManufacturerFk = manufacturers[2].Id
},
new Part {
Id = 17, Name = "Автоматический воздухоотводчик Spirovent Spirotop AAV AB050", Cost = 76, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 18, Name = "Автоматический воздухоотводчик Spirotop AAV AB050/008", Cost = 115, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 19, Name = "Автоматический воздухоотводчик Spirotop AAV AB050/002", Cost = 115, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 20, Name = "Сепаратор воздуха SpiroVent Air AA075 3/4", Cost = 134, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 21, Name = "Сепаратор воздуха Spirovent Air AA100 1", Cost = 142, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 22, Name = "Гидравлическая стрелка SpiroCross DN50 (под приварку - сталь)", Cost = 1526, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 23, Name = "Гидравлическая стрелка SpiroCross DN50 (фланец - сталь)", Cost = 1777, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 24, Name = "Гидравлическая стрелка SpiroCross DN65 (под приварку - сталь)", Cost = 1780, ManufacturerFk = manufacturers[3].Id
},
new Part {
Id = 25, Name = "Гидравлическая стрелка SpiroCross DN65 (фланец - сталь)", Cost = 2062, ManufacturerFk = manufacturers[3].Id
}
};
foreach (var part in parts)
{
context.Parts.Add(part);
}
// Или можно вот так:
// Array.ForEach(books, book => context.Books.Add(book));
var partsCountHave = new PartCountHave[]
{
new PartCountHave {
Id = 1, Count = 24, PartFk = 1
},
new PartCountHave {
Id = 2, Count = 24, PartFk = 2
},
new PartCountHave {
Id = 3, Count = 24, PartFk = 3
},
new PartCountHave {
Id = 4, Count = 24, PartFk = 4
},
new PartCountHave {
Id = 5, Count = 24, PartFk = 5
},
new PartCountHave {
Id = 6, Count = 24, PartFk = 6
},
new PartCountHave {
Id = 7, Count = 24, PartFk = 7
},
new PartCountHave {
Id = 8, Count = 24, PartFk = 8
},
new PartCountHave {
Id = 9, Count = 24, PartFk = 9
},
new PartCountHave {
Id = 10, Count = 24, PartFk = 10
},
new PartCountHave {
Id = 11, Count = 24, PartFk = 11
},
new PartCountHave {
Id = 12, Count = 24, PartFk = 12
},
new PartCountHave {
Id = 13, Count = 24, PartFk = 13
},
new PartCountHave {
Id = 14, Count = 24, PartFk = 14
},
new PartCountHave {
Id = 15, Count = 24, PartFk = 15
},
new PartCountHave {
Id = 16, Count = 24, PartFk = 16
},
new PartCountHave {
Id = 17, Count = 24, PartFk = 17
},
new PartCountHave {
Id = 18, Count = 24, PartFk = 18
},
new PartCountHave {
Id = 19, Count = 24, PartFk = 19
},
new PartCountHave {
Id = 20, Count = 24, PartFk = 20
},
new PartCountHave {
Id = 21, Count = 24, PartFk = 21
},
new PartCountHave {
Id = 22, Count = 24, PartFk = 22
},
new PartCountHave {
Id = 23, Count = 24, PartFk = 23
},
new PartCountHave {
Id = 24, Count = 24, PartFk = 24
},
new PartCountHave {
Id = 25, Count = 24, PartFk = 25
}
};
foreach (var partCountHave in partsCountHave)
{
context.PartsCountHave.Add(partCountHave);
}
var admins = new Admin[]
{
new Admin {
Id = 1, Login = "******", Password = "******", Name = "Boss"
}
};
foreach (var admin in admins)
{
context.Admins.Add(admin);
}
DateTime date = new DateTime(2000, 3, 3);
var orders = new Order[]
{
new Order {
Id = 1, OrderData = date, ClientFk = clients[0].Id
},
new Order {
Id = 2, OrderData = DateTime.Now, ClientFk = clients[1].Id
},
new Order {
Id = 3, OrderData = DateTime.Now, ClientFk = clients[1].Id
},
new Order {
Id = 4, OrderData = DateTime.Now.AddDays(-1), ClientFk = clients[2].Id
},
new Order {
Id = 5, OrderData = DateTime.Now.AddDays(-2), ClientFk = clients[3].Id
},
new Order {
Id = 6, OrderData = DateTime.Now.AddDays(-41), ClientFk = clients[4].Id
},
new Order {
Id = 7, OrderData = DateTime.Now.AddDays(-3), ClientFk = clients[4].Id
},
new Order {
Id = 8, OrderData = DateTime.Now.AddDays(-4), ClientFk = clients[0].Id
}
};
foreach (var order in orders)
{
context.Orders.Add(order);
}
var partsInOrders = new PartsInOrder[]
{
new PartsInOrder {
Id = 1, PartFk = parts[0].Id, OrderFk = orders[0].Id, Count = 1, TotalCost = 1 * parts[0].Cost
},
new PartsInOrder {
Id = 2, PartFk = parts[0].Id, OrderFk = orders[5].Id, Count = 2, TotalCost = 2 * parts[0].Cost
},
new PartsInOrder {
Id = 3, PartFk = parts[2].Id, OrderFk = orders[0].Id, Count = 1, TotalCost = 1 * parts[2].Cost
},
new PartsInOrder {
Id = 4, PartFk = parts[4].Id, OrderFk = orders[1].Id, Count = 3, TotalCost = 3 * parts[4].Cost
},
new PartsInOrder {
Id = 5, PartFk = parts[4].Id, OrderFk = orders[1].Id, Count = 1, TotalCost = 1 * parts[4].Cost
},
new PartsInOrder {
Id = 6, PartFk = parts[5].Id, OrderFk = orders[2].Id, Count = 1, TotalCost = 1 * parts[5].Cost
},
new PartsInOrder {
Id = 7, PartFk = parts[6].Id, OrderFk = orders[6].Id, Count = 2, TotalCost = 2 * parts[6].Cost
},
new PartsInOrder {
Id = 8, PartFk = parts[8].Id, OrderFk = orders[3].Id, Count = 1, TotalCost = 1 * parts[8].Cost
},
new PartsInOrder {
Id = 9, PartFk = parts[9].Id, OrderFk = orders[2].Id, Count = 6, TotalCost = 6 * parts[9].Cost
},
new PartsInOrder {
Id = 10, PartFk = parts[10].Id, OrderFk = orders[1].Id, Count = 2, TotalCost = 2 * parts[10].Cost
},
new PartsInOrder {
Id = 11, PartFk = parts[12].Id, OrderFk = orders[4].Id, Count = 5, TotalCost = 5 * parts[12].Cost
},
new PartsInOrder {
Id = 12, PartFk = parts[15].Id, OrderFk = orders[6].Id, Count = 1, TotalCost = 1 * parts[15].Cost
},
new PartsInOrder {
Id = 13, PartFk = parts[15].Id, OrderFk = orders[7].Id, Count = 2, TotalCost = 2 * parts[15].Cost
},
new PartsInOrder {
Id = 14, PartFk = parts[15].Id, OrderFk = orders[2].Id, Count = 1, TotalCost = 1 * parts[15].Cost
},
new PartsInOrder {
Id = 15, PartFk = parts[17].Id, OrderFk = orders[5].Id, Count = 3, TotalCost = 3 * parts[17].Cost
},
new PartsInOrder {
Id = 16, PartFk = parts[19].Id, OrderFk = orders[4].Id, Count = 5, TotalCost = 5 * parts[19].Cost
},
new PartsInOrder {
Id = 17, PartFk = parts[20].Id, OrderFk = orders[1].Id, Count = 4, TotalCost = 4 * parts[20].Cost
},
new PartsInOrder {
Id = 18, PartFk = parts[21].Id, OrderFk = orders[3].Id, Count = 2, TotalCost = 2 * parts[21].Cost
},
new PartsInOrder {
Id = 19, PartFk = parts[22].Id, OrderFk = orders[5].Id, Count = 1, TotalCost = 1 * parts[22].Cost
},
new PartsInOrder {
Id = 20, PartFk = parts[22].Id, OrderFk = orders[4].Id, Count = 1, TotalCost = 1 * parts[22].Cost
},
new PartsInOrder {
Id = 21, PartFk = parts[23].Id, OrderFk = orders[2].Id, Count = 3, TotalCost = 3 * parts[23].Cost
},
new PartsInOrder {
Id = 22, PartFk = parts[24].Id, OrderFk = orders[3].Id, Count = 4, TotalCost = 4 * parts[24].Cost
}
};
foreach (var partsInOrder in partsInOrders)
{
context.PartsInOrders.Add(partsInOrder);
}
base.Seed(context);
}
