Esempio n. 1
0
        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");
            }
        }
Esempio n. 2
0
        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");
            }
        }