コード例 #1
0
        public static ShipMethodCollection LoadForWarehouse(Int32 warehouseId, int maximumRows, int startRowIndex, string sortExpression)
        {
            //DEFAULT SORT EXPRESSION
            if (string.IsNullOrEmpty(sortExpression))
            {
                sortExpression = "OrderBy";
            }
            //CREATE THE DYNAMIC SQL TO LOAD OBJECT
            StringBuilder selectQuery = new StringBuilder();

            selectQuery.Append("SELECT");
            if (maximumRows > 0)
            {
                selectQuery.Append(" TOP " + (startRowIndex + maximumRows).ToString());
            }
            selectQuery.Append(" " + ShipMethod.GetColumnNames("ac_ShipMethods"));
            selectQuery.Append(" FROM ac_ShipMethods, ac_ShipMethodWarehouses");
            selectQuery.Append(" WHERE ac_ShipMethods.ShipMethodId = ac_ShipMethodWarehouses.ShipMethodId");
            selectQuery.Append(" AND ac_ShipMethodWarehouses.WarehouseId = @warehouseId");
            selectQuery.Append(" AND StoreId = @storeId");
            selectQuery.Append(" ORDER BY " + sortExpression);
            Database  database      = Token.Instance.Database;
            DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());

            database.AddInParameter(selectCommand, "@warehouseId", System.Data.DbType.Int32, warehouseId);
            database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, Token.Instance.StoreId);
            //EXECUTE THE COMMAND
            ShipMethodCollection results = new ShipMethodCollection();
            int thisIndex = 0;
            int rowCount  = 0;

            using (IDataReader dr = database.ExecuteReader(selectCommand))
            {
                while (dr.Read() && ((maximumRows < 1) || (rowCount < maximumRows)))
                {
                    if (thisIndex >= startRowIndex)
                    {
                        ShipMethod shipMethod = new ShipMethod();
                        ShipMethod.LoadDataReader(shipMethod, dr);
                        results.Add(shipMethod);
                        rowCount++;
                    }
                    thisIndex++;
                }
                dr.Close();
            }
            return(results);
        }
コード例 #2
0
        /// <summary>
        /// Gets a collection of ship rate quotes for the given shipment
        /// </summary>
        /// <param name="shipment">The basket shipment for which to get the rate quotes</param>
        /// <returns>A collection of ship rate quotes</returns>
        public static Collection <ShipRateQuote> QuoteForShipment(IShipment shipment)
        {
            Collection <ShipRateQuote> rateQuotes = new Collection <ShipRateQuote>();
            //GET ALL OF THE POSSIBLE SHIPMETHODS
            ShipMethodCollection shipMethods = ShipMethodDataSource.LoadForShipment(shipment);

            foreach (ShipMethod method in shipMethods)
            {
                ShipRateQuote quote = method.GetShipRateQuote(shipment);
                if (quote != null)
                {
                    rateQuotes.Add(quote);
                }
            }
            return(rateQuotes);
        }
コード例 #3
0
        public static ShipMethodCollection  LoadForCriteria(string sqlCriteria, int maximumRows, int startRowIndex, string sortExpression)
        {
            //DEFAULT SORT EXPRESSION
            if (string.IsNullOrEmpty(sortExpression))
            {
                sortExpression = "OrderBy";
            }
            //CREATE THE DYNAMIC SQL TO LOAD OBJECT
            StringBuilder selectQuery = new StringBuilder();

            selectQuery.Append("SELECT");
            if (maximumRows > 0)
            {
                selectQuery.Append(" TOP " + (startRowIndex + maximumRows).ToString());
            }
            selectQuery.Append(" " + ShipMethod.GetColumnNames(string.Empty));
            selectQuery.Append(" FROM ac_ShipMethods");
            string whereClause = string.IsNullOrEmpty(sqlCriteria) ? string.Empty : " WHERE " + sqlCriteria;

            selectQuery.Append(whereClause);
            selectQuery.Append(" ORDER BY " + sortExpression);
            Database  database      = Token.Instance.Database;
            DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
            //EXECUTE THE COMMAND
            ShipMethodCollection results = new ShipMethodCollection();
            int thisIndex = 0;
            int rowCount  = 0;

            using (IDataReader dr = database.ExecuteReader(selectCommand))
            {
                while (dr.Read() && ((maximumRows < 1) || (rowCount < maximumRows)))
                {
                    if (thisIndex >= startRowIndex)
                    {
                        ShipMethod shipMethod = new ShipMethod();
                        ShipMethod.LoadDataReader(shipMethod, dr);
                        results.Add(shipMethod);
                        rowCount++;
                    }
                    thisIndex++;
                }
                dr.Close();
            }
            return(results);
        }
