AbleCommerce Shopping Cart Software

Code: Select all

NameValueCollection nvc = request.Form;
String shipDate = nvc["shipdate"];

// other code

OrderShipment shipment = OrderShipmentDataSource.Load(shippedOrder.Shipments[0].OrderShipmentId);

// tracking numbers added to shipment here

if (shipDate != null && shipDate != "")
{
    shipment.Ship(DateTime.Parse(shipDate));
}
else
    shipment.Ship();

shippedOrder.ShipmentStatus = OrderShipmentStatus.Shipped;
shippedOrder.ShipmentStatusId = 2;

shippedOrder.Save();

Code: Select all

_Order.ShipmentStatus = OrderShipmentStatus.Shipped;
_Order.Save();

Code: Select all

String orderNum = nvc["ordernum"];
orderNumber = Convert.ToInt32(orderNum.Substring(2));
int acOrderId = OrderDataSource.LookupOrderId(orderNumber);
Order shippedOrder = new Order();
if (acOrderId != 0)
    shippedOrder = OrderDataSource.Load(acOrderId);

Code: Select all

<%@ WebHandler Language="C#" Class="OrderShipUpdate" %>

using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Text;
using System.Web;
using CommerceBuilder.Common;
using CommerceBuilder.Orders;
using CommerceBuilder.Shipping;
using CommerceBuilder.Stores;

public class OrderShipUpdate : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        Store _Store = StoreDataSource.Load(1);
        Token.Instance.InitStoreContext(_Store);

        HttpRequest request = context.Request;
        HttpResponse response = context.Response;

        NameValueCollection nvc = request.Form;
        String headerID = nvc["ID"];
        String trackingNums = nvc["trackingnums"];
        String shipDate = nvc["shipdate"];
        String orderNum = nvc["ordernum"];
        String orderStatus = nvc["status"];

        response.ContentType = "text/xml";
        response.ContentEncoding = Encoding.UTF8;

        Int32 orderNumber = 0;
        String ConvertError = "";
        try
        {
            orderNumber = Convert.ToInt32(orderNum.Substring(2));
        }
        catch (Exception err)
        {
            ConvertError = err.Message + "(" + orderNum + ")";
        }

        int acOrderId = OrderDataSource.LookupOrderId(orderNumber);
        Order shippedOrder = new Order();
        if (acOrderId != 0)
        {
            shippedOrder = OrderDataSource.Load(acOrderId);
            if (shippedOrder != null)
            {
                List<String> tn = new List<String>();

                if (trackingNums.Trim() != "")
                {
                    String[] TrackingNumbers = trackingNums.Split('/');
                    for (int nt = 0; nt < TrackingNumbers.Length; nt++)
                    {
                        String[] subTrackNums = TrackingNumbers[nt].Split(';');
                        for (int sub = 0; sub < subTrackNums.Length; sub++)
                            tn.Add(subTrackNums[sub].Replace("USPF", "UPSF").Trim());
                    }
                }

                for (int ship = 0; ship < shippedOrder.Shipments.Count; ship++)
                {
                    OrderShipment shipment = OrderShipmentDataSource.Load(shippedOrder.Shipments[ship].OrderShipmentId);

                    if (tn.Count > 0 && tn.Count != shipment.TrackingNumbers.Count)
                    {
                        if (shipment.TrackingNumbers.Count > 0)
                            shipment.TrackingNumbers.DeleteAll();

                        foreach (String trackNum in tn)
                        {
                            TrackingNumber trackingNum = new TrackingNumber();
                            trackingNum.TrackingNumberData = trackNum;
                            trackingNum.OrderShipmentId = shipment.OrderShipmentId;
                            trackingNum.Save();
                            shipment.TrackingNumbers.Add(trackingNum);
                        }

                        shipment.Save();

                        if (orderStatus == "complete")
                        {
                            if (shipDate != null && shipDate != "")
                            {
                                shipment.Ship(DateTime.Parse(shipDate));
                            }
                            else
                                shipment.Ship();
                        }

                        shipment.Save();
                        shippedOrder.Save();
                    }
                    else
                    {
                        TrackingNumber trackingNum = new TrackingNumber();
                        trackingNum.TrackingNumberData = "Customer Pick Up";
                        trackingNum.OrderShipmentId = shipment.OrderShipmentId;
                        trackingNum.Save();
                        shipment.TrackingNumbers.Add(trackingNum);
                        shipment.Save();
                        shippedOrder.Save();
                    }
                }

                shippedOrder = OrderDataSource.Load(shippedOrder.OrderId);
                if (orderStatus == "complete")
                {
                    shippedOrder.ShipmentStatus = OrderShipmentStatus.Shipped;
                    shippedOrder.ShipmentStatusId = 2;
                }   
                shippedOrder.OrderStatusId = 3;
                shippedOrder.Save();

                SendResponse(response, "SUCCESS");
            }
            else
                SendResponse(response, "FAILED");
        }
        else
            SendResponse(response, "FAILED");
    }

Code: Select all

shippedOrder = OrderDataSource.Load(shippedOrder.OrderId);
if (shippedOrder.ShipmentStatusId != 2)
{
    try
    {
        CommerceBuilder.Data.Database database = Token.Instance.Database;
        StringBuilder sql = new StringBuilder();
        sql.Append("UPDATE ac_Orders SET ac_Orders.ShipmentStatusId=2 WHERE ac_Orders.OrderId=" + acOrderId.ToString());
        System.Data.Common.DbCommand selectCommand = database.GetSqlStringCommand(sql.ToString());
        database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, Token.Instance.StoreId);
        System.Data.IDataReader dbResults = database.ExecuteReader(selectCommand);
        dbResults.Close();
        dbResults.Dispose();
        selectCommand.Connection.Close();
    }
    catch (Exception)
    {
        SendResponse(response, "FAILED");
        return;
    }
}