Exemple #1
0
        /// <summary>
        /// Creates a <see cref="IShipment"/> without persisting it to the database.
        /// </summary>
        /// <param name="shipmentStatus">
        /// The shipment status.
        /// </param>
        /// <param name="origin">
        /// The origin.
        /// </param>
        /// <param name="destination">
        /// The destination.
        /// </param>
        /// <param name="items">
        /// The items.
        /// </param>
        /// <param name="raiseEvents">
        /// Optional boolean indicating whether or not to raise events
        /// </param>
        /// <returns>
        /// The <see cref="IShipment"/>.
        /// </returns>
        public IShipment CreateShipment(IShipmentStatus shipmentStatus, IAddress origin, IAddress destination, LineItemCollection items, bool raiseEvents = true)
        {
            Mandate.ParameterNotNull(shipmentStatus, "shipmentStatus");
            Mandate.ParameterNotNull(origin, "origin");
            Mandate.ParameterNotNull(destination, "destination");
            Mandate.ParameterNotNull(items, "items");

            // Use the visitor to filter out and validate shippable line items
            var visitor = new ShippableProductVisitor();

            items.Accept(visitor);

            var lineItemCollection = new LineItemCollection();

            foreach (var item in visitor.ShippableItems)
            {
                lineItemCollection.Add(item);
            }

            var shipment = new Shipment(shipmentStatus, origin, destination, lineItemCollection)
            {
                VersionKey = Guid.NewGuid()
            };

            if (!raiseEvents)
            {
                return(shipment);
            }

            Creating.RaiseEvent(new Events.NewEventArgs <IShipment>(shipment), this);
            return(shipment);
        }
        internal static IOrder ToOrder(this OrderDisplay orderDisplay, IOrder destination)
        {
            if (orderDisplay.Key != Guid.Empty)
            {
                destination.Key = orderDisplay.Key;
            }
            destination.OrderNumberPrefix = orderDisplay.OrderNumberPrefix;
            destination.OrderDate         = orderDisplay.OrderDate;
            destination.OrderStatus       = orderDisplay.OrderStatus.ToOrderStatus();
            destination.VersionKey        = orderDisplay.VersionKey;
            destination.Exported          = orderDisplay.Exported;

            // TODO remove existing line items from destination not present in orderDisplay
            var items      = destination.Items.Where(x => orderDisplay.Items.Any(display => display.Key == x.Key));
            var collection = new LineItemCollection();

            foreach (var item in items)
            {
                collection.Add(item);
            }

            ((Order)destination).Items = collection;

            return(destination);
        }
Exemple #3
0
        public static LineItemCollection Select(string WhereClause, string OrderByClause)
        {
            string Sql = string.Format("SELECT * from [lineItem] WHERE ({0}) ORDER BY {1}", WhereClause, OrderByClause);
            //string ConnStr = @"Server=STUDENT05;Database=prs;Trusted_Connection=True;";
            SqlCommand    Cmd    = CreateConnection(ConnStr, Sql, "Connection didn't open");
            SqlDataReader Reader = Cmd.ExecuteReader();
            //if (!Reader.HasRows) {
            //    throw new ApplicationException("Result set has no rows!");
            //}
            LineItemCollection lineItems = new LineItemCollection();

            while (Reader.Read())
            {
                int id = Reader.GetInt32(Reader.GetOrdinal("Id"));
                int purchaseRequestId = Reader.GetInt32(Reader.GetOrdinal("PurchaseRequestId"));
                int productId         = Reader.GetInt32(Reader.GetOrdinal("ProductId"));
                int quantity          = Reader.GetInt32(Reader.GetOrdinal("Quantity"));

                LineItem lineItem = new LineItem();
                lineItem.Id = id;
                lineItem.PurchaseRequestId = purchaseRequestId;
                lineItem.ProductId         = productId;
                lineItem.Quantity          = quantity;

                // get the PurchaseRequest
                lineItem.PurchaseRequest = PurchaseRequest.Select(lineItem.PurchaseRequestId);
                // get the Product
                lineItem.Product = Product.Select(lineItem.ProductId);

                lineItems.Add(lineItem);
            }

            Cmd.Connection.Close();
            return(lineItems);
        }
