Convert money to decimal

(0) Share

Report

Posted on by Community Member

Morning all

I'm trying to convert a money field to a decimal but i keep getting an error about unable to cast. I have tried it various ways with no joy. Any ideas

for (int index = 0; productPriceLevelList.Entities != null && index < productPriceLevelList.Entities.Count; index++)
{
Entity newProductPriceLevelEntity = new Entity("productpricelevel");
newProductPriceLevelEntity["pricelevelid"] = new EntityReference("pricelevel", newPriceLevel.Id);
newProductPriceLevelEntity["productid"] = productPriceLevelList.Entities[index]["productid"];
newProductPriceLevelEntity["productnumber"] = productPriceLevelList.Entities[index]["productnumber"];
newProductPriceLevelEntity["uomid"] = productPriceLevelList.Entities[index]["uomid"];
string prodidse = Convert.ToString(productPriceLevelList.Entities[index]["productnumber"]);
decimal currentvar = Convert.ToDecimal(productPriceLevelList.Entities[index]["amount"]);

Kind regards

Dan

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Refer this:

forums.asp.net/.../1900908.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i had a look at that and tried this with no luck

decimal currentvar = decimal.Parse(productPriceLevelList.Entities[index]["amount"]);

Was this reply helpful? Yes No
Verified answer

Gopalan Bhuvanesh 11,401 on at

Like (0)

Report
decimal currentvar = ((Money)productPriceLevelList.Entities[index]["amount"]).value;

Try the above.

Was this reply helpful? Yes No
Guowei_Xu 407 on at

Like (0)

Report

I think you may check the entity Contains the field of "amount", before you convert it ToDecimal.

For example,

if (productPriceLevelList.Entities[index].Contains("amount"){

decimal currentvar = Convert.ToDecimal(productPriceLevelList.Entities[index]["amount"]);

}

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report

Hi Dan,

just go with Bopalan's answer.. That attribute is of "Money" type. You can't convert directly to Decimal. First cast it to Money, then get the Value

Was this reply helpful? Yes No
clarkjoel547 10 on at

Like (0)

Report

Thanks and I loved this post so much.

Was this reply helpful? Yes No