Decimal Value comparison with integer value

Arifullah Irfann

Hello

I am working on Inventory system

I have a product table which contains Id, item name, SalePrice

the data type for sale price is decimal(18,2)

when I want to add this item to sale list there is a condition that if this item already added to list it will increase the quantity and will not add this item again

the problem is

the product sale price is 50.00 and I add it to sale list if I add again this with 50.00 price product it will increase the quantity

but I change the price to 50 it adds a new item in the sale list

how to change this 50 to decimal then make the comparison in c# windows app

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews7y ago
If you need this check in C#, use double type as below.
double price = 50.00;
double price1 = 50;
bool flag = Double.Equals(price, price1);
Double.Equals will evaluate and return correct result without bothering about with decimals or without decimals. It only look for actual content value.
0
Amit Gupta7y ago
You don't neee to do any comparison, just find the itemid of product, if it exists then update the list else add a new item. datatable.Select(...) Will help you to find the item contained in the datatable.
0
Suraj Kumar7y ago
In SQL Server both 50 as integer and 50.00 as decimal both are equal. I have tried it by running the below query in SSMS:
if (50 = 50.00)
begin
    print 'Select 50 and 50.00 are equal.'
end
else
begin
    print 'Select 50 and 50.00 are not equal.'
end
In C# if you want to compare it then you can convert integer value to decimal format with 2 point precision as shown below:
decimal price = 50.20M;
int price1 = 50;
double price2 = 50.30;

price.ToString("0.00"); //Output - 50.20
price1.ToString("0.00"); //Output - 50.00
price2.ToString("0.00"); //Output - 50.30
0