Exemple #4
0
        /// <summary>
        /// The get line item collection.
        /// </summary>
        /// <param name="invoiceKey">
        /// The invoice key.
        /// </param>
        /// <returns>
        /// The <see cref="LineItemCollection"/>.
        /// </returns>
        private LineItemCollection GetLineItemCollection(Guid invoiceKey)
        {
            var sql = new Sql();

            sql.Select("*").From <InvoiceItemDto>(SqlSyntax).Where <InvoiceItemDto>(x => x.ContainerKey == invoiceKey);

            var dtos = Database.Fetch <InvoiceItemDto>(sql);

            var factory    = new LineItemFactory();
            var collection = new LineItemCollection();

            foreach (var dto in dtos)
            {
                collection.Add(factory.BuildEntity(dto));
            }

            return(collection);
        }
        /// <summary>
        /// Creates an instance of <see cref="LineItemCollection"/> from a serialized collection in the ExtendedDataCollection
        /// </summary>
        /// <typeparam name="T">The type of the <see cref="ILineItem"/></typeparam>
        /// <param name="extendedData">The extended data collection</param>
        /// <returns><see cref="LineItemCollection"/></returns>
        public static LineItemCollection GetLineItemCollection <T>(this ExtendedDataCollection extendedData) where T : LineItemBase
        {
            if (!extendedData.ContainsKey(Constants.ExtendedDataKeys.LineItemCollection))
            {
                return(null);
            }

            var xdoc = XDocument.Parse(extendedData.GetValue(Constants.ExtendedDataKeys.LineItemCollection));
            var lineItemCollection = new LineItemCollection();

            foreach (var element in xdoc.Descendants(Constants.ExtendedDataKeys.LineItem))
            {
                var dictionary = GetLineItemXmlValues(element.ToString());

                var extendData = new ExtendedDataCollection(dictionary[Constants.ExtendedDataKeys.ExtendedData]);

                var ctrValues = new object[]
                {
                    new Guid(dictionary[Constants.ExtendedDataKeys.LineItemTfKey]),
                    dictionary[Constants.ExtendedDataKeys.Name],
                    dictionary[Constants.ExtendedDataKeys.Sku],
                    int.Parse(dictionary[Constants.ExtendedDataKeys.Quantity]),
                    decimal.Parse(dictionary[Constants.ExtendedDataKeys.Price], NumberStyles.Any, CultureInfo.InvariantCulture),
                    new ExtendedDataCollection(dictionary[Constants.ExtendedDataKeys.ExtendedData])
                };

                var attempt = ActivatorHelper.CreateInstance <LineItemBase>(typeof(T).FullName, ctrValues);

                if (!attempt.Success)
                {
                    MultiLogHelper.Error <LineItemCollection>("Failed to instantiate a LineItemCollection from ExtendedData", attempt.Exception);
                    throw attempt.Exception;
                }

                attempt.Result.ContainerKey = new Guid(dictionary[Constants.ExtendedDataKeys.ContainerKey]);

                lineItemCollection.Add(attempt.Result);
            }

            return(lineItemCollection);
        }
Exemple #6
0
        /// <summary>
        /// Clones a shipment
        /// </summary>
        /// <param name="org">
        /// The org.
        /// </param>
        /// <returns>
        /// The <see cref="IShipment"/>.
        /// </returns>
        /// <remarks>
        /// http://issues.merchello.com/youtrack/issue/M-458
        /// </remarks>
        internal static IShipment Clone(this IShipment org)
        {
            var lineItemCollection = new LineItemCollection();

            foreach (var li in org.Items)
            {
                lineItemCollection.Add(li.AsLineItemOf <OrderLineItem>());
            }

            return(new Shipment(org.ShipmentStatus, org.GetOriginAddress(), org.GetDestinationAddress(), lineItemCollection)
            {
                ShipmentNumberPrefix = org.ShipmentNumberPrefix,
                ShipmentNumber = org.ShipmentNumber,
                ShippedDate = org.ShippedDate,
                TrackingCode = org.TrackingCode,
                Carrier = org.Carrier,
                ShipMethodKey = org.ShipMethodKey,
                Phone = org.Phone,
                Email = org.Email
            });
        }
Exemple #7
0
        private LineItemCollection GetLineItemCollection(Guid itemCacheKey)
        {
            var sql = new Sql();

            sql.Select("*")
            .From <ItemCacheItemDto>()
            .Where <ItemCacheItemDto>(x => x.ContainerKey == itemCacheKey);

            var dtos = Database.Fetch <ItemCacheItemDto>(sql);

            //var lineItems = _lineItemRepository.GetByContainerId(itemCacheId);

            var factory    = new LineItemFactory();
            var collection = new LineItemCollection();

            foreach (var dto in dtos)
            {
                collection.Add(factory.BuildEntity(dto));
            }

            return(collection);
        }
