public CustomerEditOrder addRequirement(int customerID, int orderID, InvoiceOrderOrderItemModel orderItem, int requirementKind) { try { using (var con = new inventorymanagementEntities()) { var requirement = new CustomerEditOrder() { OrderID = orderID, OrderItemID = orderItem.id, ProductID = orderItem.product.productID, ProductVariableID = orderItem.product.productVariableID, SKU = orderItem.product.sku, Quantity = orderItem.quantity, Price = orderItem.price, TotalPrice = orderItem.totalPrice, Status = requirementKind, CustomerID = customerID, CreatedDate = DateTime.Now }; con.CustomerEditOrders.Add(requirement); con.SaveChanges(); return(requirement); } } catch (Exception) { throw new Exception("Xảy ra lỗi trong quá trình khởi tạo yêu cầu của khách hàng"); } }
public List <CustomerEditOrder> addRequirement(int customerID, int orderID, List <InvoiceOrderOrderItemModel> orderItems, int requirementKind) { try { using (var con = new inventorymanagementEntities()) { var index = 0; var result = new List <CustomerEditOrder>(); foreach (var item in orderItems) { ++index; var requirement = new CustomerEditOrder() { OrderID = orderID, OrderItemID = item.id, ProductID = item.product.productID, ProductVariableID = item.product.productVariableID, SKU = item.product.sku, Quantity = item.quantity, Price = item.price, TotalPrice = item.totalPrice, Status = requirementKind, CustomerID = customerID, CreatedDate = DateTime.Now }; result.Add(requirement); con.CustomerEditOrders.Add(requirement); if (index >= 100) { index = 0; con.SaveChanges(); } } if (index > 0) { con.SaveChanges(); } return(result); } } catch (Exception) { throw new Exception("Xảy ra lỗi trong quá trình khởi tạo yêu cầu của khách hàng"); } }