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(); }
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 ButtonFechaActualizacionTotalesArticulo_Click(object sender, EventArgs e) { var dataContext = new MyEntityModel.ApplicationDbContextSql(); string sql; ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando ArticuloComprado"; Application.DoEvents(); sql = "UPDATE lineas SET ArticuloCompradoID = (SELECT ArticuloId FROM Articulos a WHERE a.Codigo = ArticuloComprado)"; dataContext.Database.ExecuteSqlCommand(sql); ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando Vendidos - 1"; Application.DoEvents(); sql = string.Format("UPDATE articulos SET vendidos = (" + "SELECT SUM(unidades) from lineas l WHERE l.ArticuloID = articulos.ArticuloID AND SUBSTRING(l.Tipo, 3, 1) IN ({0}) " + ")", Global.TiposVentasSQL); dataContext.Database.ExecuteSqlCommand(sql); ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando Comprados - 1"; Application.DoEvents(); sql = string.Format("UPDATE articulos SET comprados = (" + "SELECT SUM(unidades) from lineas l WHERE l.ArticuloID = articulos.ArticuloID AND SUBSTRING(l.Tipo, 3, 1) IN ('B')" + ")"); dataContext.Database.ExecuteSqlCommand(sql); DateTime Siete = DateTime.Now.AddDays(-7); var parameters = new List <SqlParameter> { new SqlParameter { ParameterName = "@Fecha", SqlDbType = SqlDbType.DateTime, Value = Siete } }; ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando Vendidos Semana - 1"; Application.DoEvents(); sql = string.Format("UPDATE articulos SET vendidossiete = (" + "SELECT SUM(unidades) from lineas l WHERE l.ArticuloID = articulos.ArticuloID AND SUBSTRING(l.Tipo, 3, 1) IN ({0}) and l.fecha >= @Fecha" + ")", Global.TiposVentasSQL); dataContext.Database.ExecuteSqlCommand(sql, new SqlParameter { ParameterName = "@Fecha", SqlDbType = SqlDbType.DateTime, Value = Siete }); DateTime Treinta = DateTime.Now.AddDays(-30); ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando Vendidos Mes - 1"; Application.DoEvents(); sql = string.Format("UPDATE articulos SET vendidostreinta = (" + "SELECT SUM(unidades) from lineas l WHERE l.ArticuloID = articulos.ArticuloID AND SUBSTRING(l.Tipo, 3, 1) IN ({0}) and l.fecha >= @Fecha" + " AND ((SELECT COUNT(*) FROM Escandallo e WHERE e.ArticuloID = Articulos.ArticuloID) = 0)" + ")", Global.TiposVentasSQL); dataContext.Database.ExecuteSqlCommand(sql, new SqlParameter { ParameterName = "@Fecha", SqlDbType = SqlDbType.DateTime, Value = Treinta }); ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando Vendidos - 2"; Application.DoEvents(); sql = string.Format("UPDATE articulos SET vendidos = (" + "SELECT SUM(UnidadesArticuloComprado) from lineas l WHERE l.ArticuloCompradoID = articulos.ArticuloID AND SUBSTRING(l.Tipo, 3, 1) IN ({0}) " + " )" + " WHERE ((SELECT COUNT(*) FROM Escandallo e WHERE e.ArticuloID = Articulos.ArticuloID) > 0)", Global.TiposVentasSQL); dataContext.Database.ExecuteSqlCommand(sql); ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando Vendidos Semana - 2"; Application.DoEvents(); sql = string.Format("UPDATE articulos SET vendidossiete = (" + "SELECT SUM(unidades) from lineas l WHERE l.ArticuloCompradoID = articulos.ArticuloID AND SUBSTRING(l.Tipo, 3, 1) IN ({0}) and l.fecha >= @Fecha" + " )" + " WHERE ((SELECT COUNT(*) FROM Escandallo e WHERE e.ArticuloID = Articulos.ArticuloID) > 0)", Global.TiposVentasSQL); dataContext.Database.ExecuteSqlCommand(sql, new SqlParameter { ParameterName = "Fecha", SqlDbType = SqlDbType.DateTime, Value = Siete }); ButtonFechaActualizacionTotalesArticulo.Text = "Actualizando Vendidos Mes - 2"; Application.DoEvents(); sql = string.Format("UPDATE articulos SET vendidostreinta = (" + "SELECT SUM(unidades) from lineas l WHERE l.ArticuloCompradoID = articulos.ArticuloID AND SUBSTRING(l.Tipo, 3, 1) IN ({0}) and l.fecha >= @Fecha" + " )" + " WHERE ((SELECT COUNT(*) FROM Escandallo e WHERE e.ArticuloID = Articulos.ArticuloID) > 0)", Global.TiposVentasSQL); dataContext.Database.ExecuteSqlCommand(sql, new SqlParameter { ParameterName = "Fecha", SqlDbType = SqlDbType.DateTime, Value = Treinta }); MyEntityModel.Datos datos = dataContext.datos.FirstOrDefault(); if (datos == null) { datos = new MyEntityModel.Datos(); datos.FechaActualizacionTotalesArticulo = DateTime.Now; dataContext.datos.Add(datos); } else { datos.FechaActualizacionTotalesArticulo = DateTime.Now; } dataContext.SaveChanges(); FechaActualizacionTotalesArticulo(); }