Posted on 17/04/2012 15:56:15
Hmm, well here is the implementation of what I currently have, and it seams that I can get the collection of items through the event args.
Maybe I am doing this in a wrong way, maybe you could suggest another way to do it (I am using dynamicweb 8.0.1.3).
Since I need to save the order information and than save items that where in the order, obviously I need to save how many items the user added to the cart. But I do not like the idea of having foreach in another foreach loop. Since I would have to call it to find out how many items did the user added.
public override void OnNotify(string notification, NotificationArgs args)
{
//errorMessage("Method called");
//Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsCompleteArgs myArgs = (Dynamicweb.Notifications.eCommerce.Cart.CheckoutDoneOrderIsCompleteArgs)args;
Dynamicweb.Notifications.eCommerce.Cart.OrderIsPassedToCheckoutHandlerArgs myArgs = (Dynamicweb.Notifications.eCommerce.Cart.OrderIsPassedToCheckoutHandlerArgs)args;
string orderID = myArgs.Order.ID;
string orderState = myArgs.Order.StateID;
string orderDate = myArgs.Order.Date.ToLongDateString();
//...
SqlConnection conn;
SqlCommand comm;
string connectionString = CONNSTR;
conn = new SqlConnection(connectionString);
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();
// just for test purposes 7 is a standart ammount passed
comm = new SqlCommand(query, conn);
//OrderStateID
comm.Parameters.AddWithValue("@OrderStateID", orderState);
//...
try
{
//...
}
catch (Exception)
{
errorMessage(status);
}
finally
{
}
}
catch
{
//...
errorMessage(status);
}
finally
{
conn.Close();
status = "counter: " + counter.ToString();
}
// PASSING PRODUCTS HERE
passOrderProducts(myArgs.Order.Products);
}
// PRODUCTS PASSED - need to iterate through order products and gether information about them...
private void passOrderProducts(Dynamicweb.eCommerce.Products.ProductCollection productCollection)
{
// SQL connection information etc...
try
{
comm.Connection.Open();
foreach (Dynamicweb.eCommerce.Products.Product product in productCollection)
{
// just for test purposes 7 is a standart ammount passed
comm = new SqlCommand(query, conn);
//totalCount
comm.Parameters.AddWithValue("@totalCount", product.); // <-- need to find how many products where added in the cart here
// other parameters here...
try
{
//...
}
catch (Exception)
{
//...
errorMessage(status);
}
finally
{
}
}
try
{
}
catch (Exception)
{
//...
errorMessage(status);
}
finally
{
}
}
catch
{
//...
errorMessage(status);
}
finally
{
conn.Close();
status = "counter: " + counter.ToString();
}
}
Is that a good way or a bad way? Some suggestions would be more than appreciated ;-)
