private void GrabarOrderItems(List <OrderItem> orderItems, Order order) { bool nuevo; // return; ApplicationDbContextSql dbContext = new ApplicationDbContextSql(); var transaction = dbContext.Database.BeginTransaction(IsolationLevel.RepeatableRead); foreach (OrderItem item in orderItems) { AmazonOrderLinea amazonOrderLinea = dbContext.amazonorderLineas.Where(w => w.AmazonOrderLineaID == item.OrderItemId).FirstOrDefault(); if (amazonOrderLinea == null) { nuevo = true; amazonOrderLinea = new AmazonOrderLinea(); } else { nuevo = false; } amazonOrderLinea.OrderItemId = item.OrderItemId; amazonOrderLinea.AmazonOrderID = order.AmazonOrderId; amazonOrderLinea.AmazonOrderLineaID = item.OrderItemId; if (item.IsSetASIN()) { amazonOrderLinea.Asin = item.ASIN; } amazonOrderLinea.Cuenta = order.SellerOrderId; if (item.IsSetItemPrice()) { amazonOrderLinea.ItemPriceAmount = FuncionesEbay.fnSpreciodprecio(item.ItemPrice.Amount); amazonOrderLinea.ItemPriceCurrencyCode = item.ItemPrice.CurrencyCode; } if (item.IsSetQuantityOrdered()) { amazonOrderLinea.QuantityOrdered = item.QuantityOrdered; } if (item.IsSetQuantityShipped()) { amazonOrderLinea.QuantityShipped = item.QuantityShipped; } if (item.IsSetSellerSKU()) { amazonOrderLinea.SellerSKU = item.SellerSKU; } if (item.IsSetShippingPrice()) { amazonOrderLinea.ShippingPriceAmount = FuncionesEbay.fnSpreciodprecio(item.ShippingPrice.Amount); amazonOrderLinea.ShippingPriceCurrencyCode = item.ShippingPrice.CurrencyCode; } if (item.IsSetTitle()) { amazonOrderLinea.Title = item.Title; } if (nuevo) { dbContext.amazonorderLineas.Add(amazonOrderLinea); } } try { dbContext.SaveChanges(); transaction.Commit(); dbContext.Dispose(); } catch (Exception e) { } }
private void GrabarOrder(Order order, string cuenta) { bool nuevo = false; // return; ApplicationDbContextSql dbContext = new ApplicationDbContextSql(); var transaction = dbContext.Database.BeginTransaction(IsolationLevel.RepeatableRead); AmazonOrder amazonOrder = dbContext.amazonorders.Where(w => w.AmazonOrderID == order.AmazonOrderId).FirstOrDefault(); if (amazonOrder == null) { amazonOrder = new AmazonOrder(); nuevo = true; } amazonOrder.AmazonOrderID = order.AmazonOrderId; if (order.IsSetBuyerEmail()) { amazonOrder.BuyerEmail = order.BuyerEmail; } if (order.IsSetBuyerName()) { amazonOrder.BuyerName = order.BuyerName; } amazonOrder.Cuenta = cuenta; if (order.IsSetEarliestDeliveryDate()) { amazonOrder.EarliestDeliveryDate = order.EarliestDeliveryDate; } if (order.IsSetEarliestShipDate()) { amazonOrder.EarliestShipDate = order.EarliestShipDate; } if (order.IsSetFulfillmentChannel()) { amazonOrder.fulfillmentChannel = order.FulfillmentChannel; } if (order.IsSetIsPremiumOrder()) { amazonOrder.IsPremiumOrder = order.IsPremiumOrder; } if (order.IsSetIsPrime()) { amazonOrder.IsPrime = order.IsPrime; } if (order.IsSetLastUpdateDate()) { amazonOrder.lastUpdateDate = order.LastUpdateDate; } if (order.IsSetLatestDeliveryDate()) { amazonOrder.LatestDeliveryDate = order.LatestDeliveryDate; } if (order.IsSetLatestShipDate()) { amazonOrder.LatestShipDate = order.LatestShipDate; } if (order.IsSetMarketplaceId()) { amazonOrder.MarketplaceId = order.MarketplaceId; } if (order.IsSetNumberOfItemsShipped()) { amazonOrder.NumberOfItemsShipped = order.NumberOfItemsShipped; } if (order.IsSetNumberOfItemsUnshipped()) { amazonOrder.NumberOfItemsUnshipped = order.NumberOfItemsUnshipped; } if (order.IsSetOrderChannel()) { amazonOrder.orderChannel = order.OrderChannel; } if (order.IsSetOrderTotal()) { amazonOrder.OrderTotalAmount = FuncionesEbay.fnSpreciodprecio(order.OrderTotal.Amount); amazonOrder.OrderTotalCurrencyCode = order.OrderTotal.CurrencyCode; } if (order.IsSetOrderType()) { amazonOrder.OrderType = order.OrderType; } if (order.IsSetPaymentMethod()) { amazonOrder.PaymentMethod = order.PaymentMethod; } if (order.IsSetPurchaseDate()) { amazonOrder.purchaseDate = order.PurchaseDate; } if (order.IsSetOrderChannel()) { amazonOrder.salesChannel = order.SalesChannel; } if (order.IsSetSellerOrderId()) { amazonOrder.SellerOrderID = order.SellerOrderId; } if (order.IsSetShipmentServiceLevelCategory()) { amazonOrder.ShipmentServiceLevelCategory = order.ShipmentServiceLevelCategory; } if (order.IsSetShippedByAmazonTFM()) { amazonOrder.ShippedByAmazonTFM = order.ShippedByAmazonTFM; } if (order.IsSetShippingAddress()) { amazonOrder.ShippingAddressAddressLine1 = order.ShippingAddress.AddressLine1; amazonOrder.ShippingAddressAddressLine2 = order.ShippingAddress.AddressLine2; amazonOrder.ShippingAddressAddressLine3 = order.ShippingAddress.AddressLine3; amazonOrder.ShippingAddressCity = order.ShippingAddress.City; amazonOrder.ShippingAddressCountryCode = order.ShippingAddress.CountryCode; amazonOrder.ShippingAddressDistrict = order.ShippingAddress.District; amazonOrder.ShippingAddressName = order.ShippingAddress.Name; amazonOrder.ShippingAddressPhone = order.ShippingAddress.Phone; amazonOrder.ShippingAddressPostalCode = order.ShippingAddress.PostalCode; amazonOrder.ShippingAddressStateOrRegion = order.ShippingAddress.StateOrRegion; } if (order.IsSetShipServiceLevel()) { amazonOrder.shipServiceLevel = order.ShipServiceLevel; } if (nuevo) { dbContext.amazonorders.Add(amazonOrder); } dbContext.SaveChanges(); transaction.Commit(); dbContext.Dispose(); }