Developer forum

//[Subscribe(Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsComplete)]

    [Subscribe(Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsNotComplete)]
    public class CheckoutHandler1 : NotificationSubscriber
    {
        // just a basic connection string here
        private string CONNSTR;
        
        public override void OnNotify(string notification, NotificationArgs args)
        {
			// my debugging method
			errorMessage("Method called");

            //Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsCompleteArgs myArgs = (Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsCompleteArgs)args;
            Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsNotCompleteArgs myArgs = (Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsNotCompleteArgs)args;
            string orderID = myArgs.Order.ID;

            string orderState = myArgs.Order.StateID;
            string orderDate = myArgs.Order.Date.ToLongDateString();
            string orderTime = myArgs.Order.Date.ToLongTimeString();
            string totalPrice = myArgs.Order.TotalPrice.ToString();
            // OrderDeliveryData - hardcoded
            string orderStatus = "processing";// my order status - processing.
            string orderUserName = myArgs.Order.CustomerAccessUserUserName;
            string orderAdress = myArgs.Order.CustomerAddress;

            string orderSeller = "DJ";

            string orderOurRef = "CHI";
            string orderTheirRef = "C5ref";
            string orderTheirRek = "C5rek";

            //foreach (Dynamicweb.eCommerce.Products.Product product in myArgs.Order.Products)
            //{
            //    // list products here...
            //    // product. and import them to the 
            //}

            // TODO: make SQL insert here.

            string status = "";
            SqlConnection conn;
            SqlCommand comm;

            string connectionString = CONNSTR;
            conn = new SqlConnection(connectionString);

			// insert into my table
            string query = "INSERT INTO EXPORT_ORDERS Values (@OrderStateID, @OrderNr, @OrderDate, @OrderTime, @OrderTotalPrice, @OrderDeliveryData, @OrderStatus, @OrderUserName, @OrderAdress, @OrderSeller, @OrderOurRef, @OrderTheirRef, @OrderTheirRek, @MyOrderStatus)";

            comm = new SqlCommand(query, conn);

            int counter = 1;
            try
            {
                comm.Connection.Open();

                comm = new SqlCommand(query, conn);
                //OrderStateID
                comm.Parameters.AddWithValue("@OrderStateID", orderState);
                //OrderNr
                comm.Parameters.AddWithValue("@OrderNr", orderID);
                //OrderDate
                comm.Parameters.AddWithValue("@OrderDate", orderDate);
                //OrderTime
                comm.Parameters.AddWithValue("@OrderTime", orderTime);
                //OrderTotalPrice
                comm.Parameters.AddWithValue("@OrderTotalPrice", totalPrice);
                //OrderDeliveryData
                comm.Parameters.AddWithValue("@OrderDeliveryData", "deliveryDataReference");
                //OrderStatus
                comm.Parameters.AddWithValue("@OrderStatus", orderStatus);
                //OrderUserName
                comm.Parameters.AddWithValue("@OrderUserName", orderUserName);
                //OrderAdress
                comm.Parameters.AddWithValue("@OrderAdress", orderAdress);
                //OrderSeller
                comm.Parameters.AddWithValue("@OrderSeller", orderSeller);
                //OrderOurRef
                comm.Parameters.AddWithValue("@OrderOurRef", orderOurRef);
                //OrderTheirRef
                comm.Parameters.AddWithValue("@OrderTheirRef", orderTheirRef);
                //OrderTheirRek
                comm.Parameters.AddWithValue("@OrderTheirRek", orderTheirRek);
                //MyOrderStatus
                comm.Parameters.AddWithValue("@MyOrderStatus", "myStatus");

                try
                {
                    comm.ExecuteNonQuery();
                    counter++;
                    status = "counter++ passed";
                    status = "executeNonQuery passed";
                }
                catch (Exception)
                {
                    status = "Could not execute order insert";
                    errorMessage(status);
                }
                finally
                {
				
                }
            }
            catch
            {
                status = "ERROR AT ORDER counter ID " + counter.ToString();
                errorMessage(status);
            }
            finally
            {
                conn.Close();
                status = "counter: " + counter.ToString();
            }
            passOrderProducts(myArgs.Order.Products);

            ////Product product = new Dynamicweb.eCommerce.Products.Product("ProductID");Order order =Dynamicweb.eCommerce.Common.Context.Cart;

            ////Dynamicweb.eCommerce.Orders.
            ////order.Products.Add(product);

            // ... do stuff

        }