public void Fill() { FillMainData(); Checks = _dataSet.Tables[0].AsEnumerable().Select(dataRow => new Check { Id = dataRow.Field <long>("Id"), Number = dataRow.Field <string>("Number"), Date = dataRow.Field <DateTime>("Date"), Buyer = Buyers.Where(b => b.Id == dataRow.Field <long>("BuyerFk")).Single(), Seller = Sellers.Where(s => s.Id == dataRow.Field <long>("SellerFk")).Single(), Fridge = Fridges.Where(f => f.Id == dataRow.Field <long>("FridgeFk")).Single() }).ToList(); _dataSet.Clear(); }
public async Task CreateOrder(int userID, int addressID, IEnumerable <Fridge> fridges, decimal price) { PurchaseOrder order = new PurchaseOrder { UserId = userID, AddressId = addressID, ActualState = 1, OrderState = new List <OrderState> { new OrderState { Data = DateTime.Now, State = 1 } }, TotalValue = price }; context.PurchaseOrder.Add(order); context.SaveChanges(); foreach (var fridge in fridges) { var result = IsRepeated(fridge); if (result == null) { await CreateFridge(fridge); result = fridge.FridgeId; } else { Fridges.Where(x => x.FridgeId == result).FirstOrDefault().Bought += 1; } await CreateSpecimen(fridge, (int)result, order.OrderId); } await context.SaveChangesAsync(); }