Exemple #8
0
        //Select
        public static LineItemCollection Select(string whereClause, string orderByClause)
        {
            string        Sql     = string.Format("SELECT * from [LineItem] WHERE {0} ORDER BY {1}", whereClause, orderByClause);
            string        ConnStr = @"Server=STUDENT05;Database=prs;Trusted_Connection=True;";
            SqlConnection Conn    = new SqlConnection(ConnStr);

            Conn.Open();
            if (Conn.State != System.Data.ConnectionState.Open)
            {
                throw new ApplicationException("Connection didn't open");
            }
            SqlCommand    Cmd    = new SqlCommand(Sql, Conn);
            SqlDataReader Reader = Cmd.ExecuteReader();

            if (!Reader.HasRows)
            {
                throw new ApplicationException("Result set has no rows!");
            }
            LineItemCollection lineitems = new LineItemCollection();

            while (Reader.Read())
            {
                int id = Reader.GetInt32(Reader.GetOrdinal("id"));
                int purchaseRequestId = Reader.GetInt32(Reader.GetOrdinal("PurchaseRequestId"));
                int productId         = Reader.GetInt32(Reader.GetOrdinal("ProductID"));
                int quantity          = Reader.GetInt32(Reader.GetOrdinal("Quantity"));

                LineItem lineitem = new LineItem();
                lineitem.Id = id;
                lineitem.PurchaseRequestID = purchaseRequestId;
                lineitem.ProductID         = productId;
                lineitem.quantity          = quantity;


                lineitems.Add(lineitem);
            }
            return(lineitems);
        }
        internal static IOrder ToOrder(this OrderDisplay orderDisplay, IOrder destination)
        {
            if (orderDisplay.Key != Guid.Empty) destination.Key = orderDisplay.Key;
            destination.OrderNumberPrefix = orderDisplay.OrderNumberPrefix;
            destination.OrderDate = orderDisplay.OrderDate;
            destination.OrderStatus = orderDisplay.OrderStatus.ToOrderStatus();
            destination.VersionKey = orderDisplay.VersionKey;
            destination.Exported = orderDisplay.Exported;

            // TODO remove existing line items from destination not present in orderDisplay
            var items = destination.Items.Where(x => orderDisplay.Items.Any(display => display.Key == x.Key));
            var collection = new LineItemCollection();
            foreach (var item in items)
            {
                collection.Add(item);
            }

            ((Order)destination).Items = collection;

            return destination;
        }
        /// <summary>
        /// Creates a <see cref="IShipment"/> without persisting it to the database.
        /// </summary>
        /// <param name="shipmentStatus">
        /// The shipment status.
        /// </param>
        /// <param name="origin">
        /// The origin.
        /// </param>
        /// <param name="destination">
        /// The destination.
        /// </param>
        /// <param name="items">
        /// The items.
        /// </param>
        /// <param name="raiseEvents">
        /// Optional boolean indicating whether or not to raise events
        /// </param>
        /// <returns>
        /// The <see cref="IShipment"/>.
        /// </returns>
        public IShipment CreateShipment(IShipmentStatus shipmentStatus, IAddress origin, IAddress destination, LineItemCollection items, bool raiseEvents = true)
        {
            Mandate.ParameterNotNull(shipmentStatus, "shipmentStatus");
            Mandate.ParameterNotNull(origin, "origin");
            Mandate.ParameterNotNull(destination, "destination");
            Mandate.ParameterNotNull(items, "items");

            // Use the visitor to filter out and validate shippable line items
            var visitor = new ShippableProductVisitor();
            items.Accept(visitor);

            var lineItemCollection = new LineItemCollection();

            foreach (var item in visitor.ShippableItems)
            {
                lineItemCollection.Add(item);
            }

            var shipment = new Shipment(shipmentStatus, origin, destination, lineItemCollection)
                               {
                                   VersionKey = Guid.NewGuid()
                               };

            if (!raiseEvents)
            {
                return shipment;
            }

            Creating.RaiseEvent(new Events.NewEventArgs<IShipment>(shipment), this);
            return shipment;
        }
        /// <summary>
        /// Clones a shipment
        /// </summary>
        /// <param name="org">
        /// The org.
        /// </param>
        /// <returns>
        /// The <see cref="IShipment"/>.
        /// </returns>
        /// <remarks>
        /// http://issues.merchello.com/youtrack/issue/M-458
        /// </remarks>
        internal static IShipment Clone(this IShipment org)
        {
            var lineItemCollection = new LineItemCollection();

            foreach (var li in org.Items)
            {
                lineItemCollection.Add(li.AsLineItemOf<OrderLineItem>());
            }

            return new Shipment(org.ShipmentStatus, org.GetOriginAddress(), org.GetDestinationAddress(), lineItemCollection)
                               {
                                   ShipmentNumberPrefix = org.ShipmentNumberPrefix,
                                   ShipmentNumber = org.ShipmentNumber,
                                   ShippedDate = org.ShippedDate,
                                   TrackingCode = org.TrackingCode,
                                   Carrier = org.Carrier,
                                   ShipMethodKey = org.ShipMethodKey,
                                   Phone = org.Phone,
                                   Email = org.Email
                               };
        }