コード例 #4
0
        /// <summary>
        /// Gets an array of ship rate quotes for the given basket
        /// </summary>
        /// <param name="basket">The basket for which to get the ship rate quotes</param>
        /// <param name="destination">The destination address for which to get the rates</param>
        /// <returns>An array of ShipRateQuote objects</returns>
        public static ShipRateQuote[] QuoteForBasket(Basket basket, Address destination)
        {
            //*******
            //SUMMARY: LOOP ALL SHIPMENTS IN BASKET AND GET QUOTES FOR EACH
            //ADD QUOTES TOGETHER FOR SERVICES IN COMMON TO ALL SHIPMENTS AND RETURN TOTALS
            //*******
            //CREATE A DICTIONARY TO HOLD QUOTED RATES
            Dictionary <int, ShipRateQuoteStack> rateQuotes = new Dictionary <int, ShipRateQuoteStack>();

            foreach (BasketShipment shipment in basket.Shipments)
            {
                //GET ALL OF THE POSSIBLE SHIPMETHODS
                Address tempAddress = shipment.Address;
                shipment.SetAddress(destination);
                ShipMethodCollection shipMethods = ShipMethodDataSource.LoadForShipment(shipment);
                foreach (ShipMethod method in shipMethods)
                {
                    ShipRateQuote quote = method.GetShipRateQuote(shipment);
                    if (quote != null)
                    {
                        if (rateQuotes.ContainsKey(method.ShipMethodId))
                        {
                            rateQuotes[method.ShipMethodId].Add(quote);
                        }
                        else
                        {
                            rateQuotes.Add(method.ShipMethodId, new ShipRateQuoteStack(quote));
                        }
                    }
                }
                shipment.SetAddress(tempAddress);
            }
            //NOW BUILD LIST OF QUOTES VALID FOR ALL SHIPMENTS
            List <ShipRateQuote> validQuotes = new List <ShipRateQuote>();

            foreach (ShipRateQuoteStack item in rateQuotes.Values)
            {
                if (item.ShipmentCount == basket.Shipments.Count)
                {
                    validQuotes.Add(item.ShipRateQuote);
                }
            }
            return(validQuotes.ToArray());
        }
