dashCommerce

Hello,

 

I have problem when installing dashcommerce caused by sqlcommand timeout.

I suggest to insert command.CommandTimeout = 0; in ExecuteStatements proc as shown below:

 

private void ExecuteStatements(string[ statements, string connectionString) {

if(statements.Length > 0) {

using(SqlConnection conn = new SqlConnection()) {

conn.ConnectionString = connectionString;

conn.Open();

using(SqlCommand command = new SqlCommand(string.Empty, conn)) {

command.CommandTimeout = 0;

foreach(string statement in statements) {

command.CommandText = statement;

command.ExecuteNonQuery();

}

}

}

}

}

 

Regards

Setting the timeout to 0 is bad as this means you can wait forever for the command to excecute causing other potential problems and will impact the performance of your site if you have allot of visitors.

Instead it's safer changing the default setting to something like 60 if you have a slow database.

Hello,

There is an issue in btnProcessOrder_Click method in checkout.aspx in line

Response.Redirect(string.Format("~/receipt.aspx?tid={0}", transaction.TransactionId), true);

, which is inside try-catch statement.

I run into a problem which is described in http://support.microsoft.com/kb/312629/EN-US/.

I suggest to modify the code in:

Response.Redirect(string.Format("~/receipt.aspx?tid={0}", transaction.TransactionId), FALSE);

Regards

tring:

Hello,

There is an issue in btnProcessOrder_Click method in checkout.aspx in line

Response.Redirect(string.Format("~/receipt.aspx?tid={0}", transaction.TransactionId), true);

, which is inside try-catch statement.

I run into a problem which is described in http://support.microsoft.com/kb/312629/EN-US/.

I suggest to modify the code in:

Response.Redirect(string.Format("~/receipt.aspx?tid={0}", transaction.TransactionId), FALSE);

Regards

 

I've fixed this bug it's number 17 on the first post. Disabling thread abort is to wrong way to deal with this as it means the prevous thread will continue to load even though you've been redirected causing some performance loss as for a breif moment you will have two thread running when you don't need to.

The better option and the fix i wrote is to catch and throw the exception instead of logging it or putting the redirect outside the try catch.

This site explains it in much more detail if your interested.http://www.jonsagara.com/blogs/tech/archive/2007/07/31/response-redirect-and-the-threadabortexception-and-why-it-s-a-good-thing.aspx

In checkout.aspx - the LoadExpirationMonthDropDown and LoadExpirationYearDropDown methods are called at every page load, hence during every step of the checkout. By the time the user gets to the Payment Information section, the Month/Year dropdowns have their values populated 4 or 5 times. My solution was to wrap the method calls around a If statement, only calling them on the first page load, not during postbacks.

FIX:
In checkout.aspx.cs around lines 230-231, replace the following:

LoadExpirationYearDropDown();
LoadExpirationMonthDropDown();

With:

if (!Page.IsPostBack) {
LoadExpirationYearDropDown();
LoadExpirationMonthDropDown();
}

Logged in codeplex here.

ERROR in calculating the tax

If a customer gets a 50% discount from a 100$ product the new price should be 50$ and the tax should be calculated from the 50$ not from the 100$ as
dashCommerce does.

If you use a 100% discount coupon in dashCommerce which means the product is free of charge,you still have to pay tax for the product.

So if someone gets a 50% discount for a product which price is 100$ and the tax is 10% the new total price should be 45$ and the tax 5$.

100 * 0.5 = 50       50 * 0.1 = 5         50 - 5 = 45

And one more thing. The prices in the site are tax excluded, so some routine must inform the customer that the prices are tax exclusive.

regards Berndt

Paypal Express Checkout

Exception Details: MettleSystems.dashCommerce.Store.Services.PaymentService.PayPal.PayPalServiceException: ErrorCode: 10002. ErrorParameters: . LongMessage: Security header is not valid. SeverityCode: Error. ShortMessage: Security error. CorrectiveAction: 10002.

Source Error:

Line 358:      if(expressCheckoutResponse.Ack != AckCodeType.Success || expressCheckoutResponse.Ack != AckCodeType.SuccessWithWarning) {
Line 359:        if (!string.IsNullOrEmpty(errorList)) {
Line 360:          throw new PayPalServiceException(errorList);
Line 361:        }
Line 362:      }
 

 

Any idea?

 

Thanks,

Myo Zaw.

 

I have several problems. Almost applied all the fixed listed above. Here is my list of problems: 1) For most of my products the add to chart area is disabled. There is inventory for the products. Checking Allow Negative Inventory and hitting save inventory wont save it. Anytime i tab away and come back to sku tab, allow negative inventory checkbox is cleared out. More important than that, why cant i add a product to my shopping cart when it exists in inventory? 2) In checkout.aspx page sometimes i am not able to add a new address, sometimes checking Use for Shipment throws a critical error message and now use for shipping seems to work but now i lose the country list in shipping information. the drop down loads with nothing in it and wont allow me to put in something and its a required field. Each time i visit the page it acts different. Is it working fine for everybody else? 3) Shipment method has nothing to configure. Is it possible to configure shipment for ranges? Anything purchase between $0 to $45 will pay $8 for shipping, anything between $45 and $75 will pay $12 kind of method. Is it possible? Anyone developed any method other than what it provided? 4) How does the tax exactly work? What does region code mean? Is it the state abv for USA? Whatever i do i alwasy get the default rate. thanks -shane

Hello, I keep getting an error log at paypalcheckout.aspx Saying:

System.NullReferenceException: Object reference not set to an instance of an object.
   at MettleSystems.dashCommerce.Web.paypalcheckout.btnShippingMethod_Click(Object sender, EventArgs e) in C:\Users\username\Desktop\ecomm\dashCommerce 3\dashCommerce 3.0 Beta\Web\paypalcheckout.aspx.cs:line 228

 Here is line 228 of paypalcheckout.aspx.cs
OrderController.SetShipping(WebUtility.GetUserName(), shippingAmount, rblShippingOptions.SelectedItem.Text);

 I haven't seen any reference in the site whatsoever that ties it to my computer. And that is the old directory structure of where it is on my computer, I had since moved it.

My "Shipping Method" box is empty and I can't get past that panel, is there a work around for that?

Any help would be much appreciated!

 Thanks!
God Bless!

Gabriel Hounsome