private List <int> UpdateProductInventories(List <OrderItemDto> orderItemDtos) { List <int> results = new List <int>(); foreach (var orderItemDto in orderItemDtos) { int productId = orderItemDto.product.ProductId; Products_audit productsAudit = _context.ProductsAudits.Where(n => n.ProductId == productId).ToList().Last(); int result = productsAudit.Product_AuditId; results.Add(result); } return(results); }
public void MakeProductsAvailable(int OrderId) { List <OrderItem> items = _context.OrderItems.Where(n => n.OrderId == OrderId).ToList(); for (int i = 0; i < items.Count; i++) { int productAuditId = items[i].Product_AuditId; Products_audit productAudit = _context.ProductsAudits.FirstOrDefault(n => n.Product_AuditId == productAuditId); Product product = new Product(); product.ProductId = productAudit.ProductId; product.Inventory = items[i].Quantity; AddInventory(product); } }
private List <OrderItemDto> GetOrderItemsDto(string status, int orderId) { List <OrderItemDto> orderItemDto = new List <OrderItemDto>(); List <OrderItem> orderItems = _context.OrderItems.Where(n => n.OrderId == orderId).ToList(); for (int i = 0; i < orderItems.Count; i++) { OrderItemDto orderItem = new OrderItemDto(); Product product = new Product(); orderItem.product = product; int productAuditId = orderItems[i].Product_AuditId; Products_audit productAudit = new Products_audit(); if (status == "PENDING") { string ProductAuditQuery = "SELECT o.Product_AuditId,o.ProductId,o.Name,o.Description,o.ImageRef,o.Price, p.Inventory, o.Updated_at,o.Operation" + " FROM dbo.Products_audit o" + " JOIN dbo.Products p" + " ON p.Productid = o.ProductId" + " WHERE o.Product_AuditId = " + productAuditId; productAudit = _context.ProductsAudits.SqlQuery(ProductAuditQuery).ToList().First(); } else { productAudit = _context.ProductsAudits.FirstOrDefault(n => n.Product_AuditId == productAuditId); } orderItem.product.ProductId = productAudit.ProductId; orderItem.product.Description = productAudit.Description; orderItem.product.ImageRef = null; orderItem.product.Name = productAudit.Name; orderItem.product.ProductId = productAudit.ProductId; orderItem.product.Price = productAudit.Price; orderItem.product.Inventory = productAudit.Inventory; orderItem.Quantity = orderItems[i].Quantity; orderItemDto.Add(orderItem); } return(orderItemDto); }