コード例 #5
0
        /// <summary>
        /// Loads a collection of ShipMethod objects for given BasketShipment
        /// </summary>
        /// <param name="shipment">BasketShipment to load the ship methods for</param>
        /// <returns>A collection of ShipMethod objects for given BasketShipment</returns>
        public static ShipMethodCollection LoadForShipment(IShipment shipment)
        {
            //GET ALL SHIP METHODS THAT CAN APPLY TO THIS SHIPMENT
            ShipMethodCollection shipMethodCollection = new ShipMethodCollection();

            //FIRST DETERMINE THE SHIP ZONE(S) FOR THE SHIPMENT
            ShipZoneCollection shipmentZoneCollection = shipment.ShipZones;
            //BUILD A LIST OF ZONEIDS FOR QUERY CRITERIA

            //NOW QUERY ANY SHIP METHODS THAT CAN SHIP FROM THIS WAREHOUSE TO ANY ZONE OR ONE OF THE ASSOCIATED ZONES
            //CREATE THE DYNAMIC SQL TO LOAD OBJECT
            StringBuilder selectQuery = new StringBuilder();

            selectQuery.Append("SELECT DISTINCT " + ShipMethod.GetColumnNames("ac_ShipMethods"));
            selectQuery.Append(" FROM ((ac_ShipMethods LEFT JOIN ac_ShipMethodWarehouses ON ac_ShipMethods.ShipMethodId = ac_ShipMethodWarehouses.ShipMethodId)");
            selectQuery.Append(" LEFT JOIN ac_ShipMethodShipZones ON ac_ShipMethods.ShipMethodId = ac_ShipMethodShipZones.ShipMethodId)");
            selectQuery.Append(" LEFT JOIN ac_ShipMethodGroups ON ac_ShipMethods.ShipMethodId = ac_ShipMethodGroups.ShipMethodId");
            selectQuery.Append(" WHERE StoreId = @storeId");
            //PROCESS MINPURCHASE EXCLUSION
            selectQuery.Append(" AND MinPurchase <= @shipmentValue");
            //PROCESS WAREHOUSE EXCLUSION
            selectQuery.Append(" AND (ac_ShipMethodWarehouses.WarehouseId IS NULL OR ac_ShipMethodWarehouses.WarehouseId = @warehouseId)");
            //PROCESS SHIPZONE EXCLUSION
            selectQuery.Append(" AND (ac_ShipMethodShipZones.ShipZoneId IS NULL");
            for (int i = 0; i < shipmentZoneCollection.Count; i++)
            {
                selectQuery.Append(" OR ac_ShipMethodShipZones.ShipZoneId = @shipZoneId" + i.ToString());
            }
            selectQuery.Append(")");

            //PROCESS GROUP EXCLUSION
            selectQuery.Append(" AND (ac_ShipMethodGroups.GroupId IS NULL");
            User user = UserDataSource.LoadForShipment(shipment);

            if (user != null)
            {
                for (int i = 0; i < user.UserGroups.Count; i++)
                {
                    selectQuery.Append(" OR ac_ShipMethodGroups.GroupId = @groupId" + i.ToString());
                }
            }
            selectQuery.Append(")");
            //ORDER ACCORDING TO MERCHANT RULES
            //selectQuery.Append(" ORDER BY ac_ShipMethods.OrderBy");


            Database  database      = Token.Instance.Database;
            DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());

            database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, Token.Instance.StoreId);
            //ADD IN MINPURCHASE PARAMETER
            database.AddInParameter(selectCommand, "@shipmentValue", System.Data.DbType.Decimal, shipment.GetItems().TotalProductPrice());
            //ADD IN WAREHOUSE PARAMETER
            database.AddInParameter(selectCommand, "@warehouseId", System.Data.DbType.Int32, shipment.WarehouseId);
            //ADD IN NUMBERED ZONE PARAMETERS
            for (int i = 0; i < shipmentZoneCollection.Count; i++)
            {
                database.AddInParameter(selectCommand, "@shipZoneId" + i.ToString(), System.Data.DbType.Int32, shipmentZoneCollection[i].ShipZoneId);
            }
            //ADD IN NUMBERED GROUP PARAMETERS
            for (int i = 0; i < user.UserGroups.Count; i++)
            {
                database.AddInParameter(selectCommand, "@groupId" + i.ToString(), System.Data.DbType.Int32, user.UserGroups[i].GroupId);
            }
            //EXECUTE THE COMMAND
            using (IDataReader dr = database.ExecuteReader(selectCommand))
            {
                while (dr.Read())
                {
                    ShipMethod shipMethod = new ShipMethod();
                    ShipMethod.LoadDataReader(shipMethod, dr);
                    shipMethodCollection.Add(shipMethod);
                }
                dr.Close();
            }
            //SORT THE ITEMS (NOT DONE IN QUERY BECAUSE OF DISTINCT CLAUSE)
            shipMethodCollection.Sort("OrderBy");
            return(shipMethodCollection);
        }